Microsoft Office Skills (Microsoft Excel, Word, PowerPoint), Administration & IT Training

Complete Microsoft Office Diploma (Office 365, Microsoft Excel, Word, PowerPoint, Outlook, Access) With Essential Office Skills, IT Functional Skills & Administration - All in a Single Purchase.

The Most Convenient Way to Boost Your Confidence And Learn Microsoft Office (Microsoft Excel, Word, PowerPoint, Outlook, Access, IT, Functional Skills, Administration) Inside And Out—Quickly, No Travel or Classes.

Designed to help you accomplish office tasks easily and with greater efficiency, Microsoft Office is the choice of many office professionals. If you're working in an office, you'll likely need to use the Microsoft Office suite and it's likely you're working for it, rather than having it work for you. Turn that around today and finally learn all the deep, dark secrets of this course.

Main CPD Accredited Courses in this Bundle are:

• Course 1: Microsoft Excel
• Course 2: Microsoft Word
• Course 3: Microsoft PowerPoint
• Course 4: Microsoft Access
• Course 5: Microsoft Outlook

The following topics are covered in this Online Microsoft Office Diploma (Microsoft Excel, Word, PowerPoint, Outlook, Access) With Essential Office Skills, IT Functional Skills & Administration Courses:

• Topic 01: Microsoft Excel 2021
• Topic 02: Microsoft Excel 2019
• Topic 03: Microsoft Excel 2016
• Topic 04: Microsoft Word 2021
• Topic 05: Microsoft Word 2019
• Topic 06: MS Word 2016
• Topic 07: Microsoft PowerPoint 2021
• Topic 08: Microsoft PowerPoint 2019
• Topic 09: MS PowerPoint 2016
• Topic 10: Microsoft Access 2019
• Topic 11: MS Access 2016
• Topic 12: Microsoft Outlook 2016
• Topic 13: MS Office 365

GIFTS Included with Microsoft Office (Microsoft Excel, Word, PowerPoint, Outlook, Access, IT, Functional Skills, Administration) -

• Free Course 01: Office Skills, Administration & Management
  
• Free Course 02: IT Functional Skills

We are concerned about the progression of your career. Therefore, after conducting extensive studies and consulting with experienced personnel, we formulated this outstanding Microsoft Office Diploma (Microsoft Excel, Word, PowerPoint, Outlook, Access, IT, Functional Skills, Administration) With Office Skills course to improve your pertinent skills. In this easy-to-digest course, you will get exclusive training, which will enable you to stand out in this competitive market.

What you'll learn

• Learn the essential Microsoft Office Skills in these three courses: Word, Excel, and PowerPoint
• Apply new and improved features in Excel 2021 and Office 365.
• How to use Microsoft Word to create, format, and edit documents
• Work with styles, templates, tables, and images in Word
• Learn to use Microsoft Excel to create, format, and analyze data in spreadsheets
• Effectively use formulas, functions, charts, and graphs in Excel
• Master of VLOOKUP, XLOOKUP, and Pivot table to create speedy Data Analytics
• Use to apply Microsoft PowerPoint to create dynamic and engaging presentations
• Add multimedia elements, animations, and transitions in PowerPoint
• Access and manage files from anywhere using Office 365
• Take advantage of the many benefits of cloud computing with Office 365
• Expert Tips and tricks to improve your productivity and efficiency in Microsoft Office.
• Learn time-saving techniques including how to copy slides, and set your presentation
• Control page appearance including using columns, indents, footers, borders, and watermarks.
• How to create a mail merge in Microsoft Word
• Learn how to correctly Print envelopes and labels in Word
• Make your Word documents look amazing by inserting and editing tables

What will make you stand out?

On completion of this Microsoft Office Diploma (Excel, Word, PowerPoint, Outlook, Access) With Office Skills, Functional Skills, Administration course, you will gain:

• CPD QS Accredited Proficiency
• After successfully completing the Microsoft Office, IT & Excel Course, you will receive a FREE PDF Certificate from REED as evidence of your newly acquired abilities.
• Lifetime access to the whole collection of Microsoft Office learning materials.
• The online test with immediate results
• You can study Microsoft Office, IT and complete the Excel course at your own pace.
• Study for the Microsoft Office course using any internet-connected device, such as a computer, tablet, or mobile device.

Expand all

• Microsoft Excel 2019 New Features (The Basics of MS Excel Start from Section 14) 27:14

  • 1: Introduction to Microsoft Excel 2019 New Features Preview 06:38
  • 2: CONCAT 01:30
  • 3: IFS 01:27
  • 4: MAXIFS 01:12
  • 5: MINIFS 00:47
  • 6: SWITCH 01:39
  • 7: TEXTJOIN 00:56
  • 8: Map Chart 01:40
  • 9: Funnel Chart 01:15
  • 10: Better Visuals 06:13
  • 11: Pivot Table Enhancements 01:38
  • 12: Power Pivot Updates 01:19
  • 13: Share Your Feedback 01:00

• Getting Started with Microsoft Excel 1:13:36

  • 14: Navigate the Excel User Interface 28:20
  • 15: Use Excel Commands Preview 10:01
  • 16: Create and Save a Basic Workbook 18:44
  • 17: Enter Cell Data 11:40
  • 18: Use Excel Help 04:51

• Performing Calculations in Microsoft Excel 49:21

  • 19: Create Worksheet Formulas 15:01
  • 20: Insert Functions 17:10
  • 21: Reuse Formulas and Functions 17:10

• Modifying a Worksheet 25:59

  • 22: Insert, Delete, and Adjust Cells, Columns, and Rows 10:08
  • 23: Search for and Replace Data 08:38
  • 24: Use Proofing and Research Tools 07:13

• Formatting a in Microsoft Excel Worksheet 1:02:43

  • 25: Apply Text Formats 16:18
  • 26: Apply Number Format 07:30
  • 27: Align Cell Contents 08:52
  • 28: Apply Styles and Themes 11:39
  • 29: Apply Basic Conditional Formatting 10:48
  • 30: Create and Use Templates 07:36

• Printing Workbooks 26:24

  • 31: Preview and Print a Workbook 10:28
  • 32: Set Up the Page Layout 08:32
  • 33: Configure Headers and Footers 07:24

• Managing in Microsoft Excel Workbooks 17:33

  • 34: Manage Worksheets 05:06
  • 35: Manage Workbook and Worksheet Views 06:54
  • 36: Manage Workbook Properties 05:33

• Microsoft Word 2019 New Features 48:34

  • 37: Introduction to Microsoft Word 2019 New Features 14:15
  • 38: Inking Tools 03:02
  • 39: Inking Tools 1 06:56
  • 40: Learning Tools 06:40
  • 41: Microsoft Translate Preview 02:46
  • 42: LaTeX 05:11
  • 43: Smart Lookup 04:13
  • 44: Side to Side Scrolling 02:14
  • 45: Scalable Vector Graphics 03:17

• Getting Started with Word 1:10:03

  • 46: Navigate in Microsoft Word 12:28
  • 47: Create and Save Word Documents 24:17
  • 48: Manage Your Workspace 05:43
  • 49: Edit Documents 15:38
  • 50: Preview and Print Documents 04:06
  • 51: Customize the Word Environment 07:51

• Formatting Text and Paragraphs 50:34

  • 52: Apply Character Formatting 16:56
  • 53: Control Paragraph Layout 19:20
  • 54: Align Text Using Tabs 07:11
  • 55: Display Text in Bulleted or Numbered Lists 02:38
  • 56: Apply Borders and Shading 04:29

• Working More Efficiently 30:00

  • 57: Make Repetitive Edits 05:52
  • 58: Apply Repetitive Formatting 09:51
  • 59: Use Styles to Streamline Repetitive Formatting Tasks 14:17

• Managing Lists 11:22

  • 60: Sort a List 05:19
  • 61: Format a List 06:03

• Adding Tables 18:03

  • 62: Inserting a Table 05:28
  • 63: Modify a Table 05:32
  • 64: Format a Table 02:34
  • 65: Convert Text to a Table 04:29

• Inserting Graphic Objects 15:25

  • 66: Insert Symbols and Special Characters 04:01
  • 67: Add Images to a Document 11:24

• Controlling Page Appearance 17:25

  • 68: Apply a Page Border and Color 03:09
  • 69: Add Headers and Footers 05:36
  • 70: Control Page Layout 05:00
  • 71: Add a Watermark 03:40

• Preparing to Publish a Document 21:15

  • 72: Check Spelling Grammar and Readability 07:14
  • 73: Use Proofing and Research Tools 07:13
  • 74: Check Accessibility 03:12
  • 75: Save a Document to Other Formats 03:36

• Microsoft PowerPoint 2019 New Features 31:16

  • 76: Introduction to Microsoft PowerPoint 2019 New Features 06:24
  • 77: Highlighting 01:30
  • 78: Morph Transition 02:39
  • 79: Zoom 02:53
  • 80: Vector Graphics 02:34
  • 81: SVG Icons to Shapes 04:16
  • 82: 3D Modeling 04:28
  • 83: Background Removal 03:06
  • 84: 4K 03:26

• PowerPoint Interface 1:05:46

  • 85: Navigate the PowerPoint Environment 28:23
  • 86: View and Navigate a Presentation Preview 14:48
  • 87: Create and Save a PowerPoint Presentation 12:58
  • 88: Use PowerPoint Help 09:37

• Presentation Basics 48:21

  • 89: Select a Presentation Type 08:24
  • 90: Edit Text 13:18
  • 91: Build a Presentation 26:39

• Formatting 36:32

  • 92: Format Characters 11:19
  • 93: Format Paragraphs 16:12
  • 94: Format Text Boxes 09:01

• Inserting Options 24:26

  • 95: Insert Images 09:38
  • 96: Insert Shapes 14:48

• Working with Objects 40:25

  • 97: Edit Objects 15:31
  • 98: Format Objects 06:08
  • 99: Group Objects 04:22
  • 100: Arrange Objects 06:59
  • 101: Animate Objects 07:25

• Table 18:06

  • 102: Create a Table 09:14
  • 103: Format a Table 02:34
  • 104: Insert a Table from Other Microsoft Office Applications 06:18

• Charts 24:35

  • 105: Create a Chart 10:16
  • 106: Format a Chart 09:39
  • 107: Insert a Chart from Microsoft Excel 04:40

• Review and Presentation 28:44

  • 108: Review Your Presentation 11:20
  • 109: Apply Transitions 04:29
  • 110: Print Your Presentation 04:58
  • 111: Deliver Your Presentation 07:57

• Microsoft Access 2019 New Features 12:28

  • 112: Introduction to Microsoft Access 2019 New Features 05:25
  • 113: Window Resize 00:44
  • 114: Charts 02:23
  • 115: dbf 01:11
  • 116: Large Number 01:22
  • 117: Property Sorting 01:23

• Introduction to Access 54:27

  • 118: Orientation to Microsoft Access 39:02
  • 119: Create a Simple Access Database 09:50
  • 120: Get Help and Configure Options in Microsoft Access 05:35

• Modify Data 22:33

  • 121: Modify Table Data 17:15
  • 122: Sort and Filter Records 05:18

• Working with Queries 37:18

  • 123: Create Basic Queries 15:12
  • 124: Sort and Filter Data in a Query 14:16
  • 125: Perform Calculations in a Query 07:50

• Access Forms 30:15

  • 126: Create Basic Access Forms 07:03
  • 127: Work with Data on Access Forms 23:12

• Working with Reports 1:00:33

  • 128: Create a Report 12:05
  • 129: Add Controls to a Report 11:42
  • 130: Enhance the Appearance of a Report 04:34
  • 131: Prepare a Report for Print 03:11
  • 132: Organize Report Information 14:56
  • 133: Format Reports 12:05
  • 134: Thank You! 01:00
  • 135: Find Out More! 01:00

• Assignment (Fully Optional) - Microsoft Office 2019 04:00

  • 136: Assignment on Microsoft Office 2019 04:00

• ***Getting Started With MS Office 2021*** 06:52

  • 137: Introduction Preview 02:58
  • 138: Getting started on Windows, macOS, and Linux 01:21
  • 139: How to ask great questions 01:14
  • 140: FAQ’s 01:19

• Excel 2021: Basics 41:27

  • 141: Excel Overview 05:20
  • 142: Start Excel Spreadsheet 04:26
  • 143: Enter Text and Numbers 07:24
  • 144: Relative References 03:40
  • 145: Working with ranges 06:52
  • 146: Save and Save as Actions 07:52
  • 147: File Extensions, Share, Export, and Publish files 05:53

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

  • 148: Adding Rows and Columns 02:34
  • 149: Modifying Rows and Column lengths 05:03

• Excel 2021: Data Handling 10:08

  • 150: Copy, Cut, and Paste 07:07
  • 151: Copying Formulas 03:01

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

  • 152: Page setup options 05:50
  • 153: Fit to print on One Page 02:39
  • 154: Print Workbooks 02:47

• Excel 2021: Sorting and Filtering 10:22

  • 155: Sorting Data Ascending Order 03:48
  • 156: Sorting Data Descending Order 02:25
  • 157: Filter Data 04:09

• Excel 2021: Writing Formulas 44:51

  • 158: Creating Basic Formulas 06:14
  • 159: Datetime Formulas 06:20
  • 160: Mathematical formulas phase1 19:54
  • 161: Mathematical formulas phase2 12:23

• Excel 2021: Advanced Formulas 16:19

  • 162: VLOOKUP formula 12:12
  • 163: HLOOKUP formula 04:07

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

  • 164: XLOOKUP 07:39
  • 165: Handling #NA and Approximates match in XLOOKUP 10:31

• Excel 2021: Data and Tools 37:27

  • 166: Split Text into columns 07:03
  • 167: Flash Fill 07:03
  • 168: Data Validation 06:34
  • 169: Remove Duplicates 07:47
  • 170: Import Data from Text files 05:38
  • 171: Import Data from .CSV files 03:22

• Excel 2021: Formatting data and tables 23:38

  • 172: Formatting Font 04:15
  • 173: Formatting Alignment 06:04
  • 174: Formatting Numbers 04:37
  • 175: Formatting Date 03:29
  • 176: Formatting Tables 05:13

• Excel 2021: Pivot Tables 08:32

  • 177: Pivot Tables 06:43
  • 178: Pivot Charts 01:49

• Excel 2021: Charts 23:35

  • 179: Excel Charts – Categories 02:30
  • 180: Elements of a chart 04:12
  • 181: Creating Charts 01:55
  • 182: Column or Bar charts 04:21
  • 183: Formatting charts 03:37
  • 184: Line Charts 02:13
  • 185: Pie and Doughnut charts 03:47
  • 186: Share Your Feedback 01:00

• PowerPoint 2021: Course Introduction 13:23

  • 187: Overview 03:47
  • 188: Start PowerPoint Presentation 04:59
  • 189: Screen setting and Views 04:37

• PowerPoint 2021: Basics 20:57

  • 190: Presentation Tips and Guidelines 06:00
  • 191: Creating a New Presentation 03:51
  • 192: Working with Slides 03:40
  • 193: Save a Presentation 04:16
  • 194: Print Slides 03:10

• PowerPoint 2021: Text and Bullet Options 12:34

  • 195: Formatting Text 05:05
  • 196: Slide Text Alignments 03:01
  • 197: Multi-Column Text Alignments 01:40
  • 198: Adding Bullets and Numbered List Items 02:48

• PowerPoint 2021: Adding Graphic Assets 15:45

  • 199: Insert Shapes 03:26
  • 200: Insert Icons 03:02
  • 201: Insert Graphics 03:38
  • 202: Add 3D Models 02:41
  • 203: Insert Pictures 02:58

• PowerPoint 2021: Picture Formatting 10:31

  • 204: Picture Options 03:56
  • 205: Picture Cropping 02:33
  • 206: Applying Built-in Picture Styles 04:02

• PowerPoint 2021: SmartArt Graphics 08:50

  • 207: Add SmartArt Graphic 02:33
  • 208: Modifying SmartArt 03:13
  • 209: Creating a Target Chart using SmartArt 03:04

• PowerPoint 2021: Working with Tables 09:51

  • 210: Create a Table on Slide 04:13
  • 211: Formatting Tables 02:24
  • 212: Inserting Tables 01:55
  • 213: Table Layouts 01:19

• PowerPoint 2021: Working with Charts 06:42

  • 214: Add a Chart 01:57
  • 215: Formatting Charts 01:48
  • 216: Insert Chart from Microsoft Excel 02:57

• PowerPoint 2021: Adding Multimedia 06:32

  • 217: Adding Video to a Presentation 02:31
  • 218: Adding Audio to a Presentation 01:33
  • 219: Screen Recording and Adding 02:28

• PowerPoint 2021: Working with Transition 04:14

  • 220: Applying Transitions to Presentation 04:14

• PowerPoint 2021: Animation 08:35

  • 221: Object Animation 03:14
  • 222: Effect Options 02:03
  • 223: Advanced Animation 01:31
  • 224: Triggers to control animation 01:47

• PowerPoint 2021: Slideshow Effects 07:58

  • 225: Onscreen Presentation 02:16
  • 226: Hiding Slides 01:42
  • 227: Changing Order of Slides 01:50
  • 228: Copying Slides 02:10

• Word 2021: Introduction 08:45

  • 229: Overview of MS Word 03:57
  • 230: Start MS Word 2021 04:48

• Word 2021: Basics 20:11

  • 231: Create a new blank document 04:20
  • 232: Creating a paragraph text 04:55
  • 233: Non-printing characters 02:59
  • 234: Save a document 02:45
  • 235: Open a document 01:22
  • 236: Find and replace 03:50

• Word 2021: Word Formatting 25:20

  • 237: AutoCorrect options 02:54
  • 238: Formatting text 03:59
  • 239: Copy cut and paste 03:50
  • 240: Character formatting 02:28
  • 241: Format painter 03:58
  • 242: Work with numbers 01:43
  • 243: Add bullets 02:46
  • 244: Outline creation 03:42

• Word 2021: Tables 24:17

  • 245: Creating a table 02:30
  • 246: Adding rows and columns to a table 02:10
  • 247: Formatting table data 02:19
  • 248: Borders and shading 01:45
  • 249: Sorting in a table 03:41
  • 250: Draw a table 03:31
  • 251: Convert text to table 02:43
  • 252: Convert table to text 02:05
  • 253: Insert a spreadsheet 01:41
  • 254: Quick tables – readily available formats 01:52

• Word 2021: Styles 05:00

  • 255: Working with styles 01:54
  • 256: Creating styles 01:50
  • 257: Clear formatting 01:16

• Word 2021: Page Layout 14:44

  • 258: Margins 01:44
  • 259: Orientation 01:23
  • 260: Page size setting 00:57
  • 261: Adding columns 03:24
  • 262: Page break – section break 01:37
  • 263: Adding watermark 02:58
  • 264: Headers and footers 02:41

• Word 2021: Envelops and Lables 04:26

  • 265: Create envelops 02:28
  • 266: Creating labels 01:58

• Word 2021: Mail Merges 03:19

  • 267: Creating a mail merge document 03:19

• Word 2021: Review and Printing 05:51

  • 268: Thesaurus and spell check 01:09
  • 269: Word count 01:21
  • 270: Speech - read aloud 00:58
  • 271: Language - translate 01:13
  • 272: Tracking 01:10

• Assignment (Fully Optional) : Mastering Microsoft Office 2021 04:00

  • 273: Assignment: MS Office 2021 04:00

• Order Your CPD Quality Standard Certificate (Optional) 01:00

  • 274: CPD Quality Standard Certificate 01:00

• Free Course 01: Office Skills , Administration & Management 1:07:24

  • 275: Module 01: Introduction to Office Administration 07:16
  • 276: Module 02: Skills of an Effective Administrator 09:18
  • 277: Module 03: Organisational Skills 17:05
  • 278: Module 04: Organising Meeting and Conferences 17:24
  • 279: Module 05: Communication Skills 16:21

• Free Course 02: Functional Skills - IT 1:22:19

  • 280: Module 01: Introduction to Information Management 18:08
  • 281: Module 02: Information Management Strategy 10:28
  • 282: Module 03: Databases and Information Management 17:08
  • 283: Module 04: Management Information Systems 09:17
  • 284: Module 05: Auditing Information Systems 09:18
  • 285: Module 06: Ethical and Social Issues and Data Protection 18:00

• Section 01: Microsoft Word 2016 5:59:00

  • 286: Lesson 1.1 - Modify User Information 03:00
  • 287: Lesson 1.2 -Share a Document 07:00
  • 288: Lesson 1.3 -Work with Comments 05:00
  • 289: Lesson 1.4 -Compare Document Changes 04:00
  • 290: Lesson 1.5 -Review a Document 05:00
  • 291: Lesson 1.6 -Merge Document Changes 04:00
  • 292: Lesson 1.7 -Coauthor Documents 04:00
  • 293: Lesson 2.1 -Add Captions 04:00
  • 294: Lesson 2.2 -Add Cross-References 04:00
  • 295: Lesson 2.3 -Add Bookmarks 04:00
  • 296: Lesson 2.4 -Add Hyperlinks 05:00
  • 297: Lesson 2.5 -Insert Footnotes and Endnotes 05:00
  • 298: Lesson 2.6 -Add Citations 07:00
  • 299: Lesson 2.7 -Insert a Bibliography 03:00
  • 300: Lesson 3.1 -Insert Blank and Cover Pages 02:00
  • 301: Lesson 3.2 -Insert an Index 08:00
  • 302: Lesson 3.3 -Insert a Table of Contents 33:00
  • 303: Lesson 3.4 -Insert an Ancillary Table 21:00
  • 304: Lesson 3.5 -Manage Outlines 27:00
  • 305: Lesson 3.6 -Create a Master Document 27:00
  • 306: Lesson 4.1 -Suppress Information 23:00
  • 307: Lesson 4.2 -Set Editing Restrictions 24:00
  • 308: Lesson 4.3 -Add a Digital Signature to a Document 16:00
  • 309: Lesson 4.4 -Restrict Document Access 14:00
  • 310: Lesson 5.1 - Create Forms 34:00
  • 311: Lesson 5.2 - Manipulate Forms 16:00
  • 312: Lesson 5.3 - Form Data Conversion 16:00
  • 313: Lesson 6.1 - Create a New Document Version 28:00
  • 314: Lesson 6.2 - Compare Document Versions 03:00
  • 315: Lesson 6.3 - Merge Document Versions 03:00

• Section 02: Microsoft Excel 2016 3:07:00

  • 316: Update Workbook Properties 08:00
  • 317: Activity-Update Workbook Properties 02:00
  • 318: Create and Edit a Macro 13:00
  • 319: Activity-Create And Edit A Macro 03:00
  • 320: Apply Conditional Formatting 13:00
  • 321: Activity-Apply Conditional Formatting 03:00
  • 322: Add Data Validation Criteria 04:00
  • 323: Activity-Add Data Validation Criteria 03:00
  • 324: Trace Cells 04:00
  • 325: Activity-Trace Cells 02:00
  • 326: Troubleshoot Invalid Data and Formula Errors 06:00
  • 327: Activity - Troubleshoot Invalid Data and Formula Errors 03:00
  • 328: Watch and Evaluate Formulas 04:00
  • 329: Activity-Watch and Evaluate Formulas 03:00
  • 330: Create a Data List Outline 04:00
  • 331: Activity - Create a Data List Outline 02:00
  • 332: Create Sparklines 04:00
  • 333: Activity - Create Sparklines 02:00
  • 334: Create Scenarios 04:00
  • 335: Activity - Create Scenarios 04:00
  • 336: Perform a What-If Analysis 13:00
  • 337: Activity - Perform a What-If Analysis 04:00
  • 338: Perform a Statistical Analysis with the Analysis ToolPak 03:00
  • 339: Activity - Perform a Statistical Analysis with the Analysis ToolPak 02:00
  • 340: Create Interactive Data with Power View 10:00
  • 341: Activity - Create Interactive Data with Power View 02:00
  • 342: Consolidate Data 04:00
  • 343: Activity - Consolidate Data 02:00
  • 344: Link Cells in Different Workbooks 03:00
  • 345: Activity - Link Cells in Different Workbooks 02:00
  • 346: Merge Workbooks 03:00
  • 347: Activity - Merge Workbooks 02:00
  • 348: Export Excel Data 03:00
  • 349: Activity - Export Excel Data 02:00
  • 350: Import a Delimited Text File 03:00
  • 351: Activity- Import a Delimited Text File 02:00
  • 352: Integrate Excel Data with the Web 06:00
  • 353: Activity - Integrate Excel Data with the Web 02:00
  • 354: Create a Web Query 06:00
  • 355: Activity - Create a Web Query 02:00
  • 356: Import and Export XML Data 18:00
  • 357: Activity - Import and Export XML Data 02:00

• Section 03: Microsoft PowerPoint 2016 6:33:00

  • 358: Customize the User Interface 31:00
  • 359: Set PowerPoint 2016 Options 14:00
  • 360: Create and Manage Sections 18:00
  • 361: Modify Slide Masters and Slide Layouts 24:00
  • 362: Add Headers and Footers 10:00
  • 363: Modify the Notes Master and the Handout Master 14:00
  • 364: Create SmartArt 14:00
  • 365: Modify SmartArt 23:00
  • 366: Add Audio to a Presentation 13:00
  • 367: Add Video to a Presentation 20:00
  • 368: Customize Animations and Transitions 24:00
  • 369: Add Comments to a Presentation 14:00
  • 370: Review a Presentation 17:00
  • 371: Store and Share Presentations on the Web 28:00
  • 372: Annotate a Presentation 17:00
  • 373: Set Up a Slide Show 14:00
  • 374: Create a Custom Slide Show 11:00
  • 375: Add Hyperlinks and Action Buttons 17:00
  • 376: Record a Presentation 08:00
  • 377: Secure a Presentation 28:00
  • 378: Present a Slide Show Online 20:00
  • 379: Create a Video or a CD 14:00

• Section 04: Microsoft Outlook 2016 7:58:00

  • 380: Insert Advanced Characters and Objects 37:00
  • 381: Modify Message Settings, Properties, and Options 27:00
  • 382: Use Automatic Replies 31:00
  • 383: Sort Messages 13:00
  • 384: Filter Messages 17:00
  • 385: Organize Messages 40:00
  • 386: Search Messages 28:00
  • 387: Manage Junk Mail 21:00
  • 388: Manage Your Mailbox 37:00
  • 389: Manage Advanced Calendar Options 18:00
  • 390: Manage Additional Calendars 18:00
  • 391: Manage Meeting Responses 23:00
  • 392: Assign and Manage Tasks 21:00
  • 393: Edit an Electronic Business Card 17:00
  • 394: Manage Advanced Contact Options 27:00
  • 395: Forward Contacts 08:00
  • 396: Export Contacts 18:00
  • 397: Delegate Access to Mail Folders 23:00
  • 398: Share Your Calendar 08:00
  • 399: Share Your Contacts 06:00
  • 400: Back Up Outlook Items 16:00
  • 401: Change Data File Settings 16:00
  • 402: Configure E-mail Message Security Settings 08:00

• Section 05: Microsoft Access 2016 7:30:00

  • 403: Add Controls to Forms 27:00
  • 404: Set Form Controls 25:00
  • 405: Create Subforms 18:00
  • 406: Organize Information with Tab Pages 16:00
  • 407: Enhance Navigation with Forms 17:00
  • 408: Format a Form 37:00
  • 409: Apply Conditional Formatting 18:00
  • 410: Field Validation 20:00
  • 411: Form and Record Validation 20:00
  • 412: Create a Macro 27:00
  • 413: Restrict Records Using a Condition 16:00
  • 414: Validate Data Using a Macro 17:00
  • 415: Automate Data Entry Using a Macro 14:00
  • 416: Convert a Macro to VBA 08:00
  • 417: Link Tables to External Data Sources 13:00
  • 418: Manage a Database 11:00
  • 419: Determine Object Dependency 10:00
  • 420: Document a Database 10:00
  • 421: Analyze the Performance of a Database 08:00
  • 422: Split a Database for Multiple User Access 14:00
  • 423: Implement Security 20:00
  • 424: Set Passwords 08:00
  • 425: Convert an Access Database to an ACCDE File 13:00
  • 426: Package a Database with a Digital Signature 13:00
  • 427: Create a Database Switchboard 25:00
  • 428: Modify a Database Switchboard 08:00
  • 429: Set Startup Options 17:00

• Assignment (Fully Optional) : Microsoft Office 2016 03:00

  • 430: Assignment On Microsoft Office 101 03:00

• Thank you for being a part of this course! We'd appreciate your feedback 01:00

  • 431: Please leave a review 01:00

The substantial Microsoft Office Diploma (Excel, Word, PowerPoint, Outlook, Access, IT, Functional Skills, Administration) With Office Skills course with free Reed certificate is designed to help you demonstrate the preliminary to in-depth level of learning regarding this topic. Moreover, you will be provided with the most knowledgeable and informative modules for your lifetime by enrolling in this course just once.

Therefore, reinforce your knowledge and furnish your skills by enrolling in our course. Take one step closer to achieving your goal.

This Microsoft Office Diploma (Microsoft Excel, Word, PowerPoint, Outlook, Access, IT, Functional Skills, Administration) With Office Skills Course is suitable for anyone interested in:

• Microsoft Office Specialist (MOS)
• Microsoft Office Specialist (MOS) Expert
• Microsoft Office Specialist (MOS) Master
• Microsoft Specialist certification in Office 365
• MS Office User
• Touch Typing Worker
  

Without any formal requirements, you can delightfully enrol in this MS Office Diploma (Excel, Word, PowerPoint, Outlook, Access, IT, Functional Skills, Administration) With Office Skills course online . Just get a device with internet connectivity and you are ready to start your learning journey. Thus, complete this MS Office Diploma (Excel, Word, PowerPoint, Outlook, Access, Functional Skills, Administration) With Office Skills course at your own pace.

The aim of this exclusive Microsoft Office Diploma (Microsoft Excel, Word, PowerPoint, Outlook, Access, IT, Functional Skills, Administration) With Office Skills course is to help you toward your dream career.

• Office Administrator
• Entrepreneur
• Data Analyst
• HR Admin
• MS Office Specialist
• Receptionist
• Audio Typist
• Microsoft Excel for Accounting

Search questions

---

Reed courses certificate of completion

Digital certificate - Included

CPD Quality Standard Certificate

Digital certificate - £4.99

Hardcopy Certificate (FREE UK Delivery)

Hard copy certificate - £9.99