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