Advanced Excel for Data Analysis

This course focuses on how to effectively and efficiently utilize Microsoft Excel for data analysis. Learn how to save time and perform more detailed analysis quickly.

In this course you will:

  • Apply commonly-used formulas in new and different ways
  • Uncover often over-looked Excel formulas
  • Streamline number crunching and analysis via functions and tools including pivot tables, sumif, sum+if, transpose, working with arrays, vlook-up, subtotals, and regression analysis
  • Enhance your spreadsheets with drop-down boxes, data validation techniques, and automation of alternate row shading
Please allow 24 hours for purchase to be processed before you can access this online course.