In this Microsoft Excel Certification Exam Prep presentation, author and Microsoft Excel expert David H. Ringstrom, CPA, walks you through a wide range of topics that frequently appear on the MO-210 certification exam and are essential for real-world productivity. You’ll learn practical skills such as importing data, filtering records, and linking workbooks; streamlining navigation with named ranges; and using tools like Sparkline and chart sheets. David also explains how to work with newer Excel functions such as UNIQUE, SEQUENCE, and RANDBETWEEN, as well as modern cell references—including spilled ranges. Throughout the session, you’ll discover efficiency tips like customizing the Quick Access Toolbar, using Show Formulas to audit worksheets, and improving accessibility by avoiding image-based data. Whether you’re preparing for certification or sharpening your skills, this session provides essential insights to elevate your Excel game.

David H. Ringstrom, CPA, has more than 30 years of experience as a spreadsheet and accounting software consultant and speaker. He has presented over 2,500 live webinars and is the author or co-author of ten books, including “Microsoft 365 Excel All-in-One for Dummies”, “Microsoft 365 Excel for Dummies”, “Exploring Microsoft Excel’s Hidden Treasures”, and “QuickBooks Online for Dummies”.

In his webinars, David demonstrates every technique twice: first on a PowerPoint slide with numbered steps, and then live in Excel for Microsoft 365 for Windows. He highlights any differences in Excel 2024, 2021, or 2019 during the presentation and in his detailed handouts. Attendees also receive an Excel workbook containing most of the examples he uses, making it easy to follow along and apply the techniques later. David additionally supports Excel for Mac users by answering their follow-up questions via email.

Who should attend: Professionals seeking to take the MO-210 Microsoft Office Specialist: Excel Associate (Microsoft 365 Apps) exam.

Topics typically covered:

· Integrating data on web pages into your workbooks and creating automatic links.

· Saving Excel workbooks in alternate formats, such as .XLS for backwards compatibility.

· Displaying all formulas in a worksheet at once with the Show Formulas feature.

· Reviewing and updating workbook properties.

· Adding a recorded macro to the Quick Access Toolbar for quick access.

· Reorganizing the Quick Access toolbar to prioritize frequently used keyboard shortcuts.

· Making the same edits on multiple worksheets at once by grouping worksheets.

· Streamlining navigation and formula writing by turning worksheet labels into named ranges.

· Creating line, column, and win/loss sparklines to show data trends.

· Creating a dynamic list of period numbers in an amortization table with the SEQUENCE function.

· Adding totals and filters that automatically adjust based on which rows are visible

· Comparing relative, mixed, absolute, named, structured, and spilled range cell references.

· Pairing the trim (.) and spill (#) operators with UNIQUE and SUMIF in Microsoft 365

· Making formulas easier to read, more resilient, and table-aware.

· Utilizing chart sheets to easily fit multiple charts onto a single printed page.

· Specifying chart styles and borders.

Learning objectives:

• Recall the key that allows you to group a series of adjacent worksheets at once.

• Recall the keyboard shortcut that toggles absolute references within a formula.

• Describe how Excel Tables and structured references improve formula readability and cross-sheet referencing.

Level: Intermediate

Instructional Method: Group: Internet-based

NASBA Field of Study: Computer Software & Applications (2 hours)

Program Prerequisites: Prior experience with Microsoft Excel is recommended.

Advance Preparation: None