Unlock the full potential of Microsoft Excel to increase your productivity and precision in this hands-on, skill-focused webinar designed specifically for administrative professionals. Join Excel expert David Ringstrom, CPA, as he walks you through powerful yet practical Excel fundamentals that can transform the way you manage data and perform routine tasks. Through clear, step-by-step instruction, David demonstrates essential features such as pivot tables, lookup functions, and the Table and Slicer tools, all aimed at improving accuracy, minimizing manual input, and streamlining your workflow.
David teaches each concept twice—first via easy-to-follow PowerPoint slides, and then directly in Microsoft 365 Excel—making it easy to follow along and retain the techniques. You'll also receive a comprehensive workbook with live examples and detailed handouts, including version-specific tips for Excel 2021, 2019, 2016, and earlier. Whether you're just starting to explore Excel’s capabilities or looking to polish your foundational skills, this course equips you with practical tools you can apply immediately.
Areas Covered in the Session:-
- Creating and modifying pivot tables
- Using the Table feature to enhance data integrity
- Utilizing the Slicer tool for quick data filtering
- Eliminating duplicate entries efficiently
- Applying lookup functions such as VLOOKUP and SUMIF
- Adjusting data entry settings for improved workflow
Why Should You Attend?
- Recall how to change the cursor direction to facilitate faster data entry in Excel.
- State the arguments used in Excel's VLOOKUP function.
- Identify the steps required to create a pivot table.
- Improve spreadsheet reliability using functions like VLOOKUP and SUMIF.
- Remove duplicates and filter data effectively with the Slicer feature.
- Create instant reports and drill down into data using pivot tables.
- Understand the differences in Excel functionality between Microsoft 365 and perpetual versions.
This webinar is a valuable opportunity for professionals aiming to strengthen their command of Excel and increase both speed and accuracy in daily tasks. You’ll gain time-saving techniques and practical knowledge that can make an immediate impact in your role.
Who Will Benefit?
Administrative professionals and office staff who work with spreadsheets and are looking to improve data management skills using core Excel features.
Order Now!
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.