Microsoft Excel
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,…
How to Use Custom Number Formatting in Excel
(Note: Suitable for users of Excel 2013, 2016, 2019, 2021, and Excel for Microsoft 365.) Objective Understand how custom number formats work and how you can create your own custom number formatting. Custom Number Formatting in Excel Explained If you’ve been using Excel for a while, you are probably aware of how we can change…
How to Build Your Own Excel Functions with the LAMBDA Function
(Note: Suitable for users of Excel 2021 and Excel for Microsoft 365.) Objective Use the new LAMBDA function to build your own Excel functions. LAMBDA Function Explained The new LAMBDA function in Excel is a game-changer! It allows us to create custom functions that can be called by user-friendly names and reused throughout the workbook….
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:…
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…
How to Generate Datasets in Excel with Functions and Utilities
(Note: Suitable for users of Excel 2021 and Excel for Microsoft 365.) Objective Generate a ‘dummy’ dataset quickly for practice or training purposes using Excel functions and utilities. How to Generate Datasets in Excel Explained Finding good and, most importantly, free datasets to download from the web is not an easy task. Most datasets we…
How to Use the AGGREGATE Function in Excel
(Note: Suitable for users of Excel 2016, 2019, 2021, and Excel for Microsoft 365.) Objective Use the AGGREGATE Function in Excel to return an aggregate calculation, optionally ignoring errors values and hidden rows. The AGGREGATE Function Explained The AGGREGATE function in Excel returns an aggregate calculation like SUM, AVERAGE, COUNT, MIN, MAX etc. We can…
Dynamic Arrays: How to Use the Excel SEQUENCE Function and Unstacking Records
(Note: Suitable for users of Excel 2021 and Excel for Microsoft 365.) Objective Use the SEQUENCE Function to generate a list of sequential numbers in an array and see how the SEQUENCE Function can be combined with other Excel functions to provide practical solutions to common problems. The SEQUENCE Function Explained In its simplest form,…
What-If Analysis: How to Create One and Two Variable Data Tables in Excel
(Note: Suitable for users of Excel 2016, 2019, 2021, and Excel for Microsoft 365.) Objective Use one-variable and two-variable data tables in Excel to vary the interest rate and term length for a loan, to evaluate potential monthly payment amounts. Data Tables in Excel Explained Data tables are part of a suite of utilities known…