Advanced Excel is the first step towards Analytics. Learn all the tips, tricks, shortcuts, functions and formulas you need to be an Excel power user.

What You’ll Learn

  • Getting Started with Excel
  • Data Entry, Data Editing, and Number Formatting
  • Data Formatting
  • Working with Cells and Ranges in Excel
  • Managing Worksheets
  • Introduction to Excel Tables
  • Auto-fill, Custom Lists, and Flash Fill
  • Number Formatting in Excel
  • Excel Formula Basics
  • Logical Formulas in Excel
  • Math Formulas in Excel
  • Lookup and Reference Formulas in Excel
  • Stats Formulas in Excel
  • Text Formulas in Excel
  • Date and Time Formulas in Excel
  • Formulas Mix and Match (10 Examples)
  • Named Ranges in Excel
  • Data Validation in Excel
  • Data Sorting and Filtering in Excel
  • Using Conditional Formatting in Excel
  • Introduction to Excel Charting
  • 10 Advanced Excel Charting Examples
  • Dynamic Charts in Excel
  • Overview of Excel Pivot Table
  • Protection in Excel
  • Arrays
  • Trend Linest
  • What If Analysis Goal – Seek Solver Scenario Analysis Data Tables
  • Add-ins
  • Introduction to Macros and VB Editor

Requirements

  • A computer or laptop with Windows (some techniques might not work on Mac)
  • No prior Excel knowledge is needed.
  • Willingness to learn.