Everyone

EDUTREE

KitKat

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

excel 2007 Tutor (In Eng - Hindi - Tamil )

excel 2007 Tutor (In Eng - Hindi - Tamil ) ਦਾ ਨਵਾਂ ਵਰਜਨ

ਹੋਰ ਵਰਜਨ