Analysing Data in Excel

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.

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.

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.

• 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