Data Analysis and Visualization with Excel

Course objective

Gain the knowledge and skills needed for data analytics as a crucial step in any decision-making process to ensure successful outcomes company-wide. In this course you’ll learn how to analyse data with formulas and functions; analysing data with PivotTables, present visual insights with dashboards in excel, and many more.

What is included

  • Pre and post assessment
  • Flashcards and quizzes
  • Virtual labs
  • Study planner
  • Certification of completion

Course outline

  • Introduction
  • Data Analysis Fundamentals
  • Visualizing Data with Excel
  • Analyzing Data with Formulas and Functions
  • Analyzing Data with PivotTables
  • Presenting Visual Insights with Dashboards in Excel
  • Creating Geospatial Visualizations with Excel
  • Performing Statistical Analysis
  • Getting and Transforming Data
  • Modeling and Analyzing Data with Power Pivot
  • Presenting Insights with Reports