Payroll Data Analysis For Professionals In Excel

Welcome to myCPE

Excel Accountant: Payroll Analysis

Learning Objectives

To recall how to reformat Social Security Numbers using Excel’s Flash Fill feature.
To define how to assign random numbers to a data set in Excel.
To apply password-protection techniques for sensitive payroll files, worksheets, and spreadsheet columns.

Course Description

Excel offers payroll professionals many features and functions that can improve the accuracy and efficiency of payroll production. In this comprehensive CPE course, David, explains mathematics for employee timesheets, date and time formatting and stamping, conditional formatting to highlight HR requirements, password protection for sensitive payroll files and worksheets, salary information formatting, using pivot tables for HR reporting and analysis tasks, and more.

David demonstrates every technique at least twice in this Excel continuing professional education course: first, on a PowerPoint slide with numbered steps, and second, in the subscription-based Microsoft 365 version of Excel. Excel expert David Ringstorm, CPA 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.

Microsoft 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.

This online Excel CPE webinar covers the following key topics:

Computing the due dates for semi-monthly federal payroll tax deposits by using the CHOOSE and WEEKDAY functions.
Discerning the nuance involved in making pivot tables present data in tabular form.
Determining the previous Friday when payroll dates fall on a weekend by using the IF and WEEKDAY functions.
Calculating a series of semi-monthly dates by way of the IF and EOMONTH worksheet functions.
Improving the integrity of Excel pivot tables with the Table feature.
Adding fields to a blank pivot table to create instant reports.
Redacting portions of Social Security numbers by way of Excel’s TEXT worksheet function.
Discovering four different ways to remove data from a pivot table report.
Formatting certain words within a column of text with Conditional Formatting.
Employing the NETWORKDAYS.INTL worksheet function to determine the number of workdays in a period by excluding holidays as well as specific days of the week.
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.

This online CPE Excel Webinar will be helpful for CPAs, CMAs, and Payroll professionals who wish to learn practical Excel fundamentals to improve the accuracy and efficiency of payroll production.

Webinar Qualifies For

2 CPE Credit of Accounting for Certified Public Accountants (CPA-US)
2 General Credit of Accounting for Accountant/Bookkeeper/Tax Professionals
2 CPD Credit of Accounting for CPA in Canada
2 PDC Credit of Business Acumen for SHRM Professionals (Approval No. 24-7GT5C)
2 RCH Credit of HR (General) for Human Resource Certification Institute (HRCI) (Approval No. 650044)
2 CPD Credit for Association of Chartered Certified Accountants (ACCA)
2 CPD Credit for Chartered Accountant - ICAEW
2 CPD Credit for Chartered Accountants - Scotland
2 CPE Credit of Accounting for Iowa Licensed Public Accountant (IA-LPA)
2 CPD Credit for Chartered Accountants - Ireland (CAI)
2 CPD Credit for CPA - Ireland
2 CPE Credit of Accounting for Maine Licensed Public Accountant (ME-LPA)
2 CPE Credit of Accounting for Delaware Licensed Public Accountant (DE-LPA)

About Instructor

David Ringstrom, CPA (US)

President, EXCEL Accountant

I own an Atlanta-based training and consulting firm that helps businesses nationwide streamline accounting challenges. Our specialties include:

Microsoft Excel
Microsoft Access
Sage 50/Peachtree Accounting
QuickBooks

Our services include training, technical support, accounting automation, and problem solving. I have spoken at conferences or meetings for these organizations:

National Association of Certified Valuators and Analysts
Institute of Real Estate Managers
Georgia Society of CPAs
South Carolina Society of CPAs
Georgia Government Finance Officers Association
Atlanta chapter, American Society of Women CPAs
Perimeter Chapter, Georgia Society of CPAs

I teach over 200 live webinars annually on Microsoft Excel across roughly two-dozen training providers. I am available for in-house training or select conference engagements as well.

I am the co-author of Idiot's Guide to Introductory Accounting. I've published hundreds of freelance articles on various topics, including Lotus 1-2-3, Quattro Pro, Microsoft Excel, Microsoft Office Accounting, QuickBooks, Peachtree Accounting, and more.

I serve as the technical editor for several books in Wiley's Dummies series, including QuickBooks for Dummies, Quicken for Dummies, Peachtree for Dummies, and more.

Specialties: Microsoft Excel, Visual Basic for Applications, Sage 50, Peachtree Accounting, QuickBooks, Microsoft Office Accounting, freelance writing, training, business consulting

Additional Information

Duration

2 Hours

Course Level

Basic

Instructional Method

Group Internet Based

Pre-requisites

Basic Understanding Of Excel Functionalities

Advance Preparation

None

FAQ’s

Click Here to View

NASBA APPROVED

MY-CPE LLC, 1600 Highway 6 south, suite 250, sugar land, TX, 77478

MY-CPE LLC (Sponsor Id#: 143597) 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.

Ratings and Review

4.6

Excellent

Very Good

Average

Poor

Terrible

Louis Digiovine, CPA (US)

Another great course by this instructor. The title is a bit misleading. Although it was taught using examples from payroll, the applicability of what was covered is far more broad.

Denise Kovatch, CPA (US)

Great course the instructor shows the many ways that you can use Excel and how much information can be obtained with the program.

Tracy Penneau, CPA (US)

Great instructor, I always pick up a few new things in Excel when I take his courses.

HHCNP

Heather Hookstratten, Cpb, Notary Public, CPA (US)

Great content and tools! Will look up more from this instructor. Very effective.

Beth Josey, CPA (US)

Really enjoyed the presenter. Very relatable.

2 Credits

Add to Watchlist

Subject Area

Accounting

Unlimited Access Plan

Access to 12000+ Hours of Continuing Education Approved Content Know More

Subscribe To Register

Inclusions

Continuing Education Certificates for Multiple Qualifications View
Instant Certificates
Multiple Dates
Access on Mobile, Tablet and Desktop

Didn’t received verification email? Resend Email

Live Webinars

On Demand Webinars

Virtual Conferences

Specialized Packages

Advanced Certification Programs

myCPE Shorts Trending

Preparer Course

U.S. Individual Tax Preparer Course

U.S. Business Tax Preparer Course

Exam Prep Course

EA Exam Prep Course

CFP® Review Course

Teams Subscription (Per User)

Individual Subscription

Contact Sales Team

646-688-2884

inquiry@my-cpe.com

Schedule a Call

Flat $300 Off

Flat $640 Off

Flat $1000 Off

6 Million+

100K+

"Steven was knowledgeable and thorough…”

Crystal lovejoy

"Great Customer Service”

Lori corry

"It is what it advertised to be”

Brian Carey

"Great customer service”

Steve

Get 60% Off

Get 64% Off

Get 67% Off

Verification Code