Data Analysis and Visualisation with Microsoft Excel Pro Course – Classroom

Go from beginner to expert in Data Analysis and Visualisation with Excel to organise and manipulate large data sets and create visualisations and reports of insights and trends.

Section background Data Analysis and Visualisation with Microsoft Excel Pro Course – Classroom
100% Money Back Guarantee
Free Assessment
Post Course Support
Share This

Course Overview

This intensive 3 days, hands-on Data Analysis and Visualisation with Excel PRO course takes you from beginner to advance level and helps 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 solid understanding of Data Analysis tools to help you organise, manipulate, and report on large amount of data in the best way possible, including connecting to a wide range of data sources, perform robust data analysis, create divers and robust data-backed visualisations to show insight and trends, and create reports.

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

£744 + VAT

Duration

3 Days

Training Options

Classroom

Data Analysis and Visualisation with Microsoft Excel Pro 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

Lesson 5: 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

Lesson 6: Creating Geospatial Visualisations with Excel

  • Topic A: Create Map Charts in Excel
  • Topic B: Customise Map Charts in Excel

Lesson 7: Performing Statistical Analysis

  • Topic A: Visualise Trendlines and Sparklines with Excel
  • Topic B: Analyse Data with the Analysis ToolPak

Lesson 8: Getting and Transforming Data

  • Topic A: Connect to Data with Queries
  • Topic B: Clean and Combine Data
  • Topic C: Shape and Transform Data

Lesson 9: Modeling 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

Lesson 10: Presenting Insights with Reports

  • Topic A: Plan a Report
  • Topic B: Create a Report

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
  • Create geospatial visualisations with Excel
  • Perform statistical analysis
  • Get and transform data
  • Model and analyse data with Power Pivot
  • Present insights with reports

Instructor led, group-paced, virtual 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 PRO, 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.

Choose Your Date & Location

Start Date
Location
Session Times
Duration
Price (Excl Tax)
Please contact us for information
Birmingham
There is no public schedule for this course
3 Days
£744
Please contact us for information
Bristol
There is no public schedule for this course
3 Days
£744
Please contact us for information
Leeds
There is no public schedule for this course
3 Days
£744
Please contact us for information
Leicester
There is no public schedule for this course
3 Days
£744
Please contact us for information
Liverpool
There is no public schedule for this course
3 Days
£744
Please contact us for information
London
There is no public schedule for this course
3 Days
£744
Please contact us for information
Manchester
There is no public schedule for this course
3 Days
£744
Please contact us for information
Nottingham
There is no public schedule for this course
3 Days
£744

Testimonials

quote image
quote image
The Data Analysis and Visualisation Intro course at Infero exceeded my expectations. The course was well-structured and covered all the essential aspects of data analysis. The real-world examples and case studies were particularly helpful. I feel much more confident analysing data now, and it has already made a positive impact on my career.

Whitney Perkins

quote image
quote image
Attending the course was the best investment in my future. The topics were rigorous but well-paced, and the instructors were always available to help. I went from having no experience to doing the basics. I’m now working at a new job as I can utilise my skills.

Ali Chaney

quote image
quote image
The data analytics course at Infero was incredibly insightful. The combination of theoretical knowledge and practical application was perfect. The use of real-world business scenarios helped me understand complex concepts easily. I feel much more equipped to make data-driven decisions at my job.

Francis Winter

Top Data Analysis FAQs

What is the schedule for the training course?
  • Start: 9:00am
  • Break: 11:00am
  • Lunch: 1:00pm
  • Break: 3:00pm
  • Finish: 5:00pm
The schedule for 1, 2 and 3 days training will be the same but course content will vary. Times can be changed for group and onsite to start earlier, you can ask before booking.
Do I need any equipment for training?
For Classroom training courses you usually don’t need any equipment, unless we specifically advise otherwise. For Live Virtual training courses you will only need a computer, or laptop, and Internet access.
Can we have a course in our own workplace?
If you are interested in having a training course at your own workplace, whether it be through one-to-one sessions or group training, we offer Onsite Bespoke courses.
How do I know if this course is right for me?
Although you can start the training course at beginner’s level, knowledge of Excel at Intermediate level will ensure your success in this course. To find more give us a call or follow the training course’s prerequisites section above.
How experienced are your tutors?
Our company prides itself on the quality of our training courses, which is not possible without our exceptional trainers! Our tutors have both practical and teaching experience, and specialist knowledge. We are happy to provide references and their profiles upon request.
Is there ongoing support after completing the course?
Absolutely! Following the training course, we provide a variety of post-course support documents so you can revisit the content at your own pace, along with offering 12 months of support via email.
Will I receive a certificate upon completion?
Yes, all of our training courses come with a certificate of completion. Once you finish the course, we will email your certificate to you within 2-3 working days.

Looking to book some training for your team?

Request a Quote