Course description
Data Analysis and Visualisation (3day)
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.
Do you work at this organisation and want to update this page?
Is there out-of-date information about your organisation or courses published here? Fill out this form to get in touch with us.
Upcoming start dates
Suitability - Who should attend?
Prerequisites
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. You can obtain this level of knowledge and skill by taking the following or any similar equivalent course:
- Microsoft Excel Introduction
Target Students
This Data Analysis and Visualisation with Excel PRO course is designed for learners who already have foundational knowledge and skills in Excel and who wish to perform robust and advanced data and statistical analysis with Microsoft Excel using PivotTables, use tools such as Power Pivot and the Data Analysis ToolPak to analyse data, and visualise data and insights using advanced visualizations in charts and dashboards in Excel.
Outcome / Qualification etc.
Certification
Upon completion of the Data Analysis and Visualisation with Excel PRO course, you will receive a Certificate of Completion.
This course is also one of a series of courses that addresses Microsoft Certified Application Specialist (Microsoft Business Certification) skill sets.
Course Objectives
Upon successful completion of this Data Analysis and Visualisation with Excel course, students will be able to:
- become familiar with the Power Pivot application and import data
- 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 visualisation with Excel
- perform statistical analysis
- get and transform data
- model and analyse data with Power Pivot
- present insights with reports.
Course delivery details
Instructor led, group-paced, classroom-delivery learning model with structured hands-on activities.
Why choose Infero Training Ltd
97% Recommend Us from 4000 Corporate Clients
100% Money Back Guarantee
Training at 15 locations, Your Office or Live Virtual
Expenses
Course fee: £748.00 + VAT