Live Classes
Custom Formatting in Excel – Recorded Webinar
In this month’s webinar, you’ll learn some amazing tips and tricks on custom formatting in Excel that can help improve your spreadsheet efficiency. Your Excel MVP, Deb Ashby, will explain what custom formatting is and walk you through some basic formatting examples. Learn about conditional formatting, how to copy custom formats, how to use emojis…
Cleaning Data in Power Query – Recorded Webinar
In this recorded live webinar, we’ll teach you the best tips and tricks for cleaning data in Power Query in Microsoft Excel. Your expert Excel trainer and Microsoft MVP, Deb Ashby, discusses what Power Query is and provides an example of what a messy Excel dataset looks like. She will walk you through importing a…
Practical Uses of Lookup Functions in Excel – Recorded Webinar
This recorded live webinar walks you through the practical uses of lookup functions in Excel. Deb Ashby, your Excel expert and Microsoft MVP, will teach you the different lookup functions that are available in Microsoft Excel and how to use them, including basic examples. Learn about the popular VLOOKUP, how to perform flexible lookups using…
PivotTable Tips and Tricks – Recorded Webinar
This recorded live webinar will teach you some of the best Excel PivotTable tips and tricks. Your expert Excel trainer, Deb Ashby, will walk you through the importance of cleaning data, working with both Excel tables and PivotTables, formatting tables, filtering and sorting data, creating a PivotChart, and so much more! In this month’s webinar,…
Practical Uses of Logical Formulas in Excel – Recorded Webinar
This recorded live webinar walks you through the practical uses of logical formulas in Excel. Deb Ashby, your expert Excel trainer, teaches you the different logical functions that are available in Excel and how to use them, including basic examples. This webinar covers the following: Watch the session here, and download the instructor demo files…
New Dynamic Array Functions in Excel – Recorded Webinar
This recorded live webinar is a follow on from last month’s webinar, dynamic arrays in Excel. In this webinar, Deb discusses NEW dynamic array functions in Excel that will help you elevate your Excel skills. In this webinar, Deb teaches you: Watch the session here, and download the instructor demo files to follow along. New…
Dynamic Array Functions in Excel – Recorded Webinar
This recorded live webinar will walk you through dynamic arrays in Excel. Dynamic arrays allow you to work with multiple values simultaneously in a formula. This feature enables Excel formulas to return numerous results based on a single formula entered in one cell. The results are also dynamic, meaning that if the source data changes,…
Excel Chart Formatting Tips and Tricks – Recorded Webinar
In this month’s member webinar, we learn some amazing Microsoft Excel chart formatting tips and tricks that can help you improve your spreadsheet efficiency. Join your expert Excel trainer, Deborah Ashby, in another amazing Excel webinar and let her guide you through working with Excel charts like a pro. Deb will discuss the following tips:…
Cool PowerPoint Hacks – Recorded Webinar
In this month’s member webinar, we talk about some cool PowerPoint hacks that you can utilize in 2023. Join your expert Microsoft trainer, Deborah Ashby, as she guides you through creating fantastic slide decks that stand out and avoid the dreaded “death by PowerPoint”. Deb will discuss the following tips: Watch the session here: Cool…
Excel Bad Habits (and how to change them!) – 1 Hour Recorded Webinar
In this month’s member webinar, we talk about the common Excel bad habits that we are all guilty of committing at one point in our spreadsheet journey and give you tips on how to change these bad habits. Join your expert Excel trainer, Deborah Ashby, in another amazing Excel webinar that can help you improve…
Top 20 Excel Efficiency Hacks to Improve Productivity (1-Hour Recorded Webinar)
In this month’s member webinar, we introduce 20 Excel tips and tricks to improve your productivity. These amazing Excel efficiency hacks will definitely help you work better with Excel and elevate your spreadsheets game. Deb, your professional trainer, covers the following: Watch the session here, and download the instructor demo files to follow along. Top…
Interactive Dashboards in Excel (1-Hour Recorded Webinar)
This recorded live webinar will walk you through creating interactive dashboards in Excel and the elements you can add or use for your dashboards. Our expert Excel and Microsoft trainer, Deb Ashby, shows you how to create amazing-looking graphs and charts in Excel, dashboards that update automatically when new data is added, and more! Deb…
