Microsoft Excel
Dynamic Array Functions in Excel (XLOOKUP, FILTER, UNIQUE, XMATCH): Webinar Recording
We were once again joined by Excel expert, Deb Ashby, who took us through the Array Functions introduced in Microsoft Excel a few years ago. These functions replace and improve upon some existing functions (XLOOKUP instead of INDEX, MATCH). In this Dynamic Array session Debs covers the following Excel Functions: FILTER RANDARRAY SEQUENCE UNIQUE SORT…
The Excel FILTER Function
This Excel FILTER Function tutorial is suitable for users of Excel for Microsoft 365 Objective Use the Excel Filter Function to filter a range of data based on criteria you define to extract matching records. The Excel FILTER Function Explained The FILTER function is a new function available to Microsoft 365 users to filter data based on criteria…
Ten Ways to Clean Data in Excel
This 10 Ways to Clean Data in Excel tutorial is suitable for users of Excel 2013/2016/2019 and Microsoft 365. Objective Use Excel’s functions and utilities to clean a raw dataset, removing errors and making it consistent ready for analysis. Cleaning Data Explained Data is the foundation of any analysis you do in Excel. If you receive a dataset…
Basic Forecasting in Excel: Recorded Webinar
In this Excel tutorial, we take you through some of the formulas and functions you can use to perform basic forecasting in Excel. Forecasting is essential to make sure you plan correctly in business and is used everywhere. Excel is packed with forecasting formulas and functions aimed at helping you predict future results based on…
Creating a Dynamic Pivot Chart Title Based on Slicer(6 Easy Steps)
This Dynamic Pivot Chart Title tutorial is suitable for users of Excel 2013/2016/2019 and Excel for Microsoft Office 365. Objective Create a dynamic Pivot Chart title using the new TEXTJOIN function that changes depending on the selection made in the slicer. In this tutorial I’ll cover: What is a Dynamic Pivot Chart Title? Video Tutorial – Pivot Chart Title Based on Slicer How to…
Using GETPIVOTDATA in Excel
This GETPIVOTDATA tutorial is suitable for users of Excel 2013/2016/2019 and Excel for Microsoft 365. Objective Use the GETPIVOTDATA function in Excel to reference values in cells contained within a PivotTable. In this guide, you’ll learn: What is GETPIVOTDATA? Video Tutorial – GETPIVOTDATA Excel How to Use GETPIVOTDATA in Excel? How to Toggle GET PIVOT Off/On? How to…
Advanced PivotTables – 1 Hour Crash Course
In this 1-hour class, we take you through some Advanced PivotTables tips and tricks. The PivotTable is one of the most popular, and powerful functions Excel offers. In this advanced session, we take a look at how to get the most from this super function. Once again, this advanced Excel Tutorial was hosted by the…
Excel INDIRECT Function—The Best Guide with 5 Examples
This tutorial on the INDIRECT function in Excel is suitable for users of Excel 2013/2016/2019 and Microsoft 365. This guide deals with the INDIRECT function in Excel. We’ll cover, Table Of Contents Objective The Excel INDIRECT Function — Explained INDIRECT Function Syntax Video Tutorial for INDIRECT Function How to use the INDIRECT function? Example 1…
How to use the OFFSET function in Excel
This tutorial on how to use the OFFSET function in Excel is suitable for users of Excel 2013/2016/2019 and Microsoft 365. Objective Use the OFFSET function to return a cell or range of cells that is a specified number of rows and columns from a cell or range of cells. The OFFSET Function Explained The OFFSET function is part of the…
Getting Started with Power Pivot: Advanced Excel
Power Pivot is a tool in Excel that enables us to create data models and perform more complex operations than the standard Pivot Tables allow. You may have seen references to the data model in Excel before when creating PivotTables – this is Power Pivot. It is also known as the data model. This article…
What-If Analysis in Excel – Recorded Excel Live Class
In this 1-hour class, we look at the awesome power of What-If Analysis in Excel. What If Analysis in Excel allows you to test out different scenarios without complex formulas. In this tutorial we cover Goal Seek, Scenario Manager, Data Tables, and Solver. Once again, this class was hosted by the excellent Deborah Ashby. In…
Pivot Charts in Excel Tutorial
This Pivot Charts in Excel tutorial is Suitable for users of Excel 2010/2013/2016/2019 and Microsoft 365. Objective Create an interactive Pivot Chart in Excel from a raw dataset and customize it to suit your needs. What is a Pivot Chart? Whenever I hear the word ‘Pivot’ I immediately think about that scene in ‘Friends’. Ross, Rachel and…
