1. MS Word 

Introduction

Grammar and Spell Checker Vocabulary of Word

Smartly Use Auto Correct for Auto Typing

Creating Mail Merge Connecting Word with Excel

Configuring Gmail Account on Outlook for Mail Merge

Send Individual Emails to Persons

Letter Formatting and Word Spacing

Working on Non-Printing Characters on Word Document

Line Spacing Settings on Word

Save as Types in Microsoft Word

Manage Multiple Documents with Split and View Options

Amazing Short Keys of Word Part 1

2. MS Word Training - Part 2

Amazing Short Keys of Word

Find and Replace Options

Formatting Techniques

Using Style Function to Format with Navigation

Selection Techniques in Microsoft Word

Working with Tabs for Auto Spacing

Dealing with Bullets and Numbers

Sorting Data in MS Word

Demote and Promote Functions in Word

Creating and Working on Tables in MS Word

Insert and Deleting Rows and Columns in a Table

Tables Layout and Design

Creating Custom Design in Tables

Sorting Data in a Table

Creating a Custom Table

Saving Custom Table Templates in Word

Converting Raw Text to a Table

Inserting Formulas to Tables

Inserting Hard Page Breaks in Document

Column Breaks in Word

Columns Break Settings

4. MS Word Training - Part 4

Inserting Watermarks

Applying Page Borders

Headers and Footers

Working with Pictures

5. Microsoft Excel Training - Part 1

Fill Dilig

Fill Series

Editing Custom List

Excel Short Keys & Golden Key

Introduction to Absolute & Relative References (Fixed & Variable)

The Marksheet

Random Number Generation

Clearing Formula with Intact Values

Key Components of Marksheet

6. Microsoft Excel Training - Part 2

Introduction to IF-Then Conditions

Nested IFs (Looping Function)

Ranking Positions

Conditional Formatting & Data Bars

Freeze Panes

Table Formatting & Range Conversion

Sort & Filters

Max, Min, Average, CountBlank, CountIf, and Much More

7. Microsoft Excel Training - Part 3

Prepare a Sales and Bonus Report with Manual Totaling

Grouping and Auto Totaling

Hiding and Unhiding Rows, Grouping and Auto Totaling

Removing Duplicates and Sales Summary with SumIf Function

Understanding Absolute and Relative Referencing

Applying SumIf with Absolute and Relative Referencing

SumIf with External Sheet References

8. Microsoft Excel Training - Part 4

IF Conditions with Multiple Logics

Introduction to Aged Debtors Analysis

Arranging the Data to Get Started

Automate Data Arrangement

Quick Trick Formatting

Conditional Formatting Advanced

9. Microsoft Excel Training - Part 5

Applying Advanced Formatting Tricks

Formula Analysis for Aging

Absolute, Relative Functions & Date Values

Live Aging

Introduction to VLOOKUP

Using Named Ranges and IFERROR

Simplifying Even More with Data Validation

10. Microsoft Excel Training - Part 6

Combo Boxes

Using Combo Boxes

The HLOOKUP Function

Lookup for Inverse Data

Introduction to Index Match

Quiz Assignment Remington Pharma Explanation

Invoicing System Remington Pharmaceuticals

SumIf and IFS

11. Microsoft Excel Training - Part 7

Forget Filters - Use DSUM Search Box

Amazing Advanced Filters & Macros

Introduction to Pivot Tables

Grouping in Pivot Tables

Calculated Fields

12. Microsoft Excel Training - Part 8

Pivot Charts

Dashboard Reporting

Automated Cheque Printing System (Using Mail Merge)

Introduction to Hyperlinks

Hyperlinks with External Sheet References

Columns Separation & Concatenation

13. Microsoft Excel Training - Part 9

Excel Flash Fill Saves the Day

Creating Blank Presentation and PowerPoint Interface

14. Microsoft PowerPoint Training - Part 1

Inserting New Slides and Working with Layouts

Changing Layout and Arrangement of Slides

Designing Slides in PowerPoint

Inserting and Customizing Pictures in PowerPoint

Logo Insert in Presentation and Online Images

Use Smart Art to Enhance Graphical Look of Presentation

15. Microsoft PowerPoint Training - Part 2

Using Charts in PowerPoint Presentations

Inserting Audio to Your Slides

Introduction and Configure Gmail on Outlook

16. Microsoft Outlook Training - Part 1

Understanding Microsoft Outlook Interface

Using Calendar Feature for Appointments and Meetings

Sending Meeting Invites to Attendees

Using Auto Correct Function to Automate Email Typing

Using Quick Access Toolbar

17. Microsoft Outlook Training - Part 2

Use of Voting Buttons

Enable Blind Carbon Copy

Change Reply to Address in Outlook

Using Search Folders for Email Management

Inserting Signature in Outlook

Adding Calendar to Email

Working in Offline Mode

Delay Delivery

18. Microsoft Outlook Training - Part 3

Insert Attachments and Pictures in Email

Send Emails to Multiple Recipients

Creating and Managing Folders in Outlook

Creating Rules for Managing Emails

Managing Emails by Color Categories

How to Add Contacts in Outlook

Managing and Importing Contacts in Outlook

Congratulations on Completion of Outlook