Learn Advanced - Microsoft Excel for Professionals!

Overview : Are you looking for clear explanations that help you master many Excel features ? Advanced Excel users know how to Structure, Analyze & Present their data so that it looks impressive & meaningful. Good understanding of Excel features like Tables, Cell styles, Advanced Formatting options is necessary to make awesome Excel workbooks!

Course Description and Objective

Formulas make Excel smart. Excel is not just
a data keeping tool. By using formulas, you can crunch data, analyze it and get
answers to most complex questions.

Content of Course

Basic Excel skills will be brushed up in
initial sessions to understand your present level

Pivot Tables, Charts and reporting

Pivot tables & pivot reporting allows us
to analyze massive amounts of data & answer questions with just a few
clicks. With Pivot tables you can extract the significance / desired result
from a large data. This topic will cover:-

By using conditional formatting, you can tell
Excel to highlight portions of your data that meet any given condition. Good
understanding of Excel features like tables, cell styles, formatting options is
necessary to make awesome Excel workbooks.

• Using
Conditional Formatting with multiple cell rules

• Using
color scales and icon sets in Conditional formatting

• Create
a drop down list and Sheet protection

• Link
Between Different Work books and sheets

Advanced Formulas and Functions

Excel provides an enormous number of
established formulas and assistance in auditing and calculating your data.

•Lookup
(Vlookup) and Reference functions

• Logical
and data base functions

• Date
and time functions

• Statistical
functions

Data Sorting, filtering and Analyzing Data

Using the Filter and Sort function is a quick
and simple way to organize your information.

• Sorting
Data by Values, Colors etc

• Advanced
Filtering Options

• Create
and manage Scenarios and Summaries

• Define
and use cells names

Class Delivery:

• Live
Interactive session with teacher on webcam

• Take
feedback from your teacher during & after the class

• Excel
will be taught through screen sharing with live question answer sessions