Visual Excel – Data Analysis and Visualisation with Microsoft Excel

REIM Training Solutions

Visual Excel – Data Analysis and Visualisation with Microsoft Excel

75 75 people viewed this event.

Learn how to analyse your data set to identify issues, patterns, insights, and opportunities.  Discover how Excel can draw data from various sources, perform sophisticated analysis and visualise findings in ways that are easy to understand.  This course is about learning the functionality in Excel that will turn your data into information enabling you to make informed decisions.

 

Choice of Flexible Delivery Options:

 

~  2 Day of Training

~  4 Mornings  /  4 Afternoons  /   4 Evenings

 

Enquire Now

 

Date And Time

-
 

Location

Online event
 

Event Category

 
Download Events iCal

Share With Friends

Who Should Attend

This course is designed for students who already have  a working knowledge of Excel and are ready to perform more sophisticated data and statistical analysis with Microsoft Excel using PivotTables,  Power Pivot and the Data Analysis ToolPak.  Participants will also learn how to visualize data and insights using advanced visualizations in charts and dashboards in Excel.

Learning Objectives

Upon completion of this course learners will be able to competently:

  • Perform the basics of analysis
  • Visualize data with Excel
  • Analyze data with formulas and functions
  • Analyze data with PivotTables
  • Present visual insights with dashboards in Excel
  • Perform statistical analysis
  • Obtain and transform data
  • Model and analyze data with Power Pivot

Prerequisites

Learners should have a working knowledge of Microsoft Excel worksheets, creating workbooks with formulas and functions.

Course Outline

  1. Fundamentals of Data Analysis
  2. Data Visualisation with Charts
  3. Using Formulas and Functions for Data Analysis
  4. Using Pivot Tables for Data Analysis
  5. Presenting Visual Insights with Dashboards in Excel
  6. Statistical Analysis in Excel
  7. Obtaining and Transforming Data
  8. Modeling and Analyzing Data with Power Pivot

Scroll to Top