AK Dixit

Below skills set you can develop in 10 hrs time.

Introduction of an Excel spreadsheet:
o Components of an Excel spreadsheet
o Task panes
o Creating, Printing, Entering, modifying data in a cell & range, Undoing cell entry, entering numbers, text, dates or times, Formatting, Column, rows & worksheet.

Performing Calculations:
o Entering formulae
o Selecting cells and moving around worksheet
o Reference operators
o Editing a formula
o Creating and applying names
o Copying formulae to adjacent cells
o Using absolute and relative references
o Adding a column of numbers using AutoSum
o Insert function
o Copying formulae and values
o Excel arrays
o Working with Time in Excel and Calculations using Time
o Useful Time and Date Functions
Visualizing and Presenting Data:
1. The different types of data variable
2. Tables
o What a table looks like
o Creating frequency distribution
o Types of data
o Creating a table using Excel Pivot Table
o Principles of table construction
3. Graphical representation of data
o Bar charts
o Pie charts
o Histograms
o Histograms with unequal class intervals
o Frequency polygon
o Scatter and time series plots
o Superimposing two sets of data onto one graph
LOOKUPS
o VLOOKUP: Syntax And Usage
o VLOOKUP In Live Action
o HLOOKUP: Variation On A Theme
o Using A Near Match In The Lookup
o Dealing With Missing Data In A Lookup
PivotTables : Creating Changing the formatting your own Pivot Tables.