Course Overview
This CPD-accredited Microsoft Office course offers a well-rounded, skill-building journey through the four core Office programs: Excel, Word, PowerPoint, and Access. With 33 sections and 66 focused lectures, you’ll learn to create spreadsheets, format professional documents, build impactful presentations, and manage databases effectively. The Level 2 Microsoft Office Essentials course is ideal for learners looking to boost workplace productivity, job readiness, and confidence in everyday digital tasks.
Learning Outcomes
By the end of this course, you will:
- Confidently navigate the Microsoft Office 2016 suite: Excel, Word, PowerPoint, and Access
- Perform calculations, manage workbooks, and format worksheets in Excel
- Format documents, add graphics, and prepare reports using Word
- Create compelling presentations with charts, tables, and design tools in PowerPoint
- Modify data, generate reports, and manage queries and forms in Access
- Apply time-saving tools and formatting techniques across all applications
Why Enrol in This Course?
The Level 2 Microsoft Office Essentials course offers a flexible program for students, jobseekers, office professionals, and anyone looking to upgrade their digital competency. With CPD accreditation and full online access, you’ll learn skills that will prepare you for sectors including administration, finance, education, and customer service.
Who is This Course for?
Perfect for:
- School leavers and graduates entering the workforce
- Professionals transitioning into administrative or customer service roles
- Small business owners and freelancers managing their own operations
- Anyone looking to improve their CV and digital literacy
Prerequisites for This Course
This course is ideal for:
- Beginners with basic computer knowledge
- Students, jobseekers, and professionals looking to improve digital office skills
- Individuals preparing for office, admin, or support roles
No prior Microsoft Office experience is required.
Certification
Upon completing the course and passing the final exam, you will receive a CPD QS Accredited Certificate from Apex Learning. This certification demonstrates your knowledge and skills as a nursing assistant in the UK. The Digital version of the certificate is available for £9.99 only, and you can order a hard copy of the certificate for £14.99 only.
Career Path
Upon completing this Microsoft Office course, you’ll be prepared for roles such as:
- Administrative Assistant
Manage documents, spreadsheets, and presentations with confidence.
Average UK Salary: £20,000 – £28,000 per year - Office Manager
Oversee workflow, communications, and reporting tools using Microsoft Office.
Average UK Salary: £28,000 – £40,000 per year - Data Entry Specialist
Use Excel and Access for data processing, analysis, and management.
Average UK Salary: £20,000 – £30,000 per year - Customer Service Administrator
Handle documents, schedules, and reports with clarity and accuracy.
Average UK Salary: £22,000 – £32,000 per year
Level 2 Microsoft Office Essentials | CPD Accredited Microsoft Office Course Online – UK
Learning Microsoft Office is no longer optional, but essential. The Level 2 Microsoft Office Essentials course provides structured training you need to work efficiently across the most widely used software in business today. Whether you’re advancing your admin skills or preparing for an office-based career, this course equips you to confidently use Excel, Word, PowerPoint, and Access with precision and professionalism.
Course Overview
This CPD-accredited Microsoft Office course offers a well-rounded, skill-building journey through the four core Office programs: Excel, Word, PowerPoint, and Access. With 33 sections and 66 focused lectures, you’ll learn to create spreadsheets, format professional documents, build impactful presentations, and manage databases effectively. The Level 2 Microsoft Office Essentials course is ideal for learners looking to boost workplace productivity, job readiness, and confidence in everyday digital tasks.
Learning Outcomes
By the end of this course, you will:
- Confidently navigate the Microsoft Office 2016 suite: Excel, Word, PowerPoint, and Access
- Perform calculations, manage workbooks, and format worksheets in Excel
- Format documents, add graphics, and prepare reports using Word
- Create compelling presentations with charts, tables, and design tools in PowerPoint
- Modify data, generate reports, and manage queries and forms in Access
- Apply time-saving tools and formatting techniques across all applications
Why Enrol in This Course?
The Level 2 Microsoft Office Essentials course offers a flexible program for students, jobseekers, office professionals, and anyone looking to upgrade their digital competency. With CPD accreditation and full online access, you’ll learn skills that will prepare you for sectors including administration, finance, education, and customer service.
Who is This Course for?
Perfect for:
- School leavers and graduates entering the workforce
- Professionals transitioning into administrative or customer service roles
- Small business owners and freelancers managing their own operations
- Anyone looking to improve their CV and digital literacy
Prerequisites
This course is ideal for:
- Beginners with basic computer knowledge
- Students, jobseekers, and professionals looking to improve digital office skills
- Individuals preparing for office, admin, or support roles
No prior Microsoft Office experience is required.
Assessment Method
Assessment for the course is conducted through an automated multiple-choice exam. A score of 60% is required to pass and earn the CPD Accredited Certificate. Reflective assignments are provided to enhance your learning, with expert tutor feedback available.
Certification
Upon completing the course and passing the final exam, you will receive a CPD QS Accredited Certificate from Apex Learning. This certification demonstrates your knowledge and skills as a nursing assistant in the UK. The Digital version of the certificate is available for £9.99 only, and you can order a hard copy of the certificate for £14.99 only.
Career Path
Upon completing this Microsoft Office course, you’ll be prepared for roles such as:
- Administrative Assistant
Manage documents, spreadsheets, and presentations with confidence.
Average UK Salary: £20,000 – £28,000 per year - Office Manager
Oversee workflow, communications, and reporting tools using Microsoft Office.
Average UK Salary: £28,000 – £40,000 per year - Data Entry Specialist
Use Excel and Access for data processing, analysis, and management.
Average UK Salary: £20,000 – £30,000 per year - Customer Service Administrator
Handle documents, schedules, and reports with clarity and accuracy.
Average UK Salary: £22,000 – £32,000 per year
Frequestly Asked Questions
What is the Level 2 Microsoft Office Essentials course?
It’s a CPD-accredited course covering key skills in Microsoft Word, Excel, PowerPoint, and Access for everyday business and admin tasks.
Do I need Microsoft Office installed to take the course?
While not required, having access to Office 2016 or newer will help you follow along and practise skills.
Will I receive a certificate?
Yes, a CPD-accredited digital certificate will be awarded upon successful completion.
Will I receive a certificate?
Answer 3
Can I study on mobile?
Yes, the course is fully accessible across all devices—desktop, tablet, and mobile.
Is this course suitable for job preparation?
Absolutely. Microsoft Office skills are essential for most admin, clerical, and office-based jobs.
How do I enrol?
Just visit our website to register and gain instant access to all course content.
Course Curriculum
- 33 sections
- 66 lectures
- 00:00:00 total length
-
Navigate the Excel User Interfact 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
-
Create Worksheet Formulas 00:15:00
-
Insert Functions 00:17:00
-
Reuse Formulas and Functions 00:17:00
-
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
-
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
-
Preview and Print a Workbook 00:11:00
-
Set Up the Page Layout 00:09:00
-
Configure Headers and Footers 00:07:00
-
Manage Worksheets 00:05:00
-
Manage Workbook and Worksheet Views 00:07:00
-
Manage Workbook Properties 00:06:00
-
Navigate in Microsoft Word 00:12:00
-
Create and Save Word Documents 00:24:00
-
Manage Your Workspace 00:06:00
-
Edit Documents 00:16:00
-
Preview and Print Documents 00:04:00
-
Customize the Word Environment 00:08:00
-
Apply Character Formatting 00:17:00
-
Control Paragraph Layout 00:19:00
-
Align Text Using Tabs 00:07:00
-
Display Text in Bulleted or Numbered Lists 00:03:00
-
Apply Borders and Shading 00:05:00
-
Make Repetitive Edits 00:06:00
-
Apply Repetitive Formatting 00:10:00
-
Use Styles to Streamline Repetitive Formatting Tasks 00:14:00
-
Sort a List 00:05:00
-
Format a List 00:06:00
-
Insert a Table 00:07:00
-
Modify a Table 00:06:00
-
Format a Table 00:03:00
-
Convert Text to a Table 00:04:00
-
Insert Symbols and Special Characters 00:04:00
-
Add Images to a Document 00:11:00
-
Apply a Page Border and Color 00:03:00
-
Add Headers and Footers 00:06:00
-
Control Page Layout 00:05:00
-
Add a Watermark 00:04:00
-
Check Spelling Grammar and Readability 00:07:00
-
Use Research Tools 00:06:00
-
Check Accessibility 00:03:00
-
Save a Document to Other Formats 00:04:00
-
Workbooks – Microsoft Word 2016 (Beginner) 00:00:00
-
Navigate the PowerPoint Environment 00:28:00
-
View and Navigate a Presentation 00:15:00
-
Create and Save a PowerPoint Presentation 00:13:00
-
Use PowerPoint Help 00:10:00
-
Select a Presentation Type 00:08:00
-
Edit Text 00:13:00
-
Build a Presentation 00:27:00
-
Format Characters 00:11:00
-
Format Paragraphs 00:16:00
-
Format Text Boxes 00:09:00
-
Insert Images 00:10:00
-
Insert Shapes 00:15:00
-
Edit Objects 00:16:00
-
Format Objects 00:06:00
-
Group Objects 00:04:00
-
Arrange Objects 00:07:00
-
Animate Objects 00:07:00
-
Create a Table 00:09:00
-
Insert a Table from Other Microsoft Office Applications 00:06:00
-
Create a Chart 00:10:00
-
Format a Chart 00:10:00
-
Insert a Chart from Microsoft Excel 00:05:00
-
Review Your Presentation 00:11:00
-
Apply Transitions 00:05:00
-
Print Your Presentation 00:05:00
-
Deliver Your Presentation 00:08:00
-
Orientation to Microsoft Access1 00:39:00
-
Create a Simple Access Database 00:10:00
-
Get Help and Configure Options in Microsoft Access 00:06:00
-
Modify Table Data 00:17:00
-
Sort and Filter Records 00:05:00
-
Create Basic Queries 00:15:00
-
Sort and Filter Data in a Query 00:14:00
-
Perform Calculations in a Query 00:08:00
-
Create Basic Access Forms 00:07:00
-
Work with Data on Access Forms 00:23:00
-
Create a Report 00:23:00
-
Add Controls to a Report 00:12:00
-
Enhance the Appearance of a Report 00:05:00
-
Prepare a Report for Print 00:03:00
-
Organize Report Information 00:15:00
-
Format Reports 00:12:00
-
Claim Your Certificate 00:00:00
Level 2 Microsoft Office Essentials
Save 95% - Sale Ends in
Frequently Bought Together
5 Star course rating
£19.99
£419
Save 95% - Sale Ends in
ALL COURSES FOR - £99 This course includes:
-
Duration:16 hours, 31 minutes
-
Access:1 year access
-
Level:
-
CPD Points:10
