Microsoft Excel
-
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…
-
Dynamic Arrays in Excel: Eight, Must-Know Formulas
This Dynamic Arrays in Excel tutorial is suitable for users of Excel for Microsoft 365. Objective Explore Microsoft’s NEW Dynamic Array functions in Excel and use them effectively to solve problems. Dynamic Arrays in Excel Explained Dynamic Array Formulas were introduced by Microsoft in 2018 and are the most significant change to Excel formulas in years. Dynamic Arrays allow you to work…
-
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 using Slicers
This Dynamic Pivot Chart Title tutorial is suitable for users of Excel 2013/2016/2019 and Excel for Microsoft 365. Objective Create a dynamic Pivot Chart title using the new TEXTJOIN function that changes depending on the selection made in the slicer. What is a Dynamic Pivot Chart Title? A dynamic Pivot Chart title is a title that changes based on the selection you have made. For example, if you…
-
Using GETPIVOTDATA in Excel
This GETPIVOTDATA in Excel 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. What is GETPIVOTDATA? GETPIVOTDATA is a function in Excel that belongs to the Lookup and Reference group of functions. It allows you to create a formula…
-
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…
