Intermediate Class

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
Scroll to Top