Visual Excel – Data Analysis and Visualisation with Microsoft Excel
Visual Excel – Data Analysis and Visualisation with Microsoft Excel
17 17 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
Organiser
REIM Training Solutions
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
- Fundamentals of Data Analysis
- Data Visualisation with Charts
- Using Formulas and Functions for Data Analysis
- Using Pivot Tables for Data Analysis
- Presenting Visual Insights with Dashboards in Excel
- Statistical Analysis in Excel
- Obtaining and Transforming Data
- Modeling and Analyzing Data with Power Pivot
