How can I enroll in the class?

To enroll in a course, visit www.professionalslearning.com. Find your desired webinar, choose the quantity, and add it to your cart. Enter your details, complete the payment, and check your registered email for the confirmation and webinar info.

Are your live webinars eligible for SHRM and HRCI credits?

Yes, the webinars are approved for SHRM and HRCI recertification credits. This is usually mentioned in the webinar description on the website.

Will I receive a certificate of participation?

Yes, all participants receive a Certificate of Participation upon completion of the course or webinar. This certificate is usually delivered via email 24 hours after the class.

How can I contact the Professionals Learning if I face any glitches?

For assistance, you may contact the support team via email at support@professionalslearning.com. For immediate assistance, consider using the live chat feature to connect with a CSR. Most issues such as registration, access, or technical concerns are typically resolved promptly and efficiently.

Mastery in Advanced Excel skills: Power tools for Accounting and Finance

By Professionals Learning

Online event

Overview

Boost your efficiency with Advanced Excel tools like XLOOKUP, Power Query, and Solver—designed for accounting and financial professionals.

Event Overview:

Live Webinar - November 07, 2025 | Speaker: David Ringstrom, CPA | 90 Minutes | HRCI | SHRM & NASBA-Approved Online Training

Boost your accounting efficiency with this Advanced Excel live training designed for finance professionals who want to solve real business challenges using Excel’s most powerful tools. Led by David Ringstrom, CPA, a nationally recognized Excel expert with over 30 years of teaching experience, this webinar goes beyond basic formulas to practical problem-solving. Learn how to replace outdated functions like VLOOKUP with modern lookup methods such as INDEX/MATCH and XLOOKUP, clean messy accounting data instantly using Power Query, and automate reconciliation tasks using Excel’s Solver tool. Whether you're managing financial reports, audits, or complex calculations, this session will help you work smarter, faster, and with greater accuracy.

What You’ll Learn:

By the end of this course, you will know how to:

Use XLOOKUP to match data across multiple columns with ease
Compare INDEX/MATCH vs. XLOOKUP for faster lookups
Clean and transform exported reports using Power Query
Remove duplicates, blanks, and merged formatting in seconds
Use Solver to automate reconciliation and matching
Enable backup and version history for Excel files with OneDrive
Apply advanced Excel features in real accounting workflows
Compatible tips for Excel 2019, 2021, 365 & Excel for Mac

Why You Should Attend:

Gain hands-on Advanced Excel skills to automate accounting and reporting tasks.
Learn time-saving techniques trusted by accounting and finance professionals.
Improve data accuracy and eliminate manual errors in spreadsheets.

Need Immediate Assistance- Chat With Us

Check out the Course Details Here

Session Format:

Live Webinar: Get real-time access and ask questions directly during the Q&A with our Expert Speaker.

Recording & E-Transcript: Can’t attend live? Sign up for the "Recorded or E-transcript" session.

Category: Business, Other

Good to know

Highlights

1 hour 30 minutes
Online

Refund Policy

Refunds up to 7 days before event

Location

Online event

Frequently asked questions

Organized by

Professionals Learning

Followers

--

Events

--

Hosting

--