Module 1: Getting Started
Opening Excel 365 (Desktop Version)
Opening a New Workbook
Guide to the Interface
Working with Sheets
Working with Columns
Working with Rows
Selecting Cells
Saving & Closing Workbooks
Opening an existing Workbook

Module 2: Entering Data & Formatting Cells
Entering Text
Formatting Text
Cell Alignment
Merge and Centre Feature
Wrap Feature
Formatting Numbers
Entering Dates
Formatting Dates
AutoFill
FlashFill
Cell Styles
Find & Select Options
Undo & Redo
Cut, Copy & Paste
More Paste Options
Inserting an Image

Module 3: Basic Calculations
Operators : Addition, Subtraction
Operators : Multiplication, Division
Operators : Use of ()
Functions: SUM
Functions: AVERAGE
Functions: MAX and MIN
Functions: COUNT, COUNTA, COUNTBLANK
Relative and Absolute Referencing

Module 4: Printing
Printing a Sheet
Page Setup Options
Headers and Footers
Print Multiple sheets

Module 5: Charts
Different Chart Types
Creating a Chart
Printing a Chart
Simple Edits to a Chart

Module 6: Working With Lists
Freeze Panes
Sorting
Basic Filters

Module 7: Advanced formatting
Formatting Dates
Custom Formats
Conditional Formatting
Advanced Conditional Formatting
Conditional Formatting with Formulae
Advanced Find & Select

Module 8: Sheet Options
Sheet Navigation
Hide & Unhide
Tab Colour
Simple Sheet Protection Protection
Move and/or Copy Sheets
Grouping Sheets

Module 9: Named Cell Ranges
Name a Cell
Name a Range
The Name Manager

Module 10: Format As Table
Introduction to Tables
Creating a Table
Table Tools & Style Options
Add/Delete Data in a Table
Slicers in a Table
Basic Formula in a Table
Converting a Table Back to a Data Range

Module 11: LookUp Functions
Introduction to LOOKUPS
Simple VLOOKUP
VLOOKUP between 2 Sheets
VLOOKUP between 2 Workbooks
HLOOKUP
Introduction to XLOOKUP Functions
XLOOKUP with an Exact Match
XLOOKUP with an Approximate Match
XLOOKUP Additional Options
The Match Function
The Index Formula

Module 12: Text Functions
Concat (Concatenate)
Trim & Clean
Text Join
Case: Upper, Lower, Proper

Module 13: Data Tools
Flash Fill
Text to Columns
Remove Duplicates
Data Validation
Consolidate
Goal Seek
Scenarios
Data Table
Forecast Sheet

Module 14: Protection
Protect Sheet
Protect Workbook
Allow Editable Ranges
Sharing Workbooks

Module 15: Page Layouts & Advanced Printing
Themes
Margins & Paper Size
Print Titles
Print Areas
Other Print Options
Backgrounds

Module 15: Page Layouts & Advanced Printing
Themes
Margins & Scale
Print Areas
Print Titles
Other Print Options
Backgrounds

Module 16: Date Functions
Today & Now
Weekday, Weeknum
Networkdays
Day, Month & Year
Add Month & EOMonth (end of)

Module 17: IF Functions
Simple IF Statements
Nested IF Statements
IF AND Statements
COUNTIF & SUMIF
AVERAGE IF
SUM IFS, COUNT IFS & AVERAGE IFS
MAX IFS & MIN IFS

Module 18: Pivot Table
What is a Pivot Table
Creating a Pivot Table Recommended Command
Creating a Pivot Table Manually
Calculations in a Pivot Table
Formatting a Pivot Table
Pivot Table Options
Default Layouts for Pivot Tables
Refreshing a Pivot Table
Drill Down
Editing Source Data
Using Tables as Data Sources
Inserting Slicers
Formatting Slicers
Slicer Connections
Inserting a Timeline
Creating a Pivot Chart
Formatting a Pivot Chat

Module 19: Inserting Objects
Inserting a Sparkline
Edit a Sparkline
Group & Ungroup Sparklines
Sparkline Axis Options
Deleting a Sparkline
Hyperlinks
Comments & Notes
Text Boxes

Module 20: Formula Auditing & Calculation Options
Place, Precedence & Dependence
Show Formulas
The Watch Window
Calculation Options

Module 21: Macros
Recording a Macro
Run a Macro
Assign a Macro to an Icon
Absolute & Relative Macros
Deleting a Macro
Where to Save a Macro
Opening the Developer Tab
Running a Macro in Another Workbook
Copying a Macro Between Workbooks
Creating a Macro Workbook
Assign a Macro to a Control Button
Custom Tabs & Ribbons
Macro Security

Module 22: Advanced Charts
More Types of Charts
Map Charts
Quick Layouts
Add a Chart Element
Chart Styles
Selecting Multiple Ranges within Charts
Showing Filters in a Chart
Format Parts of a Chart
Advanced Axes Options
Creating a Secondary Axis
Adding a Trendline
Saving a Chart as a Template
Pie & Line Charts
Changing Chart Type for one Series
Charting with Negative Values

Module 23: Dashboards
Mini Charts
The Camera Tool
The Traffic Light Example
Spin Controls With Dates

Module 1: Introduction to Outlook
Opening Outlook
The Outlook Interface

Module 2: Email
Creating An Email
Attaching Files To An Email
Email Options
Reading An Email
Opening And Saving Attachments
Replying And Forwarding An Email
More Mail Options
Creating A Signature
Working with your emails
Deleting Emails
Sorting Your Email
Creating An Email Folder
Moving Emails From Your Inbox
Junk Email Options
Clutter Folder

Module 3: Contacts, tasks and other options
Practice Files
Contacts
Creating A Contact
Sending An Email To A Contact
Editing And Deleting An Existing Contact
Forwarding A Contact
Creating A New Contact Group
To do list
Create A Task
Marking An Email For A Follow Up
Viewing Tasks From Email Section
Options
Out Of Office
Printing

Module 1: Introduction to PowerPoint
Opening PowerPoint
Tabs And Ribbons
Quick Access Toolbar
Saving A Presentation
Closing And Exiting
Using A Built-In Template

Module 2: Inserting objects
Practice Files
working with smart art
Using SmartArt
Inserting SmartArt – Example 1
Inserting SmartArt – Example 2
Inserting SmartArt – Example 3 With Pictures
Convert Text To SmartArt
Convert SmartArtBack To Text
working with pictures
Insert A Picture Onto A Slide
Moving And Resizing A Picture
Cropping A Picture
Picture Styles
Picture Adjustments
Removing A Background
Photo Albums
working with charts
Insert A Chart And Chart Data
Moving And Resizing A Chart
Changing The Chart Type
Edit The Data
Switch Row And Column Option
Chart Elements, Styles And Filters
video & sound
Inserting a Sound File
Inserting a Video File
Editing the Video File

Module 3: Transitions & Animations
Practice Files
Transitions & Animations
Applying A Transition Effect
Transition Effect Options
Types Of Animations
Applying An Animation To An Object
Applying More Than One Animation To An Object
Applying Animation To A SmartArt Graphic
Applying Animation To A Chart

Module 3: Slide Design
Applying A Theme
Format The Background Only
Save A Current Theme
Slide Master
What Is A Master Slide?
Editing The Master Slide
Insert New Master Slide

Module 4: Running & Presenting a Slide Show
Practice Files
set up a slide show
Running A Slide Show
Custom Shows
Hide And Unhide Slides
Rehearse Timings
Set Up Show Options
Recording A Show
Shortcuts To Use When Presenting
presenting
Printing A Slide Show
Running A Slide Show
Saving Options

Module 5: Reviewing & printing
Practice Files
Review
Proofing A Presentation
Comments
Compare Presentations
Saving & printing

Module 6: Saving Options
Sharing A Presentation
Printing A Slide Show
Save As A Template
Export Options

Module 1: Opening Word

Opening The Word Application
Opening A New Word Document
Tour Of The Word Screen
Saving And Closing A Word Document
Difference Between Save And Save As
Opening An Existing Document
Customising The Quick Access Toolbar
Exiting The Word Application

Module 2: Working with text
Practice Files
Working with text
Inserting Text
Highlighting Text
Deleting Text
Cut, Copy And Paste Options
Formatting Text
Text Alignment
Line And Paragraph Spacing
Indents
Basic Bullets And Numbering
Find And Replace Options
Basic Styles

Module 3: Working with pictures
Practice Files
Working with Pictures
Inserting & Deleting A Picture
Resizing A Picture
Wrap Text Options
Formatting Options
Crop a Picture

Module 4: Working with tables
Practice Files
Working With Tables
Insert And Delete A Table
Insert And Delete Rows And Columns
Merge Cells
Split Cells
Format Cells
Table Properties

Module 5: Inserting Other Objects
Practice Files
Insterting other objects
Inserting Shapes
Inserting A Comment
Inserting A Hyperlink
Inserting an Icon
Inserting A Text Box
Inserting Word Art

Module 6: Design Options
Practice Files
Design Options
Applying A Theme
Changing The Themes Colours And Fonts
Inserting A Watermark
Changing The Page Colour
Applying Page Borders

Module 7: Basic Mail Merge
Practice Files
Basic Mail Merge
Create A Letter
Create A Mailing List
Merge The Letter And The Mailing List
Saving The Files

Module 8: Page Layout Options
Practice Files
Page Layout options
Margin Settings
Orientation Settings
Paper Size
Inserting Page Breaks
Using Hyphenation
Basic Headers And Footers
Print Preview And Print Options

Module 9: Reviewing A Word Document
Practice Files
Reviewing a Word Document
Spelling And Grammar Options
Thesaurus
Word Count

Module 10: Window Options
Practice Files
Window Options
Different Views Available In Word
Showing Ruler And Gridlines
Viewing Multiple Pages At Once

Module 11: Saving & Help
Practice Files
Saving & Help
Saving a Word Document
Saving as a PDF
Opening a PDF in Word

Module 12: Advanced Formats
Practice Files
Advanced Formats
Advanced Formatting Options for Text
Outline Lists for Bullets and Numbers
Advanced Paste Options
Define a New Outline List
Line and Page Break Options
Using the Format Painter

Module 13: Sections
Practice Files
Sections
Column Breaks
Section Breaks
Sections when using Headers and Footers

Module 7: Basic Mail Merge
Practice Files
Basic Mail Merge
Create A Letter
Create A Mailing List
Merge The Letter And The Mailing List
Saving The Files

Module 8: Page Layout Options
Practice Files
Page Layout options
Margin Settings
Orientation Settings
Paper Size
Inserting Page Breaks
Using Hyphenation
Basic Headers And Footers
Print Preview And Print Options

Module 9: Reviewing A Word Document
Practice Files
Reviewing a Word Document
Spelling And Grammar Options
Thesaurus
Word Count

Module 10: Window Options
Practice Files
Window Options
Different Views Available In Word
Showing Ruler And Gridlines
Viewing Multiple Pages At Once

Module 11: Saving & Help
Practice Files
Saving & Help
Saving a Word Document
Saving as a PDF
Opening a PDF in Word

Module 12: Advanced Formats
Practice Files
Advanced Formats
Advanced Formatting Options for Text
Outline Lists for Bullets and Numbers
Advanced Paste Options
Define a New Outline List
Line and Page Break Options
Using the Format Painter

Module 13: Sections
Practice Files
Sections
Column Breaks
Section Breaks
Sections when using Headers and Footers

Module 14: Styles & Templates
Practice Files
Styles & Templates
Different Types of Styles
Create a Style
Apply a Style
Modify an Existing Style
The Style Panel Options
Using Cover Pages

Module 15: Inserting Objects
Practice Files
Inserting Objects
Inserting Smart Art
Inserting Charts
Wikipedia and Other Store Apps
Inserting Online Videos
Using Quick Parts
Inserting Date and Time Options
Inserting Symbols
Inserting a ScreenShot
Introduction to 3D Models
Add from Files Option

Module 16: Using References
Practice Files
Using References
Inserting a Table of Contents
Modifying and Updating a Table of Contents
Inserting Footnotes and Endnotes
Creating Citations
Inserting a Bibliography
Manage Citation Sources Between Documents
Captions and Table of Figures
Index Entries and Cross References
Inserting an Index
Inserting a Table of Authorities

Module 17: Advanced Mail Merge
Practice Files
Advanced Mail Merge
Creating Envelopes and Labels
Mail Merge Advanced Options
Turning on Track Changes
Accepting and Rejecting Changes
Comparing Word Documents
Protecting a Document
Inking Within a Document

Module 18: Forms
Practice Files
Forms
Inserting Form Fields
Restrict Editing
Section Five: Forms
Quiz: Forms
Section Six: Macros
Practice Files
Macros
Recording and Storing a Macro
Running a Macro
Assigning Macro to an Icon
Editing a Macro

Module 19: Templates
Practice Files
Templates
Creating a Template
Using a Template

Module 1: Introduction to Power Bi
Introduction to Power BI
Power BI Desktop Interface
Updating Power BI

Getting started
Opening PowerBI
Importing Data from different sources
Create a simple PowerBI Report

Module 2: Working with data
Get Data
Row Options
Column Options
Fill Down Option
Data Types
Create a Calculated Column
Load the Data
Manually Create a Data Set
Extra Home Tab Options
Extra Transform Tab Options
Append Queries
Merge Queries

Module 3: Data Modeling
Calculated Column in DAX
Measures in DAX
Create Additional Tables in DAX

Module 4: Managing Relationships
Creating Relationships
Visualizing Related Data

Module 5: Publishing and Sharing Reports
Publishing and Sharing Reports
Download and Install Reports
Quiz: Publishing and sharing reports

Module 6: Report Pages
Managing our Report Pages

Module 7: Setting Page View Options
Setting Page View

Module 8: Creating Visualisations
Overview of Visualisations
General Properties
Bar & Column Charts
Line Charts
Table
Matrix
Card
Treemap
Gauge
KPIs

Module 9: Creating slicers
Creating Slicers

Module 10: Arranging Visualisations
Arranging Visualisations
Quiz: Arranging Visualisations

Module 11 Maps
Maps