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