Data Analysis and Visualisation with Microsoft Excel Introduction Course – Classroom

Start by learning the basics of Data Analysis with Excel, such as formulas, functions, and PivotTables. Then, explore how to effectively convey data insights through visual aids.

Data Analysis and Visualisation with Microsoft Excel Introduction Course – Classroom

100% Money Back Guarantee

Free Assessment

Post Course Support

All Courses
Data Analytics
Data Analysis
Data Analysis and Visualisation with Microsoft Excel Introduction Course – Classroom

Course Overview

This intensive 1 day, hands-on course is part 3 days Data Analysis and Visualisation with Excel PRO course and will introduce you to basics of Data Analysis and will help you gain comprehensive, practical understanding of Data Analysis using Excel.

Analysing data to find issues, insights, and opportunities is now a critical part of many job roles. Beyond the analysis, data analysts in all job roles must be able to effectively present and communicate their findings in visually compelling ways.

You will gain a fundamentals of performing data analysis, visualise data with Excel, analyse data with formulas and function, and PivotTables.

This course is suitable for anybody wanting to learn any version between 2007 and latest 2021. Our courses cover all differences between the versions.

Price

£248 + VAT

Duration

1 Day

Training Options

Classroom

Course Content Objectives Delivery Method What’s Included Who is it for? Prerequisite Certification

Data Analysis and Visualisation with Microsoft Excel Introduction Course Content:

Lesson 1: Data Analysis Fundamentals

Topic A: Introduction to Data Science
Topic B: Create and Modify Tables
Topic C: Sort and Filter Data

Lesson 2: Visualising Data with Excel

Topic A: Visualise Data with Charts
Topic B: Modify and Format Charts
Topic C: Apply Best Practices in Chart Design

Lesson 3: 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 Visualisations with Lookup Functions

Lesson 4: Analysing Data with PivotTables

Topic A: Create a PivotTable
Topic B: Analyse PivotTable Data

Upon successful completion of this course, students will be able to:

Perform data analysis fundamentals
Visualise data with Excel
Analyse data with formulas and functions
Analyse data with PivotTables
Present visual insights with dashboards in Excel

Instructor led, group-paced, classroom-delivery learning model with structured hands-on activities.

Professional Microsoft Certified Trainer
CPD Accredited Classroom training in Small Groups for Max Focus
Only Microsoft Approved Courseware and Exercise Files are used
Free Assessment of Skills prior to booking
Certificate of Completion & Complementary 12 Months Post Course Support
100% Money Back Guarantee & Price Match Guarantee
Bespoke Courses & Group Discounts from £89 per person

This course is designed for students who already have foundational knowledge and skills in Excel and who wish to perform robust and advanced data and statistical analysis with Excel using PivotTables, use tools such as Power Pivot and the Analysis ToolPak to analyse data, and visualise data and insights using advanced visualisations in charts and dashboards in Excel.

To ensure success in Data Analysis and Visualisation course with Excel Introduction, you should have baseline skill using Microsoft Excel worksheets, particularly in creating workbooks with formulas and functions.

To meet this prerequisite, you can take any one or more of the following courses:

Microsoft Excel Introduction
Microsoft Excel Intermediate
Microsoft Excel Advanced

This course is one of a series of courses that addresses Microsoft Certified Application Specialist (Microsoft Business Certification) skill sets.

The Microsoft Certified Application Specialist program is for individuals who use Microsoft’s business desktop software and who seek recognition for their expertise with specific Microsoft products. Certification candidates must pass one or more proficiency exams in order to earn Microsoft Certified Application Specialist certification.