How to insert symbols

Multi-level List

Step by Step Mail Merge Wizard

Select and Edit Recipients List

Envelopes and Labels

Hyperlink and Bookmark

Insert a SmartArt Graphics and Charts

Selection Pane

Thesaurus, Word Count, Translate and Language

How to create a cover page

Insert date and Time

Take a Screenshot

Arrangement of Objects

Introduction to Excel

Saving Workbook and Adding / Deleting Renaming Worksheets

Basic calculations : Sum, Product, Factorial, Square Root, Average, Max, Min, Mode & Median

Basic functions like Count, Counta & Count Blank, Upper, Lower, Subtotal

Data Sorting

Format Painter

Text to Column, Text Formatting

Filter, Rand Function

Average and AverageA

Count, Counta and Countblank

How to insert and delete a cell, row and column from a worksheet

Round, Roundup, Rounddown

Date & Time Functions like Date, Day, Month, Year, Today, Hour, Minute, Second

Charts

Multicategory Chart

Static Transpose

Find Depreciation of an Asset

Logical Functions like IF, IF-Else

Text Functions like Find, Replace, Len, Right, Left, MID, Proper, Text, Trim

Lookup

Subtotal Function

Rank Function

Rand and Randbetween

Sumproduct

Choose

Format as table

Conditional formatting

Page setup & Print

Freeze Panes

Date & Time Functions like Edate, Now, Eomonth, Workday, Weekday,

Error Handling with ISBLANK, ISTEXT, ISERROR, ISNUMBER, IFERROR functions

Introduction to PowerPoint

Create a presentation

Slide Setup

Save a presentation

Choose a slide design

Text Formatting in Slides (Change in font, change in font size and change in text color)

Text Alignment in Slides

Background formatting in slides

Working with Text box

Insert Pictures

Draw a shapes

Add Symbols

Working with Tables

Change Text Direction

Insert a Smartart & Chart

Text formatting through WordArt

Different types of Slide Layout

Create a Photo Album

Insert a Screenshot

Adding Audio and Video to your Presentation

Transitions and Animations

Create custom slideshow of slides

Date and Time & Slide Number

Different views in PowerPoint( Normal, Outline view, Slides Sorter, Notes Pages, Reading View)

MS Word- Format documents efficiently in MS Word.

MS Word- Preparations of document

MS Word- Create Registration & Application Form

MS Excel - Create and manage Spreadsheet Layouts

MS Excel- Increase your efficiency by creating and using important Excel shortcuts

MS Excel- Create Salary Slip of an Employee

MS PowerPoint- Apply Charts, Graphs & Tables to your PowerPoint Presentation