Knowing how to work on MS Excel is an absolute necessity nowadays, almost every business in the world uses MS Excel and you will fall behind the competition if you do not know how to use MS Excel.
Save 93.18 % - NEW YEAR SALE
Or
1 Year Access 
Level 7
627 Students 
3 weeks, 5 days 
Get access to 5000+ courses including this for
This course introduces Microsoft Excel within Microsoft Office 2019 on Windows, guiding learners through spreadsheets, calculations and workbook management while building strong foundations for professional data handling and everyday productivity tasks.
Learners develop advanced Microsoft Excel skills including functions, PivotTables, charts and data analysis, while connecting Excel with Power BI, OneDrive and SharePoint for smarter reporting, collaboration and efficient workflow management.
The programme also explores automation using Visual Basic for Applications, forecasting, templates and auditing tools. Supported by Microsoft Learn concepts, this course helps users confidently manage, analyse and visualise data across modern Office environments.
Learners complete an assignment designed to evaluate their understanding of the course content. The assignment is reviewed by qualified tutors who provide personalised feedback, allowing learners to demonstrate their applied knowledge and skills.
After completing the Microsoft Excel Complete Course assessments, learners qualify for a CPD QS accredited certificate from One Education.
The certificate is available in two formats: a PDF version for £9 or a printed hard copy delivered by post for £15.
Quality Licence Scheme Endorsed Certificate
Learners also have the option to order a Quality Licence Scheme (QLS) Endorsed Certificate as additional proof of achievement. The QLS Endorsed Certificate can be delivered by post for £129, with an additional £10 postage charge for international students.
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. Your training provider 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.
Microsoft Excel remains one of the most in-demand workplace skills across business, finance, administration, data analysis, and management roles. Strong Excel proficiency enables professionals to organise data efficiently, analyse information accurately, and support better decision-making in fast-paced working environments.
Studying the Microsoft Excel Complete Course strengthens technical confidence, improves productivity, and enhances problem-solving skills using real-world spreadsheets. Gaining CPD recognition demonstrates professional development, adds measurable value to your CV, and supports career progression across multiple industries.
The Property Development Course has a total learning time of 3 weeks and 5 days. Learners can progress through the course at a pace that suits their individual schedule, allowing them to complete the programme within a timeframe that aligns with their availability and level of commitment.
The Microsoft Excel Complete Course has simple and flexible entry requirements. Learners only need basic computer skills and an interest in improving their spreadsheet and data management abilities. The course is delivered entirely online and can be accessed from any internet-enabled device, allowing you to study at your own pace from home or anywhere that suits your schedule.
No prior experience is required. The course starts with Excel basics and gradually progresses to advanced functions and features.
The course covers formulas, functions, data analysis, charts, PivotTables, dashboards, and Excel tools used in real-world scenarios.
Yes, the course is suitable for students, job seekers, and professionals looking to improve productivity and data-handling skills.
Yes, you will receive a CPD-accredited certificate upon successful completion of the course and assessment.
You will have full access to the course materials for one year, allowing you to learn at your own pace.
Yes, Excel skills are widely used across industries and can enhance your CV, workplace efficiency, and career prospects.
| Microsoft Excel 2019 New Features | |||
| Introduction to Microsoft Excel 2019 New Features | 00:07:00 | ||
| CONCAT | 00:02:00 | ||
| IFS | 00:01:00 | ||
| MAXIFS | 00:01:00 | ||
| MINIFS | 00:01:00 | ||
| SWITCH | 00:02:00 | ||
| TEXTJOIN | 00:01:00 | ||
| Map Chart | 00:02:00 | ||
| Funnel Chart | 00:01:00 | ||
| Better Visuals | 00:06:00 | ||
| Pivot Table Enhancements | 00:02:00 | ||
| Power Pivot Updates | 00:01:00 | ||
| Getting Started with Microsoft Office Excel | |||
| Navigate the Excel User Interface | 00:28:00 | ||
| Use Excel Commands | 00:10:00 | ||
| Create and Save a Basic Workbook | 00:19:00 | ||
| Enter Cell Data | 00:12:00 | ||
| Use Excel Help | 00:05:00 | ||
| Performing Calculations | |||
| Create Worksheet Formulas | 00:15:00 | ||
| Insert Functions | 00:17:00 | ||
| Reuse Formulas and Functions | 00:17:00 | ||
| Modifying a Worksheet | |||
| Insert, Delete, and Adjust Cells, Columns, and Rows | 00:10:00 | ||
| Search for and Replace Data | 00:09:00 | ||
| Use Proofing and Research Tools | 00:07:00 | ||
| Formatting a Worksheet | |||
| Apply Text Formats | 00:16:00 | ||
| Apply Number Format | 00:08:00 | ||
| Align Cell Contents | 00:09:00 | ||
| Apply Styles and Themes | 00:12:00 | ||
| Apply Basic Conditional Formatting | 00:11:00 | ||
| Create and Use Templates | 00:08:00 | ||
| Printing Workbooks | |||
| Preview and Print a Workbook | 00:10:00 | ||
| Set Up the Page Layout | 00:09:00 | ||
| Configure Headers and Footers | 00:07:00 | ||
| Managing Workbooks | |||
| Manage Worksheets | 00:05:00 | ||
| Manage Workbook and Worksheet Views | 00:07:00 | ||
| Manage Workbook Properties | 00:06:00 | ||
| Working with Functions | |||
| Work with Ranges | 00:18:00 | ||
| Use Specialized Functions | 00:11:00 | ||
| Work with Logical Functions | 00:23:00 | ||
| Work with Date & Time Functions | 00:08:00 | ||
| Work with Text Functions | 00:11:00 | ||
| Working with Lists | |||
| Sort Data | 00:10:00 | ||
| Filter Data | 00:10:00 | ||
| Query Data with Database Functions | 00:09:00 | ||
| Outline and Subtotal Data | 00:09:00 | ||
| Analyzing Data | |||
| Apply Intermediate Conditional Formatting | 00:07:00 | ||
| Apply Advanced Conditional Formatting | 00:05:00 | ||
| Visualizing Data with Charts | |||
| Create Charts | 00:13:00 | ||
| Modify and Format Charts | 00:12:00 | ||
| Use Advanced Chart Features | 00:12:00 | ||
| Using PivotTables and PivotCharts | |||
| Create a PivotTable | 00:13:00 | ||
| Analyze PivotTable Data | 00:12:00 | ||
| Present Data with PivotCharts | 00:07:00 | ||
| Filter Data by Using Timelines and Slicers | 00:11:00 | ||
| Working with Multiple Worksheets and Workbooks | |||
| Use Links and External References | 00:12:00 | ||
| Use 3-D References | 00:06:00 | ||
| Consolidate Data | 00:05:00 | ||
| Using Lookup Functions and Formula Auditing | |||
| Use Lookup Functions | 00:12:00 | ||
| Trace Cells | 00:09:00 | ||
| Watch and Evaluate Formulas | 00:08:00 | ||
| Sharing and Protecting Workbooks | |||
| Collaborate on a Workbook | 00:19:00 | ||
| Protect Worksheets and Workbooks | 00:08:00 | ||
| Automating Workbook Functionality | |||
| Apply Data Validation | 00:13:00 | ||
| Search for Invalid Data and Formulas with Errors | 00:04:00 | ||
| Work with Macros | 00:18:00 | ||
| Creating Sparklines and Mapping Data | |||
| Create Sparklines | 00:07:00 | ||
| MapData | 00:07:00 | ||
| Forecasting Data | |||
| Determine Potential Outcomes Using Data Tables | 00:08:00 | ||
| Determine Potential Outcomes Using Scenarios | 00:09:00 | ||
| Use the Goal Seek Feature | 00:04:00 | ||
| Forecasting Data Trends | 00:05:00 | ||
| Excel Templates | |||
| Excel Templates | 00:00:00 | ||
| Assignment | |||
| Assignment – Microsoft Excel Complete Course 2019 | 1 week, 3 days | ||
| Recommended Materials | |||
| Workbook – Microsoft Excel Complete Course 2019 | 2 weeks, 1 day | ||
| Order Your Certificate | |||
| Order Your Certificate QLS | 00:00:00 | ||
| Trustpilot Review | |||
| Trustpilot Review | 00:00:00 | ||
With a team of industry professionals producing and delivering our course content, you can be sure the skills and knowledge you learn are applicable to your career aspirations, whether that’s in management, administration or beyond.
Take All courses for £49