Learn Advanced Microsoft Excel Course with excel Classes

Learn Advanced - Microsoft Excel for Professionals!

Category : IT & Software » MS Office

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!

  • Request A
    New Time
  • FrequencyTwice a week
  • LevelAdvanced
  • Duration1 Month
    • Fun Quotient (30%)
    • Learn Quotient (70%)
Sign Up Free Demo call us at +91-9569-101-102
Course Description and Objective

Overview

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:-

•           Creating Pivot charts & tables

•           Using pivot tables & charts

•           Formatting Pivot Table and making dynamic pivot Charts

•           Grouping, 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.

•           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


No reviews yet.
No questions yet.

Similar Classes
MS Excel - Basic & Intermediate
Rs. 5000 Rs. 4000


0 Reviews
Learn Excel VBA Macros
MS Excel - Full course
MS Power Point Training
`