MS Excel full Training Course |MS Excel Advanced training Classes

MS Excel - Full course

Price Per Session
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-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.

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

Who Should Attend
  • Users with a basic knowledge of Excel
Course Outcomes
  • It prepares you for a successful career
  • You will be able to Understand Excel Abilities and its Functions
  • Breaks even the most complex applications down into simplistic steps
  • Ability to set up dynamic & interactive charts
  • Involves working on live projects
  • You will be comfortable with many of the advanced features and functions that this powerful spreadsheet software from Microsoft has to offer.
  • Ability to handle advanced tasks in Excel, 
  • Able to get more power out of your worksheets 


Pre-Requisites
  • Basic computer knowledge 
  • MS Office installed in their Computer System
No schedule yet.
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
`