Microsoft Office Specialist

Academy of Skills

Certificate of completion

Digital certificate - Included

Reed courses certificate of completion

Digital certificate - Included

• Course 1: Microsoft Word Basics 24:33

  • 1: New Document and Templates 02:05
  • 2: Tabs, Ribbons and Groups 02:48
  • 3: Zoom and Rulers 02:01
  • 4: Editing the Document 02:44
  • 5: Insert Pictures 05:27
  • 6: Insert Shape and Text Box 01:47
  • 7: Review Tab 02:47
  • 8: Layout 01:35
  • 9: File Options 01:58
  • 10: Closing and Reopening 01:21

• Course 2: Microsoft Word Advance 2:31:19

  • 11: Overview of the Microsoft Word 2016 Ribbon 03:47
  • 12: Open and Save a New Microsoft Word 2016 Document 03:06
  • 13: Save or Covert a Word document as a PDF in Word 2016 01:47
  • 14: Save or Covert a Word document as a PDF in Word 2016 01:47
  • 15: Edit a PDF Document Using Word 2016 03:47
  • 16: Making Business Cards With Word 2016 02:45
  • 17: Create double space lines in Microsoft Word 2016 02:40
  • 18: Add or remove page numbers in Microsoft Word 2016 03:01
  • 19: Use a different header for each page in Microsoft Word 2016 03:45
  • 20: Delete blank pages in Microsoft Word 2016 02:30
  • 21: Create a page break in Word 2016 01:15
  • 22: Create a Document Using a Microsoft Template 02:38
  • 23: Inspecting and protecting documents in Word 2016. 03:12
  • 24: Encrypting and De-encrypting a Microsoft Word 2016 Document 02:26
  • 25: Insert a chart in Word 2016 04:31
  • 26: Insert and movie a picture in Word 2016 03:34
  • 27: Insert an online image in Word 2016 02:26
  • 28: Insert a hyper-link in Word 2016 02:19
  • 29: Embed an Excel Spreadsheet in word 2016 05:46
  • 30: Insert, Resize and Format a Table in Word 2016 03:34
  • 31: How to Use Bookmarks in Word 2016 02:32
  • 32: Insert Text Boxes in Word 2016 04:55
  • 33: Insert a Video or Audio File in Word 2016 04:12
  • 34: Installing free fonts for Microsoft Word 2016 02:25
  • 35: Using the APA template in Microsoft Word 2016 05:03
  • 36: Adding Grammarly to Your Microsoft Word 2016 Program 04:14
  • 37: Create an Automatic Table of Contents in Word 2016 03:11
  • 38: Create a cover page in Word 2016 03:30
  • 39: Add Recently Viewed Document to Pin List 01:40
  • 40: Using Search & Replace in Word 2016 04:31
  • 41: Use Comments in Word 2016 02:34
  • 42: Using the New Undo feature in Word 2016 02:25
  • 43: Set the Default Font in Word 2016 02:05
  • 44: Using SmartArt for Graphic Design 03:17
  • 45: Reshaping Images in word 2016 03:45
  • 46: Remove the background of an image using Word 2016 03:29
  • 47: Perform Calculations in Word 2016 02:40
  • 48: Write Equations in Word 2016 02:52
  • 49: Using Smart Lookup in word 2016 01:48
  • 50: Using Microsoft's Random Text Generator 02:46
  • 51: Enable Text to Speech in Word 2016 02:18
  • 52: Using the Clipboard and Multi-Paste 02:20
  • 53: Add page numbers to an existing header or footer 02:25
  • 54: Tips & Tricks Video #1 08:13
  • 55: Using the File Open and Repair Feature 01:23
  • 56: Repair or Reinstall Your Microsoft Office Word 2016 03:20
  • 57: Word Experinced an Error Trying to Open the file 04:36
  • 58: Reset Microsoft Office Word to Default Settings 02:14

• Course 3: Microsoft Excel Basics 2:13:08

  • 59: Formatting Keyboard Shortcuts 01:48
  • 60: Table Keyboard Shortcuts 02:10
  • 61: Editing Keyboard Shortcuts 04:47
  • 62: Formula Keyboard Shortcuts 03:04
  • 63: Workbook Keyboard Shortcuts 01:32
  • 64: Handy Shortcuts Keyboard Shortcuts 04:53
  • 65: Formulas and Functions - 1 - Building basic math formulas 08:19
  • 66: Formulas and Functions - 2 - Autosum and Relative references 09:21
  • 67: Formulas and Functions - 3 - Absolute references 06:20
  • 68: Formulas and Functions - 4 - Named Ranges 06:23
  • 69: Formulas and Functions - 5 - Linking sheets and workbooks 05:36
  • 70: Formulas and Functions - 6 - If, And, Or, and the nested If func 15:53
  • 71: Formulas and Functions - 7 - Countif, Sumif, Averageif, Sumifs, 09:15
  • 72: Formulas and Functions - 8 - Vlookup and Hlookup functions 15:19
  • 73: Formulas and Functions - 9 - Match and Index functions 07:27
  • 74: Formulas and Functions - 10 - Date and time formulas and functio 12:26
  • 75: Formulas and Functions - 11 - Text functions 10:55
  • 76: Formulas and Functions - 12 - Tracing formulas 07:40

• Course 4: Microsoft Excel Advance 2:36:41

  • 77: Excel vlookup 1.1 08:21
  • 78: Excel xlookup 1.2 06:09
  • 79: Excel vlookup 1.3 08:12
  • 80: Excel vlookup 1.4 02:59
  • 81: Excel vlookup 1.5 10:56
  • 82: Excel vlookup 1.6 04:44
  • 83: Excel vlookup 1.7 05:26
  • 84: pivot table power query power pivot - 1 09:05
  • 85: pivot table power query power pivot - 2 00:59
  • 86: pivot table power query power pivot - 3 02:10
  • 87: pivot table power query power pivot - 4 02:40
  • 88: pivot table power query power pivot - 5 01:03
  • 89: pivot table power query power pivot - 6 03:48
  • 90: pivot table power query power pivot - 7 08:05
  • 91: pivot table power query power pivot - 8 04:49
  • 92: pivot table power query power pivot - 9 02:31
  • 93: pivot table power query power pivot - 10 04:18
  • 94: pivot table power query power pivot - 11 03:52
  • 95: pivot table power query power pivot - 12 01:48
  • 96: pivot table power query power pivot - 13 03:29
  • 97: pivot table power query power pivot - 14 05:01
  • 98: pivot table power query power pivot - 15 01:56
  • 99: pivot table power query power pivot - 16 03:16
  • 100: pivot table power query power pivot - 17 03:17
  • 101: pivot table power query power pivot - 18 08:13
  • 102: pivot table power query power pivot - 19 02:02
  • 103: pivot table power query power pivot - 20 03:41
  • 104: pivot table power query power pivot - 21 04:47
  • 105: pivot table power query power pivot - 22 08:50
  • 106: pivot table power query power pivot - 23 04:04
  • 107: pivot table power query power pivot - 24 03:16
  • 108: pivot table power query power pivot - 25 03:45
  • 109: pivot table power query power pivot - 26 09:09

• Course 5: Microsoft PowerPoint 21:47

  • 110: New Presentation and Templates 01:34
  • 111: Tabs Ribbons and Groups 02:38
  • 112: First Slide and Designing the Slide 01:42
  • 113: Home Tab and Updates 01:55
  • 114: Buttons 00:50
  • 115: Inserting Pictures 03:41
  • 116: Presentation Mode 01:01
  • 117: Animations Tab 05:01
  • 118: File Options 02:01
  • 119: Closing and Reopening 01:24

• Course 6: Microsoft Outlook 28:18

  • 120: Setting Up Outlook with Accounts 02:53
  • 121: Tabs, Ribbons and Groups in Outlook 02:32
  • 122: Navigation Bar in Outlook 00:58
  • 123: Organizing Outlook with Favorites and Folders 02:39
  • 124: Additional Options inside Outlook Tabs 00:41
  • 125: Reading, Writing and Receiving Emails 08:18
  • 126: Attaching Items in Outlook Mails 02:37
  • 127: The View Tab in Outlook 01:36
  • 128: Create a Rule to move emails to a folder 04:14
  • 129: Insert a screen shot from Excel 01:50

• Course 7: Microsoft Outlook Tips and tricks 49:01

  • 130: Basic sort 02:29
  • 131: Handling Attachments 05:52
  • 132: Advanced Sort 04:34
  • 133: Conditional Formatting 03:59
  • 134: Filter and Advanced Filter 05:25
  • 135: Categories 02:36
  • 136: Flags and Reminders 04:58
  • 137: Rules 08:09
  • 138: Managing Junk Email 03:24
  • 139: Managing Folders 03:10
  • 140: Inbox Maintenance 04:25

• Course 8: Microsoft OneNote 54:10

  • 141: Get Started with OneNote 01:49
  • 142: Organize Notebooks 06:48
  • 143: Settings and View Tab 09:14
  • 144: Work with Multiple Accounts 00:34
  • 145: Tell Me In OneNote 01:41
  • 146: Adding Text and Videos 04:43
  • 147: Inserting More Items 05:36
  • 148: Drawing Tools 05:49
  • 149: Search Tool 01:36
  • 150: OneNote Web Clipper 04:13
  • 151: Share notebooks and pages 02:28
  • 152: Print Pages 00:47
  • 153: OneNote online 01:36
  • 154: OneNote 2016 07:16

• FREE Course: Microsoft PowerBI 1:13:23

  • 155: Tour of the screen 03:50
  • 156: Pulling in your data from different sources 11:59
  • 157: Creating your first Visual 08:53
  • 158: Building a visual from 2 tables 07:46
  • 159: Slicers 07:00
  • 160: Making a Combo Chart Visual 05:47
  • 161: Using PowerQuery to restructure the data 03:38
  • 162: Creating Map Visuals 03:09
  • 163: Creating a report by Year, Qtr, or Month 03:41
  • 164: Calculating % of total 01:48
  • 165: Creating your own Calculation 04:30
  • 166: Decomposition Tree Visual 02:11
  • 167: Pulling it all together 09:11

Microsoft Office is a suite of desktop productivity applications that includes Microsoft Word, Excel, PowerPoint, and more. These programs are widely used in offices and businesses around the world and are essential tools for many tasks such as creating documents, managing spreadsheets, and creating presentations.

Having proficiency in Microsoft Office can be beneficial in the workplace because it allows individuals to complete tasks efficiently and effectively. For example, an employee who knows how to use Microsoft Word can create professional documents, while an employee who knows how to use Excel can create and manage spreadsheets.

In addition to being helpful in the workplace, proficiency in Microsoft Office can also be beneficial when it comes to getting a job. Many job listings will list Microsoft Office as a required skill, and being able to demonstrate proficiency in the software can make an individual a more competitive job candidate. Employers often prefer to hire employees who have a strong set of computer skills, and being proficient in Microsoft Office is an important part of this.

Overall, Microsoft Office is an essential tool in the modern workplace, and being proficient in its programs can help individuals be more productive and effective in their work, as well as make them more attractive job candidates.

• Students
• Professionals
• Businesses
• Individuals who are new to Microsoft Office
• Those who want to improve their existing skills
• Those who want to stay up to date on the latest features and tools in the software
• Individuals preparing for a career that requires proficiency in Microsoft Office

• There are no official requirements for Microsoft Office - Microsoft Office Specialist
• Microsoft Office - Microsoft Office Training requires basic Internet connection
• Microsoft Office - Microsoft Office Specialist requires you to have access to a computer, tablet, or a mobile device
• Knowledge of basic English

The Microsoft Office - Microsoft Office Specialist course is meant to prepare you for the job of your dreams, a promotion at work, or being self-employed and starting your own business. Courses from the Academy of Skills will help you enhance your profession and keep your skills current.