Webs Jyoti is a professional Development and Training organization located in Gurgaon, offering web designing and Information Technology services for the global entrepreneurs. Our tried and true system is based on over 8 years cumulative experience shared between our trainers. Webs jyoti provide employee training and development courses focuses on knowledge transfer, skill acquisition and behavior change. We all are & become what we repeatedly do. Excellence then, is not an act, but a habit. Proper habits grow from obtaining knowledge, attitude and skills. Knowledge understands what, how, and why we need to do something. Skill is applying that knowledge in a practical situation is revising to transform our knowledge into skills and ultimately into a habit.


Our training sessions are planned by our trainer and are designed in a manner geared toward the maximization of efficiency. Your time is valuable, and so is ours, so our goal is to best prepare you while taking up the least amount of your time possible.


The Trainer shall conduct training in Advanced Excel in accordance with the schedule as follow:

  • Worksheet Basics
  • Conditional Formatting
  • Relative and Absolute Reference ( $ in Reference)
  • Data Validations (Simple and Custom Data Validation)
  • Popular functions (Lookup, Conditional, Date, Text)
  • Text to column wizard
  • Name Manger, Selection, Define Name
  • Advanced Logical Functions if, and or, iferror
  • Charting and Analyzing Data
  • Advanced Filter (Based on 15 different scenarios)
  • Arrays Functions –(ctrl+alt+shift functions)
  • Pivot Table and Pivot Chart
  • Consolidate Data Tool
  • Advanced Lookup – Vlookup/ Reverse Lookup, index, match indirect
  • Goal Seek & Solver, Scenario Manager, Data Tables Analysis Too
  • Importing data from other sources
  • Excel Dashboard
author image

About admin

You Might Also Like...

php book written by indian author Hirdesh Bhardwaj
Sanitize and Validations Functions
VBA Hirdesh Bhardwaj, Hirdesh Bhardwaj Book
Drop Down List in Excel

1 Comment

  1. excellent service….

Leave a Reply

Your email address will not be published.

Enjoy the tutorial? Please spread the word :)

Follow by Email