Payroll Analysis

Level: Intermediate

Available Durations:

  • 50 minutes
  • 60 minutes
  • 75 minutes
  • 90 minutes
  • 100 minutes
  • 120 minutes

Description:

There are many features and functions payroll professionals might not be aware of that can be used to improve the accuracy and efficiency of payroll production. In this valuable webcast, Excel expert David Ringstrom, CPA, clearly explains: mathematics for employee time sheets, date and time formatting and stamping, conditional formatting to highlight HR requirements, password protection for sensitive payroll files and worksheets, salary information formatting, and using pivot tables for HR reporting and analysis tasks.

David demonstrates every technique at least twice: first, on a PowerPoint slide with numbered steps, and second, in the subscription-based Office 365 version of Excel. David draws your attention to any differences in the older versions of Excel (2019, 2016, 2013, and earlier) during the presentation as well as in his detailed handouts. David also provides an Excel workbook that includes most of the examples he uses during the webcast.

Office 365 is a subscription-based product that provides new-feature updates as often as monthly. Conversely, the perpetual licensed versions of Excel have feature sets that don’t change. Perpetual licensed versions have year numbers, such as Excel 2019, Excel 2016, and so on.

Topics/Areas Typically Covered:

  • Using Excel’s Text to Columns feature to convert Social Security numbers to values and then apply Excel’s Social Security number format.
  • Redacting portions of Social Security numbers by way of Excel’s TEXT worksheet function.
  • Discovering the capabilities of the SUMPRODUCT function for calculating payroll and other amounts.
  • Revealing the undocumented DATEDIF function in Excel for determining the number of months or years between two dates.
  • Utilizing the NETWORKDAYS function to ascertain the number of workdays between two dates.
  • Determining how to calculate the last day of the current month, as well as future or prior months, with the EOMONTH function.
  • Computing the due dates for semimonthly federal payroll tax deposits by using the CHOOSE and WEEKDAY functions.
  • Drilling down into the details behind any amount within a pivot table with just a double-click.
  • Discovering four different ways to remove data from a pivot table report.
  • Utilizing the RANDBETWEEN worksheet function to create a series of random numbers.
  • Employing pivot tables to pull random sets of employee names, such as for drug testing.
  • Preventing errors from the start by choosing from thousands of free Excel spreadsheet templates.
  • Limiting access to sensitive workbooks by way of password protection.
  • Exploring options for recovering lost passwords for Excel spreadsheets.

Learning Objectives/Why You Should Attend:

  • Identify the function that can multiply cells together and provide a sum of the result.
  • Recall the technique that enables you to drill down into underlying records within a pivot table.
  • Identify the command within the Tools menu within the Save As dialog box that enables you to password protect an Excel workbook from being opened or modified.

Target Industries:

  • Accounting and Finance
  • Business
  • Excel Users
  • Consulting
  • IT
  • Auditing
  • Human Resources
  • Marketing
  • Sales
  • Government
  • Tax

Target Job Title:

  • Accountants
  • CPAs
  • CFOs
  • Controllers
  • Income Tax Preparers
  • Enrolled Agents
  • Financial Consultants
  • IT Professionals
  • Auditors
  • Human Resource Personnel
  • Bookkeepers
  • Excel Users
  • Marketers
  • Government Personnel

About the Instructor:

David H. Ringstrom, CPA, is an author and nationally recognized instructor who teaches scores of webinars each year. His Excel courses are based on over 25 years of consulting and teaching experience. David’s mantra is “Either you work Excel, or it works you,” so he focuses on what he sees users don’t, but should, know about Microsoft Excel. His goal is to empower you to use Excel more effectively. To learn more about David, you can view his LinkedIn profile and follow him on Facebook or Twitter (@excelwriter).

Pricing and Format Options:

Click here to learn about the presentation format and view pricing information.

Click here to view other topics.