webinarbrite


Advanced Excel for Administrative Assistants

David H. Ringstrom, CPA,
Date & Time: Jun 03, 2026 , 01 : 00 PM ET |  1 Days Left
Duration: 90 Minutes
Category: Information & Technologies
Type: Live Webinar

Description

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.

Areas Covered:

  • Appending data from two or more worksheets into a self-updating consolidated list with Power Query
  • Eliminating non-printing characters using CLEAN and TRIM
  • Extracting and transforming text with UPPER, LOWER, and PROPER
  • Dynamic sorting with SORT and UNIQUE
  • Filtering data based on two or more conditions using FILTER
  • Creating in-cell dropdowns with Data Validation
  • Using XLOOKUP for exact matches and last-match results
  • Customizing workbook views with Sheet View
  • Reviewing Microsoft Forms styles, settings, and sharing options

Why Should Attend?

  • Gain confidence using Excel’s text-cleanup functions like TRIM, CLEAN, and PROPER to format data quickly and accurately.
  • Learn how to consolidate data from multiple sheets using Power Query for efficient reporting.
  • Master XLOOKUP for precise lookups, including how to find the last matching value in a list.
  • Utilize dynamic array functions (SORT, UNIQUE, FILTER) to display and manage data sets with ease.
  • Customize your workbook views using Sheet View and explore Microsoft Forms for data collection.
  • Build dropdown lists with Data Validation and apply advanced filtering with multiple conditions.
  • 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.

Price Details

Speaker Profile : David H. Ringstrom, CPA,

David H. Ringstrom, CPA, is an author and nationally recognized instructor who teaches scores of webinars each year. His Excel courses are based on over 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 users don’t, but should, know about Microsoft Excel. His goal is to empower you to use Excel more effectively. To learn more about David, you can view his LinkedIn profile and follow him on Facebook or Twitter (@excelwriter).