Practical Excel Techniques for Payroll Professionals 2018 is a webinar that covers topics such as:
- 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
Practical Excel Techniques for Payroll Professionals 2018 is intended for:
- Business
- Accounting
- Finance
- Cross Functional
- Information Technology
- Human Resources
