Certificate in Microsoft Office & Power BI

Microsoft Word is the most widely used word-processing software, with a significant presence worldwide in both personal and professional settings. Our Word 2019 training course will teach you how to harness its powerful features. Despite its extensive capabilities to boost productivity, Microsoft continues to innovate with each new version they release.

Microsoft Word 2019
Module 1: Beginner
1.01 Instructor Intro
1.02 Course Intro
1.1 Explaining the Ribbon
1.2 Creating a Document
1.3 Saving Files
1.4 Page Views
1.5 Formatting Text
1.6 Ruler, Margins and Tab Stops
1.7 Moving and Duplicating Text
1.8 Line Spacing and Paragraph Formatting
1.9 Basic Editing
1.10 Insert a Basic Table and Graphics
1.11 Working with Styles
Module 2: Intermediate
2.1 Intermediate Intro
2.2 Collaboration & Co-Authorship
2.3 Tracking and Viewing Changes
2.4 Commenting
2.5 Templates & Layouts
2.6 Layout Functions on the Ribbon
2.7 Customize, Format and Convert Tables and Use as a Page Layout
2.8 Insert and Edit a Cover Page
2.9 Insert and Customize Headers and Footers
2.10 Insert and Customize Endnotes and Footnotes
2.11 Creating Sections in a Long Document
2.12 Using Sections to Format a Document
2.13 Deleting a Section
2.14 Reviewing, Inserting and Updating TOC
2.15 Creating a Data Source and Linking a Mailing List
2.16 Print Settings for Mail Merge
Module 3: Advanced
3.1 Adding the Developer Tab
3.2 Functionality Among Microsoft Office Products
3.3 Using Formulas in Word
3.4 Citing Sources in Word
O U T L I N E
3.5 Reviewing and Merging Versions of the Same Document
3.6 Creating a Master Document
3.7 Creating Sub Documents and Editing Master and Sub Docs
3.8 Controlling Editable Content
3.9 Form Creation Using the Developer Tab
3.10 Macros

Microsoft Excel is the go-to spreadsheet application for both personal and professional use. Whether you are a beginner or have advanced knowledge, our Microsoft Excel 2019 Training online course will elevate your abilities. The course covers topics ranging from basic to intermediate and advanced levels.

Microsoft Excel 2019
Module 1: Beginner
1.0 Intro
1.1 The Ribbon
1.2 Saving Files
1.3 Entering and Formatting Data
1.4 Printing from Excel & Using Page Layout View
1.5 Formulas Explained
1.6 Working with Formulas and Absolute References
1.7 Specifying and Using Named Range
1.8 Correct a Formula Error
1.9 What is a Function
1.10 Insert Function & Formula Builder
1.11 How to Use a Function- AUTOSUM, COUNT, AVERAGE
1.12 Create and Customize Charts
Module 2: Intermediate
2.0 Recap
2.1 Navigating and editing in two or more worksheets
2.2 View options – Split screen, view multiple windows
2.3 Moving or copying worksheets to another workbook
2.4 Create a link between two worksheets and workbooks
2.5 Creating summary worksheets
2.6 Freezing Cells
2.7 Add a hyperlink to another document
2.8 Filters
2.9 Grouping and ungrouping data
2.10 Creating and customizing all different kinds of charts
2.11 Adding graphics and using page layout to create visually appealing pages
2.12 Using Sparkline formatting
2.13 Converting tabular data to an Excel table
2.14 Using Structured References
2.15 Applying Data Validation to cells
2.16 Comments – Add, review, edit
2.17 Locating errors
Module 3: Advanced
3.1 Recap
3.2 Conditional (IF) functions
3.3 Nested condition formulas
O U T L I N E
3.4 Date and Time functions
3.5 Logical functions
3.6 Informational functions
3.7 VLOOKUP & HLOOKUP
3.8 Custom drop down lists
3.9 Create outline of data
3.10 Convert text to columns
3.11 Protecting the integrity of the data
3.12 What is it, how we use it and how to create a new rule
3.13 Clear conditional formatting & Themes
3.14 What is a Pivot Table and why do we want one
3.15 Create and modify data in a Pivot Table
3.16 Formatting and deleting a Pivot Table
3.17 Create and modify Pivot Charts
3.18 Customize Pivot Charts
3.19 Pivot Charts and Data Analysis
3.20 What is it and what do we use it for
3.21 Scenarios
3.22 Goal Seek
3.23 Running preinstalled Macros
3.24 Recording and assigning a new Macro
3.25 Save a Workbook to be Macro enabled
3.26 Create a simple Macro with Visual Basics for Applications (VBA)
3.27 Outro

This course will guide you through the basics of relational database design and the creation of database objects. You will learn to manage data using forms, query tables, and reports. Additionally, you will understand the interface, customisation, and editing of various objects within Microsoft Access. The course is divided into three levels: Basic Microsoft Access, Intermediate Microsoft Access, and Advanced Microsoft Access.

Microsoft Access 2016
Module 1 Access 2016 Basic
Introduction Part1
Introduction Part2
Elements Part1
Elements Part2
Reviewing Data
Queries Part1
Queries Part2
Tracking Time Part1
Tracking Time Part2
Tracking Time Part3
Design Work With Forms
Module 2 Access 2016 Intermediate
Relationships Part1
Relationships Part2
Changing Information
Loading Tables
Relating Invoices Part1
Relating Invoices Part2
Relating Invoices Part3
Relating Invoices Part4
Time Entry Form
Module 3 Access 2016 Advanced
Queries Part1
Queries Part2
Queries Part3
Queries Part4
Reports Based On Queries
Adding Additional Information
Update Query Part1
Update Query Part2
Creating A Report From Scratch Part1
Creating A Report From Scratch Part2
Creating A Report From Scratch Part3

In this course, you will learn how to use Microsoft PowerPoint 2016, the presentation software included in the Office 2016 Suite. You’ll master navigating the interface, inserting a range of objects, and creating engaging presentations that will impress your audience. Topics include design, customisation, and presentation of information using Microsoft PowerPoint 2016. This training course covers basic, intermediate, and advanced competency levels.

Microsoft PowerPoint 2016
Module 1 Basic Microsoft PowerPoint 2016
What Is PowerPoint Part 1
What Is PowerPoint Part 2
New Presentation
Viewing Presentation
Inserting Transitions
More Visual Designs Part 1
More Visual Designs Part 2
More Visual Designs Part 3
More Visual Designs Part 4
Notes
Module 2 Intermediate Microsoft PowerPoint 2016
Visual Designs With Logos And Animation Part1
Visual Designs With Logos And Animation Part2
Visual Designs With Logos And Animation Part3
Visual Designs With Logos And Animation Part4
Visual Designs With Logos And Animation Part5
Exit Animation Part1
Exit Animation Part2
Exit Animation Part3
Navigation Buttons
Layout Options Part1
Layout Options Part2
Module 3 Advanced Microsoft PowerPoint 2016
Master Pages Part1
Master Pages Part2
Software Simulation Part1
Software Simulation Part2
Setting Pictures To Music
Advanced Animation Techniques
Triggers
Motion Path Animation
Video In PowerPoint
PowerPoint Review Part1
PowerPoint Review Part2
Additional Options

In this Microsoft Outlook 2016 training course, you will learn about the four major components of Outlook: contacts, email, calendars, and tasks. Additionally, you will explore the OneNote application, which offers a cross-platform and cross-application note-taking tool. This course covers all proficiency levels, including Basic Outlook 2016, Intermediate Outlook 2016, and Advanced Outlook 2016.

Microsoft Outlook 2016
Module 1 Outlook 2016 Basic
Introduction Part 1
Introduction Part 2
Options For Displaying Email Messages
Create And Send An Email
Receive An Email
Calendar Part 1
Calendar Part 2
Contacts Part 1
Contacts Part 2
Tasks
Module 2Outlook 2016 Intermediate
Folder Structure Part
Folder Structure Part 2
Multiple Email Accounts Part 1
Multiple Email Accounts Part 2
Create A New Email Part 1
Create A New Email Part 2
Signatures
Calendars Part 1
Calendars Part 2
Contacts
Outlook Settings Part 1
Outlook Settings Part 2
Module 3 Outlook 2016 Advanced
One Note Introduction Part 1
One Note Introduction Part 2
One Note And PowerPoint
One Note And Word
One Note And Outlook
Sharing Information
OneNote And Mobile Devices
Additional Elements Part 1
Additional Elements Part 2

Welcome to the “Introduction to Microsoft Power BI” course. This course will teach you the essential skills you need to use Power BI for data analysis and visualization. You will learn how to connect to different data sources, clean and transform data, and create advanced data models. The course will also cover using DAX (Data Analysis Expressions) for creating calculations, generating reports, and building interactive dashboards. By the end, you will be able to create great data visualizations and perform advanced analytics to make better business decisions.

What you will learn in Microsoft Power BI Course?

In the Microsoft Power BI course, you will gain a thorough understanding of Power BI, from data preparation to advanced analytics, with practical skills you can use right away at work. You will learn how to:

Prepare and connect to various data sources in Power BI
Clean, transform, and load data
Design and develop data models
Create and manage model calculations using DAX
Generate and enhance reports and dashboards
Perform advanced analytics using Power BI tools
Create paginated reports and manage workspaces
Build Power App visuals and integrate with Analysis Services

Who this Microsoft Power BI course is for?

This Microsoft Power BI course is perfect for anyone looking to improve their data analysis and visualization skills with Power BI. Whether you’re new to Power BI or want to enhance your expertise, this course is for you. It’s ideal for:

Data Analysts and Business Analysts
Business Intelligence Professionals
IT Professionals and Database Administrators
Project Managers and Team Leaders
Anyone interested in learning Power BI from scratch