Microsoft Office Complete Bundle

This training bundle provides a complete understanding of a wide range of Microsoft Office applications including Word, Excel, Outlook and more. It includes all these courses:

• Microsoft Access Masterclass
• Microsoft Excel Masterclass
• Microsoft Excel VBA & Macros
• Microsoft Outlook Masterclass
• Microsoft Power BI Training
• Microsoft PowerPoint Masterclass
• Microsoft Project Masterclass
• Microsoft SharePoint Masterclass
• Microsoft Visio Masterclass
• Microsoft Word Masterclass

This bundle covers the following topics:

Microsoft Access Masterclass

• Module 1: Navigating Access
• Module 2: The Structure of Access
• Module 3: Advanced Elements
• Module 4: Automation
• Module 5: Tips and Tricks

Microsoft Excel Masterclass

• Module 1: Navigation of the Excel Interface
• Module 2: Use of Lists and Tables
• Module 3: Conditional Formatting
• Module 4: Using Formulas and Creating Pivot Tables

Microsoft Excel VBA & Macros

• Module 1: Introduction
• Module 2: Event Handling
• Module 3: Functions
• Module 4: ERROR Statements
• Module 5: Forms
• Module 6: Referencing Other Applications
• Module 7: Messages and Variables
• Module 8: Simple IF Conditions
• Module 9: Three Main Types of Loop
• Module 10: Recording Macros and Buttons
• Module 11: The Excel Object Model
• Module 12: Debugging and Error Handling

Microsoft Outlook Masterclass

• Module 1 - Email Model:
• Module 2 - Getting Started with Outlook
• Module 3 - Working with Attachments
• Module 4 - Flagging Messages
• Module 5 - Junk Email
• Module 6 - Working with the Calendar
• Module 7 - People
• Module 8 - Tasks
• Module 9 - Working with Rules
• Module 10 - Scheduling Meetings

Microsoft Power BI Training

• Module 1: Introduction to Power BI
• Module 2: Data Sources
• Module 3: Shaping and Combining Data
• Module 4: Modelling Data
• Module 5: Interactive Data Visualisations

Microsoft PowerPoint Masterclass

• Module 1: Ribbons
• Module 2: Getting Started
• Module 3: Views
• Module 4: Working with Text
• Module 5: Working with Shapes
• Module 6: Slide Master
• Module 7: Using the Insert Ribbon
• Module 8: Charts
• Module 9: Transitions and Animation
• Module 10: Printing and Publishing

Microsoft Project Masterclass

• Module 1 - Getting Started with Microsoft Project
• Module 2 - Creating the Project Schedule
• Module 3 - Managing Resources in a Project Plan
• Module 4 – Assigning Resources and Levelling
• Module 5 – Costs
• Module 6 – Constraints and Deadlines
• Module 7 – Project Tracking and Controlling
• Module 8 – Reporting

Microsoft SharePoint Masterclass

• Module 1: SharePoint Fundamentals
• Module 2: Working with Sites and Pages
• Module 3: Regulating Content
• Module 4: Working with Items and Lists
• Module 5: Integrity of Metadata
• Module 6: Understanding Groups
• Module 7: Default and Custom Groups
• Module 8: Applying Workflows
• Module 9: RSS Feeds and Pulling RSS Feeds from other sites
• Module 10: Live Co-Authoring

Microsoft Visio Masterclass

• Module 1: Creating Technical Layouts
• Module 2: Exploring Advanced Diagrams
• Module 3: Diagramming and Data
• Module 4: Advanced Customer Shape Design

Microsoft Word Masterclass

• Module 1: The Ribbon Interface
• Module 2: Utilising Text
• Module 3: Printing and Viewing Your Document
• Module 4: Managing Your Documents
• Module 5: Using Formatting Tools and Tables

Anybody looking to learn how to use a wide range of Microsoft Office software.

There are no prerequisites to study.