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

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 - CPD Certified 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.

• 01: Microsoft Excel for Beginner(Microsoft Office) 1:02:00

  • 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

• 02: Microsoft Word(Microsoft Office) 1:41:00

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

• 03: Microsoft Power Point(Microsoft Office) 1:23:00

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

• 04: Microsoft Access(Microsoft Office) 1:17:00

  • 20: Microsoft Office: Basics of Database 10:00
  • 21: Microsoft Office: Setting up Microsoft Access 12:00
  • 22: Microsoft Office: Relationships and Keys of a Database 05:00
  • 23: Microsoft Office: Navigation of a Database 14:00
  • 24: Microsoft Office: Manage Database Data 16:00
  • 25: Microsoft Office: Queries 20:00

• 05: Microsoft Outlook(Microsoft Office) 27:00

  • 26: Microsoft Office: User Interface in Outlook 09:00
  • 27: Microsoft Office: Email Management in Outlook 09:00
  • 28: Microsoft Office: Microsoft Outlook Productivity Hack 09:00

• 06: Microsoft Teams(Microsoft Office) 27:00

  • 29: Microsoft Office: Introduction to Microsoft Teams 09:00
  • 30: Microsoft Office: Advanced Collaboration Techniques 13:00
  • 31: Microsoft Office: Integration and Customization 05:00

• 07: Ultimate Microsoft Excel(Microsoft Office) 13:11:10

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

Microsoft Office Diploma - CPD Certified Course Syllabus

• Navigating the Microsoft Office Excel Interface 2023
• Basic Functions in Microsoft Office Excel
• Microsoft Office Excel: Working with Worksheets
• Data Management with Microsoft Office Excel Tables
• Basic Calculations in Microsoft Office Excel
• Microsoft Office Excel Shortcuts Mastery
• Introduction to Microsoft Office Word
• Formatting Text in Microsoft Office Word Documents
• Enhancing Document Contents in Microsoft Office Word
• Basic Graphics Tools in Microsoft Office Word
• Presenting Documents with Microsoft Office Word
• Reviewing and Finalizing Documents in Microsoft Office Word
• Introduction to Microsoft Office PowerPoint
• Setting Up and Managing Microsoft Office PowerPoint Presentations
• Creating and Designing Slides in Microsoft Office PowerPoint
• Animations and Effects in Microsoft Office PowerPoint
• Utilising Tables, Charts, and SmartArt in Microsoft Office PowerPoint
• Finalising Presentations in Microsoft Office PowerPoint
• Basics of Database Management in Microsoft Office Access
• Setting Up Microsoft Office Access
• Database Relationships and Keys in Microsoft Office Access
• Navigating Databases in Microsoft Office Access
• Managing Data in Microsoft Office Access Databases
• Crafting Queries in Microsoft Office Access
• Email Management Techniques in Microsoft Office Outlook

• Microsoft Office Specialist (MOS)
• Microsoft Office Specialist (MOS) Expert
• Microsoft Office Specialist (MOS) Master

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
• 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 Certificate in Microsoft Office Suite
• 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 2 Certificate in Microsoft Office Suite
• Level 3 Diploma in Microsoft Office Suite

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

CPDQE Certificate on Microsoft Office

Digital certificate - Included

Reed Courses Certificate of Completion

Digital certificate - Included