Skip to content
Microsoft Office Skills (Microsoft Excel, Word, PowerPoint) Administration & Office Skills cover image
Play overlay
Preview this course

Microsoft Office Skills (Microsoft Excel, Word, PowerPoint) Administration & Office Skills
Royal Open College

07 Course | Microsoft Office 2026 Complete Package (250+ Trending Topics) | Free Certificate | Learn Basic to Advanced

Summary

Price
Save 23%
£15 inc VAT (was £19.50)
Offer ends 15 September 2026
Study method
Online, On Demand 
Course format
246 Videos and 50 PDFs
Duration
23.5 hours · Self-paced
Qualification
No formal qualification
Additional info
  • Tutor is available to students

21 students purchased this course

Add to basket or enquire

Overview

**What's New?**

  • ➥ Latest Update (September 2026)
  • ➥ 14 Topics Added
  • ➥ 07 Course Bundle
  • ➥ Budget-friendly
  • ➥ Free MCQ Based Assessment with Unlimited Retake Exam

In today’s fast-paced digital workplace, employers value professionals who can confidently manage office software, communication, administration, and business operations. The Microsoft Office Skills (Microsoft Excel, Word, PowerPoint) Administration & Office Skills course is designed to provide learners with the practical knowledge and workplace competencies needed to thrive in modern office environments. Whether you are starting your career, improving existing skills, or aiming to increase workplace productivity, this course offers comprehensive training to support your professional development.

The course provides in-depth training in Microsoft Office applications, including Word, Excel, PowerPoint, Outlook, Teams, and Access, helping learners develop the skills needed to create professional documents, manage data, deliver presentations, and communicate effectively. Learners will also explore advanced workplace technologies such as Power BI, Power Platform, Office 365, and AI-powered productivity tools like Copilot to enhance collaboration, reporting, and digital efficiency.

In addition to technical software skills, this course develops essential office administration and professional workplace competencies, including business communication, office management, record-keeping, customer service, workplace productivity, organisation, and business ethics. By the end of the course, learners will possess a well-rounded combination of digital, administrative, and professional skills applicable to a wide range of office and business support roles.

Courses included in this Bundle:

  • Course 01: MS Word 2026
  • Course 02: MS Excel 2026
  • Course 03: MS PowerPoint 2026
  • Course 04: Office Skills
  • Course 05: Administrative Skills in the Office
  • Course 06: Office Management
  • Course 07: IT Support Technician

Learning Outcomes of the Microsoft Office Skills Course

  • Develop essential Microsoft Office and workplace productivity skills.
  • Create professional documents, spreadsheets, and presentations confidently.
  • Apply advanced Excel, Word, and PowerPoint features effectively.
  • Manage communication, collaboration, and scheduling using Microsoft tools.
  • Analyse data and create reports using Power BI.
  • Demonstrate office administration, communication, and professional workplace skills.

What Our Learners Say
★★★★★ - Sarah M., Manchester
"Royal Open College transformed my career. New job within 8 weeks!"

★★★★★ - James T., Birmingham
"Clear modules, responsive tutors, excellent value. Highly recommend to anyone."

★★★★★ - Priya K., London
"Studied while working full-time. Flexible schedule made it actually achievable."

Begin your professional development today!

Certificates

Curriculum

This course contains

Format: 246 Videos and 50 PDFs

Duration: 23h and 33m

    • 5: Creating a New Blank Document 08:21
    • 6: Saving a Document 06:27
    • 7: Opening a Document 06:36
    • 8: Navigating a Document 03:41
    • 9: Go To, Find and Replace 07:03
    • 10: Editing a Document 03:14
    • 11: Practice Exercise 00:49
    • 12: Practice Exercise Resources: Word 2026 – Getting Started 01:00
    • 13: AutoCorrect Options 07:53
    • 14: Selecting Text 04:47
    • 15: Cut, Copy and Paste 07:06
    • 16: Character Formatting Options 07:16
    • 17: Format Painter 02:58
    • 18: Working with Numbers 07:13
    • 19: Working with Bullets 06:11
    • 20: Creating an Outline 05:05
    • 21: Practice Exercise 01:30
    • 22: Practice Exercise Resources: Word 2026 – Character Formatting 01:00
    • 23: Alignment Options 03:12
    • 24: Line Spacing Options 04:32
    • 25: Working with Indents 04:55
    • 26: Working with Tabs 10:38
    • 27: Practice Exercise 00:55
    • 28: Practice Exercise Resources: Word 2026 – Paragraph Formatting 01:00
    • 29: Sorting a List 05:13
    • 30: Working with Tables 04:12
    • 31: Creating a Table 05:09
    • 32: Formatting Table Data 08:18
    • 33: Borders and Shading 11:48
    • 34: Sorting in a Table 05:46
    • 35: Drawing in a Table 06:34
    • 36: Converting Existing Data to a Table 04:18
    • 37: Practice Exercise 01:07
    • 38: Practice Exercise Resources: Word 2026 – Tables 01:00
    • 39: Working with Styles 04:24
    • 40: Creating Styles 08:01
    • 41: Editing Style 06:18
    • 42: Practice Exercise 01:01
    • 43: Practice Exercise Resources: Word 2026 – Styles 01:00
    • 44: Working with Page Breaks 03:36
    • 45: Working with Columns 05:33
    • 46: Adding a Watermark 03:33
    • 47: Headers and Footers 08:20
    • 48: What is Sectioning? 03:49
    • 49: Sectioning a Document 11:33
    • 50: Odd and Even Sections 02:36
    • 51: Practice Exercise Resources: Word 2026 – Sectioning 01:00
    • 52: Inserting Pictures 04:47
    • 53: Inserting Pictures into Existing Documents 04:38
    • 54: Picture Options 10:13
    • 55: Working with Shapes 09:57
    • 56: Icons and 3D Models 05:02
    • 57: SmartArt, Charts and Screenshots 12:46
    • 58: Practice Exercise 00:52
    • 59: Practice Exercise Resources Word 2026 – Graphics 01:00
    • 60: Working with Envelopes 05:58
    • 61: Working with Labels 03:30
    • 62: What is Mail Merge? 04:00
    • 63: Creating a Mail Merge Document - Part 1 11:22
    • 64: Creating a Mail Merge Document - Part 2 09:30
    • 65: Merging a Document with an Existing Data Source 05:21
    • 66: Merging Envelopes and Labels 06:06
    • 67: Merging a Directory 03:46
    • 68: Practice Exercise 01:22
    • 69: Practice Exercise Resources: Word 2026 – Mail Merges 01:00
    • 70: Building Blocks 07:39
    • 71: Auto Text 03:05
    • 72: Practice Exercise 01:01
    • 73: Practice Exercise Resources: Word 2026 – Page Setup Options 01:00
    • 74: Creating an Index 05:59
    • 75: Creating a Table of Contents 07:10
    • 76: Practice Exercise 01:01
    • 77: Practice Exercise Resources: Word 2026 – Indexing and Table of Contents 01:00
    • 78: Using the Thesaurus and Spell Check 04:22
    • 79: Comments 04:22
    • 80: Page Setup Options 06:52
    • 81: Printing 05:46
    • 82: Practice Exercise 01:33
    • 83: Practice Exercise Resources: Word 2026 – Review and Printing 01:00
    • 84: Word Options 06:37
    • 85: Protecting a Document 02:25
    • 86: Practice Exercise 01:09
    • 87: Closing 00:25
    • 88: Final Words! 01:00
    • 89: Intro to Excel 01:00
    • 90: Whats New In Excel 2026 04:27
    • 91: Overview of Formulas 02:49
    • 92: Overview of the Excel window 07:15
    • 93: Mouse Feature 03:09
    • 94: Backstage View 02:30
    • 95: Entering Text and Numbers 04:32
    • 96: Creating Basic Formulas 07:33
    • 97: Relative References 02:52
    • 98: Order of Operations 04:53
    • 99: Working with Ranges 03:57
    • 100: Module 2 - Practice Exercise 01:31
    • 101: Practice Exercise Resources: Excel 2026 – Creating Workbooks 01:00
    • 102: Working with the Save and Save As Commands 04:27
    • 103: Module 3 - Practice Exercise 00:51
    • 104: Practice Exercise Resources: Excel 2026 – Saving Workbooks 01:00
    • 105: Opening a File 04:45
    • 106: Working with Larger Files 05:19
    • 107: Freeze Panes Option 03:21
    • 108: Split Screen Option 03:19
    • 109: Module 4 - Practice Exercise 02:52
    • 110: Practice Exercise Resources: Excel 2026 – Navigating Workbooks 01:00
    • 111: Print Titles 02:47
    • 112: Comments 04:28
    • 113: Page Setup Options 07:02
    • 114: Fit to Print on One Page 03:44
    • 115: Printing Workbooks 03:12
    • 116: Practice Exercise 5 01:51
    • 117: Practice Exercise Resources: Excel 2026 – Page Setup and Print Options 01:00
    • 118: Adding and deleting rows columns and cells 05:55
    • 119: Changing Column and-Row Widths 03:38
    • 120: Module 6 - Practice Exercise 01:03
    • 121: Practice Exercise Resources: Excel 2026 – Working with Rows, Columns and Cells 01:00
    • 122: Cut, Copy and Paste 07:01
    • 123: Copying Formulas 04:59
    • 124: Module 7 - Practice Exercise 01:16
    • 125: Practice Exercise Resources: Excel 2026 – Moving Data 01:00
    • 126: Overview of Formulas 02:49
    • 127: Create Formulas Using Functions Part 1 08:24
    • 128: Create Formulas Using Functions Part 2 05:21
    • 129: Absolute Values 05:11
    • 130: Module 8 - Practice Exercise 01:13
    • 131: Practice Exercise Resources: Excel 2026 – Formulas & Functions 01:00
    • 132: Adding Deleting and Renaming Sheets 04:02
    • 133: Additional Sheet Tab Options 05:22
    • 134: 3 Dimensional Formulas 05:21
    • 135: Module 9 - Practice Exercise 01:24
    • 136: Practice Exercise Resources: Excel 2026 – Working with Sheets 01:00
    • 137: Formatting Cells Part 1 09:42
    • 138: Formatting Cells Part 2 03:25
    • 139: Formatting Numbers 08:13
    • 140: Borders and Shading 06:33
    • 141: Using Styles 03:37
    • 142: Using Format Painter 04:14
    • 143: Protecting Sheets 08:28
    • 144: Fill Handle and Custom Lists 07:04
    • 145: Module 10 - Practice Exercise 01:08
    • 146: Practice Exercise Resources: Excel 2026 – Formatting Worksheets 01:00
    • 147: Creating Charts 09:49
    • 148: Types of Charts 05:30
    • 149: Editing Charts Part 1 09:57
    • 150: Editing Charts Part 2 02:52
    • 151: Using Graphics to Enhance Charts 05:07
    • 152: Linking Chart Titles 02:38
    • 153: Module 11 - Practice Exercise 00:54
    • 154: Practice Exercise Resources: Excel 2026 – Creating Charts 01:00
    • 155: Creating Range Names 07:25
    • 156: Managing Names 03:04
    • 157: Using Names in Formulas 05:51
    • 158: Module 12 - Practice Exercise 01:03
    • 159: Practice Exercise Resources: Excel 2026 – Working With Names 01:00
    • 160: Remove Duplicates 07:00
    • 161: Sort Data 07:59
    • 162: Filter Data 07:14
    • 163: Advanced Filters 04:12
    • 164: Module 13 - Practice Exercise 00:55
    • 165: Practice Exercise Resources: Excel 2026 – Sorting and Filtering 01:00
    • 166: Creating an Outline 05:40
    • 167: Subtotals 07:26
    • 168: Module 14 - Practice Exercise 00:57
    • 169: Practice Exercise Resources: Excel 2026 – Outlining and Subtotaling 01:00
    • 170: Arranging Files 03:00
    • 171: New Window Option 02:52
    • 172: Custom Views 04:56
    • 173: Module 15 - Practice Exercise 01:02
    • 174: Practice Exercise Resources: Excel 2026 – Working With Views 01:00
    • 175: Creating Formulas Between File 06:02
    • 176: Working with Links 03:54
    • 177: Module 16 - Practice Exercise 01:26
    • 178: Practice Exercise Resources: Excel 2026 – Linking Files 01:00
    • 179: Goal Seeker 02:39
    • 180: Text to Columns 02:33
    • 181: Watch Window 02:23
    • 182: Customizing Ribbons and Tabs 03:15
    • 183: Module 19 - Practice Exercise 01:22
    • 184: Practice Exercise Resources: Excel 2026 – Additional Features 01:00
    • 185: Closing Video 00:37
    • 186: Functions - Part 1 12:01
    • 187: Functions - Part 2 08:03
    • 188: Autosum 05:26
    • 189: How Date and Time Works 09:29
    • 190: Final Words! 01:00
    • 191: Welcome and Overview 03:10
    • 192: Navigate a PowerPoint Presentation 10:00
    • 193: Overview of the Screen and Views 11:42
    • 194: Exercise 1 01:04
    • 195: Practice Exercise Resources: PowerPoint 2026 – Overview 01:00
    • 196: Presentation Tips and Guidelines 08:12
    • 197: Creating a New Presentation 04:22
    • 198: Working with Slides 06:11
    • 199: Saving a Presentation 06:08
    • 200: Exercise 02 01:42
    • 201: Practice Exercise Resources: PowerPoint 2026 – Getting Started 01:00
    • 202: Formatting Text 10:45
    • 203: Exercise 03 01:14
    • 204: Practice Exercise Resources: PowerPoint 2026 – Text and Bullet Editing Options 01:00
    • 205: Inserting Shapes 11:41
    • 206: Inserting Graphics 05:27
    • 207: Inserting Icons and 3D Models 05:41
    • 208: Inserting Pictures 06:06
    • 209: Exercise 04 01:01
    • 210: Practice Exercise Resources: PowerPoint 2026 – Adding Graphics 01:00
    • 211: Selecting Objects 03:20
    • 212: Editing Objects 04:11
    • 213: Formatting Objects - Part 1 11:57
    • 214: Formatting Objects - Part 2 08:28
    • 215: Arranging Objects 09:09
    • 216: Grouping Objects 06:00
    • 217: Exercise 05 01:09
    • 218: Practice Exercise Resources: PowerPoint 2026 – Working with Objects 01:00
    • 219: Picture Options 05:42
    • 220: Exercise 06 00:57
    • 221: Practice Exercise Resources: PowerPoint 2026 – Editing Pictures 01:00
    • 222: Creating SmartArt 07:06
    • 223: Modifying SmartArt 05:43
    • 224: Creating a Flowchart using SmartArt 03:51
    • 225: Exercise 07 01:02
    • 226: Practice Exercise Resources: PowerPoint 2026 – Working with SmartArt 01:00
    • 227: Creating Tables 06:29
    • 228: Exercise 08 00:55
    • 229: Practice Exercise Resources: PowerPoint 2026 – Working with Tables 01:00
    • 230: Adding Charts 06:16
    • 231: Inserting Charts from Microsoft Excel 03:54
    • 232: Exercise 09 00:56
    • 233: Practice Exercise Resources: PowerPoint 2026 – Working with Charts 01:00
    • 234: Using Master Slides 04:38
    • 235: Modifying Master Slides 07:10
    • 236: Exercise 10 01:16
    • 237: Practice Exercise Resources: PowerPoint 2026 – Unlocking the Power of Masters 01:00
    • 238: Animating an Object 10:05
    • 239: Effect Options 05:36
    • 240: Working with the Animation Pane 04:52
    • 241: Motion Paths 05:44
    • 242: Triggers 08:37
    • 243: Practice Exercise Resources PowerPoint 2026 – Animation 01:00
    • 244: Adding Video to a Presentation 05:36
    • 245: Adding Audio to a Presentation 05:32
    • 246: Exercise 11 01:01
    • 247: Practice Exercise Resources: PowerPoint 2026 – Adding Media 01:00
    • 248: Applying Transitions 04:46
    • 249: Transition Options 05:29
    • 250: Exercise 12 00:52
    • 251: Practice Exercise Resources: PowerPoint 2026 – Working with Transitions 01:00
    • 252: Working with Action Buttons 05:37
    • 253: Working with Hyperllinks 04:38
    • 254: Exercise 14 00:50
    • 255: Practice Exercise Resources: PowerPoint 2026 – Hyperlinks and Action Buttons 01:00
    • 256: Onscreen Presentation Options 06:56
    • 257: Hiding Slides 03:00
    • 258: Changing the order of slides 02:24
    • 259: Copying slides 02:13
    • 260: Slideshow Options 04:37
    • 261: Exercise 15 01:17
    • 262: Practice Exercise Resources: PowerPoint 2026 – Slide Show Options 01:00
    • 263: Rehearse Timings 05:32
    • 264: Recording a Presentation 03:46
    • 265: Slide Show Settings 03:42
    • 266: Exercise 16 01:00
    • 267: Practice Exercise Resources: PowerPoint 2026 – Preparing a Presentation 01:00
    • 268: My Presentation 00:39
    • 269: Exporting options 05:50
    • 270: The Backstage Area 05:06
    • 271: Printing a Presentation 04:49
    • 272: Exercise 17 00:56
    • 273: Practice Exercise Resources: PowerPoint 2026 – Exploring the Backstage Area 01:00
    • 274: Conclusion 01:15
    • 275: Additional Information 01:00
    • 276: Final Words! 01:00
    • 277: Office Management & Administration 10:12
    • 278: Administrative Support Skills 14:04
    • 279: Business Writing for the Workplace 10:45
    • 280: Business Communication Skills 12:18
    • 281: Organisation and Record-Keeping 11:11
    • 282: Time Management & Workplace Productivity 08:59
    • 283: Office Technology & Digital Workplace Skills 15:06
    • 284: Data Management and Analysis 17:16
    • 285: Customer Service for Office Professionals 11:14
    • 286: Business Ethics and Professionalism 11:22
    • 287: Additional Information 01:00
    • 288: Introduction to IT Support 17:19
    • 289: Operating Systems 20:50
    • 290: Security Essentials 16:25
    • 291: Troubleshooting Techniques 18:11
    • 292: Customer Service Skills 16:34
    • 293: Cloud Computing Basics 19:28
    • 294: Software Installation and Management 18:56
    • 295: Remote Support Tools 19:20
    • 296: Additional Information 01:00

Course media

Description

Microsoft Office Skills (Microsoft Excel, Word, PowerPoint) Administration & Office Skills

This comprehensive training programme develops essential MS Office, digital productivity, and office administration skills required in modern workplaces. The course covers MS Word, Excel, PowerPoint, Outlook, Teams, Access, Power BI, and Power Platform applications, enabling learners to create professional documents, manage data, deliver presentations, and collaborate effectively. Alongside technical software skills, the programme explores office management, business communication, record-keeping, customer service, and workplace professionalism. Learners gain the practical knowledge needed to improve productivity, support business operations, and perform confidently in administrative, office support, and professional workplace roles.

Who is this course for?

Anyone who is interested in can enrol in this course.

  • Microsoft Office Specialist (MOS)
  • Microsoft Office Specialist (MOS) Master
  • MS Specialist certification in Office 365
  • MS Office User
  • Touch Typing Worker
  • Level 3 Diploma in Microsoft Office
  • Level 4 Diploma in Microsoft Office
  • Level 5 Diploma in Microsoft Office
  • Level 3 Diploma in Microsoft Office Suite
  • Level 1 Award in Microsoft Office Word
  • Level 1 Award in Microsoft Office Excel
  • Level 1 Award in Microsoft Office PowerPoint
  • Level 2 Award in Microsoft Office Word
  • Level 2 Award in Microsoft Office Excel
  • Level 2 Award in Microsoft Office PowerPoint
  • Level 3 Diploma in Microsoft Office Suite
  • Level 3 Diploma in Microsoft Office Word
  • Level 3 Diploma in Microsoft Office Excel
  • Level 3 Diploma in Microsoft Office PowerPoint
  • Level 1 Award in Microsoft Office Suite
  • Level 3 Diploma in Microsoft Office Suite

Please Note: This course is designed to support your personal growth and skill development. After completing this course, learners can pursue the professional qualification courses.

Requirements

There is no prior requirement to enrol on this course. All you need to enrol in the program is a smart device and stable internet connection.

Career path

  • Administrative Assistant / Office Coordinator: £24,000 – £30,000 per year
  • Executive PA / Office Manager: £26,000 – £34,000 per year
  • Business Support Officer: £28,000 – £36,000 per year
  • Data & Reporting Analyst (Excel Focus): £30,000 – £40,000+ per year

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

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: Zopa Bank, Level 12, 20 Water Street, Canary Wharf, London E14 5GX. VAT Number 281765280.