http://www.careerfactory.in/register
Module 1 : Excel Basics

Cell, Column, Row, Worksheet and Workbook.
Sum & Sumif
Average Max and Min
Basic Operator (+ - / *^)
Greater than, equal to or less than 
(< = >)
Round , Roundup and Round down
Sorting and filtering data
If and Else
Conditional Formatting
Vlookup
True & False

http://www.careerfactory.in/register
Module 2 : Data Handling - I

Data Validation
Grouping, Ungrouping and Subtotals
Filters, Custom Filters, Advanced Filters & List Type
Pivot Tables & Merge pivots from multiple locations
Goal Seek
Consolidate data From multiple files
Split Data using Text to Columns
Remove Duplicates
Watch Window
Data Recovery

Module 3 : Data Handling - II

Importing Data from another location or file.
Sort Data on single & multiple criteria.
Protect Excel Files, Workbook, 
Protect Worksheet and Cells
Find Replace Blank Cells
Format Painter
Hyperlinks
Naming a Range
, Cell etc.

Module 4 : Advance Excel

a) Text Functions
LEFT,RIGHT,MID & TRIM
PROPER, UPPER, LOWER, Clean…..etc.
FIND & REPLACE
Exact

b. Date and Time Functions
Day
Days360
Now
Today

Time…etc.

c. Mathematical Functions
SumIFS
Even
Combine
ODD
Product
RAND
RANDBETWEEN

d. Statistical Functions
Len
Count
Count A
CountIF, CountIFS
Count Blank
Rank
Average, Average IF & Average IFS
Subtotal Sign
e) Logical Informatics Functions
Cell
ISERROR
ISNA
INFO...etc.
Formula editing mode.
Show Formula
Error Checking
Calculations Options
And & OR
IF & Nested IF
IF Error , Is Error & ISNA
Multiple IF Conditions
IF….Vlookup….Match
IF…Hlookup….Match
CONCATENATE & “&”.

f) Look Up & Reference Functions
Lookup & H-lookup
Address
Choose
INDEX
MATCH
Rows
Transpose…etc.
https://bit.ly/xlhrmhttp://www.careerfactory.in/jobshttp://www.careerfactory.in/register