Analyzing Payroll Data in Microsoft Excel

Authored by David Ringstrom
About this Course
Topics covered include: Revealing the undocumented DATEDIF function in Excel for determining the number of months or years between two dates; Determining the previous Friday when payroll dates fall on a weekend by using the IF and WEEKDAY functions; Employing the NETWORKDAYS.INTL worksheet function to determine the number of work days in a period by excluding holidays as well as specific days of the week; Utilizing the RANDBETWEEN worksheet function to create a series of random numbers; Gleaning the nuances of adding time values together in Microsoft Excel; Drilling down into the details behind any amount within a pivot table with just a double-click; Transforming a column of salaries into an instant heat map by way of Excel's Conditional Formatting feature; Limiting access to sensitive workbooks by way of password protection; Color-coding the top ten (or however many you wish) amounts within a column of numbers with Conditional Formatting; Improving the integrity of Excel pivot tables with the Table feature; Discovering four different ways to remove data from a pivot table report; Preventing users from drilling down into pivot table amounts. Upon completing this course, you should be able to: Identify the function that can multiply cells together and provide a sum of the result; Recall the menu command that only appears when you right-click a field that appears within the Values section of the Pivot Table field list; Define the purpose of Excel's TEXT function.
$ 36.00
Add To Cart
NASBA Field of Study
Computer Software & Applications
Level
Intermediate
CPE Credits
2.0
Prerequisites
Experience with Excel
Last Updated
07/30/2018
14299