Master the world’s most powerful spreadsheet software and unlock endless possibilities. Our Microsoft Excel Course is designed for everyone, whether you’re just starting or looking to enhance your Excel skills. Learn how to use Excel efficiently, from basic functions to advanced features like Pivot Tables, XLOOKUP, and dynamic charts. Enrol today and start mastering Excel today with this easy-to-follow course.
Exclusive Deal! 94% Off, Today Only!
Sale Ends In
Excel is the world’s most powerful tool for data management, and mastering it unlocks endless opportunities. From basic functions to advanced techniques like Pivot Tables and XLOOKUP, this Complete Excel Course equips you with the skills to manage and analyse data efficiently. Excel is at the core of productivity, driving success across industries, from finance to marketing.
In today’s data-driven job market, Excel expertise is a highly sought-after skill. Over 80% of UK employers consider Excel proficiency essential, with increasing demand for professionals skilled in advanced Excel functions such as XLOOKUP, Pivot Tables, and Business-Geo charts.
This Microsoft Excel course is designed to build your expertise step-by-step, whether you’re looking to manage data for work or enhance your career. By the end of the course, you’ll be confident using Excel’s most powerful features, optimising your data handling, and boosting your career prospects. Enrol today and unlock your potential with Excel mastery!

An endorsed certificate will be issued for the learners as proof of their achievement after the completion of this course.
After successful course completion, learners will be able to order an endorsed certificate as proof of their new achievement. Only for £119 you can order and get endorsed certificates delivered to your home. International students have to pay an extra £10 as a postage charge.
After completing the MCQ assessment, you will qualify for the CPD Certificate from HF Online as proof of your continued professional development. You can order your certificate at a cost of £10 for PDF and £29 for hard copy certificate or both for £39.
This course has been endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. This course is not regulated by Ofqual and is not an accredited qualification. Academy for Health & Fitness will be able to advise you on any further recognition, for example progression routes into further and/or higher education. For further information please visit the Learner FAQs on the Quality Licence Scheme website.
For assessing your learning, you have to complete an automated MCQ exam. It is required for the students to score at least 60% to pass the exam. Learners can apply for the certificate after they clear the exam.
There are assignment questions provided at the end of the course. You are suggested to complete the questions to enrich your understanding of the course. You can complete this according to your preferred time. The expert tutor will provide feedback on your performance after assessing your assignment.
There are no prerequisites and you may use any internet-enabled device to study at your own speed, it is adaptable and available to students of all skill levels.
Completing this Microsoft Excel Course opens doors to a variety of career opportunities across sectors like finance, marketing, administration, and data analysis. Skilled Excel users are in high demand in roles that require data management, analysis, and reporting.
This course covers everything from Excel basics to advanced features like Pivot Tables, XLOOKUP, and charts, designed to make data management, analysis, and reporting easier for everyone.
This course is perfect for beginners learning Excel from scratch, professionals looking to upskill, students who need to analyse data, and anyone wanting to master Excel for career growth.
The course is structured to start with foundational concepts and progressively introduce more advanced topics, ensuring you build a strong understanding of Excel through hands-on exercises and interactive tutorials.
Upon completion, you’ll be able to create and manage data effectively, use advanced Excel features like XLOOKUP and Pivot Tables, and create detailed reports and charts for work or personal use.
You will learn how to use essential Excel functions, create charts, work with Pivot Tables, analyse data with XLOOKUP, and understand how to import and clean data efficiently.
The course covers Excel for Windows, macOS, Android, and iOS, with specific modules for Excel 2021, Office 365, and earlier versions, including XLOOKUP.
Yes, the course is accessible on Windows, macOS, Android, and iOS, giving you the flexibility to learn anytime, anywhere.
By mastering Excel, you'll improve your data analysis, reporting, and organisational skills, making you more efficient in your role and enhancing overall productivity.
Excel is a powerful tool for data analysis, reporting, and decision-making. Mastering Excel enhances your ability to manipulate data, automate tasks, and create insights—skills that are indispensable across industries.
Proficiency in Excel is a highly sought-after skill in sectors like finance, marketing, project management, and data analysis. Completing this course will boost your career prospects by equipping you with the tools to work more efficiently and effectively with data.
| Section 01: Getting Started | |||
| Introduction | 00:03:00 | ||
| Course Curriculum | 00:04:00 | ||
| Getting started on Windows, macOS, Android, and IOS | 00:01:00 | ||
| How to ask great questions | 00:02:00 | ||
| FAQ’s | 00:01:00 | ||
| Starting Excel | 00:04:00 | ||
| Section 02: Excel Basics | |||
| Introduction | 00:02:00 | ||
| Worksheet basics | 00:22:00 | ||
| Entering values and formulas | 00:12:00 | ||
| Data formats | 00:10:00 | ||
| Data handling basics – cut copy and paste | 00:07:00 | ||
| Save and print in excel | 00:10:00 | ||
| Excel Ranges | 00:05:00 | ||
| Section 03: Excel essential functions | |||
| Introduction | 00:01:00 | ||
| Basic formula operations | 00:06:00 | ||
| Mathematical functions level 1 | 00:20:00 | ||
| Mathematical functions level 2 | 00:12:00 | ||
| Text functions level 1 | 00:09:00 | ||
| Text functions level 2 | 00:13:00 | ||
| Logical functions | 00:11:00 | ||
| Date time functions | 00:06:00 | ||
| V Lookup formula | 00:12:00 | ||
| HLookup formula | 00:04:00 | ||
| HLookup + Match formula | 00:09:00 | ||
| Match + Index formula | 00:06:00 | ||
| Section 04: XLookup only for Excel 2021 and Office 365 | |||
| Introduction | 00:02:00 | ||
| XLookup | 00:08:00 | ||
| Handling #NA and Approximates match in XLookup | 00:11:00 | ||
| Wildcard matching in XLookup | 00:06:00 | ||
| Section 05: Get Data and tools | |||
| Introduction | 00:02:00 | ||
| Split text into columns | 00:07:00 | ||
| Flash Fill | 00:07:00 | ||
| Remove Duplicates | 00:08:00 | ||
| Data Validation | 00:07:00 | ||
| Get- import Data from Text | 00:07:00 | ||
| Get – import Data from CSV | 00:03:00 | ||
| Section 06: Formatting data and tables | |||
| Introduction | 00:01:00 | ||
| Formatting Font | 00:04:00 | ||
| Formatting Alignment | 00:00:00 | ||
| Formatting Number | 00:04:00 | ||
| Formatting Date | 00:03:00 | ||
| Formatting tables | 00:05:00 | ||
| Section 07: Pivot Tables | |||
| Introduction | 00:01:00 | ||
| Creating Pivot Table | 00:07:00 | ||
| Value field settings | 00:04:00 | ||
| Number format | 00:02:00 | ||
| Pivot Table Design | 00:03:00 | ||
| Excel Exercise | 00:01:00 | ||
| Solution for Excel Exercise | 00:02:00 | ||
| Section 08: Excel Charts | |||
| Introduction | 00:01:00 | ||
| Excel Charts – Categories | 00:03:00 | ||
| Elements of a chart | 00:04:00 | ||
| Easy way to create charts | 00:02:00 | ||
| Column or Bar charts | 00:04:00 | ||
| Formatting charts | 00:04:00 | ||
| Line charts | 00:02:00 | ||
| Area charts | 00:02:00 | ||
| Pie and Doughnut charts | 00:04:00 | ||
| Format AreaPlot or XY chart | 00:08:00 | ||
| Scatter or bubble charts | 00:02:00 | ||
| Section 09: Advanced Excel charts | |||
| Introduction | 00:01:00 | ||
| Frequency Distribution and Histograms | 00:04:00 | ||
| Waterfall charts | 00:02:00 | ||
| Hierarchy charts: sunburst and tree map | 00:03:00 | ||
| Combination charts | 00:02:00 | ||
| Sparklines | 00:05:00 | ||
| Section 10: Pivot Charts | |||
| Pivot charts | 00:02:00 | ||
| Section 11: Maps Chart above 2019 | |||
| Maps chart | 00:04:00 | ||
| 3D Maps chart | 00:03:00 | ||
| Section 12: Business-Geo charts | |||
| Introduction | 00:01:00 | ||
| Stock charts | 00:02:00 | ||
| Radar charts | 00:02:00 | ||
| Surface charts | 00:02:00 | ||
| Heat maps | 00:04:00 | ||
| Section 13: Named Ranges | |||
| Named ranges | 00:05:00 | ||
| Indirect Name range Function | 00:06:00 | ||
| Section 14: Import Data into Excel | |||
| Import Data table from PDF file – Excel 2021 | 00:04:00 | ||
| Import Data from Website – Excel 2019 above | 00:09:00 | ||
| Section 15: Advanced Excel | |||
| Project: Sales forecast tracker | 00:07:00 | ||
| Product Sale Tax invoice: Tax Calculations | 00:05:00 | ||
| Order your Certificates | |||
| Claim Your Certificates | 00:00:00 | ||
| Section 01: Getting Started | |||
| Introduction | 00:03:00 | ||
| Course Curriculum | 00:04:00 | ||
| Getting started on Windows, macOS, Android, and IOS | 00:01:00 | ||
| How to ask great questions | 00:02:00 | ||
| FAQ’s | 00:01:00 | ||
| Starting Excel | 00:04:00 | ||
| Section 02: Excel Basics | |||
| Introduction | 00:02:00 | ||
| Worksheet basics | 00:22:00 | ||
| Entering values and formulas | 00:12:00 | ||
| Data formats | 00:10:00 | ||
| Data handling basics – cut copy and paste | 00:07:00 | ||
| Save and print in excel | 00:10:00 | ||
| Excel Ranges | 00:05:00 | ||
| Section 03: Excel essential functions | |||
| Introduction | 00:01:00 | ||
| Basic formula operations | 00:06:00 | ||
| Mathematical functions level 1 | 00:20:00 | ||
| Mathematical functions level 2 | 00:12:00 | ||
| Text functions level 1 | 00:09:00 | ||
| Text functions level 2 | 00:13:00 | ||
| Logical functions | 00:11:00 | ||
| Date time functions | 00:06:00 | ||
| V Lookup formula | 00:12:00 | ||
| HLookup formula | 00:04:00 | ||
| HLookup + Match formula | 00:09:00 | ||
| Match + Index formula | 00:06:00 | ||
| Section 04: XLookup only for Excel 2021 and Office 365 | |||
| Introduction | 00:02:00 | ||
| XLookup | 00:08:00 | ||
| Handling #NA and Approximates match in XLookup | 00:11:00 | ||
| Wildcard matching in XLookup | 00:06:00 | ||
| Section 05: Get Data and tools | |||
| Introduction | 00:02:00 | ||
| Split text into columns | 00:07:00 | ||
| Flash Fill | 00:07:00 | ||
| Remove Duplicates | 00:08:00 | ||
| Data Validation | 00:07:00 | ||
| Get- import Data from Text | 00:07:00 | ||
| Get – import Data from CSV | 00:03:00 | ||
| Section 06: Formatting data and tables | |||
| Introduction | 00:01:00 | ||
| Formatting Font | 00:04:00 | ||
| Formatting Alignment | 00:00:00 | ||
| Formatting Number | 00:04:00 | ||
| Formatting Date | 00:03:00 | ||
| Formatting tables | 00:05:00 | ||
| Section 07: Pivot Tables | |||
| Introduction | 00:01:00 | ||
| Creating Pivot Table | 00:07:00 | ||
| Value field settings | 00:04:00 | ||
| Number format | 00:02:00 | ||
| Pivot Table Design | 00:03:00 | ||
| Excel Exercise | 00:01:00 | ||
| Solution for Excel Exercise | 00:02:00 | ||
| Section 08: Excel Charts | |||
| Introduction | 00:01:00 | ||
| Excel Charts – Categories | 00:03:00 | ||
| Elements of a chart | 00:04:00 | ||
| Easy way to create charts | 00:02:00 | ||
| Column or Bar charts | 00:04:00 | ||
| Formatting charts | 00:04:00 | ||
| Line charts | 00:02:00 | ||
| Area charts | 00:02:00 | ||
| Pie and Doughnut charts | 00:04:00 | ||
| Format AreaPlot or XY chart | 00:08:00 | ||
| Scatter or bubble charts | 00:02:00 | ||
| Section 09: Advanced Excel charts | |||
| Introduction | 00:01:00 | ||
| Frequency Distribution and Histograms | 00:04:00 | ||
| Waterfall charts | 00:02:00 | ||
| Hierarchy charts: sunburst and tree map | 00:03:00 | ||
| Combination charts | 00:02:00 | ||
| Sparklines | 00:05:00 | ||
| Section 10: Pivot Charts | |||
| Pivot charts | 00:02:00 | ||
| Section 11: Maps Chart above 2019 | |||
| Maps chart | 00:04:00 | ||
| 3D Maps chart | 00:03:00 | ||
| Section 12: Business-Geo charts | |||
| Introduction | 00:01:00 | ||
| Stock charts | 00:02:00 | ||
| Radar charts | 00:02:00 | ||
| Surface charts | 00:02:00 | ||
| Heat maps | 00:04:00 | ||
| Section 13: Named Ranges | |||
| Named ranges | 00:05:00 | ||
| Indirect Name range Function | 00:06:00 | ||
| Section 14: Import Data into Excel | |||
| Import Data table from PDF file – Excel 2021 | 00:04:00 | ||
| Import Data from Website – Excel 2019 above | 00:09:00 | ||
| Section 15: Advanced Excel | |||
| Project: Sales forecast tracker | 00:07:00 | ||
| Product Sale Tax invoice: Tax Calculations | 00:05:00 | ||
| Order your Certificates | |||
| Claim Your Certificates | 00:00:00 | ||
20837
5
16478
4.5
14124
4.7

