Microsoft Excel
Microsoft Excel is a CPD-accredited course for beginners and professionals seeking certification and essential Excel skills. Learn formulas, functions, charts, PivotTables, data analysis, forecasting, and workbook management to improve workplace productivity.
4.9
(9 Reviews)
8 Students
Microsoft Excel
Exclusive Deal! 94% Off, Today Only!
Sale Ends In
TAKE All courses for
£99 
This course includes:
-
Access1 Year Access -
Skill Level -
Duration11 hours, 19 minutes -
Students8 Students -
CPD Point
15
- Original price was: £415.£25Current price is: £25. ex VAT
- 1 year
- Number of Units71
- Number of Quizzes2
- 11 hours, 19 minutes Gift this course
14-Day Money-Back Guarantee
Microsoft Excel – CPD Accredited
Build the Excel skills employers value with this CPD-accredited Microsoft Excel course, designed to help you work more efficiently with spreadsheets, calculations, data, and reports. In the UK, 56% of adults improved their digital or online skills in the last year, highlighting the growing importance of continuous digital development.
Throughout the course, you will learn Excel 2019 features, formulas and functions, worksheet formatting, charts, PivotTables, lookup functions, data analysis, forecasting, workbook protection, automation, templates, and more. You will also explore tools such as CONCAT, IFS, MAXIFS, MINIFS, TEXTJOIN, Map Charts, and Power Pivot.
By completing this course, you can improve productivity, organise and analyse information more confidently, produce clearer reports, and strengthen your CV with valuable Excel knowledge that can support a wide range of professional roles.
Course Description
This Microsoft Excel course is designed to build a strong understanding of spreadsheet management, data organisation, calculations, and reporting, making it suitable for beginners and professionals who want to improve their digital workplace skills.
Throughout the course, you will learn how to create and manage worksheets, use formulas and functions, format data, work with lists, analyse information, and present results using charts, PivotTables, and PivotCharts. You will also explore Excel 2019 features such as CONCAT, IFS, MAXIFS, MINIFS, SWITCH, TEXTJOIN, Map Charts, and Power Pivot.
In addition, the course covers lookup functions, formula auditing, forecasting, workbook protection, templates, automation, and working across multiple worksheets and workbooks. These skills can help you manage data more efficiently, improve productivity, create clearer reports, and strengthen your confidence when using Microsoft Excel in professional settings.
Learning Outcomes
By completing this Microsoft Excel online course, you will:
- Understand key Microsoft Excel 2019 features and spreadsheet tools
- Create, modify, format, and manage worksheets and workbooks effectively
- Perform calculations using formulas and essential Excel functions
- Use functions such as CONCAT, IFS, MAXIFS, MINIFS, SWITCH, and TEXTJOIN
- Organise, sort, filter, and manage data using Excel lists
- Analyse data using PivotTables, PivotCharts, and other Excel tools
- Create charts, sparklines, Map Charts, and Funnel Charts to present data clearly
- Use lookup functions and formula auditing tools with greater confidence
- Work efficiently with multiple worksheets and workbooks
- Apply forecasting tools to analyse trends and future data
- Protect and share workbooks appropriately
- Use templates, Power Pivot features, and automation tools to improve productivity
Why People Love This Course
- CPD Accredited certification to strengthen your CV and demonstrate your Microsoft Excel knowledge
- Study Microsoft Excel online with 12 months unlimited access – learn anytime, anywhere
- Develop valuable skills in formulas, functions, charts, PivotTables, data analysis, forecasting, and workbook management
- Build confidence using Excel 2019 features such as CONCAT, IFS, MAXIFS, MINIFS, TEXTJOIN, Map Charts, and Power Pivot
- Instant digital certificate upon completion, with the option to order a hard copy
- Receive a free student ID card to enhance your learner profile
- Flexible, self-paced learning with no deadlines, ideal for busy professionals
- Transparent pricing with no hidden fees
- Access dedicated tutor support on weekdays throughout your learning journey
- Fast assessment and instant results, helping you complete the course efficiently
Why Study This Course?
Whether you are starting your career or looking to strengthen your digital workplace skills, this Microsoft Excel course provides essential knowledge to help you work more confidently with spreadsheets, data, calculations, and reports.
As a comprehensive Excel training course, it covers key features including formulas, functions, charts, PivotTables, data analysis, forecasting, lookup functions, workbook management, and Excel 2019 tools.
This course can support your development in roles such as administrator, office assistant, data entry professional, accounts assistant, or business support worker. It can also help you improve productivity, strengthen your CV, and build valuable Excel skills used across a wide range of professional environments.
Who is this Microsoft Excel course for?
This course is ideal for individuals who want to build or improve their Microsoft Excel skills for professional, academic, or everyday use.
It is suitable for:
- Beginners wanting to learn essential Microsoft Excel skills
- Office workers managing spreadsheets, data, and reports
- Administrators looking to improve workplace productivity skills
- Professionals seeking stronger data analysis and reporting skills
- Job seekers wanting to strengthen their CV
- Accounts staff working with formulas and calculations
- Business professionals using spreadsheets for everyday tasks
- Anyone interested in improving their Microsoft Excel knowledge
Requirements
There are no specific prerequisites to enrol in this Microsoft Excel course. Anyone interested in developing their Excel skills can take this course.
The course is accessible from any internet-enabled smart device, allowing you to study conveniently from the comfort of your home.
All you need is a willingness to learn, basic literacy skills, and to be over the age of 16.
CPD Certification
After successfully completing the Microsoft Excel course, you will qualify for a CPD Certificate as proof of your continued professional development and achievement. This certificate can enhance your professional profile and showcase your commitment to building relevant skills and knowledge. You can receive your digital certificate for only £10, or request a printed hard copy sent by post for just £29 or both for £39.
Assessment
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 and fulfil the Quality Licence Scheme-endorsed certificate criteria. 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.
Job Opportunities
The Microsoft Excel course is an online knowledge-based programme designed to strengthen spreadsheet, data management, reporting, and analysis skills. While it does not guarantee employment or provide a professional licence, it can support progression into a range of administrative, finance, sales, and data-focused roles.
- Admin Assistant
Maintain spreadsheets, organise records, prepare reports, and support everyday office administration using Excel efficiently.
Average UK Salary: £21,000–£28,000 per year - Sales Administrator
Manage sales records, process orders, track payments, and maintain accurate customer information using spreadsheet tools.
Average UK Salary: £22,000–£28,000 per year - Payroll Administrator
Organise payroll information, maintain employee payment records, and support accurate salary calculations and reporting.
Average UK Salary: £22,000–£35,000 per year - Bookkeeper
Maintain financial records, track transactions, organise accounts data, and support accurate financial reporting activities.
Average UK Salary: £24,000–£35,000 per year - Accounting Technician
Support financial operations, prepare accounts, organise payment data, and assist with financial calculations and records.
Average UK Salary: £24,000–£35,000 per year - Finance Officer
Manage financial records, monitor organisational income and spending, and prepare information for reports and compliance.
Average UK Salary: £26,000–£38,000 per year - Business Analyst
Analyse business information, identify operational improvements, and use data to support informed organisational decisions.
Average UK Salary: £23,000–£55,000 per year - Executive Assistant
Support senior managers with reports, projects, data organisation, scheduling, and important business documentation.
Average UK Salary: £28,000–£60,000 per year - Database Administrator
Organise digital records, update stored information, maintain data accuracy, and support secure information management.
Average UK Salary: £28,000–£62,000 per year - Credit Controller
Monitor customer accounts, track outstanding payments, maintain financial records, and support effective debt recovery processes.
Average UK Salary: £21,000–£32,000 per year
Frequently Asked Questions
What does the Microsoft Excel course cover?
This course covers Excel 2019 features, formulas, functions, worksheet formatting, charts, PivotTables, lookup functions, data analysis, forecasting, workbook management, automation, templates, and Power Pivot. It is designed to build useful spreadsheet and reporting knowledge for professional settings.
Is the Microsoft Excel course suitable for beginners?
Yes. The course is suitable for beginners as well as professionals who want to improve their existing Excel knowledge. It introduces essential features before progressing to more advanced tools and functions.
Can I study this Microsoft Excel course online?
Yes. The Microsoft Excel course is delivered online, allowing you to study from home and learn around your work, family, or other commitments.
Will I receive a certificate after completing the course?
Yes. Successful learners can receive a CPD-accredited certificate after completing the course. This can help demonstrate your Excel knowledge and strengthen your CV.
Does this course provide a professional Microsoft certification?
No. This course provides CPD-accredited training but is not an official Microsoft certification such as Microsoft Office Specialist. It is designed to develop knowledge and improve workplace Excel skills.
What jobs can this Microsoft Excel course support?
This course can support skills useful for roles such as administrator, sales administrator, payroll administrator, bookkeeper, finance officer, executive assistant, and business support professional.
What Excel functions will I learn?
You will explore functions such as CONCAT, IFS, MAXIFS, MINIFS, SWITCH, and TEXTJOIN, alongside formulas, lookup functions, and formula auditing tools.
Will I learn data analysis in this course?
Yes. The course covers data analysis, PivotTables, PivotCharts, charts, forecasting, lists, and other tools used to organise and interpret spreadsheet data.
Who is this Microsoft Excel course best for?
It is ideal for beginners, office workers, administrators, finance staff, job seekers, business professionals, and anyone who wants to improve their spreadsheet and data management skills.
Why should I study Microsoft Excel?
Excel is widely used for calculations, reporting, data organisation, budgeting, and analysis. Developing stronger Excel skills can improve productivity, support career development, and help you work more confidently with business information.
Course Curriculum
| 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 | ||
| Mock Exam | |||
| Mock Exam- MS Office 2016 Excel for Beginners | 00:20:00 | ||
| Final Exam | |||
| Final Exam- MS Office 2016 Excel for Beginners | 00:20:00 | ||