Use the Data Analysis and Visualisation with Excel course and lab to learn the skills of excel data visualisation. The course and lab provide knowledge and skills required for analysing data with formulas and functions; analysing data with PivotTables, presenting visual insights with dashboards in excel. This course also provides knowledge related to analysing data with the data analysis ToolPak, connecting to Data with Queries.
Lessons 1: Introduction
- Course Description
- How to Use This Course
- Course-Specific Technical Requirements
Lessons 2: Data Analysis Fundamentals
- Topic A: Introduction to Data Science
- Topic B: Create and Modify Tables
- Topic C: Sort and Filter Data
Lessons 3: Visualising Data with Excel
- Topic A: Visualise Data with Charts
- Topic B: Modify and Format Charts
- Topic C: Apply Best Practices in Chart Design
Lessons 4: Analysing Data with Formulas and Functions
- Topic A: Analyse Data with Formulas and Named Ranges
- Topic B: Analyse Data with Functions
- Topic C: Implement Data Validation, Forms, and Controls
- Topic D: Create Conditional Visualizations with Lookup Functions
Lessons 5: Analysing Data with PivotTables
- Topic A: Create a PivotTable
- Topic B: Analyse PivotTable Data
Lessons 6: Presenting Visual Insights with Dashboards in Excel
- Topic A: Visualise Data with PivotCharts
- Topic B: Filter Data Using Slicers and Timelines
- Topic C: Create a Dashboard in Excel
Lessons 7: Creating Geospatial Visualisations with Excel
- Topic A: Create Map Charts in Excel
- Topic B: Customise Map Charts in Excel
Lessons 8: Performing Statistical Analysis
- Topic A: Visualise Trendlines and Sparklines with Excel
- Topic B: Analyse Data with the Data Analysis ToolPak
Lessons 9: Getting and Transforming Data
- Topic A: Connect to Data with Queries
- Topic B: Clean and Combine Data
- Topic C: Shape and Transform Data
Lessons 10: Modelling and Analysing Data with Power Pivot
- Topic A: Install Power Pivot in Excel
- Topic B: Create Data Models with Power Pivot
- Topic C: Create Power Pivots
- Topic D: Perform Advanced Data Analysis and Visualisation
Lessons 11: Presenting Insights with Reports
- Topic A: Plan a Report
- Topic B: Create a Report
Hands-on LAB Activities
Data Analysis Fundamentals
- Analysing Data
- Creating and Modifying a Table
- Sorting and Filtering Data
Visualising Data with Excel
- Creating Charts
- Modifying and Formatting Charts
- Applying the Best Practices of Chart Design
Analysing Data with Formulas and Functions
- Analysing Data Using Formulas
- Analysing Data Using Functions
- Working with Logical Functions
- Implementing Data Validation
- Implementing Form Controls
- Using LOOKUP Functions
Analysing Data with PivotTables
- Creating PivotTables
- Analysing the PivotTable Data
Presenting Visual Insights with Dashboards in Excel
- Visualising Data with PivotCharts
- Filtering Data Using Slicers
- Filtering Data Using Timelines
- Creating a Dashboard in Excel
Creating Geospatial Visualisations with Excel
- Creating Map Charts in Excel
- Formatting and Customising Map Charts
Performing Statistical Analysis
- Visualising Trendlines in Excel
- Visualising Sparklines in Excel
- Installing and Activating the Data Analysis ToolPak
- Performing Statistical Analysis with the Data Analysis ToolPak
Getting and Transforming Data
- Connecting to Data with Microsoft Power Query
- Cleaning and Combining Data using the Power Query Editor
Modelling and Analysing Data with Power Pivot
- Installing and Activating Power Pivot
- Creating Data Models with Power Pivot
- Creating Power Pivots
- Creating a KPI
- Creating a New Perspective
Presenting Insights with Reports
- Creating a Report in Excel
- Creating a Template of a Report
Exam FAQs
FAQ's are not Available for this course.Summary
Standard:
Data Analysis & Visualisation
Lessons:
11+ Lessons
Delivery Method:
Online
Language:
English