Course in Microsoft EXCEL - Advanced

Radhika EduWorld
In Pune

Price on request
Compare this course with other similar courses
See all

Important information

  • Course
  • Pune
  • Duration:
    1 Day

Important information

Where and when

Starts Location
On request
Office 206 C-3 Wing, Bramha Majestic, NIBM Road, Kondhwa , 411048, Maharashtra, India
See map

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

Compare this course with other similar courses
See all