Lew

CIS125E Xlookup Explanation
CIS125E Xlookup Explanation
IFERROR function
IFERROR function
How to Protect a worksheet
How to Protect a worksheet
3d Cell References in Excel
3d Cell References in Excel
Hyperlinks in Excel
Hyperlinks in Excel
Working with grouped worksheets
Working with grouped worksheets
Scenario Summary
Scenario Summary
Goal Seek
Goal Seek
One and Two Variable Data Tables
One and Two Variable Data Tables
Net Present Value and Internal Rate of Return in Excel
Net Present Value and Internal Rate of Return in Excel
CIS125E Financial Functions in Excel
CIS125E Financial Functions in Excel
Map Chart
Map Chart
Switch, IFS, AND OR functions
Switch, IFS, AND OR functions
CIS125E More Date and Time Functions
CIS125E More Date and Time Functions
Referencing Tables data in two way lookup
Referencing Tables data in two way lookup
Control User Input - Data Validation
Control User Input - Data Validation
Creating and Using Named Ranges
Creating and Using Named Ranges
Subtotal Function
Subtotal Function
Table Slicers
Table Slicers
Two way lookup using nested XLOOKUP
Two way lookup using nested XLOOKUP
Index_Match functions
Index_Match functions
Drill Down in a Pivot Table
Drill Down in a Pivot Table
Pivot Tables Show Values As
Pivot Tables Show Values As
Pivot Charts
Pivot Charts
Pivot Table Calculated Item and Fields
Pivot Table Calculated Item and Fields
Pivot Table Slicers
Pivot Table Slicers
Sorting and Filtering a Pivot Table
Sorting and Filtering a Pivot Table
GetPivotData Function
GetPivotData Function
Grouping and Subtotals
Grouping and Subtotals
CIS125E Using Icons and Shapes in Excel
CIS125E Using Icons and Shapes in Excel