Course in Microsoft EXCEL - Advanced
Course
In Pune
Description
-
Type
Course
-
Location
Pune
-
Duration
1 Day
Facilities
Location
Start date
Start date
Reviews
Course programme
This institute organized the program MS Excel Advanced program for experts who already have a working knowledge of MS Excel and who would like to discover the characteristics of MS Excel to get better their effectiveness and output at work.
This program is suitable for those who want to acquire the knowledge of MS Excel, but now feels the needs for learning feature & optional of Excel, to managed their worksheet relate task more efficiently using advance functions in Excel & working with Excel VBA
Those who have good working knowledge of MS Excel can acquire this program, they should know the formula, referencing cell, and introduction to condition format, sortings, filtering datas etc.
Program Content includes:
a. Reviews of Formula & Function
· Carry out complexes calculation using different excel function
· Analyze data
· Automated process to speeds up routine works
b. Reviews of Chart
c. Lookup & Reference function (V lookup , Index & Match Functions)
· Condition Logics such as:
· The IF Functions
· Condition Format
· Count IF
· Sum IF
d. Process Data in EXCEL 2007 covers subjects such as:
· Data Table in Excel 2007
· Excel 2007 Scenario
· Goal Seeks
· Pivot Table
e. Recording Macro
f. Introduction to VBA Editors
g. Other Advanced Feature such as:
· Quick Access Toolbar in Excel 2007
· Data Form
· Drop Down List in Excel 2007
· Add your own Error Message
· Hyperlink in Excel 2007
· Object linking and embedding
· Insert Drawing Object
Course in Microsoft EXCEL - Advanced