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...]
How to Use Networkdays in Excel
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...]
Adding and Subtracting Time in Excel
Adding and subtracting time in Excel is something that people often times have a difficult time figuring out how to do correctly. Often times you are doing it right, but the results don't seem to be displaying correctly. Other times you may give up doing it the "correct" way and set up an hours column and a minutes column. Then add the minutes, divide by 60, and add it to the … [Read more...]
Count Cells Meeting Certain Criteria
Whenever you are dealing with lists it seems like you always are looking to count how many of a certain item is in the list. Maybe you want to count how many cars were sold by a certain salesperson, or how many times an employee called out sick. Luckily Excel makes it easy to count cells meeting certain criteria just like this. Count cells meeting certain criteria with Excel's … [Read more...]
VLOOKUP Price Ranges in a Table
Recently, I was working on a budget for a class that I was putting together. Most of the expenses that would be incurred were fairly straightforward and would increase in proportion to the number of students that were in the class. For example, student manuals cost $11 per student. Easy enough to find out the total student manual cost by multiplying by the number of students, … [Read more...]