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

Accredited Certificate on Microsoft Office From SkillArts

Digital certificate - Included

Reed Courses Certificate of Completion

Digital certificate - Included

Reference Letter

Digital certificate - £3

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

• Claim Your Free Certificate 01:00

  • 187: Claim Your Free Certificate 01:00

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.

• 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