Course in Microsoft EXCEL - Advanced

Course

In Pune

Price on request

Description

  • Type

    Course

  • Location

    Pune

  • Duration

    1 Day

Facilities

Location

Start date

Pune (Mahārāshtra)
See map
Office 206 C-3 Wing, Bramha Majestic, NIBM Road, Kondhwa , 411048

Start date

On request

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

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

Price on request