MS Excel full Training Course |MS Excel Advanced training Classes

MS Excel - Full course

Category : IT & Software » MS Office

Overview : Are you looking for clear explanations that help you master many Excel features ?Advanced Excel Tricks That Will Help You Get An Instant Raise At Work. Now a days, many jobs require advanced Excel skills. Naturally, you are interested to know what are these Advanced Excel Skills?Microsoft Excel is a spreadsheet programme which enables millions of people worldwide to ease their manual work of calculation.

  • Request A
    New Time
  • FrequencyThrice a week
  • LevelAdvanced
  • Duration1 Month
    • Fun Quotient (35%)
    • Learn Quotient (65%)
Sign Up Free Demo call us at +91-9592-700-274
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.

Advanced Excel users know how to structure & present their data so that it looks impressive. Good understanding of Excel features like tables, cell styles, formatting options is necessary to make awesome Excel workbooks.

Content of Course

Getting Started with Excel

·         Starting Excel

·         Navigating within the Worksheet

·         Selecting a Cell or Range of Cells

·         Entering Data

·         Entering Cell Contents

·         Cutting, Copying, and Pasting Cell Values            

·         Copy and Paste Special

·         Saving your Workbook

·         Opening your Workbook


Managing Rows & Columns

·         Inserting, Moving & Deleting Cells

·         Managing Columns and Rows

·         Hide and Unhide Rows/Columns

·         Changing Column Width & Row Height


Managing Worksheets

·         Format Worksheet Tabs

·         Insert and Delete Worksheet

·         Move and Copy Worksheet

·         Hide & Unhide Worksheet


Formatting the Cell

·         Formatting the Cell

·         Number and Date Formatting

·         Finding and Replacing Text

·         Working with Styles


Working with Formulas and Functions

·         Excel Arithmetic Operators & Order of Operations

·         Using AutoFill Options

·         Using Commonly Used Functions

·         Using SUMIF() and COUNTIF():

·         Adding and counting only the cell you specify


Organizing Worksheet and Table Data

·         Create and Modify Tables

·         Sorting and Filtering Data in a Table

·         Getting Summary Information in a Table


Working with Chart

·         Summarizing Data Visually Using Charts

·         Customizing Chart Data

·         Format Chart Legend and Titles

·         Change the Chart Body

·         Saving the Chart as a Template

·         Creating a Pie Chart


Working with Graphics

·         Adding Pictures into a Worksheet

·         Customizing Pictures and Objects

·         Adding Drawing Objects into a Worksheet

·         Adding Smart Art into a Worksheet

·         Adding Clip Art into a Worksheet


Managing Large Workbook

·         Managing Large Workbooks

·         Printing Worksheets

·         Setting Page Setup Options

·         Setting Page Breaks


Customizing & Enhancing Workbooks

·         Customizing Excel to the Way You Work

·         Creating Hyperlinks

·         Working with Workbook Themes

·         Working with Templates

Look Up functions

Vlook up

H Lookup

Using a near match in lookup

Lookups nested within Lookups

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 dropdown 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 Power Point Training