Beginner

Course Outline

• Getting Started With Excel 2016
• Excel 2016 Selection Techniques
• Manipulating Rows and Columns within Excel 2016
• Manipulating Cells and Cell Content within Excel 2016
• Excel 2016 Worksheets
• Font Formatting within Excel 2016
• Alignment Formatting within Excel 2016
• Number Formatting within Excel 2016
• Freezing Row and Column Titles
• Excel 2016 Formulas
• Excel 2016 Functions
• Excel 2016 Charts
• Customising Excel 2016

Exam Code

77-727

Intermediate

Overview

This Intermediate Microsoft Excel 2016 training class is meant for students who want to advance their skill set by learning to work with formulas, functions and formatting.

Target Audience

Students who have basic skills with Microsoft Excel 2016 who want to learn intermediate-level skills or students who want to learn the topics covered in this course in the 2016 interface.

Objectives

• Learn to use formulas and functions.
• Create and modify charts.
• Convert, sort, filter, and manage lists.
• Insert and modify illustrations in a worksheet.
• Learn to work with tables.
• Learn to use conditional formatting and styles.

Course Outline

Excel 2016 Setup & Printing Issues
Excel 2016 Functions and Formulas
Excel 2016 Time & Date Functions
Excel 2016 Mathematical Functions
Excel 2016 Logical Functions
Excel 2016 Mathematical Functions
Excel 2016 Statistical Functions
Excel 2016 Text Functions
Excel 2016 Financial Functions
Excel 2016 Lookup Functions
Excel 2016 Database Functions
Excel 2016 Named Ranges
Excel 2016 Cell Formatting
Manipulating Worksheets within Excel 2016
Excel 2016 Templates
Paste Special Options within Excel 2016

Exam Code

77-728

Advanced

Overview

This Advanced Microsoft Excel 2016 training class is designed for students to gain the skills necessary to use pivot tables, audit and analyze worksheet data, utilize data tools, collaborate with others, and create and manage macros.

Objectives

• Create pivot tables and charts.
• Learn to trace precedents and dependents.
• Convert text and validate and consolidate data.
• Collaborate with others by protecting worksheets and workbooks.
• Create, use, edit, and manage macros.
• Import and export data.

Course Outline

Pivot Tables
Input Tables
Charts
Hyperlinks
Linking & Embedding
Importing Text Files
Sorting and Filtering Data
Tracking and Reviewing Changes
Scenarios
Validating
Auditing
Macros
Passwords & Security Issues

Exam Code

77-728

Microsoft Excel Dashboard

Descriptions

Excel Dashboards provide insight, analysis and even alerts. They are interactive and dynamic, and have a wide range of applications, providing help with project management, customer service, KPI management, forecasting and so on. They usually fit on one page, displaying key trends, comparisons and data in small graphs or tables. This makes them easy to read and digest the information. They are also often interactive, which allows the user to filter data and switch views themselves.

Overviews

This advanced one-days training course teaches delegates how to create interactive Excel dashboards that update with the click of the Refresh button, or with a simple copy and paste of your new data into your spreadsheet.

Target Audience

Anyone with an advanced knowledge of Excel who wants to learn how to create dashboards which will enhance their spreadsheets with easily understood and interactive data displays.

Course Outline

Module 1: Introduction to Dashboards
Module 2: Inserting Graphics for a Dashboard
Module 3: Specialist Functions and Formulas
Module 4: Dashboard Navigation
Module 5: Preparing your Workbook’s Layout and Structure
Module 6: Using Excel Objects for Specialist Dashboard Views
Module 7: Using Macros and VBA with Dashboards

Exam Code

77-728

Micracles Excel Formulas and Functions

Overviews

This course targets audience who would like to explore the possibilities of Excel formulas and functions. This is also for those who wish to gain the skills and understand the formulas and functions syntax.

Prerequisites

Knowledge of Microsoft Excel Intermediate is essential with the following pre-requisites:

• Able to switch between task applications
• Able to Create, Save, Open and Print spreadsheet
• Able to use the Undo function
• Insert and delete Row & Column
• Print a spreadsheet with headers and footer
• Insert, Delete and Rename a worksheet
• Able to create basic formulas like addition, substraction, multiplication and division
• Able to use basic functions like Sum, Average, Count, Max and Min functions

Course Outline

Unit 1: Cell and Range References
Unit 2: Statistical Function
Unit 3: Math and Trig Function
Unit 4: The Wonders of Text Functions
Unit 5: Logical Functions
Units 6: Lookup & Reference Formulas
Unit 7: Date & Time Formulas

Exam Code

77-728

Power Pivot and Power Query for Excel 2016

Overviews

Power Pivot, Power Query, Power View, 3D maps are free add-ins that expand and combine the features and capabilities of Excel. It includes the ability to import, manipulate and work with large amounts of data from a variety of data sources both inside and outside Excel. This course will cover techniques for manipulating and querying data, the structure of DAX functions, ways to distribute and visualize data using PivotCharts, Slicers, Sparklines, Timelines, Power View and 3D maps.

Learning Outcome

By the end of this course, participants should be comfortable with navigating the Power Pivot and Power
Query applications, manipulating data, creating queries and reports, using DAX functions, and distributing and visualizing data.

Prerequisites

Participants should be comfortable using the Excel 2016 interface and have a firm understanding of how Excel works and what it is used for. Understanding and experience with formulas, functions, and PivotTables is strongly recommended.

Target Group

Individuals interested in learning more about Power Pivot and Power Query applications.

Course Outline

Getting Started with Power Pivot
Manipulating Power Pivot Data
Manipulate Power Pivot Data Using DAX Functions
Extract Data from Tables Using Functions
Work with Time Dependent Data
Data Sources
Organizing Data
Queries
Create PivotTables
Bringing It All Together with Visualizations

Beginner

Course Outline

Module 1: Creating and Managing Presentations
Module 2: Inserting and Formatting Text, Shapes, and Images
Module 3: Tables, Charts, SmartArt, and Media
Module 4: Transitions and Animations
Module 5: Finalizing and Delivering

Exam Code

77-729

Intermediate

Course Outline

PowerPoint 2016 Customising and Compatibility Issues
PowerPoint 2016 Sections
PowerPoint 2016 Slide Masters
PowerPoint 2016 ThemesFormatting Pictures within PowerPoint 2016
Manipulating Graphics within PowerPoint
Formatting AutoShapes in PowerPoint 2016

Exam Code

77-729

Advanced

Course Outline

Diagrams within PowerPoint 2016
Charts in PowerPoint 2016
PowerPoint 2016 Video and Audio
PowerPoint 2016 Animation
Linking and Embedding In PowerPoint 2016
Hyperlinks and PowerPoint 2016
Merging, Comparing & Exporting within PowerPoint 2016
PowerPoint 2016 Slide Shows
Sharing PowerPoint 2016 Presentations
PowerPoint 2016 Presentation Design & Compatibility Issues

Exam Code

77-729

Microsoft Access VBA Programming

Overview

Microsoft Access VBA (Visual Basic for Applications) is the programming language used to extend the functionality of Access databases beyond what is possible with the standard user interface and macros. In 2026, while Microsoft has shifted focus toward cloud-based “Low-Code” solutions like Power Apps, Access VBA remains a critical skill for maintaining legacy systems and building complex, high performance desktop database applications.

Key Learning Outcomes

• The Visual Basic Editor (VBE): Master the development environment, including managing modules, using the Project Explorer, and leveraging the Immediate Window for real-time code testing.
• Object-Oriented Programming: Understand the Access Object Model. Learn how to control forms, reports, and controls (like combo boxes and subforms) through code.
• Data Manipulation (DAO & ADO): Learn to use DAO for native Access data operations and ADO for connecting Access to external data sources like SQL Server or Oracle.
• Logical Control Structures: Implement decision-making logic using If…Then…Else and Select Case, and automate repetitive actions using For…Next and Do…Loop structures.
• Error Handling & Debugging: Write robust code by implementing On Error routines and using debugging tools like Breakpoints and Step Through to resolve logic issues.
• Automation: Create “Cross-App” solutions that allow Access to automatically generate Excel charts, Word reports, or Outlook emails based on database queries.

Detailed Course Outline

• Introduction to VBA: Modules vs. Class Modules, the structure of a Procedure (Sub vs. Function), and naming conventions.
• Variables and Data Types: Understanding scope (Local, Module, and Global), declaring variables, and using intrinsic constants.
• Controlling Form Events: Writing code for events like On Click, After Update, and On Load to create interactive user experiences.
• Working with Recordsets: Using VBA to navigate, edit, add, and delete data directly in tables without using forms.
• Access SQL in VBA: Dynamically building and executing SQL strings to run Action Queries (Update, Insert, Delete) through code.

Exam Code

77-730

Microsoft Excel VBA Programming

In this course, you will learn:

• Using Macro recorder to create macros for task automation
• How to use VBA to control Workbooks, Worksheets, Ranges, and Cells
• The best practice of coding VBA programs
• Creating custom formulas
• Creating complex decision-making criteria to process data
• Creating validation functions to ensure source data is correct
• Using worksheet functions to simplify and empower your VBA programs
• Handling dynamic ranges based upon user input or data content
• Processing records in dynamic size data tables
• Using VBA to generate PivotTable reports automatically
• Using user forms and controls to create customized software interface
• Distribution issues such as Macro file types and security
• Basic VBA program diagnostics techniques

Prerequisites

Basic knowledge of Microsoft Excel

Course Outline

Introducing Visual Basic for Applications
VBA Programming Fundamentals
Working with VBA Sub Procedures
Creating Function Procedures
VBA Programming Examples and Techniques
Custom Dialog Box Alternatives
Introducing UserForms
Working with Pivot Tables

Exam Code

77-728

Managing Your Finances using Microsoft Excel

Decription

A “Managing Your Finances using Microsoft Excel” course typically covers building personal budgets, tracking expenses, calculating net worth, and planning for retirement using tools like PivotTables, formulas (NPV, IRR), and data visualization. Key focus areas include automation, scenario analysis, and creating dashboards to monitor cash flow.

Course Outline

Module 1: Excel Fundamentals for Finance
Module 2: Personal Budgeting & Expense Tracking
Module 3: Managing Net Worth & Cash Flow
Module 4: Financial Analysis & Decision Making
Module 5: Financial Data Visualization & Reporting