Intermediate Class
- Financial Formulas
- Borrowing and Investing Formulas
- Discounting and Depreciation Formulas
- Financial Schedules
- Array Formulas
- Introduction
- Dimensions of an Array
- Naming Array Constants
- Multicell Array Formulas
- Single-Cell Array Formulas
- Importing and Cleaning Data
- Importing Data
- Data Cleanup Techniques
- Exporting Data
- Charting Techniques
- Using Series Formula
- Creating links to cells
- Creating a Timeline
- Working with Trendlines
- Creating interactive Charts
- Pivot Tables
- Data Appropriation for a Pivot Table
- Creating Pivot Table Automatically and Manually
- Grouping Pivot Table Items
- Creating Frequency Distribution and Calculated Field
- Conditional Formatting
- Using Data bars, color scales and icon sets
- Formula-Based Rules
- Conditional formats
- Data Validation
- Data Validation Rules
- Data Validation formula
- Creating a Drop-Down List
- Cell References