Microsoft Excel – Intermediate

Course Modules

• Module 1: Referencing Calculations
  

  Topic A: Formula Reference
  – Relative References
  – Absolute References
  – Mixed References

• Module 2: Working with Functions
  

  Topic A: Data Summary with Function
  – COUNTA
  – AVERAGEA

  Topic B: Conditional Data Summary 1
  – COUNTIF
  – AVERAGEIF
  – SUMIF

  Topic C: Conditional Data Extraction
  – IFERROR
  – IF

• Module 3: Organizing Dynamic Data Range with Tables

  Topic A: Create and Modify Tables
  – Create table
  – Styles and Quick Style Sets
  – Removing Duplicate Values

  Topic B: Sort and Filter Data
  – Sorting Data
  – Filtering Data
  – Advanced Filtering

  Topic C: Use Subtotal to Calculate Data
  – Total Row with SubTotal Functions

• Module 4: Visualizing Data as a Graphics

  Topic A: Conditional Formatting
  – Highlight Cell Rules
  – Using Data Bars
  – Using Icon Sets
  – Creating New Rules with Formula

  Topic B: Create Charts
  – Charts
  – Chart Types
  – Chart Insertion Methods
  – Resizing and Moving the Chart
  – Adding Additional Data
  – Switching Between Rows and Columns

  Topic C: Modify and Format Charts
  – Difference Between Modifying and Formatting
  – Chart Elements
  – Minimize Extraneous Chart Elements
  – The Chart Tools Contextual Tabs
  – Formatting the Chart with a Style
  – Adding a Legend to the Chart

• Module 5: Setting Up Reports as Pages

  Topic A: Managing Multiple Windows
  – Arranging Workbooks
  – Comparing Workbooks Side by Side
  – Synchronous Scrolling and Resetting a Window