Practical Excel Techniques for Payroll Professionals 2018

Topics

• Color-coding the top ten (or however many you wish) amounts within a column of numbers with Conditional Formatting
• Adding fields to a blank pivot table to create instant reports
• Discovering four different ways to remove data from a pivot table report
• Discerning the nuance involved in making pivot tables present data in tabular form
• Distinguishing the differences among pivot table-related menus in Excel 2013 and later versus older versions of Excel
• Discovering the capabilities of the SUMPRODUCT function for calculating payroll and other amounts
• Employing pivot tables to pull random sets of employee names, such as for drug testing
• Drilling down into the details behind any amount within a pivot table with just a double-click
• Exploring options for recovering lost passwords for Excel spreadsheets
• Expanding reports horizontally by adding columns to pivot tables
• Improving the integrity of Excel pivot tables with the Table feature
• Formatting certain words within a column of text with Conditional Formatting

Who should Attend

• Business
• Accounting
• Finance
• Cross Functional
• Information Technology
• Human Resources