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.
- All Courses
- Data Analytics
- Data Analysis
- Data Analysis and Visualisation with Microsoft Excel Pro Course – Classroom
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
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
Testimonials
Take Yourself Further With Infero
Top Data Analysis FAQs
- Start: 9:00am
- Break: 11:00am
- Lunch: 1:00pm
- Break: 3:00pm
- Finish: 5:00pm