Microsoft Excel
-
Advanced Formulas in Excel – 1 Hour Recorded Webinar
In this one hour, recorded live webinar, Deb Ashby takes us through some Advanced Formulas in Excel. Deb starts by looking at logical functions and two-way lookups before moving onto combining a number of more advanced functions to solve complex problems in Excel. Here’s what she covers in detail: Logical Functions (IF, IFS, AND, OR)…
-
How to Make a Formula in Excel – Excel Basics
This How to Make a Formula in Excel tutorial is suitable for users of Excel 2013/2016/2019 and Microsoft 365. OBJECTIVE Explore Excel functions and create simple formulas from scratch to perform calculations. FUNCTIONS AND FORMULAS EXPLAINED If Excel is known for one thing, it’s formulas. Being able to perform simple to very complex calculations by learning how to…
-
Using the LET Function in Excel
This LET Function in Excel tutorial is suitable for users of Excel for Microsoft 365. OBJECTIVE Use the new LET function in Excel to define a calculation once and use it multiple times in a single formula. THE LET FUNCTION EXPLAINED The new LET function is part of the Text group of functions in Excel. It allows you to assign names to calculate…
-
The Excel Solver Add-In: Five Minute Tutorial
This Excel Solver Add-In tutorial is suitable for users of Excel 2013/2016/2019 and Microsoft 365. Objective Use the Excel Solver add-in to help you solve basic to complex problems in Microsoft Excel. Excel Solver Explained Excel includes an analysis utility called Solver. It’s available as an add-in and helps you solve problems and find the optimum solution for any given scenario. Loading…
-
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…
-
Creating an Excel Dashboard in 5 Minutes
This Excel Dashboard tutorial is suitable for users of Excel 2013/2016/2019 and Microsoft 365. Objective Create a simple interactive dashboard in Excel to display critical metrics in 5 minutes. Excel Dashboards Explained An interactive dashboard is a data management tool that harnesses the power of Excel data analysis tools such as Pivot Tables and Pivot Charts to track, analyze, monitor, and display key…
-
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…