Skip to content

Data Analysis with Excel for Complete Beginners - ExpertTrack

FutureLearn

Summary

Price
£36 inc VAT
Study method
Online
Duration
10 weeks · Self-paced
Qualification
No formal qualification

Overview

Learn data analysis from scratch, including an introduction to essential maths and Microsoft Excel.

Course media

Description

An introduction to the fundamentals of data analysis using Excel.

Data analysis skills are in increasing demand across a huge range of industries, but if maths is not your strong suit, it can be a daunting thing to learn. This ExpertTrack has been designed with exactly that in mind. It is a complete beginner’s guide to the subject, covering the basics of data analytics, maths, and Excel fundamentals to refresh your memory and build your confidence in these areas.

You’ll explore:

*data in life and society *ways to build your data literacy *data analysis methods * how to create tables and pivot tables in Excel *how to create data visualisations in Excel *the maths behind data analysis *how to apply basic inferential maths to your data sets

Every course within this ExpertTrack is self-paced, allowing you to review the course content as quickly or as slowly as you’d like.


Brush up on your mathematics before delving into data analysis

Data analysis involves applying maths - whether it’s statistics or simple formula - to data sets. This ExpertTrack offers you the chance to refresh your maths knowledge before you get started so that you feel confident in mathematical notation, applying summary statistics, and calculating business metrics as you proceed through the courses.


Learn how to use Excel functions for data analysis

Microsoft Excel is one of the top tools for data analysis and the built-in pivot tables are arguably the most popular analytic tool.
You will learn how to perform data analysis using Excel’s most popular features, including how to create pivot tables from a range with rows and columns in Excel. You will see the power of Excel pivots in action and their ability to summarise data in flexible ways, enabling quick exploration of data and producing valuable insights from the accumulated data.


Grow your data analysis skills

Once you’ve covered the maths behind data analytics and the Excel functions to support it, you’ll be able to grow your analytics skills more directly. This involves creating flexible data aggregations and representing data visually. Before long, you’ll be able to calculate margins and other calculations, as well as filtering data and creating reports using simple Excel formulas.


Feel confident making data-driven decisions

All of this works towards offering you more control and confidence in your data. You’ll be able to apply your new-found skills in both decision making and problem solving at work. You can even use this as a pathway into more specialised training in data analysis.


Key skills you will learn

Microsoft Excel
Decision Making
Mathematics
Data Analysis

Who is this course for?

This ExpertTrack has been designed for learners who are new to Excel and to data analysis, who want to improve their skills.

You may want to advance your career, perform tasks more efficiently, or test out whether a career in data analysis is really for you.

Requirements

In order to benefit from this course, it would be helpful to have a basic understanding of how to create formulas and how cells are referenced by rows and columns within Excel.

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
Related searches: Online courses