Microsoft Excel

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…
How to Add Borders in Excel? 3 Easy Ways

(Note: This guide on how to add borders in Excel is suitable for all Excel versions including Office 365) Excel is one of the most popular data-handling applications. When working with large amounts of different data types, you might need to differentiate the data. To differentiate the data, Excel offers a variety of formatting options. One…
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…