Microsoft Excel
-
Creating a Dynamic Drop-Down List Using Data Validation in Excel
This Data Validation in Excel tutorial is suitable for users of Excel 2013, 2016, 2019, and Word for Microsoft 365. Objective Create a data validation drop-down list that dynamically updates when new items are added. Dynamic Data Validation Lists Explained Data Validation in Excel is a useful feature that allows you to control the type of…
-
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…
-
How to Use Conditional Formatting in Excel
This Conditional Formatting in Excel tutorial is suitable for users of Excel 2010, 2013,2016,2019, and Microsoft 365. Objective Use Conditional Formatting to highlight important data visually and identify patterns and trends. Conditional Formatting Explained Conditional Formatting changes the appearance of a cell or a range of cells based on conditions you specify. It makes it easy to highlight important information in a dataset,…
-
Using COUNTIFS in Excel
This COUNTIFS in Excel tutorial is suitable for users of Excel 2010/2013/2016/2019 and Microsoft 365. Objective Use the COUNTIFS function to count the number of cells in a range that match one or more criteria. COUNTIFS Explained COUNTIFS is a statistical function in Excel. It differs from its closely related friend COUNTIF, as it allows you to count…
-
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…
-
Using XLOOKUP in Excel
This XLOOKUP in Excel tutorial is suitable for users of Microsoft 365. Objective Use XLOOKUP in Excel to look in one column for a search term and return the result from the same row in another column. XLOOKUP Explained XLOOKUP is a new lookup function in Excel. If you have ever used (and struggled with) INDEX and MATCH or VLOOKUP to perform complex lookups, then XLOOKUP…
-
Excel Mac – Free Introductory Course
Follow along with this Excel Mac tutorial and download the practice exercise files here. Microsoft Excel for Mac is getting better. Microsoft has finally added more of the functionality available to PC users. If you’re using Excel for basic to intermediate spreadsheet work, then they pretty much offer a similar experience in terms of functionality. HOWEVER, While you…
