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

Diploma

Advanced Level

business

Diploma in Microsoft Excel for Beginners and Experts

6-10 hrs 83,056 learners

You Will Learn How To

Explain how to get started with Microsoft Excel
Discuss how to use Excel functions
Describe how to create compelling graphics wi... Read More

Certificate

Mastering Data Analysis using Microsoft Excel: Formulas and Pivot Tables

Advanced Level

Information Technology

Mastering Data Analysis using Microsoft Excel: Formulas and Pivot Tables

2 - 3 hrs 35,690 learners

You Will Learn How To

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

Certificate

Data Analysis with Tables and PivotTables in Microsoft Excel 2013

Beginner Level

business

Data Analysis with Tables and PivotTables in Microsoft Excel 2013

3-4 hrs 39,324 learners

You Will Learn How To

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

Certificate

Beginner Level

Information Technology

Simplified Microsoft Excel Functions

2 - 3 hrs 5,675 learners

You Will Learn How To

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

Certificate

Beginner Level

education

Advanced Excel 2021

2 - 3 hrs 36,393 learners

You Will Learn How To

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

Certificate

Advanced Level

education

MS Excel 2013 Advanced

3-4 hrs 17,334 learners

You Will Learn How To

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

Certificate

Microsoft Excel 2013 - Advanced: Master Spreadsheets

Beginner Level

business

Microsoft Excel 2013 - Advanced: Master Spreadsheets

5-6 hrs 43,955 learners

You Will Learn How To

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

Certificate

Microsoft Excel 365: From Beginner to Pro

Advanced Level

Information Technology

Microsoft Excel 365: From Beginner to Pro

6-10 hrs 5,279 learners

You Will Learn How To

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

Certificate

A Quick Guide to Excel Tables and Functions

Advanced Level

Information Technology

A Quick Guide to Excel Tables and Functions

2 - 3 hrs 4,868 learners

You Will Learn How To

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

Certificate

Interactive Dashboards and Data Visualization in Excel

Advanced Level

Information Technology

Interactive Dashboards and Data Visualization in Excel

2 - 3 hrs 4,712 learners

You Will Learn How To

Explain the concept of dashboards
Identify the functions of interactive dashboards in MS E...
Discuss the dynamics of information–transform... Read More

Certificate

Beginner Level

personal-development

Introduction to Excel for Mac

2 - 3 hrs 5,458 learners

You Will Learn How To

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

Certificate

Beginner Level

Information Technology

Building a Spreadsheet Model

2 - 3 hrs 2,130 learners

You Will Learn How To

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

Certificate

Advanced Level

Information Technology

The Basics of Decision Formulas

2 - 3 hrs 2,025 learners

You Will Learn How To

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 learned
Stand Out From The Crowd
Add your Alison Certification to your resumé and stay ahead of the competition
Advance in Your Career
Share your Alison Certification with potential employers to show off your skills and capabilities