Analytics Using Advanced Excel

Course Objective

To enable learners explore and understand the inbuilt tools & functions available in microsoft excel 2010/2013.

Learning Outcomes

The learner shall be able to apply various formatting techniques, data manipulation methods and summarize large sets of data

Course Description

Download Brochure

We shall take the student through the course of study which will include all advanced topics in microsoft excel. Topics such as Pivot Tables, Functions, Conditional Formatting, Data Validation, Solver, Charts etc. shall be covered in detail. Apart from the regular course work we also make students to go through case studies and examples taken real-time work environment.


Formatting is Fun
  • Arithmetic Operations using Paste Special
  • Conditional Formatting
Data Management Tools
  • Sorting
  • Auto Filter & Advanced Filter
  • Text to Columns
  • Data Validation
  • Remove Duplicate
  • Subtotal
Encounter with Excel Functions
  • Cell Referencing
  • Name Ranges
  • Mathematical - Sum, average, subtotal, min, max, count, counta, sumproduct, ceiling
  • Text functions - concatenate, lookup, lower, upper, proper, trim, find, right, left, middle
  • Lookup functions - vlookup, hlookup, lookup, match, index, offset
  • Conditional Formulas - sumif, sumifs, countif, countifs, averageif, averageifs
  • Logical functions - if, or, and, iserror, isnontext, isnumber
  • Magic of Array formulas
  • Tracing Formulas
  • Dynamic Ranges
Summarizing Data
  • Pivot Tables - Rows, Columns, Report Filter
  • Pivot Tables - Values & their summary
  • Pivot Tables - Calculated Fields & Items
  • Pivot Charts
  • Slicers
Visual Representation of Data
  • Column Charts
  • Bar Charts
  • Pie Charts
  • Doughnut Charts
  • Line Charts
  • Area Charts
  • Dynamic Charts (Speedometer, Control Chart, Pareto Charts, etc.)
Optimization Tools in Excel
  • Goal Seek
  • Solver (Optimization Problems)

Course Extract

  Level Intermediate
    Methodology Online / Offline / Self Learning
    Duration 10 hrs
    Price ₹ 9999 – Offline
₹ 6999 - Online
₹ 4999 - Self Learning
  Pre-requisites None
  Batch size 10-15 students
  Classes On Weekend / Sunday
  Certificate Yes
  Placement Assistance Yes

We're ready to listen...

* Indicates a required field

Complete the form below or call us on 784 008 4266.

What services are
you interested in?