LearnExcel2007 हिंदी-Eng-தமிழ்

This app is for- Learning excel2007in Hindi - English -Tamil

www.edu-tree.com

-------------------------------------------------------------------------------------------

Main features of this course

-4-5hrs on line training

-Very high quality Videos & Audios

-Hands on examples

-15 lessons covers step by step explanation

----------------------------------------------------------------------------------------

Excel2007 in Hindi - English -Tamil 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