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

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

Embark on the Microsoft Office Skills Diploma 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 Feedback on the Microsoft Office course
• Free Digital Reed Certificate on Microsoft Office course
• Compatible with iPhone & Android Devices
• Moneyback Guarantee

Accredited Empower UK Diploma Certificate on Microsoft Office

Digital certificate - Included

Reed Courses Certificate of Completion

Digital certificate - Included

• Getting Started 06:52

  • 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

• Excel 2021: Basics 41:27

  • 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: Microsoft Office: Save and Save as Actions 07:52
  • 11: Microsoft Office: File Extensions, Share, Export, and Publish files 05:53

• Excel 2021: Row, Columns, and Cells 07:37

  • 12: Microsoft Office: Adding Rows and Columns 02:34
  • 13: Microsoft Office: Modifying Rows and Column lengths 05:03

• Excel 2021: Data Handling 10:08

  • 14: Microsoft Office: Copy Cut and Paste 07:07
  • 15: Microsoft Office: Copying Formulas 03:01

• Excel 2021: Page Setting Up and print 11:16

  • 16: Microsoft Office: Page setup options 05:50
  • 17: Microsoft Office: Fit to print on One Page 02:39
  • 18: Microsoft Office: Print Workbooks 02:47

• Excel 2021: Sorting and Filtering 10:22

  • 19: Microsoft Office: Sorting Data Ascending Order 03:48
  • 20: Microsoft Office: Sorting Data Descending Order 02:25
  • 21: Microsoft Office: Filter Data 04:09

• Excel 2021: Writing Formulas 44:51

  • 22: Microsoft Office: Basic formula operations 06:14
  • 23: Microsoft Office: Date time functions 06:20
  • 24: Microsoft Office: Mathematical functions phase 1 19:54
  • 25: Microsoft Office: Mathematical functions phase 2 12:23

• Excel 2021: Advanced Formulas 16:19

  • 26: Microsoft Office: Vlookup Formula 12:12
  • 27: Microsoft Office: Hlookup Formula 04:07

• Excel 2021: XLOOKUP Only for 2021 and Office 365 18:10

  • 28: Microsoft Office: Xlookup 07:39
  • 29: Microsoft Office: Handling NA and Approximates match in XLookup 10:31

• Excel 2021: Data and Tools 37:27

  • 30: Microsoft Office: Split Text into columns 07:03
  • 31: Microsoft Office: Flash Fill 07:03
  • 32: Microsoft Office: Data Validation 06:34
  • 33: Microsoft Office: Remove Duplicates 07:47
  • 34: Microsoft Office: Import Data From Text Files 05:38
  • 35: Microsoft Office: Import Data From .CSV Files 03:22

• Excel 2021: Formatting Data and Tables 23:38

  • 36: Microsoft Office: Formatting Font 04:15
  • 37: Microsoft Office: Formatting Alignment 06:04
  • 38: Microsoft Office: Formatting Number 04:37
  • 39: Microsoft Office: Formatting Date 03:29
  • 40: Microsoft Office: Formatting Tables 05:13

• Excel 2021: Pivot Tables 05:40

  • 41: Microsoft Office: Creating Pivot Tables 03:51
  • 42: Microsoft Office: Pivot Charts 01:49

• Excel 2021: Charts 22:35

  • 43: Microsoft Office: Excel Charts – Categories 02:30
  • 44: Microsoft Office: Elements of a Chart 04:12
  • 45: Microsoft Office: Creating Charts 01:55
  • 46: Microsoft Office: Column or Bar charts 04:21
  • 47: Microsoft Office: Formatting Charts 03:37
  • 48: Microsoft Office: Line Charts 02:13
  • 49: Microsoft Office: Pie and Doughnut charts 03:47

• PowerPoint 2021: Introduction 13:23

  • 50: Microsoft Office: Overview 03:47
  • 51: Microsoft Office: Start PowerPoint Presentation 04:59
  • 52: Microsoft Office: Screen Setting and Views 04:37

• PowerPoint 2021: Basics 20:57

  • 53: Microsoft Office: Presentation Tips and Guidelines 06:00
  • 54: Microsoft Office: Creating a New Presentation 03:51
  • 55: Microsoft Office: Working with Slides 03:40
  • 56: Microsoft Office: Save a Presentation 04:16
  • 57: Microsoft Office: Print Slides 03:10

• PowerPoint 2021: Text and Bullet Options 12:34

  • 58: Microsoft Office: Formatting Text 05:05
  • 59: Microsoft Office: Slide Text Alignments 03:01
  • 60: Microsoft Office: Multi-Column Text Alignments 01:40
  • 61: Microsoft Office: Adding Bullets and Numbered List Items 02:48

• PowerPoint 2021: Adding Graphic Assets 15:45

  • 62: Microsoft Office: Insert Shapes 03:26
  • 63: Microsoft Office: Insert Icons 03:02
  • 64: Microsoft Office: Insert Graphics 03:38
  • 65: Microsoft Office: Add 3D Models 02:41
  • 66: Microsoft Office: Insert Pictures 02:58

• PowerPoint 2021: Picture Formatting 10:31

  • 67: Microsoft Office: Picture Options 03:56
  • 68: Microsoft Office: Picture Cropping 02:33
  • 69: Microsoft Office: Applying Built-in Picture Styles 04:02

• PowerPoint 2021: SmartArt Graphics 08:50

  • 70: Microsoft Office: Add SmartArt Graphic 02:33
  • 71: Microsoft Office: Modifying SmartArt 03:13
  • 72: Microsoft Office: Creating a Target Chart using SmartArt 03:04

• PowerPoint 2021: Working with Tables 16:33

  • 73: Microsoft Office: Create a Table on Slide 04:13
  • 74: Microsoft Office: Formatting Tables 02:24
  • 75: Microsoft Office: Inserting Tables 01:55
  • 76: Microsoft Office: Table Layouts 01:19
  • 77: Microsoft Office: Add a Chart 01:57
  • 78: Microsoft Office: Formatting Charts 01:48
  • 79: Microsoft Office: Insert Chart from Microsoft Excel 02:57

• PowerPoint 2021: Working with Charts 06:42

  • 80: Microsoft Office: Add a Chart 01:57
  • 81: Microsoft Office: Formatting Charts 01:48
  • 82: Microsoft Office: Insert Chart from Microsoft Excel 02:57

• PowerPoint 2021: Adding Multimedia 06:32

  • 83: Microsoft Office: Adding Video to a Presentation 02:31
  • 84: Microsoft Office: Adding Audio to a Presentation 01:33
  • 85: Microsoft Office: Screen Recording and Adding 02:28

• PowerPoint 2021: Working with Transition 04:14

  • 86: Microsoft Office: Applying Transitions to Presentation 04:14

• PowerPoint 2021: Animation 08:35

  • 87: Microsoft Office: Object Animation 03:14
  • 88: Microsoft Office: Effect Options 02:03
  • 89: Microsoft Office: Advanced Animation 01:31
  • 90: Microsoft Office: Triggers to control animation 01:47

• PowerPoint 2021: Slideshow Affects 07:58

  • 91: Microsoft Office: Onscreen Presentation 02:16
  • 92: Microsoft Office: Hiding Slides 01:42
  • 93: Microsoft Office: Changing Order of Slides 01:50
  • 94: Microsoft Office: Copying Slides 02:10

• Word 2021: Introduction 08:45

  • 95: Microsoft Office: Overview of MS Word 03:57
  • 96: Microsoft Office: Start MS Word 2021 04:48

• Word 2021: Basics 20:11

  • 97: Microsoft Office: Create a New Blank Document 04:20
  • 98: Microsoft Office: Creating a Paragraph Text 04:55
  • 99: Microsoft Office: Non-printing characters 02:59
  • 100: Microsoft Office: Save a Document 02:45
  • 101: Microsoft Office: Open a Document 01:22
  • 102: Microsoft Office: Find and Replace 03:50

• Word 2021: Word Formatting 25:20

  • 103: Microsoft Office: AutoCorrect Options 02:54
  • 104: Microsoft Office: Formatting Text 03:59
  • 105: Microsoft Office: Copy Cut and Paste 03:50
  • 106: Microsoft Office: Character Formatting 02:28
  • 107: Microsoft Office: Format Painter 03:58
  • 108: Microsoft Office: Work with Numbers 01:43
  • 109: Microsoft Office: Add Bullets 02:46
  • 110: Microsoft Office: Outline Creation 03:42

• Word 2021: Tables 24:17

  • 111: Microsoft Office: Creating a Table 02:30
  • 112: Microsoft Office: Adding Rows and Columns to a table 02:10
  • 113: Microsoft Office: Formatting Table Data 02:19
  • 114: Microsoft Office: Borders and Shading 01:45
  • 115: Microsoft Office: Sorting in a Table 03:41
  • 116: Microsoft Office: Draw a Table 03:31
  • 117: Microsoft Office: Convert Text to Table 02:43
  • 118: Microsoft Office: Convert Table to Text 02:05
  • 119: Microsoft Office: Insert a Spreadsheet 01:41
  • 120: Microsoft Office: Quick Tables – Readily Available Formats 01:52

• Word 2021: Styles 05:00

  • 121: Microsoft Office: Working with Styles 01:54
  • 122: Microsoft Office: Creating Styles 01:50
  • 123: Microsoft Office: Clear Formatting 01:16

• Word 2021: Page Layout 14:44

  • 124: Microsoft Office: Margins 01:44
  • 125: Microsoft Office: Orientation 01:23
  • 126: Microsoft Office: Page size setting 00:57
  • 127: Microsoft Office: Adding columns 03:24
  • 128: Microsoft Office: Page break section break 01:37
  • 129: Microsoft Office: Adding watermark 02:58
  • 130: Microsoft Office: Headers and footers 02:41

• Word 2021: Envelops and Levels 04:26

  • 131: Microsoft Office: Create envelops 02:28
  • 132: Microsoft Office: Creating labels 01:58

• Word 2021: Mail Merges 03:19

  • 133: Microsoft Office: Creating a mail merge document 03:19

• Word 2021: Review and Printing 05:51

  • 134: Microsoft Office: Thesaurus and spell check 01:09
  • 135: Microsoft Office: Word count 01:21
  • 136: Microsoft Office: Speech - read aloud 00:58
  • 137: Microsoft Office: Language - translate 01:13
  • 138: Microsoft Office: Tracking 01:10

• Microsoft Office - Course Assignment 01:00

  • 139: Microsoft Word: Assignment Instruction 01:00

• Bonus: Workplace Management Toolkit 23:18

  • 140: Workplace Management Toolkit Promo Preview 00:18
  • 141: Workplace Management Toolkit 23:00

Key Lesson Snippets:

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

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

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

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