Guaranteed to be Good
All training experiences include a 7-day 100% money-back guarantee.
Excel for Payroll Professionals: Increase Efficiency and Accuracy
Summary
How can you maximize your time, improve accuracy, and get payroll processed quicker?
Excel offers payroll professionals a variety of features and functions that are often underutilized but can improve the accuracy and efficiency of the payroll process.
With the right formulas and training, Excel will become the payroll department's new best friend.
In this comprehensive workshop, Excel expert David Ringstrom, CPA, will lead you through:
- Easy-to-use formulas for employee timesheets
- Date and time formatting and stamping for more accurate recordkeeping
- Conditional formatting for company or industry specific requirements
- Password protection for sensitive payroll files
- Worksheets and pivot tables
- Salary information formatting
- Quick tools for data analysis
- And more!
Program Highlights
- Dynamically format payroll information with conditional formatting
- Create instant payroll summaries with pivot tables
- Master the SUMPRODUCT function to verify payroll calculations
- Use NETWORKDAYS.INTL to calculate workdays in a given time period
- Compute due dates for semi-weekly federal payroll tax deposits with the CHOOSE and WEEKDAY functions
- Calculate a series of monthly dates with the IF and EOMONTH functions
- Improve the integrity of Excel pivot tables with the Table feature
- Add fields to a blank pivot table to create instant reports
- Redact portions of Social Security numbers by way of Excel’s TEXT worksheet function
- Discover four different ways to remove data from a pivot table report.
About The Speaker
David H. Ringstrom, CPA, is an author and nationally recognized instructor. His Excel courses are based on 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, that other users often don’t. His goal is to empower you to use Excel more effectively.
- David demonstrates each technique at least twice and highlights any differences between differing versions of Excel (2019, 2016, 2013, and earlier). David also provides an Excel workbook for further study.
- He equips his audience to succeed with clear handouts and actionable examples.
Program Benefits
Let Excel make your payroll process simplified and error free. Join us for 100 minutes and walk away ready to utilize all Excel has to offer.
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!
Purchase this On-Demand Workshop
Excel for Payroll Professionals: Increase Efficiency and Accuracy
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.
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.
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.
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.
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.
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.
You'll receive access to our full library of on-demand trainings along with the speaker's presentation and handouts for each event.
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.
