• Blog
  • Excel Downloads
    • Audit Tickmark Toolbar
  • Courses
  • Contact
  • Checkout

Excel Zoom

...because it's more than just a calculator


5 Must-Have Excel Skills for Accountants

June 21, 2017 by Mark Leave a Comment

Excel Must Have Skills Functions

Accountants are part of every organization, and they are important because they manage the monetary aspects of the business.  They must be able to work with different types of people and across various departments.  Therefore, they must use various tools, one of which is MS Excel.  In order to use it productively, they must have the necessary skills and know when to apply … [Read more...]

7 Things CPA Should know about VBA Macros

June 15, 2017 by Mark Leave a Comment

VBA stands for visual basic for application. It is the default programming language for MS Office. If you want to program MS Excel you should know how to work with VBA Macros. VBA is at the same time is fun and a source of improving productivity. Actually it provides an opportunity to do things what canot be done in usual way or to have features that are not available by … [Read more...]

Remove All Rows Containing Certain Data

July 20, 2015 by Mark 7 Comments

remove all rows containing certain data

Recently I had some data from a website that was poorly formatted, but I needed to get it into a spreadsheet to work with. When I copied the data into the spreadsheet, I needed to remove all of the rows that contained certain irrelevant data, such as repeated header fields. Other use cases might require you to delete any rows containing someone's name, a location, or some … [Read more...]

How to Create Combination Charts in Excel

May 1, 2017 by Mark 1 Comment

Most Excel users know how to create either a bar chart or a line chart to visually show a set of data.  One way to really step up your game and graphically show multiple relationships across two or more sets of data is to use a combination chart.  This powerful function will allow you to combine a bar chart and a line graph and add a Y-axis (vertical line) to express broader … [Read more...]

How to Use Networkdays in Excel

April 12, 2017 by Mark 2 Comments

When to use the Networkdays Function How many days an employee has worked, and should get paid for, has always been a point of concern for an organization. The department responsible for implementing this validation is typically the Payroll department along with Human Resources and other Accounting personnel that prepare the monthly payroll file/report for the company. This … [Read more...]

« Previous Page
Next Page »
Subscribe to our mailing list
  • Facebook
  • Twitter

Search this site…

Categories

  • Macros (34)
  • Tips (67)
  • Uncategorized (23)



Copyright © 2023 · Magazine Pro Theme on Genesis Framework · WordPress · Log in

Login Form

Lost your password?