Microsoft Office Skills Diploma (Office, Excel, Power BI, OneNote, SharePoint, MS Project)

The Microsoft Office Skills Diploma is a comprehensive training program designed to enhance your proficiency in various Microsoft Office applications. This course offers a thorough understanding of Office, Excel, Power BI, OneNote, SharePoint, and MS Project, equipping you with valuable skills to excel in today's professional environment. Whether you're a beginner or an experienced user, this diploma program will help you develop a solid foundation and master essential tools for increased productivity and efficiency.

This Microsoft Office Skills Diploma 12 course package consists of the following courses:

• Course 1: Microsoft Office Masterclass
• Course 2: Microsoft Excel Power Query
• Course 3: Microsoft Excel : VLOOKUP Formula
• Course 4: Microsoft Excel : Top 50 Excel Formulas
• Course 5: Microsoft Power BI Mastery
• Course 6: Microsoft OneNote
• Course 7: Microsoft Power Apps: Master Basics in Just 40 Mins
• Course 8: Microsoft SharePoint Master Basics in 50 Mins
• Course 9: Microsoft Power Automate: Master Basics in Just 40 Mins
• Course 10: Microsoft Project: Master Project Management Basics in 60 Mins!
• Course 11: Learn Microsoft Visio Basics in 30 minutes
• Course 12: Learn Microsoft forms basic in 30 minutes

The comprehensive Microsoft Office Skills Diploma 12 course package starts with the basic knowledge of Microsoft Office applications, Microsoft Excel power query, Microsoft Excel Vlookup formula, Microsoft power BI, Microsoft OneNote, Microsoft Power Apps, Microsoft SharePoint, Microsoft Power Automate, Microsoft Project, Microsoft Visio, Microsoft forms and gradually shares expertise knowledge. In this course you will get a complete idea of Microsoft office applications with key concepts, strategies regarding use of it and in-depth knowledge. The Microsoft Office Skills Diploma 12 course package is completely an online course. You can access this Microsoft course from any part of the world with just a smart device and the internet.

By the end of this Microsoft course, you will get complete knowledge and marketable skills. The course also comes with a certificate, which will add extra value to your resume and help you stand out in the job market. In short, Microsoft 12 course bundle is the perfect course to fast track your career. So, why are you waiting? Enrol this Microsoft course today!

Why Choose the Microsoft Office Skills Diploma 12 course package?

• Conducted by industry experts
• Get Instant E-certificate
• Fully online, interactive course with Professional voice-over
• Developed by qualified professionals
• Self paced learning and laptop, tablet, smartphone friendly
• Tutor Support

And you will also get these gifts

• 12 Free PDF Certificate
• Lifetime Course Access

• Microsoft Office Masterclass 1:32:30

  • 1: WORD 01 - New Document and Templates 02:04
  • 2: WORD 02 - Tabs, Ribbons and Groups 02:48
  • 3: WORD 03 - Zoom and Rulers 02:00
  • 4: WORD 04 - Editing the Document 02:44
  • 5: WORD 05 - Insert Pictures 05:27
  • 6: WORD 06 - Insert Shape and Text Box 01:46
  • 7: WORD 07 - Review Tab 02:47
  • 8: WORD 08 - Layout 01:34
  • 9: WORD 09 - File Options 01:58
  • 10: WORD 10 - Closing and Reopening 01:20
  • 11: PPT 01 - New Presentation and Templates 01:34
  • 12: PPT 02 - Tabs Ribbons and Groups 02:38
  • 13: PPT 03 - First Slide and Designing the Slide 01:41
  • 14: PPT 04 - Home Tab and Updates 01:54
  • 15: PPT 05 - Buttons 00:49
  • 16: PPT 06 - Inserting Pictures 03:40
  • 17: PPT 07 - Presentation Mode 01:00
  • 18: PPT 08 - Animations Tab 05:01
  • 19: PPT 09 - File Options 02:01
  • 20: PPT 10 - Closing and Reopening 01:23
  • 21: Outlook 01 - Setting Up Outlook with Accounts 02:52
  • 22: Outlook 02 - Tabs, Ribbons and Groups in Outlook 02:31
  • 23: Outlook 03 - Navigation Bar in Outlook 00:58
  • 24: Outlook 04 - Organizing Outlook with Favorites and Folders 02:38
  • 25: Outlook 05 - Additional Options inside Outlook Tabs 00:40
  • 26: Outlook 06 - Reading, Writing and Receiving Emails 08:18
  • 27: Outlook 07 - Attaching Items in Outlook Mails 02:36
  • 28: Outlook 08 - The View Tab in Outlook 01:36
  • 29: Outlook 09 - Create a Rule to move emails to a folder 04:14
  • 30: Outlook 10 - Insert a screen shot from Excel 01:50
  • 31: 01 - Formatting Keyboard Shortcuts 01:47
  • 32: 02 - Table Keyboard Shortcuts 02:09
  • 33: 03 - Editing Keyboard Shortcuts 04:46
  • 34: 04 - Formula Keyboard Shortcuts 03:03
  • 35: 05 - Workbook Keyboard Shortcuts 01:31
  • 36: 06 - Handy Shortcuts Keyboard Shortcuts 04:52

• Microsoft Excel Power Query 3:10:48

  • 37: Power Query Intro and Excel version 03:04
  • 38: Power Query and Query Editor Ribbon 08:38
  • 39: Trim 05:26
  • 40: Format Dates and Values 02:15
  • 41: Parsing URLs 05:25
  • 42: Split Text Fields 09:34
  • 43: Group By 02:57
  • 44: Import From Folder 06:32
  • 45: Doing Auto Cleanup 06:56
  • 46: Extract Data from Forms 13:25
  • 47: Extract - Multiple Criteria 04:39
  • 48: Extract Multiple Worksheets 04:03
  • 49: Unpivoting Columns 05:19
  • 50: Pivoting Columns 02:18
  • 51: Split Columns into Other Columns 04:04
  • 52: Filtering Rows 05:03
  • 53: Sorting Columns 02:20
  • 54: Transform and Add Columns 06:41
  • 55: Intro to Joins 03:31
  • 56: Merging 07:42
  • 57: Full Outer Join 05:43
  • 58: Right Anti Join 08:50
  • 59: Convert Reports into Pivot Tables 05:03
  • 60: Modulo 05:44
  • 61: M Language - M Introduction 02:41
  • 62: M Language - Enabling M in Power Query 02:18
  • 63: M Language - Simple Expressions 07:35
  • 64: M Language - Simple Expressions - Nested Expressions 02:54
  • 65: M Language - Variables 07:59
  • 66: M Language - Functions 06:05
  • 67: M Language - Functions - Reusable Functions 02:12
  • 68: M Language - Functions - Invoking 00:35
  • 69: M Language - Passing Functions 08:11
  • 70: M Language - Passing Functions - keyword each 02:40
  • 71: M Language - Finding the list of M functions 02:28
  • 72: M Language - Using M Functions 09:58

• Microsoft Excel : VLOOKUP Formula 1:04:55

  • 73: Menu Example with Excel Vlookup 07:34
  • 74: Wildcard Search with Excel Vlookup 09:21
  • 75: Looking to the Left with Excel Vlookup 16:36
  • 76: 2-Way Lookup 13:38
  • 77: Comparing Lists with Excel Vlookup 03:20
  • 78: Vlookup Tips and Tricks 14:26

• Microsoft Excel : Top 50 Excel Formulas 49:38

  • 79: Getting the most of the course 00:57
  • 80: Text 07:53
  • 81: Text Exercise 00:21
  • 82: Text Exercise (answers) 01:08
  • 83: Mathematical 04:01
  • 84: Math Exercise (answers) 01:00
  • 85: Math Exercise 00:16
  • 86: Date and Time 05:04
  • 87: Date and Time Exercise 00:17
  • 88: Date and Time Exercise (answers) 00:59
  • 89: Logic 12:20
  • 90: Logic Exercise 00:15
  • 91: Logic Exercise (answers) 00:41
  • 92: Financial 05:54
  • 93: Financial Exercise 00:13
  • 94: Financial Exercise (answers) 02:15
  • 95: Informational 03:58
  • 96: Informational Exercise 00:40
  • 97: Informational Exercise (answers) 01:26

• Microsoft Power BI Mastery 1:33:41

  • 98: Overview of Power BI Course 01:46
  • 99: Power BI Intro 03:26
  • 100: Power BI High Level Flow 02:20
  • 101: Install and Sign Up 02:44
  • 102: Power Query Intro 04:43
  • 103: Power Pivot Intro 01:08
  • 104: Power View Intro 01:34
  • 105: Big Picture 01:40
  • 106: Get Data 06:43
  • 107: How to Get More Data 01:03
  • 108: Modelling Data 03:00
  • 109: Adding Relationships Manually 02:06
  • 110: Visualization 04:34
  • 111: Visualization Customization 01:25
  • 112: More Visualizations 02:24
  • 113: Visualization Format and Analytics 02:56
  • 114: Ask a Question 02:07
  • 115: Adv 01 - Real World Example 05:44
  • 116: Adv 02 - Get Data 13:03
  • 117: Adv 03 - Modelling Data 05:06
  • 118: Adv 04 - Visualization with multiple charts 11:13
  • 119: Adv 05 - Publishing 04:34
  • 120: Adv 06 - Power BI Website 08:22

• Microsoft OneNote 54:01

  • 121: Get Started with OneNote 01:48
  • 122: Organize Notebooks 06:48
  • 123: Settings and View Tab 09:13
  • 124: Work with Multiple Accounts 00:34
  • 125: Tell Me In OneNote 01:40
  • 126: Adding Text and Videos 04:43
  • 127: Inserting More Items 05:36
  • 128: Drawing Tools 05:48
  • 129: Search Tool 01:36
  • 130: OneNote Web Clipper 04:12
  • 131: Share notebooks and pages 02:27
  • 132: Print Pages 00:46
  • 133: OneNote online 01:35
  • 134: OneNote 2016 07:15

• Microsoft Power Apps: Master Basics in Just 40 Mins 43:59

  • 135: Get Power Apps 04:33
  • 136: Create Excel Data Source 02:17
  • 137: Creating the App 01:39
  • 138: Previewing the App 06:07
  • 139: Tree View 02:41
  • 140: Edit Properties 04:18
  • 141: Insert New Item 03:14
  • 142: Insert New Screen 04:02
  • 143: Actions 07:37
  • 144: Additional Options 01:17
  • 145: Save and Distribute the App 04:09
  • 146: Mobile App 02:05

• Microsoft SharePoint Master Basics in 50 Mins 53:15

  • 147: What is Sharepoint 01:43
  • 148: Sharepoint Look Book 01:31
  • 149: Getting Sharepoint and Home Page Overview 02:21
  • 150: Create a New Team Site 03:12
  • 151: Team Site Home Page 01:42
  • 152: Uploading Files 02:41
  • 153: Creating a New List 05:35
  • 154: Adding Web Parts 04:16
  • 155: Reorganizing and Customizing Web Parts 02:13
  • 156: Republish Team Site 00:59
  • 157: Add Members to Team Site 01:42
  • 158: Teams and Sharepoint Integration 06:12
  • 159: Create a New Communication Site 02:15
  • 160: Add Countdown Timer Web Part 03:07
  • 161: Edit Web Part Layouts 01:54
  • 162: Edit Sections 03:02
  • 163: Add Youtube Web Part 01:21
  • 164: Change Page Look and Editing Navigation 03:09
  • 165: Create a News Post 02:58
  • 166: Manage Site Access 01:22

• Microsoft Power Automate: Master Basics in Just 40 Mins 42:26

  • 167: Accessing Power Automate 01:36
  • 168: First Template Flow 06:20
  • 169: Test run your first flow 02:30
  • 170: My Flows 02:34
  • 171: Templates Overview 03:30
  • 172: Connectors Overview 03:30
  • 173: Different Flow Types 05:04
  • 174: Create a Flow from Scratch 02:28
  • 175: Test run your new flow 00:58
  • 176: Book Order Tracker Automation Introduction 03:00
  • 177: Book Order Tracker Automation 10:56

• Microsoft Project: Master Project Management Basics in 60 Mins! 1:10:02

  • 178: What is Microsoft Project 02:51
  • 179: The Project Interface 01:33
  • 180: Project Management Phases 02:22
  • 181: Create a new Project Plan 01:22
  • 182: Create a Project Calendar 06:05
  • 183: Creating Project Tasks 04:46
  • 184: Placeholder Text and Task Types 06:20
  • 185: Create Work Breakdown Structure 05:35
  • 186: Define Task Relationships 07:56
  • 187: Tying Up Loose Ends 01:59
  • 188: Add Resources to Project Plan 04:05
  • 189: Creating a Resource Calendar 02:59
  • 190: Assign Resources to Tasks 05:21
  • 191: Resolve Resource Conflicts 04:32
  • 192: Optimize the Project Plan 06:39
  • 193: Adding Additional Resources 01:55
  • 194: Cost of the Project 01:23
  • 195: Setting a Baseline 02:19

• Learn Microsoft Visio Basics in 30 minutes 34:02

  • 196: What is Microsoft Visio 00:53
  • 197: Where to get Microsoft Visio 02:27
  • 198: Starting Visio and Templates 06:21
  • 199: Starting a Cross-Functional Flowchart 03:00
  • 200: Title and Swimlanes 02:00
  • 201: Add Shapes Text and Connectors 09:16
  • 202: Insert Containers 01:27
  • 203: Shape Colors and Styles 01:32
  • 204: Themes 01:03
  • 205: Alignment and Spacing 01:11
  • 206: Add Pages 00:55
  • 207: Presentation Mode 01:21
  • 208: Visio Web 02:36

• Learn Microsoft forms basic in 30 minutes 35:57

  • 209: What is Microsoft Forms 01:06
  • 210: Where to get Microsoft Forms 00:37
  • 211: Forms Home Page 01:33
  • 212: New Form 09:57
  • 213: Branching 02:16
  • 214: Themes 00:38
  • 215: Form Settings 01:29
  • 216: Previewing and Testing the Form 03:10
  • 217: View Results and Export to Excel 02:33
  • 218: Sending the Form Link 01:23
  • 219: New Quiz 05:34
  • 220: Quiz Settings 01:05
  • 221: Previewing and Testing the Quiz 02:03
  • 222: View Results and Export to Excel 01:24
  • 223: Sending the Quiz Link 01:09

The comprehensive Microsoft Office Skills Diploma 12 course package starts with the basic knowledge of Microsoft Office applications, Microsoft Excel power query, Microsoft Excel Vlookup formula, Microsoft power BI, Microsoft OneNote, Microsoft Power Apps, Microsoft SharePoint, Microsoft Power Automate, Microsoft Project, Microsoft Visio, Microsoft forms and gradually shares expertise knowledge. In this course you will get a complete idea of Microsoft office applications with key concepts, strategies regarding use of it and in-depth knowledge. The Microsoft Office Skills Diploma 12 course package is completely an online course. You can access this Microsoft course from any part of the world with just a smart device and the internet.

By the end of this Microsoft course, you will get complete knowledge and marketable skills. The course also comes with a certificate, which will add extra value to your resume and help you stand out in the job market. In short, Microsoft 12 course bundle is the perfect course to fast track your career. So, why are you waiting? Enrol this Microsoft course today!

Why Choose the Microsoft Office Skills Diploma 12 course package?

• Conducted by industry experts
• Get Instant E-certificate
• Fully online, interactive course with Professional voice-over
• Developed by qualified professionals
• Self paced learning and laptop, tablet, smartphone friendly
• Tutor Support

The course "Microsoft Office Skills Diploma: Office, Excel, Power BI, OneNote, SharePoint & MS Project" is designed for individuals who want to enhance their skills and proficiency in using Microsoft Office applications, specifically Excel, Power BI, OneNote, SharePoint, and MS Project. This course is suitable for a wide range of individuals, including:

1. Professionals seeking to improve their Microsoft Office skills for their current job or to enhance their career prospects.
2. Office administrators and support staff who regularly work with Microsoft Office applications and want to increase their efficiency and productivity.
3. Project managers who want to learn how to effectively utilize MS Project for project planning, scheduling, and management.
4. Students and recent graduates who wish to acquire valuable Microsoft Office skills to increase their employability.
5. Business owners or entrepreneurs who want to gain proficiency in using Microsoft Office tools for managing their business operations effectively.
6. Individuals looking to transition into a new role or industry where Microsoft Office skills are highly valued.
7. Anyone interested in learning and mastering the various features and functions of Microsoft Office applications mentioned in the course.

It is worth noting that the course assumes a basic familiarity with Microsoft Office applications, so it may not be suitable for absolute beginners with no prior experience.

• Basic computer literacy: Familiarity with operating a computer, navigating through the Windows or Mac operating system, and using a keyboard and mouse.

• Familiarity with Microsoft Office: A basic understanding of Microsoft Office applications such as Word, Excel, PowerPoint, and Outlook will be helpful.

• Access to Microsoft Office software: Ideally, you should have access to a computer with Microsoft Office installed, particularly Excel, Power BI, OneNote, SharePoint, and MS Project. This will allow you to practice and apply the skills taught in the course directly.

• Internet access

The course can open up various career paths and opportunities for individuals who have acquired proficiency in Microsoft Office applications. Here's a potential career path that can be pursued after completing this course:

• Administrative Assistant

• Data Analyst

• Project Coordinator

• Office Manager

• SharePoint Administrator

• Business Analyst

• Training Specialist

• Freelancer/Consultant

Certificate of Completion

Digital certificate - Included

Reed Courses Certificate of Completion

Digital certificate - Included