Hands On Training

Analysing Data in Excel

via

Future Learn

Course Features

Duration

3 weeks

Delivery Method

Online

Available on

Lifetime Access

Accessibility

Mobile, Desktop

Language

English

Subtitles

English

Level

Beginner

Effort

3 hours per week

Teaching Type

Self Paced

Course Description

Excel is one of most used business applications around the globe.

There are many Excel courses available, but this course is the first to be data-backed. It focuses on the functions and features that most people will use.

Excel is an essential skill that will allow you to be more productive and efficient in your current job, as well as learn new skills that can help you move up the ladder or get promoted.

This course will teach you how to use Excel formulae and functions to solve business problems, clean up data and interpret it. The course will teach you how to calculate math functions, including averages, totals, and sums.

Then, you'll apply visual and numerical formatting to Excel spreadsheets to create clear and comprehensible workbooks. You will also produce a variety of Excel spreadsheets, models, interactive dashboards, models and PivotTables which can be used across many business functions.

Final, you will use Excel formulae to analyze data sets, to extract insights and conclusions from them. This will help improve Excel's decision-making, thinking efficiency, and problem solving.

Filtered Technologies has been creating and delivering Excel courses since over 10 years.

Their research has been published in Harvard Business Review.

CPD Certification Service has certified the content of this course as meeting continuing professional development standards.

Course Overview

Alumni Network

International Faculty

Post Course Interactions

Instructor-Moderated Discussions

Skills You Will Gain

Prerequisites/Requirements

You will need access to Excel to complete the exercises. It is recommended to use a desktop, laptop or tablet to get the most out of the course

What You Will Learn

Apply Excel formulae - such as concatenate, trim, and proper - to data sets to clean and analyse data

Apply numerical and visual formatting, including conditional formatting, slicers and timelines, to spreadsheets to produce clean and comprehensible workbooks

Calculate mathematical functions including averages, counts and sums

Identify which Excel functions and formulae are appropriate to perform mathematical functions, clean and interpret data, and answer business questions

Improve decision making, thinking efficiency and problem solving in Excel

Improve spreadsheet efficiency and maintenance with shortcuts, navigation commands, and design principles

Produce a range of spreadsheets, including a cleaned data set, PivotTables, PivotCharts

Target Students

The primary audience for this course are the vast majority of knowledge workers who use Excel every week but could easily do so more effectively, faster and with more confidence

Course Content

Expand all sections

Module 1: Excel functions

Module 2: Excel formulae

Module 3: PivotTables, conditional formatting, timelines, and slicers

Module 4: PivotCharts

Course Instructors

Chris Littlewood

Instructor

I trained as a particle physicist, and since then have been applying analytical skills to business problems in consultancy, transport and learning & development.

Marc Zao-Sanders

Instructor

I'm interested in Excel, words, numbers, chess, business, decision-making, education, and finding out more about how our minds work.

Course Accreditations

This Course Is Not Available In Your Country Or Region

Explore Related Courses