excel 2007 Tutor (In Eng - Hindi - Tamil )

excel 2007 Tutor - In Eng - Hindi - Tamil
On screen tutor
-----------------------------------------------------------------
• Best Free
tutorial (India & International)
• Basic to Intermediate training
• Hands on examples
•
4-5 hrs Very high quality Audio Video lessons ( Crystal Clear Quality )
• Step by step explanation
• Application shortcut keys
_____________________________________________
MS excel 2007 - Contents
Chapter -1
Introduction & starting of excel
Understand workbook & worksheet
Understand Rows, columns,
Understand Cells & formula bars
Data entering, Boarding,
coloring merging in cells
Number formats
Chapter-2
Filling the series
Sum in excel, auto sum
using formula bar & formula menu
Chapter-3
Copy -paste ,Cut -paste
Using Undo-redo in cells
GOTO and FIND operation
FIND and REPLACE of text
Add, Delete- row and column
Chapter-4
Format cell
Formatting a table
Hide, unhide
rows and columns
Rename , add a
sheet in work book
Apply background image in worksheet
Chapter-5
Inserting a chart
Formatting a chart
conditional formatting
Chapter-6
Create new workbook
Saving a workbook
Open an existing workbook
Page layout menu
Chapter-7
Protect the worksheet
Protect the workbook
Unprotect the worksheet
Unprotect the work book
Chapter-8
Shorting data
Auto Filter data
Advance filtering
Chapter -9
Inserting & editing
pic in worksheet
Inserting clipart in worksheet
Inserting & editing
on command in cells
hyperlink in excel
Chapter- 10
Goal seek & Scenario manager
Spelling correction in excel
Auto correction option
Formula audition
Macros in excel & with example
Chapter -11
Subtotal
Pivot table and chart
Data validation
Exercises (do it with it )
Chapter -12
How to calculate mark sheet
Chapter -13
Data entering of consumer
Chapter -14
Draw a chart - data entered of consumer
Chapter-15
Profit sharing