Skip to content
Microsoft Office Skills Certification (Microsoft Word, Excel, PowerPoint, and 365) cover image
Play overlay
Preview this course

Microsoft Office Skills Certification (Microsoft Word, Excel, PowerPoint, and 365)
Empower UK Employment Training

Free Course: Admin, Secretarial & PA | 100% Pass Rate | Assignment Available | Free Certificate

Summary

Price
Save 4%
£19 inc VAT (was £19.99)
Offer ends 30 April 2026
Study method
Online, On Demand 
Duration
9.4 hours · Self-paced
Qualification
No formal qualification
Certificates
  • Empower UK Accredited Certificate on Microsoft Office - Free
  • Reed Courses Certificate of Completion - Free
  • Order Your CPDQE Certificate and Transcript - £12
Additional info
  • Tutor is available to students

27 students purchased this course

Add to basket or enquire

Overview

Microsoft Office Skills Certification (Microsoft Word, Microsoft Excel, PowerPoint, and 365)

Embark on the Microsoft Office Skills Certification course, specifically designed to elevate your expertise across Microsoft Office tools including Microsoft Word, Excel, PowerPoint, and Office 365. This curriculum is structured to provide comprehensive training from basic to advanced levels, ensuring you acquire essential skills beneficial for optimizing productivity, managing complex data, and crafting impactful presentations in any professional setting.

Learning Outcomes:

  • Apply foundational skills across Word, Excel, PowerPoint, and Office 365.
  • Analyse and manipulate data efficiently using Microsoft Office tools.
  • Create and refine presentations with advanced formatting and multimedia integration.
  • Construct and utilise complex formulas and pivot tables effectively.
  • Produce sophisticated documents using Microsoft Office's advanced formatting and styles.
  • Execute comprehensive tasks combining Word, Excel, and PowerPoint features.

Key Employment Opportunities:

  • Office Administrator: Yearly £225,00 approx.
  • Microsoft Office Specialist: Yearly £28,000 approx.
  • Administrative Assistant: Yearly £20,355 approx.

More Benefits:

  • Assignment on Microsoft Office course
  • Free Reed Certificate on Microsoft Office course
  • Moneyback Guarantee
  • Lifetime Access
  • Free Course - Admin, Secretarial & PA

Certificates

Curriculum

39
sections
155
lectures
9h 22m
total
    • 1: Microsoft Office: Introduction 02:58
    • 2: Microsoft Office: Getting started on Windows macOS and Linux 01:21
    • 3: Microsoft Office: How to ask great questions 01:14
    • 4: Microsoft Office: FAQ 01:19
    • 5: Microsoft Office: Excel Overview 05:20
    • 6: Microsoft Office: Start Excel Spreadsheet 04:26
    • 7: Microsoft Office: Enter Text and Numbers 07:24
    • 8: Microsoft Office: Relative References 03:40
    • 9: Microsoft Office: Working with ranges 06:52
    • 10: Course Feedback 01:00
    • 11: Microsoft Office: Save and Save as Actions 07:52
    • 12: Microsoft Office: File Extensions, Share, Export, and Publish files 05:53
    • 13: Microsoft Office: Adding Rows and Columns 02:34
    • 14: Microsoft Office: Modifying Rows and Column lengths 05:03
    • 15: Microsoft Office: Copy Cut and Paste 07:07
    • 16: Microsoft Office: Copying Formulas 03:01
    • 17: Microsoft Office: Page setup options 05:50
    • 18: Microsoft Office: Fit to print on One Page 02:39
    • 19: Microsoft Office: Print Workbooks 02:47
    • 20: Microsoft Office: Sorting Data Ascending Order 03:48
    • 21: Microsoft Office: Sorting Data Descending Order 02:25
    • 22: Microsoft Office: Filter Data 04:09
    • 23: Microsoft Office: Basic formula operations 06:14
    • 24: Microsoft Office: Date time functions 06:20
    • 25: Microsoft Office: Mathematical functions phase 1 19:54
    • 26: Microsoft Office: Mathematical functions phase 2 12:23
    • 27: Microsoft Office: Vlookup Formula 12:12
    • 28: Microsoft Office: Hlookup Formula 04:07
    • 29: Microsoft Office: Xlookup 07:39
    • 30: Microsoft Office: Handling NA and Approximates match in XLookup 10:31
    • 31: Microsoft Office: Split Text into columns 07:03
    • 32: Microsoft Office: Flash Fill 07:03
    • 33: Microsoft Office: Data Validation 06:34
    • 34: Microsoft Office: Remove Duplicates 07:47
    • 35: Microsoft Office: Import Data From Text Files 05:38
    • 36: Microsoft Office: Import Data From .CSV Files 03:22
    • 37: Microsoft Office: Formatting Font 04:15
    • 38: Microsoft Office: Formatting Alignment 06:04
    • 39: Microsoft Office: Formatting Number 04:37
    • 40: Microsoft Office: Formatting Date 03:29
    • 41: Microsoft Office: Formatting Tables 05:13
    • 42: Microsoft Office: Creating Pivot Tables 03:51
    • 43: Microsoft Office: Pivot Charts 01:49
    • 44: Microsoft Office: Excel Charts – Categories 02:30
    • 45: Microsoft Office: Elements of a Chart 04:12
    • 46: Microsoft Office: Creating Charts 01:55
    • 47: Microsoft Office: Column or Bar charts 04:21
    • 48: Microsoft Office: Formatting Charts 03:37
    • 49: Microsoft Office: Line Charts 02:13
    • 50: Microsoft Office: Pie and Doughnut charts 03:47
    • 51: Microsoft Office: Overview 03:47
    • 52: Microsoft Office: Start PowerPoint Presentation 04:59
    • 53: Microsoft Office: Screen Setting and Views 04:37
    • 54: Microsoft Office: Presentation Tips and Guidelines 06:00
    • 55: Microsoft Office: Creating a New Presentation 03:51
    • 56: Microsoft Office: Working with Slides 03:40
    • 57: Microsoft Office: Save a Presentation 04:16
    • 58: Microsoft Office: Print Slides 03:10
    • 59: Microsoft Office: Formatting Text 05:05
    • 60: Microsoft Office: Slide Text Alignments 03:01
    • 61: Microsoft Office: Multi-Column Text Alignments 01:40
    • 62: Microsoft Office: Adding Bullets and Numbered List Items 02:48
    • 63: Microsoft Office: Insert Shapes 03:26
    • 64: Microsoft Office: Insert Icons 03:02
    • 65: Microsoft Office: Insert Graphics 03:38
    • 66: Microsoft Office: Add 3D Models 02:41
    • 67: Microsoft Office: Insert Pictures 02:58
    • 68: Microsoft Office: Picture Options 03:56
    • 69: Microsoft Office: Picture Cropping 02:33
    • 70: Microsoft Office: Applying Built-in Picture Styles 04:02
    • 71: Microsoft Office: Add SmartArt Graphic 02:33
    • 72: Microsoft Office: Modifying SmartArt 03:13
    • 73: Microsoft Office: Creating a Target Chart using SmartArt 03:04
    • 74: Microsoft Office: Create a Table on Slide 04:13
    • 75: Microsoft Office: Formatting Tables 02:24
    • 76: Microsoft Office: Inserting Tables 01:55
    • 77: Microsoft Office: Table Layouts 01:19
    • 78: Microsoft Office: Add a Chart 01:57
    • 79: Microsoft Office: Formatting Charts 01:48
    • 80: Microsoft Office: Insert Chart from Microsoft Excel 02:57
    • 81: Microsoft Office: Add a Chart 01:57
    • 82: Microsoft Office: Formatting Charts 01:48
    • 83: Microsoft Office: Insert Chart from Microsoft Excel 02:57
    • 84: Microsoft Office: Adding Video to a Presentation 02:31
    • 85: Microsoft Office: Adding Audio to a Presentation 01:33
    • 86: Microsoft Office: Screen Recording and Adding 02:28
    • 87: Microsoft Office: Applying Transitions to Presentation 04:14
    • 88: Microsoft Office: Object Animation 03:14
    • 89: Microsoft Office: Effect Options 02:03
    • 90: Microsoft Office: Advanced Animation 01:31
    • 91: Microsoft Office: Triggers to control animation 01:47
    • 92: Microsoft Office: Onscreen Presentation 02:16
    • 93: Microsoft Office: Hiding Slides 01:42
    • 94: Microsoft Office: Changing Order of Slides 01:50
    • 95: Microsoft Office: Copying Slides 02:10
    • 96: Microsoft Office: Overview of MS Word 03:57
    • 97: Microsoft Office: Start MS Word 2021 04:48
    • 98: Microsoft Office: Create a New Blank Document 04:20
    • 99: Microsoft Office: Creating a Paragraph Text 04:55
    • 100: Microsoft Office: Non-printing characters 02:59
    • 101: Microsoft Office: Save a Document 02:45
    • 102: Microsoft Office: Open a Document 01:22
    • 103: Microsoft Office: Find and Replace 03:50
    • 104: Microsoft Office: AutoCorrect Options 02:54
    • 105: Microsoft Office: Formatting Text 03:59
    • 106: Microsoft Office: Copy Cut and Paste 03:50
    • 107: Microsoft Office: Character Formatting 02:28
    • 108: Microsoft Office: Format Painter 03:58
    • 109: Microsoft Office: Work with Numbers 01:43
    • 110: Microsoft Office: Add Bullets 02:46
    • 111: Microsoft Office: Outline Creation 03:42
    • 112: Microsoft Office: Creating a Table 02:30
    • 113: Microsoft Office: Adding Rows and Columns to a table 02:10
    • 114: Microsoft Office: Formatting Table Data 02:19
    • 115: Microsoft Office: Borders and Shading 01:45
    • 116: Microsoft Office: Sorting in a Table 03:41
    • 117: Microsoft Office: Draw a Table 03:31
    • 118: Microsoft Office: Convert Text to Table 02:43
    • 119: Microsoft Office: Convert Table to Text 02:05
    • 120: Microsoft Office: Insert a Spreadsheet 01:41
    • 121: Microsoft Office: Quick Tables – Readily Available Formats 01:52
    • 122: Microsoft Office: Working with Styles 01:54
    • 123: Microsoft Office: Creating Styles 01:50
    • 124: Microsoft Office: Clear Formatting 01:16
    • 125: Microsoft Office: Margins 01:44
    • 126: Microsoft Office: Orientation 01:23
    • 127: Microsoft Office: Page size setting 00:57
    • 128: Microsoft Office: Adding columns 03:24
    • 129: Microsoft Office: Page break section break 01:37
    • 130: Microsoft Office: Adding watermark 02:58
    • 131: Microsoft Office: Headers and footers 02:41
    • 132: Microsoft Office: Create envelops 02:28
    • 133: Microsoft Office: Creating labels 01:58
    • 134: Microsoft Office: Creating a mail merge document 03:19
    • 135: Microsoft Office: Thesaurus and spell check 01:09
    • 136: Microsoft Office: Word count 01:21
    • 137: Microsoft Office: Speech - read aloud 00:58
    • 138: Microsoft Office: Language - translate 01:13
    • 139: Microsoft Office: Tracking 01:10
    • 140: Course Completion 01:00
    • 141: Microsoft Office: Assignment Instruction 01:00
    • 142: Course Assignment Worksheet 10:00
    • 143: Empower UK Submit Your Assignment 01:00
    • 144: Ordering CPDQE Certificate and Transcript is Optional 01:00
    • 145: Order Your CPD Certificate & Transcript 01:00
    • 146: Module 01 06:00
    • 147: Module 02 05:00
    • 148: Module 03 07:00
    • 149: Module 04 12:00
    • 150: Module 05 05:00
    • 151: Module 06 06:00
    • 152: Order Certificate 01:00
    • 155: Recommendation 01:00

Course media

Description

Key Lesson Snippets of this Microsoft Office Skills Certification:

  • Microsoft Office - Excel 2021:

    • Basics to Advanced Formulas: Learn to navigate Microsoft Excel from simple spreadsheet setups to intricate formulas.
    • Data Handling and Analysis: Excel in sorting, filtering, and leveraging Pivot Tables for robust data analysis in Microsoft Excel.
    • Visual Data Representation: Become adept at using Microsoft Excel charts for effective data visualisation.
  • Microsoft Office - PowerPoint 2021:

    • Introduction to Creation: Acquire foundational skills for creating and formatting Microsoft PowerPoint presentations.
    • Advanced Features: Delve into advanced features such as graphics addition, multimedia integration, and SmartArt optimization in Microsoft PowerPoint.
    • Animations and Transitions: Master the use of animations and transitions to enhance engagement in Microsoft PowerPoint presentations.
  • Microsoft Office - Word 2021:

    • Document Creation and Management: Begin with the basics and advance to complex document management techniques in Microsoft Word.
    • Professional Document Preparation: Gain expertise in page layout, tables, and preparing professional documents for presentation and printing using Microsoft Word.

Who is this course for?

This course will pave the way for higher study in the field of Microsoft Office. You can enrol on higher level Microsoft Office courses, such as:

  • Level 3 Certificate in Microsoft Office
  • Level 4 Certificate in Microsoft Office
  • Level 5 Certificate in Microsoft Office

Career path

  • Microsoft Office Skills Specialist
  • Microsoft Excel for Accounting
  • Office Administrator

Questions and answers

There are currently no Q&As for this course. Be the first to ask a question.

Reviews

5.0
Course rating
100%
Service
100%
Content
100%
Value

FAQs

Interest free credit agreements provided by Zopa Bank Limited trading as DivideBuy are not regulated by the Financial Conduct Authority and do not fall under the jurisdiction of the Financial Ombudsman Service. Zopa Bank Limited trading as DivideBuy is authorised by the Prudential Regulation Authority and regulated by the Financial Conduct Authority and the Prudential Regulation Authority, and entered on the Financial Services Register (800542). Zopa Bank Limited (10627575) is incorporated in England & Wales and has its registered office at: 1st Floor, Cottons Centre, Tooley Street, London, SE1 2QG. VAT Number 281765280. DivideBuy's trading address is First Floor, Brunswick Court, Brunswick Street, Newcastle-under-Lyme, ST5 1HH. © Zopa Bank Limited 2026. All rights reserved.