FutureLearn
FutureLearn Logo

Analysing Data in Excel 

  • Offered byFutureLearn

Analysing Data in Excel
 at 
FutureLearn 
Overview

Duration

3 weeks

Total fee

2,205

Mode of learning

Online

Credential

Certificate

Analysing Data in Excel
 at 
FutureLearn 
Highlights

  • Duration 3 weeks
  • Weekly study 3 hours
  • Premium course $64
Details Icon

Analysing Data in Excel
 at 
FutureLearn 
Course details

Skills you will learn
More about this course
  • Excel is one of the most widely used business applications in the world.
  • But while there are thousands of Excel courses, this is the world's first data-backed course which narrows training down to the specific functions and features that the majority of people will need.
  • Using Excel is a vital skill that will enable you to become more efficient and productive in your current role, learn new skills to facilitate promotion or to move job roles, and increase your chances of getting a first job that requires using Excel.
  • This course will show you which Excel functions and formulae are appropriate to perform mathematical functions, clean and interpret data, and answer business questions. You'll then learn how to calculate mathematical functions including averages, counts, totals and sums.
  • You'll then apply numerical and visual formatting to spreadsheets to produce clean and comprehensible workbooks, and will produce a range of Excel spreadsheets, interactive dashboards, models, and PivotTables that are applicable across many business functions.
  • Finally, you'll apply Excel formulae to data sets to interpret, clean and analyse data, specifically to draw conclusions and insights from datasets, and will improve decision making, thinking efficiency and problem solving in Excel.
  • Throughout the duration of the course, you'll be learning from experts at Filtered Technologies, a company that have been designing and delivering Excel courses for over 10 years.
  • They've taught over a million individual learners, with research printed in the Harvard Business Review.
Read more

Analysing Data in Excel
 at 
FutureLearn 
Curriculum

Using data to answer questions

Welcome!

What is data analysis?

Excel as a data analysis tool

Work with a real data set

Selections from the 100 Most Useful Excel Tips

Summary

Working with data

Introduction to data cleaning and processing

Getting to grips with spreadsheets

Handling data

Cleaning data

Summary

From data to insight

Introduction to Week 3

Building a PivotTable

Formatting a PivotTable

Building a PivotChart

Course summary

Other courses offered by FutureLearn

1.81 K
2 weeks
– / –
1.32 L
15 weeks
– / –
72.5 K
10 weeks
– / –
89.23 K
12 weeks
– / –
View Other 1956 CoursesRight Arrow Icon
qna

Analysing Data in Excel
 at 
FutureLearn 

Student Forum

chatAnything you would want to ask experts?
Write here...