In this video we’ll discuss
- What is a named range?
- How to create your first one
- How to use named ranges in a formula
- How to create a pivot table using a named range
Category: Videos
How to Filter Data in Microsoft Excel
In this video we discuss how to filter data properly, how to add multiple criteria to a filter, and how to use the Top 10 feature of filters
Top 3 Mistakes made by Beginners in Excel
In this video we dive in to the top three mistakes by those new with Microsoft Excel:
1. Not structuring data properly and creating formulas at all corners of your worksheet
2. Not using keyboard shortcuts to navigate through your workbook
3. Not filter data correctly and potentially ruining your data set.