Human Resources
Advanced Excel For Administrative Assistants
CWS2025320
100 Minutes
Jan 16,2026
10:00 AM PST | 01:00 PM EST
Overview
Unlock the full potential of Excel with expert guidance from David H. Ringstrom, CPA, in this dynamic, hands-on webinar tailored for administrative professionals. Designed to enhance your day-to-day productivity, this session focuses on practical Excel skills that streamline data management, improve accuracy, and simplify reporting. You’ll begin by mastering essential text-cleanup techniques using functions like LEFT, MID, RIGHT, UPPER, LOWER, PROPER, TRIM, and CLEAN. From there, David walks you through consolidating data from multiple worksheets using Power Query—an invaluable tool for building self-updating reports.
The webinar continues with step-by-step demonstrations of how to leverage XLOOKUP for precision lookups, including last-match results and comparisons with legacy VLOOKUP formulas. You’ll explore powerful dynamic array functions such as SORT, UNIQUE, and FILTER, as well as create multi-condition filters and in-cell dropdowns using Data Validation. David also covers how to customize your Excel experience with Sheet View and provides a walkthrough on creating and personalizing Microsoft Forms. This comprehensive session ensures you walk away with a robust set of tools to elevate your Excel efficiency.
Topics Typically Covered:
1- Appending data from two or more worksheets into a self-updating consolidated list with Power Query
2- Eliminating non-printing characters using CLEAN and TRIM
3- Extracting and transforming text with UPPER, LOWER, and PROPER
4- Dynamic sorting with SORT and UNIQUE
5- Filtering data based on two or more conditions using FILTER
6- Creating in-cell dropdowns with Data Validation
7- Using XLOOKUP for exact matches and last-match results
8- Customizing workbook views with Sheet View
9- Reviewing Microsoft Forms styles, settings, and sharing options
Your Benefits for Attending:
1- Gain confidence using Excel’s text-cleanup functions like TRIM, CLEAN, and PROPER to format data quickly and accurately.
2- Learn how to consolidate data from multiple sheets using Power Query for efficient reporting.
3- Master XLOOKUP for precise lookups, including how to find the last matching value in a list.
4- Utilize dynamic array functions (SORT, UNIQUE, FILTER) to display and manage data sets with ease.
5- Customize your workbook views using Sheet View and explore Microsoft Forms for data collection.
6- Build dropdown lists with Data Validation and apply advanced filtering with multiple conditions.
7- Understand the key differences between Excel 365, 2024, 2021, and 2019 to ensure compatibility in your workflow.
This webinar is ideal for administrative professionals seeking to improve spreadsheet accuracy and speed up repetitive data tasks. You’ll leave with practical tools that make your daily work in Excel more efficient and stress-free.
Who Should Attend:
Professionals who want to enhance their Excel skills to improve the accuracy and efficiency of their spreadsheets.
David H Ringstrom
David H. Ringstrom, CPA, is a nationally recognized Microsoft Excel expert. He is the president and owner of Accounting Advisors, Inc. based in Atlanta, Georgia. David founded Accounting Advisors in 1991 as a consulting-services business, later he began teaching continuing education classes as well. His mission since is to offer quality training and consulting services on Microsoft Excel via live webcasts, on-demand self-study webcasts, and in-house engagements. David has taught hundreds of webinars on Excel and other topics, in addition to speaking at conferences and in-house engagements. More than 24 providers, located throughout the country as well as overseas, now look to David for their Excel and accounting software training needs. More than 24 providers, located throughout the country as well as overseas, now look to David for their Excel and accounting software training needs.
David’s Excel courses cover the gamut of the software’s features and functions to provide CPAs as well as accounting and financial professionals the knowledge they need to work more efficiently and effectively in Excel. David is known for saying, “Either you work Excel, or it works you.” Based on this belief, he focuses on teaching users what they don’t know but should know about Excel.
His comprehensive yet easy to understand presentations cover Excel 2019, 2016, 2013, and 2010. David’s webcasts are fast-paced, and he welcomes attendees’ questions. In addition, his detailed handouts and slides serve as handy reference tools students can fall back on after participating in his webcasts or taking his self-study courses.