Excel for Payroll Professionals: Improve Accuracy & Efficiency

Summary

For anyone working with payroll data, MS Excel is an invaluable tool to improve the accuracy and efficiency of payroll-related tasks. Whether you’re managing employee timesheets, salary information or protecting sensitive payroll files, Excel has features and functions that will help you be more effective and productive.

In our dynamic, 100-minute event, Excel and finance expert David Ringstrom will demonstrate how you can utilize Excel to get more from your payroll data. Discover how to dig deeper into the data for the information you and stakeholders need to drive your organization forward.

Join us to learn:

  • How to automate key tasks to save time and improve consistency
  • Techniques to better protect sensitive payroll files
  • Ways to accurately calculate payroll and determine pay periods
  • Stay ahead of payroll reporting and payment due dates
  • Key differences across the most-used versions of Excel

Bonus: Excel reference workbook demonstrating the techniques taught

Program Highlights

Automate Reporting with PivotTables: Do More with Payroll Data 

  • Drill down deeper into payroll data with just a few mouse-clicks
  • Create instant and shareable reports using pivot tables
  • Quickly access any type of employee data at any time  
  • Four ways to keep unwanted data from invading your reports
  • Understand pivot-table difference across Excel versions

Better Manage Payroll with Powerful Worksheet Functions

  • Stay ahead of important federal payroll tax deposit due dates
  • Using functions to accurately calculate payroll amounts
  • Looking ahead: Never miss semimonthly payroll dates
  • Easily determine the number of workdays in a given pay period
  • Create random numbers for random selection purposes (like drug testing)

Get More Out of Payroll Data: Analysis & Transformation Techniques

  • Color-coding key data to make it stand out
  • Transform batches of data into formats you can more easily process
  • Create heat maps to spot trends and identify payroll needs

About The Speaker

David H. Ringstrom, is a CPA and owner of Accounting Advisors, Inc., an Atlanta-based spreadsheet consulting firm that he started back in 1991.

  • He is an author, Microsoft Excel spreadsheet expert, and consultant.
  • David teaches over 200 live webinars on Excel each year, and has written articles on spreadsheets that have been published internationally. He is the co-author of “Idiot’s Guide: Introductory Accounting” and has served as the technical editor for dozens of books in the “QuickBooks for Dummies” series.
  • Attendees often speak highly of David's well-prepared handouts that provide numbered steps that you can follow to carry out the techniques that he presents during his webinars.

Program Benefits

In this 100-minute program, you will gain solutions for working more efficiently, plus discover how to share pertinent data with decision makers, much more clearly than ever before.  Start saving valuable time and avoid headaches, by learning invaluable Excel tips, techniques, and shortcuts!

If you'd like this program customized for your organization, call us at 1-800-964-6033.
We're certain we can fulfill your training needs, while making it fit in your budget!

Credits

NASBA logo
Credit Hours:
2.0
Field of Study:
Computer Software & Applications (2 hours)
Program Level:
Intermediate
Prerequisites:
Experience with Excel
Advance Prep:
None
Delivery Method:
Group Internet Based
Progressive Business Conferences is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website: www.nasbaregistry.org

REGISTRATION

Excel for Payroll Professionals: Improve Accuracy & Efficiency

Live event begins Wednesday, May 17, 2023, 1PM (ET)

Live + On-Demand $199 + applicable taxes
more info
For the live training(s) you've selected:
You will receive access to the live event(s) which includes a copy of the speaker's presentation, real-time training with our expert instructor, and an interactive question & answer period. Two to three business days after each live training concludes, an email is sent to registrants which contains a link for unlimited access to the on-demand recording you can revisit & review.
For the on-demand training(s) you've selected:
You'll receive a link to access the recording(s) in your order confirmation email. On-demand recordings also include a copy of the speaker's presentation and the ability to submit your questions to the expert, for up to 7 days after viewing.
3 Workshop
Bundle $300 + applicable taxes
more info
Take advantage of our three workshop bundle to enhance your learning beyond the training you initially selected. Our workshop bundle allows you to select three workshops (Live or On-Demand) at a discounted price.
For the live training(s) you've selected:
You will receive access to the live event(s) which includes a copy of the speaker's presentation, real-time training with our expert instructor, and an interactive question & answer period. Two to three business days after each live training concludes, an email is sent to registrants which contains a link for unlimited access to the on-demand recording you can revisit & review.
For the on-demand training(s) you've selected:
You'll receive a link to access the recording(s) in your order confirmation email. On-demand recordings also include a copy of the speaker's presentation and the ability to submit your questions to the expert, for up to 7 days after viewing.
One-year subscription (All Access Membership) $699 + applicable taxes
more info
With this subscription, you will receive 1 year of unlimited access to our full library of on-demand trainings as well as priority access to trainings that are upcoming.
For the live training(s):
You will receive access to the live event(s) which includes a copy of the speaker's presentation, real-time training with our expert instructor, and an interactive question & answer period. Two to three business days after each live training concludes, an email is sent to registrants which contains a link for unlimited access to the on-demand recording you can revisit & review.
For the on-demand training(s):
You'll receive access to our full library of on-demand trainings along with the speaker's presentation and handouts for each event.

If you can’t make it live, no worries! You’ll receive the recording and materials after the event.

Add To Cart

Guaranteed to be Good

All training experiences include a 7-day 100% money-back guarantee.

Full-Team Pass

Simply share the invite link with your team so you can learn and grow together!

Yours Forever

The event recording and materials are yours to rewatch and share as you choose.