• Filtered logo

Analysing Data in Excel

Discover all the fundamental data skills, tools and functions in order to make you a pro at using Microsoft Excel.

6,498 enrolled on this course

Analysing Data in Excel

6,498 enrolled on this course

  • 3 weeks

  • 3 hours per week

  • Accreditation available

  • Digital certificate when eligible

  • Introductory level

Find out more about how to join this course

Learn how to become a pro at using Microsoft Excel’s key formulas

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.

Identify the right Excel formulas to improve your efficiency

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.

Produce a range of Excel spreadsheets, interactive dashboards, models, and PivotTables

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.

Learn from Excel and data experts from Filtered Technologies

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.

What topics will you cover?

The course covers the fundamental skills, tools and functions to be competent at analysing data in Excel. Including:

  • Excel functions
  • Excel formulae
  • PivotTables, conditional formatting, timelines, and slicers
  • PivotCharts
  • Spreadsheet management/efficiency
  • Excel shortcuts/commands
  • Thinking like a data analyst

Who is this accredited by?

The CPD Certification Service
The CPD Certification Service:

The content of the following course has been certified by the CPD Certification Service as conforming to continuing professional development principles.

When would you like to start?

Start straight away and join a global classroom of learners. If the course hasn’t started yet you’ll see the future date listed below.

  • Available now

Learning on this course

On every step of the course you can meet other learners, share your ideas and join in with active discussions in the comments.

What will you achieve?

By the end of the course, you‘ll be able to...

  • Produce a range of spreadsheets, including a cleaned data set, PivotTables, PivotCharts
  • Apply Excel formulae - such as concatenate, trim, and proper - to data sets to clean and analyse data
  • 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
  • Apply numerical and visual formatting, including conditional formatting, slicers and timelines, to spreadsheets to produce clean and comprehensible workbooks
  • Improve spreadsheet efficiency and maintenance with shortcuts, navigation commands, and design principles

Who is the course for?

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.

This includes professional knowledge workers, university students and recent graduates, in-career professionals who want to upskill, and those returning to work.

What software or tools do you need?

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.

Who will you learn with?

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

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

Who developed the course?

Filtered

Filtered is a digital education company on a mission to enhance productivity and career success through intelligent, personalised, data-backed, learning experiences. In our platforms we use patented algorithms to prioritise and tailor content for individual learners. Over 10 years we’ve taught more than a million learners across hundreds of businesses, collecting millions of data points on content relevance and usefulness that we use to discern what’s necessary to learn in Excel.

Ways to learn

Buy this course

Subscribe & save

Limited access

Choose the best way to learn for you!

$39/one-off payment

$27.99

/month

Automatically renews

Free

Fulfill your current learning needDevelop skills to further your careerSample the course materials
Access to this courseticktick

Access expires 17 Dec 2022

Access to 1,000+ coursescrosstickcross
Learn at your own paceticktickcross
Discuss your learning in commentstickticktick
Tests to check your learningticktickcross
Certificate when you're eligiblePrinted and digitalDigital onlycross
Continue & Upgrade

Cancel for free anytime

Ways to learn

Choose the best way to learn for you!

Subscribe & save

$27.99 /month

Automatically renews

Develop skills to further your career

  • Access to this course
  • Access to 1,000+ courses
  • Learn at your own pace
  • Discuss your learning in comments
  • Tests to boost your learning
  • Digital certificate when you're eligible

Cancel for free anytime

Buy this course

$39/one-off payment

Fulfill your current learning need

  • Access to this course
  • Learn at your own pace
  • Discuss your learning in comments
  • Tests to boost your learning
  • Printed and digital certificate when you’re eligible

Limited access

Free

Sample the course materials

  • Access expires 17 Dec 2022

Find out more about certificates, Unlimited or buying a course (Upgrades)

Learning on FutureLearn

Your learning, your rules

  • Courses are split into weeks, activities, and steps to help you keep track of your learning
  • Learn through a mix of bite-sized videos, long- and short-form articles, audio, and practical activities
  • Stay motivated by using the Progress page to keep track of your step completion and assessment scores

Join a global classroom

  • Experience the power of social learning, and get inspired by an international network of learners
  • Share ideas with your peers and course educators on every step of the course
  • Join the conversation by reading, @ing, liking, bookmarking, and replying to comments from others

Map your progress

  • As you work through the course, use notifications and the Progress page to guide your learning
  • Whenever you’re ready, mark each step as complete, you’re in control
  • Complete 90% of course steps and all of the assessments to earn your certificate

Want to know more about learning on FutureLearn? Using FutureLearn

Learner reviews

Learner reviews cannot be loaded due to your cookie settings. Please and refresh the page to view this content.

Do you know someone who'd love this course? Tell them about it...