Skip to content

Data Analysis and Visualisation with Microsoft Excel - Introduction

Classroom based 1 day course with LIVE TRAINER with Post Course Support - Nationwide £248


Infero Training Ltd

Summary

Price
£297.60 inc VAT
Finance options

Live Virtual training - £248+VAT for 1 day training

Group Discounts available

Pay via:

Bank...

Study method
Online + live classes
Duration
1 day · Full-time
Qualification
No formal qualification
CPD
7 CPD hours / points
Certificates
  • Certificate of completion - Free
Additional info
  • Tutor is available to students

2 students enquired about this course

Add to basket or enquire

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 Data Analysis and Visualisation with Excel Introduction course is suitable for anybody wanting to learn 365, 2019, 2016, 2013, 2010 or 2007, as it cover all the aspects and 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 Introduction 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 Certification

Upon completion of the Data Analysis and Visualisation with Excel Introduction 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. 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.

CPD

7 CPD hours / points
Accredited by The CPD Certification Service

Description

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

Lesson 3: Analysing Data with Formulas and Functions

Topic A: Analyse Data with Formulas and Named Ranges
Topic B: Analyse Data with Functions

Lesson 4: Analysing Data with PivotTables

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

.

Course Objectives

Upon successful completion of this Data Analysis and Visualisation with Excel Introduction course, students will be able to:

  • perform data analysis fundamentals
  • visualise data with Excel
  • analyse data with formulas and functions
  • analyse data with PivotTables

.

Testimonials from our Website and Google Reviews

I was absolutely delighted with the Excel courses that Infero delivered which more than exceeded my expectation. I learnt new ways of using Excel that I can now use in my day to day work to make my work more efficient. Pivot tables were always a mystery to me but now I use them regularly to display HR and Payrol data.

Lisa Dunstan (Payroll Manager) from Decathlon UK

.

The day after taking the Microsoft Excel Intermediate Course, I created two pivot tables and used several advanced formulas to do, in ten minutes, tasks that would previously have taken me hours. The teaching at Infero is easy to follow, the lessons are brilliantly delivered and the instructors are experts in their field, extremely friendly and endlessly patient. There are just the right number of breaks between concise, targeted modules to make learning as near effortless as possible. The ‘aftercare’ element - a tutor will usually answer your queries within hours - is particularly valuable. A great lunch, too.

Harry Frost (Marketing Assistant) from Babcock International Group

.

Had Excel training with Infero last week, I must say it was a good day, I am not the most gifted on excel, but after spending the day with our tutor Martin I came away with a lot more confidence and knowledge, and i will be back for more at a later date, Martin paced the course excellently so no one got left behind or not understanding how to do something. We had good rapport with Martin, even though he forgot how to spell his name :) must be an age thing Lol

Martin Pountney

.

I attended the level 3b training course offered by Infero Training and, like with many similar courses I have attended, was initially worried that it would be too much information to take in at once. However, the manuals and exercises provided along with the guidance and experience of our trainer Martin made the course interactive, concise and, dare i say it, enjoyable. I would highly recommend.

Michael Sexton

.

I attended the Microsoft Excel Basic and Excel Intermediate course which I found very useful. Martin is an excellent trainer, made you feel at ease, he is very helpful and patient. I wish I had undertaken the training ages ago as would have been very beneficial in my previous role.

Leela Patel

Who is this course for?

This Data Analysis and Visualisation with Excel Introduction 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 Introduction, 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

Career path

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

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

Questions and answers

Certificates

Certificate of completion

Digital certificate - Included

Reviews

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

FAQs

What does study method mean?

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.

What are CPD hours/points?

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.

What is a ‘regulated qualification’?

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.

What is an ‘endorsed’ course?

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.