- All Courses
- BusinessExcel
- Advanced excel
Best Advanced Excel Courses
These free online courses in advanced Excel will teach you how to use every tool and function that Excel has to offer. Microsoft Excel is one of the more complex applications in the Microsoft office suite, and an advanced knowledge of Excel is very attractive to employers. Teaching advanced formulas, conditional formatting, and more, these courses will have you up to speed with Excel in no time....…Read More
- 13 Free Courses
- 285,899 Learners
- 28,544 Certificates & Diplomas Earned
Most Popular
Advanced Excel Courses

Diploma in Microsoft Excel for Beginners and Experts
- Explain how to get started with Microsoft Excel
- Discuss how to use Excel functions
- Describe how to create compelling graphics wi... Read More

Mastering Data Analysis using Microsoft Excel: Formulas and Pivot Tables
- List the most frequently used lookup and decision formul...
- Outline the methods for creating and applying formulas i...
- Identify the correct formula for calculating ... Read More

Data Analysis with Tables and PivotTables in Microsoft Excel 2013
- Identify how to create a table, name a table and remove ...
- Recognize how to insert rows and columns into tables
- Discuss the use of table styles, reference an... Read More

Simplified Microsoft Excel Functions
- Outline the uses of mode and factorial functions
- Explain count and round functions in Microsoft Excel
- Recognize how to use log and log10 functions ... Read More

Advanced Excel 2021
- Examine the key behaviours known as ‘arrays’ and ‘spills...
- Identify the key differences between unique and distinct...
- Describe the role of the SORT function and how to apply ...
- Explain how to use the SORTBY function in Exc... Read More

MS Excel 2013 Advanced
- Explain how to record a macro using the record macro dia...
- Discuss how to apply conditional formatting
- State how to watch and evaluate formula features
- Describe the watch window in Excel 2013 Read More

Microsoft Excel 2013 - Advanced: Master Spreadsheets
- Discuss the use of advanced functions and formulas in Ex...
- Illustrate a good understanding of financial functions
- Identify how time and dates are stored and ca... Read More

Microsoft Excel 365: From Beginner to Pro
- Define the process of using Excel’s check-out feature to...
- Summarize the steps to enable autosave settings in Excel...
- Describe the converting of Excel files into P... Read More

A Quick Guide to Excel Tables and Functions
- Identify the main rules and the advantages of using Exce...
- Describe the Excel function that allows making decisions...
- Distinguish between the sorting and decision ... Read More

Interactive Dashboards and Data Visualization in Excel
- Explain the concept of dashboards
- Identify the functions of interactive dashboards in MS E...
- Discuss the dynamics of information–transform... Read More

Introduction to Excel for Mac
- Differentiate between PC and Mac Excel
- Describe the main Mouse and Trackpad features
- Explain how to create a new workbook
- Discuss how to enter text and numbers into a ... Read More

Building a Spreadsheet Model
- List the components of an effective spreadsheet forecast...
- Outline the procedure for developing a spreadsheet model
- Define sensitivity analysis and explain its importance
- Analyze the effect of adjusting input paramet... Read More

The Basics of Decision Formulas
- Identify the need for thinking differently to get the mo...
- Discuss the procedure for using the camera tool in Excel
- Summarize the various development principles
- Identify the multiple tips for formula editin... Read More
Benefits Of An Alison Certificate
Certify Your Skills
A CPD accredited Alison Certificate certifies the skills you’ve learnedStand Out From The Crowd
Add your Alison Certification to your resumé and stay ahead of the competitionAdvance in Your Career
Share your Alison Certification with potential employers to show off your skills and capabilities

Explore Courses By Category
Explore In-Demand Careers
Discover More CareersPopular Course Creators
Over 45 million learners have used Alison to empower themselves
Not sure where to begin?
What is your main goal on Alison?
- 4,500+ free courses
- 45 million+ learners
- 10 million+ graduates
- 195 countries