Microsoft Excel
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…
Best Excel Formulas: Part 2 (11-20): Essential Excel Formulas to change how you work FOREVER!
Top Excel Functions Microsoft Excel is a versatile tool that goes beyond simple data entry and calculations. With the right formulas, you can transform Excel into a powerhouse for data analysis, decision-making, and automation. In today’s data-driven world, proficiency in Microsoft Excel is more than just a valuable skill—it’s a necessity. Welcome to the second…
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…
Best Excel Formulas: Part 1(1-10): Essential Excel Formulas to change how you work FOREVER!
Top Excel Functions In today’s data-driven world, proficiency in Excel is a highly sought-after skill across many professions. With its vast array of functions, Excel can help you manipulate and analyze data efficiently, making it an indispensable tool for decision-making processes. This tutorial provides a comprehensive guide to ten essential Excel functions: SUM, COUNT, COUNTIF,…
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…
How to Link Form Controls to Charts in Excel
(Note: Suitable for users of Excel 2013, 2016, 2019, 2021, and Excel for Microsoft 365.) Objective Link combo box and option group form controls to an Excel chart. How to Link Form Controls to Charts Explained Form Controls are objects that can be inserted anywhere in a workbook to handle the data that is displayed….
How to Use Excel Functions to Forecast Data
(Note: Suitable for users of Excel 2016, 2019, 2021, and Excel for Microsoft 365.) Objective Use Forecast Functions in Excel to create a linear and seasonal forecast with upper and lower confidence levels. Using Excel Functions to Forecast Data Explained Forecasting is a technique that uses historical inputs to predict future values. Many businesses use…
How to Add Dynamic Totals to a Stacked Column Chart in Excel
(Note: Suitable for users of Excel 2016, 2019, 2021, and Excel for Microsoft 365.) Objective Add dynamic totals to a stacked column chart. Dynamic Totals Explained When we use a stacked column chart to display data, we can add data labels to each ‘stack’ to show the value the stack represents. However, what if we…
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,…
