LearnExcel2007 हिंदी-Eng-தமிழ் 정보
Learn excel2007 in Hindi - English -Tamil4-5 Hrs FREE video TUROR
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