Skip to content
  1. Online
  2. Office skills
Microsoft Office (Excel, Word, PowerPoint, Access, Outlook, Teams) Diploma - CPD Certified cover image
Play overlay
Preview this course

Microsoft Office (Excel, Word, PowerPoint, Access, Outlook, Teams) Diploma - CPD Certified
Skill Arts

6-in-1 Bundle | Freebies: 1000+ Excel Templates, Word Templates & PowerPoint Slides | 100% Editable | Easy to Use

Summary

Price
Save 2%
£19 inc VAT (was £19.50)
Offer ends 31 May 2026
Study method
Online, On Demand 
Duration
19.5 hours · Self-paced
Qualification
No formal qualification
Certificates
  • Accredited Certificate on Microsoft Office From SkillArts - Free
  • Reed Courses Certificate of Completion - Free
  • CPDQE Certificate and Transcript - £10
Additional info
  • Tutor is available to students
56 students purchased this course

Add to basket or enquire

Overview

Why Study This Microsoft Office Diploma - CPD Certified?

  • The average salary for a Microsoft Office Skilled worker in the UK is £35000.
  • 90% of UK businesses use Microsoft Office.
  • The average UK worker spends 28.7 hours per week using Microsoft Office.
  • Microsoft Office is used by over 1.4 billion people worldwide.

Learning Outcomes:

  • Proficiently navigate the Microsoft Office Excel 2023 interface, including menus, ribbons, and toolbars.
  • Apply basic functions within Microsoft Office Excel, including calculations, formulas, and data manipulation, to analyse data effectively.
  • Utilise Microsoft Office Word to format and enhance text in modern documents, ensuring a professional and visually appealing appearance.
  • Create engaging presentations using Microsoft Office PowerPoint, incorporating animations, effects, tables, charts, and SmartArt graphics.
  • Implement efficient email management techniques in Microsoft Outlook, enhancing productivity and organisation in Microsoft Office email communication.

This Microsoft Office Diploma - CPD Certified Comprises The Following Courses:

  1. Microsoft Excel for Beginner(Microsoft Office)
  2. Microsoft Word(Microsoft Office)
  3. Microsoft Power Point(Microsoft Office)
  4. Microsoft Access(Microsoft Office)
  5. Microsoft Outlook(Microsoft Office)
  6. Microsoft Teams(Microsoft Office)
  7. Ultimate Microsoft Excel(Microsoft Office)

CPDQE Accreditation

This Microsoft Office Diploma Course is CPDQE accredited. CPD is a globally recognised parameter for continuous professional development acknowledged by thousands of professional bodies, employers and academic institutions in the UK and around the world.

Dual Certificates

After completing this Microsoft Office Diploma Course, you will receive a course completion certificate from Reed. Also, you will receive a Accredited Certificate of Completion From SkillArts.

Assessment Method:

  • MCQ Based
  • Pass Mark: 40%
  • Assessment Fee: £5

Certificates

Curriculum

9
sections
194
lectures
19h 28m
total

    • 1: Microsoft Office: Excel Interface 2023 06:00
    • 2: Microsoft Office: Basic Functions in Excel 14:00
    • 3: Microsoft Office: Working with Worksheet 07:00
    • 4: Microsoft Office: Work with Data and Excel Tables 21:00
    • 5: Microsoft Office: Basic Calculations 07:00
    • 6: Microsoft Office: Shortcuts in Excel 06:00
    • 7: Care for a feedback? 01:00
    • 8: Order Your Certificate 01:00

    • 9: Microsoft Office: Introduction to Microsoft Word? 11:00
    • 10: Microsoft Office: Formatting Text of a Modern Document 14:00
    • 11: Microsoft Office: Enhancing a document's contents 20:00
    • 12: Microsoft Office: Basic Graphics tools 24:00
    • 13: Microsoft Office: Presenting a Document 24:00
    • 14: Microsoft Office: Reviewing and Finalizing Documents 08:00
    • 15: Order Your Certificate 01:00

    • 16: Microsoft Office: Introduction to Microsoft PowerPoint 05:00
    • 17: Microsoft Office: Setting up and Managing presentations 11:00
    • 18: Microsoft Office: Creating and Designing Slides 22:00
    • 19: Microsoft Office: Animations and Effects 13:00
    • 20: Microsoft Office: Using tables, charts and SmartArt 19:00
    • 21: Microsoft Office: Finalizing Presentations 13:00
    • 22: Order Your Certificate 01:00

    • 23: Microsoft Office: Basics of Database 10:00
    • 24: Microsoft Office: Setting up Microsoft Access 12:00
    • 25: Microsoft Office: Relationships and Keys of a Database 05:00
    • 26: Microsoft Office: Navigation of a Database 14:00
    • 27: Microsoft Office: Manage Database Data 16:00
    • 28: Microsoft Office: Queries 20:00
    • 29: Order Your Certificate 01:00

    • 30: Microsoft Office: User Interface in Outlook 09:00
    • 31: Microsoft Office: Email Management in Outlook 09:00
    • 32: Microsoft Office: Microsoft Outlook Productivity Hack 09:00
    • 33: Order Your Certificate 01:00

    • 34: Microsoft Office: Introduction to Microsoft Teams 09:00
    • 35: Microsoft Office: Advanced Collaboration Techniques 13:00
    • 36: Microsoft Office: Integration and Customization 05:00
    • 37: Order Your Certificate 01:00

    • 38: Microsoft Office: Excel from A-Z Course Intro 03:20
    • 39: Microsoft Office: Excel Job Opportunities 02:43
    • 40: Microsoft Office: Excel Job Types 03:51
    • 41: Microsoft Office: Microsoft Excel Marketplace 04:08
    • 42: Microsoft Office: What is Microsoft Excel 04:16
    • 43: Microsoft Office: Who is This Course For 03:30
    • 44: Microsoft Office: Customizing the Excel Ribbon Preview 03:03
    • 45: Microsoft Office: Customizing the Quick Access Toolbar 02:15
    • 46: Microsoft Office: Excel Interface Cont 01:25
    • 47: Microsoft Office: Excel Shortcut Keys 01:43
    • 48: Microsoft Office: Excel Workbook vs. Excel Worksheet 02:12
    • 49: Microsoft Office: Excel_s Start Screen 03:15
    • 50: Microsoft Office: Explaining the Excel Interface 02:43
    • 51: Microsoft Office: Finding and Opening Excel 01:04
    • 52: Microsoft Office: Saving an Excel Doc 03:33
    • 53: Microsoft Office: Building Basic Formulas in Excel 04:43
    • 54: Microsoft Office: Creating Excel Labels 02:32
    • 55: Microsoft Office: Entering Numeric Data in Excel 03:25
    • 56: Microsoft Office: Formatting Date Values in Excel 05:19
    • 57: Microsoft Office: Order of Operation 06:27
    • 58: Microsoft Office: Relative vs Absolute Cell References 07:23
    • 59: Microsoft Office: COUNT Functions 04:57
    • 60: Microsoft Office: Excel Functions Explained 02:34
    • 61: Microsoft Office: The AVERAGE Function 02:00
    • 62: Microsoft Office: The MIN and MAX Function 03:43
    • 63: Microsoft Office: The SUM Function 07:31
    • 64: Microsoft Office: Adding a Workbook Password to Open File 02:09
    • 65: Microsoft Office: Adding Protection to Specific Cells 04:23
    • 66: Microsoft Office: Adjusting the Width and Height of Cells 04:34
    • 67: Microsoft Office: Hiding and Unhiding Excel Rows and Columns 04:28
    • 68: Microsoft Office: Insert and Delete Rows and Columns 05:04
    • 69: Microsoft Office: Moving and Copying Data 06:45
    • 70: Microsoft Office: Protecting the Structure of a Workbook 02:11
    • 71: Microsoft Office: Renaming Moving and Deleting Excel Worksheets 05:27
    • 72: Microsoft Office: Adding Cell Borders 04:47
    • 73: Microsoft Office: Creating Styles for Formatting Efficiency 05:55
    • 74: Microsoft Office: Formatting Data Appropriately 05:20
    • 75: Microsoft Office: Formatting Fonts and Cell Background Color 04:54
    • 76: Microsoft Office: Merging Cells 03:26
    • 77: Microsoft Office: The Magic Behind Excel_s Format Painter 03:29
    • 78: Microsoft Office: The Power of Conditional Formatting 06:09
    • 79: Microsoft Office: Create Compelling Graphics with SmartArt 05:36
    • 80: Microsoft Office: Customizing Icons 04:41
    • 81: Microsoft Office: Grab Users Attention using Illustrations 08:38
    • 82: Microsoft Office: Changing the Chart Design 01:58
    • 83: Microsoft Office: Formatting Elements of a Chart 06:23
    • 84: Microsoft Office: Little Slice of Pie Charts 05:11
    • 85: Microsoft Office: Modifying the Data Type and Location of a Chart 06:06
    • 86: Microsoft Office: The Commonly Used Column Chart 02:45
    • 87: Microsoft Office: Converting Spreadsheets to PDF Files 02:28
    • 88: Microsoft Office: Excels Page Layout View 06:36
    • 89: Microsoft Office: Print Preview Options 04:25
    • 90: Microsoft Office: Printing a Specific Range of Cells 02:38
    • 91: Microsoft Office: How to Create an Excel Template 05:22
    • 92: Microsoft Office: Why Create an Excel Template 01:22
    • 93: Microsoft Office: Applying Filters to Datasets 04:44
    • 94: Microsoft Office: Converting Datasets into Tables 05:55
    • 95: Microsoft Office: Creating Subtotals within a Dataset 05:38
    • 96: Microsoft Office: Custom Sorting Datasets in Excel 02:26
    • 97: Microsoft Office: Finding and Removing Duplicate Values 07:29
    • 98: Microsoft Office: How to Prepare Data for Analysis 04:00
    • 99: Microsoft Office: How to Sort Data in Excel 02:37
    • 100: Microsoft Office: Multi Level Sorting 02:33
    • 101: Microsoft Office: The DSUM Function Cont 07:06
    • 102: Microsoft Office: The DSUM Function 07:47
    • 103: Microsoft Office: The SUBTOTAL Function 06:28
    • 104: Microsoft Office: The SUMIF Function 08:41
    • 105: Microsoft Office: Adding Custom Alerts to Data Validation 06:53
    • 106: Microsoft Office: Creating a Drop Down List with Data Validation 07:08
    • 107: Microsoft Office: Creating a Dynamic Drop Down List 03:09
    • 108: Microsoft Office: Dependent Drop Down List 08:38
    • 109: Microsoft Office: Different Types of Data Validation 05:39
    • 110: Microsoft Office: What is Excel Data Validation 01:55
    • 111: Microsoft Office: Creating an Excel Pivot Table 05:30
    • 112: Microsoft Office: Creating PivotCharts and Slicers 07:59
    • 113: Microsoft Office: Drilling Down into PivotTable Data 01:59
    • 114: Microsoft Office: Grouping Filtering PivotTable Data 06:29
    • 115: Microsoft Office: Modifying Excel Pivot Tables 05:38
    • 116: Microsoft Office: Activating the Excel PowerPivot AddIn 01:33
    • 117: Microsoft Office: Creating Relationships between Data Tables 06:22
    • 118: Microsoft Office: How to Create PowerPivot KPIs 08:26
    • 119: Microsoft Office: Using Data Models to Create PivotTables 04:30
    • 120: Microsoft Office: What is PowerPivot 03:45
    • 121: Microsoft Office: Excels IF Function 05:16
    • 122: Microsoft Office: IF AND Function 05:23
    • 123: Microsoft Office: IF OR Function 05:13
    • 124: Microsoft Office: Key Benefits of Using Named Ranges 04:10
    • 125: Microsoft Office: Nesting Multiple IF Functions 07:23
    • 126: Microsoft Office: The COUNTIF Function 04:06
    • 127: Microsoft Office: INDEX and MATCH Combined 05:08
    • 128: Microsoft Office: The Beauty of Excels IFERROR Function 03:55
    • 129: Microsoft Office: The HLOOKUP Function 06:21
    • 130: Microsoft Office: The INDEX Function 04:42
    • 131: Microsoft Office: The MATCH Function 04:55
    • 132: Microsoft Office: The VLOOKUP Fumction 08:59
    • 133: Microsoft Office: Two Way Lookup with INDEX and MATCH 04:09
    • 134: Microsoft Office: Combining Text with CONCATENATE 06:05
    • 135: Microsoft Office: Extracting Specific Text using LEN and SEARCH 12:44
    • 136: Microsoft Office: LEFT RIGHT MID Function 07:08
    • 137: Microsoft Office: Quick Tips and Other Text Based Functions 05:48
    • 138: Microsoft Office: 3D Referencing in Formulas 05:04
    • 139: Microsoft Office: Grouping Data 02:42
    • 140: Microsoft Office: How to Freeze Panes in Excel 02:55
    • 141: Microsoft Office: Showing Formulas 01:53
    • 142: Microsoft Office: Tracing Precedents and Dependents in Formulas 04:27
    • 143: Microsoft Office: Utilizing the Watch Window in Excel 02:44
    • 144: Microsoft Office: Compare Results with Excel Data Tables 04:23
    • 145: Microsoft Office: Excels Scenario Manager Tool 05:55
    • 146: Microsoft Office: Goal Seek in Excel 06:15
    • 147: Microsoft Office: Solver Tool 10:59
    • 148: Microsoft Office: A Look Inside the Visual Basic Editor 03:56
    • 149: Microsoft Office: Recording a Macro 09:11
    • 150: Microsoft Office: Saving and Opening a Macro Enabled Workbook 02:13
    • 151: Microsoft Office: The Power Behind Excel VBA 02:35
    • 152: Microsoft Office: Excel VBA Variables 04:38
    • 153: Microsoft Office: Modules and Procedures 06:33
    • 154: Microsoft Office: Object Methods and Properties 05:58
    • 155: Microsoft Office: Creating User Defined Functions 09:18
    • 156: Microsoft Office: If Then Else Statement 10:22
    • 157: Microsoft Office: InputBox and MsgBox 05:32
    • 158: Microsoft Office: Referencing a Range 13:30
    • 159: Microsoft Office: User Defined Functions within VBA Scripts 06:08
    • 160: Microsoft Office: Using Variables in VBA Code 04:32
    • 161: Microsoft Office: Worksheet Functions inside VBA 07:32
    • 162: Microsoft Office: Debugging and Error Handling Cont 06:44
    • 163: Microsoft Office: Debugging and Error Handling 06:36
    • 164: Microsoft Office: Find Last Column of Data 03:12
    • 165: Microsoft Office: Find Last Row of Data 05:45
    • 166: Microsoft Office: With Statement 04:51
    • 167: Microsoft Office: Do Until Loop 06:03
    • 168: Microsoft Office: For Each Loop 03:36
    • 169: Microsoft Office: For Next Loop 09:12
    • 170: Microsoft Office: Assigning Macros to Shapes 03:32
    • 171: Microsoft Office: Form Controls vs Active X Controls 07:50
    • 172: Microsoft Office: Fun with VBA Events 06:54
    • 173: Microsoft Office: Workbook Events 02:54
    • 174: Microsoft Office: Worksheet Events 03:43
    • 175: Microsoft Office: Adding Controls to UserForms 10:00
    • 176: Microsoft Office: Clearing Values from UserForm Controls 03:06
    • 177: Microsoft Office: Creating an Excel UserForm 03:15
    • 178: Microsoft Office: How to Close an UserForm 01:33
    • 179: Microsoft Office: How to Show an UserForm 03:01
    • 180: Microsoft Office: Passing Option Buttons Values to Desired Cells 06:50
    • 181: Microsoft Office: Passing TextBox Values to Desired Cells 06:36
    • 182: Microsoft Office: UserForm ComboBoxes 08:08
    • 183: Microsoft Office: UserForms and Protected Sheets 04:40
    • 184: Microsoft Office: Creating an Excel Resume 04:51
    • 185: Microsoft Office: Getting Started with Freelancing1 06:15
    • 186: Microsoft Office: Getting Your First Client 07:45
    • 187: Microsoft Office: How to Become an Excel Freelancer 05:12
    • 188: Microsoft Office: Importance of Website 04:24
    • 189: Microsoft Office: Networking Do’s and Don’ts 04:21
    • 190: Microsoft Office: Personal Branding 1 06:47
    • 191: Microsoft Office: Top Freelance Sites 05:12
    • 192: Thank You ! 01:00

    • 193: Final Exam 01:00

    • 194: Order Your CPDQE Certificate and Transcript 01:00

Course media

Description

This Bundle Comes with the following Courses:

➽ Course 01: Microsoft Excel for Beginners

  • Intro to Microsoft Office Excel: Learn the basics of Microsoft Office Excel, including setup, navigation, and simple formulas.

➽ Course 02: Microsoft Word

  • Document Mastery with Microsoft Office Word: Gain proficiency in Microsoft Office Word for professional document formatting and management.

➽ Course 03: Microsoft PowerPoint

  • Presentation Skills in Microsoft Office PowerPoint: Develop advanced presentation skills using Microsoft Office PowerPoint to captivate and inform audiences.

➽ Course 04: Microsoft Access

  • Database Management with Microsoft Office Access: Learn to create and manage databases effectively with Microsoft Office Access for streamlined data handling.

➽ Course 05: Microsoft Outlook

  • Optimizing Communication with Microsoft Office Outlook: Master email management, calendar organization, and task scheduling in Microsoft Office Outlook.

➽ Course 06: Microsoft Teams

  • Team Collaboration via Microsoft Office Teams: Enhance communication and project management within teams using Microsoft Office Teams.

➽ Course 07: Ultimate Microsoft Excel

  • Advanced Techniques in Microsoft Office Excel: Dive deeper into complex functions, data analysis, and visualization tools in Microsoft Office Excel.

Career path

  • Office Administrator: £18,000 - £25,000
  • Data Analyst: £22,000 - £40,000
  • Executive Assistant: £25,000 - £35,000
  • Project Coordinator: £23,000 - £35,000
  • Database Manager: £30,000 - £45,000

Questions and answers

Reviews

4.8
Course rating
100%
Service
93%
Content
100%
Value

Legal information

This course is advertised on Reed.co.uk by the Course Provider, whose terms and conditions apply. Purchases are made directly from the Course Provider, and as such, content and materials are supplied by the Course Provider directly. Reed is acting as agent and not reseller in relation to this course. Reed's only responsibility is to facilitate your payment for the course. It is your responsibility to review and agree to the Course Provider's terms and conditions and satisfy yourself as to the suitability of the course you intend to purchase. Reed will not have any responsibility for the content of the course and/or associated materials.

FAQs

Study method describes the format in which the course will be delivered. At Reed Courses, courses are delivered in a number of ways, including online courses, where the course content can be accessed online remotely, and classroom courses, where courses are delivered in person at a classroom venue.

CPD stands for Continuing Professional Development. If you work in certain professions or for certain companies, your employer may require you to complete a number of CPD hours or points, per year. You can find a range of CPD courses on Reed Courses, many of which can be completed online.

A regulated qualification is delivered by a learning institution which is regulated by a government body. In England, the government body which regulates courses is Ofqual. Ofqual regulated qualifications sit on the Regulated Qualifications Framework (RQF), which can help students understand how different qualifications in different fields compare to each other. The framework also helps students to understand what qualifications they need to progress towards a higher learning goal, such as a university degree or equivalent higher education award.

An endorsed course is a skills based course which has been checked over and approved by an independent awarding body. Endorsed courses are not regulated so do not result in a qualification - however, the student can usually purchase a certificate showing the awarding body's logo if they wish. Certain awarding bodies - such as Quality Licence Scheme and TQUK - have developed endorsement schemes as a way to help students select the best skills based courses for them.
View all
Related searches: Microsoft Access courses, Microsoft PowerPoint courses, Microsoft Outlook courses, Online courses

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.