Excel – Intermediate

 Excel New Features

  • Chart Recommendations
  • Format Charts
  • Chart Design
  • Richer Data Labels
  • Leader Lines
  • New Functions

    Fundamental Data Analysis

  • Instant Data Analysis
  • Sorting Data by Color
  • Slicers
  • Flash Fill

    Powerful Data Analysis

  • PivotTable Recommendations

    Powerful Data Analysis – 1

  • Data Model
  • Power Pivot
  • External Data Connection
  • Pivot Table Tools

    Powerful Data Analysis – 2

  • Power View
  • Visualizations
  • Pie Charts
  • Additional Features
  • Power View Services
  • Format Reports
  • Handling Integers

    Other Features

  • Templates
  • Inquire
  • Workbook Analysis
  • Manage Passwords
  • File Formats
  • Discontinued Features