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:-
Pivot charts & tables
pivot tables & charts
Pivot Table and making dynamic pivot Charts
slicers, calculations & summary by different type of metrics.
Conditional Formatting and making reports
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.
Conditional Formatting with multiple cell rules
color scales and icon sets in Conditional formatting
a drop down list and Sheet protection
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.
(Vlookup) and Reference functions
and data base functions
and time functions
Data Sorting, filtering and Analyzing Data
Using the Filter and Sort function is a quick
and simple way to organize your information.
Data by Values, Colors etc
and manage Scenarios and Summaries
and use cells names
Interactive session with teacher on webcam
feedback from your teacher during & after the class
will be taught through screen sharing with live question answer sessions