Skip to content

Data Analysis and Visualisation with Microsoft Excel - Advanced (2 days)
Infero Training Ltd

Classroom based CPD Accredited course - Post Course Support – All Level Introduction to Advance - Free PDF Certificate

Summary

Price
£595.20 inc VAT
Finance options

Live Virtual Training - £496 +VAT for 2 days training

Classroom Training - £496 +VAT for 2 ...

Study method
Online + live classes
Duration
2 days · Full-time
Qualification
No formal qualification
CPD
21 CPD hours / points
CPD What's this?
Certificates
  • Certificate of completion - Free
Additional info
  • Tutor is available to students
30 students enquired about this course

Add to basket or enquire

Overview

This intensive 2 days, hands-on Data Analysis and Visualisation with Excel Advanced course helps you gain comprehensive, practical understanding of Data Analysis using Excel.

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 Data Analysis and Visualisation with Excel Advanced course is suitable for anybody wanting to learn any version between 2007 and latest 2021. Our courses cover all differences between the versions.

You can choose either our Classroom training at one of our venues or Live, Instructor-led Virtual training from the comfort of your home.

.

Benefits of Studying Data Analysis and Visualisation with Excel Advanced with Infero Training:

  • 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
  • Premier Locations, Latest Tech, Refreshments, OR We Come to You
  • 100% Money Back Guarantee & Price Match Guarantee
  • Bespoke Courses & Group Discounts from £89 per person

.

Data Analysis and Visualisation with Excel Advanced Certification

Upon completion of the Data Analysis and Visualisation with Excel Advanced 2 day course, you will receive a Certificate of Completion, CPD certificate and earn 21 CPD Points.

This course is also 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.

Certificates

Certificate of completion

Digital certificate - Included

Certificate will be emailed upon successful completion of the course.

CPD

21 CPD hours / points
Accredited by The CPD Certification Service

Description

Data Analysis and Visualisation with Excel Advanced Course Content

Lesson 1: Presenting Visual Insights with Dashboards in Excel

  • Visualise Data with PivotCharts
  • Filter Data Using Slicers and Timelines
  • Create a Dashboard in Excel

Lesson 2: Automating Data Analysis with Excel

  • Implement Data Validation, Forms, and Controls
  • Adding Form Controls to a Worksheet
  • Create Conditional Visualisations with Lookup Functions

Lesson 3: Creating Geospatial Visualisations with Excel

  • Create Map Charts in Excel
  • Customise Map Charts in Excel

Lesson 4: Performing Statistical Analysis with Excel

  • Visualise Trendlines and Sparklines with Excel
  • Analyse Data with the Data Analysis ToolPak
  • Apply Best Practices in Chart Design

Lesson 5: Getting and Transforming Data

  • Connect to Data with Queries
  • Clean and Combine Data
  • Shape and Transform Data

Lesson 6: Modelling Data with Power Pivot

  • Install Power Pivot in Excel
  • Create Data Models with Power Pivot
  • Create Power Pivots

Lesson 7: Analysing Data with Power Pivot

  • Data Analysis Expressions (DAX)
  • Perform Advanced Data Analysis and Visualisation with DAX
  • Create a Key Performance Indicator (KPI)
  • Work with Dates and Times in PowerPivot

Lesson 8: Presenting Insights with Reports

  • Plan a Report
  • Create a Report

.

Data Analysis and Visualisation with Excel Advanced Course Objectives

Upon successful completion of the Data Analysis and Visualisation with Excel Advanced course, you will have gained the skills necessary to:

  • 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

Who is this course for?

This Data Analysis and Visualisation with Excel Advanced 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.

Requirements

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

Career path

Being proficient in Data Analysis and Visualisation with Excel you can open the doors to many career opportunities such as:

  • Administrative Assistant
  • Data Analyst
  • Accountants
  • Financial Analyst
  • Retail Store Manager
  • Project Manager
  • Business Analyst

Questions and answers

Reviews

Currently there are no reviews for this course. Be the first to leave a review.

Leave a review

Legal information

This course is advertised on Reed.co.uk by the Course Provider, whose terms and conditions apply. Purchases are made directly from the Course Provider, and as such, content and materials are supplied by the Course Provider directly. Reed is acting as agent and not reseller in relation to this course. Reed's only responsibility is to facilitate your payment for the course. It is your responsibility to review and agree to the Course Provider's terms and conditions and satisfy yourself as to the suitability of the course you intend to purchase. Reed will not have any responsibility for the content of the course and/or associated materials.

FAQs

Study method describes the format in which the course will be delivered. At Reed Courses, courses are delivered in a number of ways, including online courses, where the course content can be accessed online remotely, and classroom courses, where courses are delivered in person at a classroom venue.

CPD stands for Continuing Professional Development. If you work in certain professions or for certain companies, your employer may require you to complete a number of CPD hours or points, per year. You can find a range of CPD courses on Reed Courses, many of which can be completed online.

A regulated qualification is delivered by a learning institution which is regulated by a government body. In England, the government body which regulates courses is Ofqual. Ofqual regulated qualifications sit on the Regulated Qualifications Framework (RQF), which can help students understand how different qualifications in different fields compare to each other. The framework also helps students to understand what qualifications they need to progress towards a higher learning goal, such as a university degree or equivalent higher education award.

An endorsed course is a skills based course which has been checked over and approved by an independent awarding body. Endorsed courses are not regulated so do not result in a qualification - however, the student can usually purchase a certificate showing the awarding body's logo if they wish. Certain awarding bodies - such as Quality Licence Scheme and TQUK - have developed endorsement schemes as a way to help students select the best skills based courses for them.
View all
Similar subjects: Data analysis, Big data, Power BI, Business, IT
Related searches: Microsoft courses, Business analysis courses, Analytics courses, Online courses