Advanced Excel

Apply Custom Formats and Layouts

  • Apply Custom Data Formats
  • Use Advanced Fill Options
  • Apply Advanced Conditional Formatting and Filtering
  • Apply Custom Styles and Templates
  • Use Form Controls
  • Prepare Workbooks for Internationalization
  • Use Outlines
  • Use Custom Views

Create advanced formulas

  • Functions
  • Apply functions in formulas
  • Mathematical Functions
  • Financial functions
  • Useful Data Functions
  • Some Other Useful Functions
  • Look up data by using functions
  • Apply advanced date and time functions
  • Functions for Manipulating Text
  • Arrays

Use Scenarios

  • Use What-If Analysis Tools
  • Create Scenarios
  • Merge Scenarios
  • Create Scenario Summaries
  • Use Data Tables

Create Advanced Charts

  • Basic Excel Charts
  • Use Area, Scatter & Stock Charts
  • Use Surface, Radar & Combination Charts
  • Create Custom Chart Templates
  • Work with Sparkline’s

Pivot Tables & Charts

  • Pivot Tables
  • Use Pivot Charts

Manage and Share Workbooks

  • Manage Workbook Versions
  • Copy Styles between Workbooks
  • Copy Macros between Workbooks
  • Use Track Changes and Comments
  • Merge Workbooks
  • Protect Workbooks for Sharing
  • Connect To External Data
Scroll to Top