MS Excel Training – Basic

 

Methodology – Online Live Demonstrative Training

Course Fees – Rs. 4000 Per Participants (Discount of Rs. 1000 on two enrollments)

Duration of Program – 08 hours 

Objective of the program

This training program intends to:

• Improve participant’s efficiency in working with worksheets
• Improve participant’s skills on Analyzing data
• Creating MIS reports

Who should attend? 

Anyone who wants to enhance their productivity of day to day work & desirous to enhance their Basic MS Excel skills.

Outcome of the training 

Upon successful completion of this training, you will be able to:

• Using various Excel functions
• Beautifying Excel Sheets
• Performing complex calculations efficiently
• Organizing and analyzing large data
• Creating MIS reports

Training Outline

1) Functions

 a)  Basic:

Text to columns, Remove Duplicates, Flash fill

b) Text:

Upper, Lower, Proper, Left, Right, Mid, Len, Trim, Concatenate

c) Date:

Today, Now, Day, Month, Year, Minute, Hour, Second, Text

d) References:

Relative, Absolute, Hybrid

e) Mathematical:

Min, Max, Average, Count, Count if, Count ifs, Sum, Sum if, Sum ifs, Sum product, consolidate

2) Graphs/Charts

1. Inserting Graphs
2. When to choose what type of Graph
3. Formatting, coloring, Giving impressive finishing looks
4. presenting in images with 3D effects

3) Formatting

applying various formatting option to make the sheets presentable

4) Data sorting and Filters & Advanced Filters

5) Conditional Formatting

1. Conditional Formatting to Highlight values
2. Highlighting mistakes like duplicate entries
3. criteria based formatting
4. Create, Edit and Manage rules

6) Working with Reports (Subtotal)

1. Creating Single Level Subtotal
2. Creating Multi level subtotal with grouping and ungrouping options

7) WhatIf Analysis

1. Goal Seek
2. Data Tables
3. Scenario Manager