Advanced Excel

VSIT is famous training institute for advance excel course near dwarka, Delhi. Our Excel Training covers advance features with practical learning. This Data Analysis course is specially prepare for whom they have some basic knowledge of excel and wants to be expert excel professional.

Excel for Professionals

Excel Formulas and Functions
  • Arithmetic Functions
  • Logical Functions
  • Date and Time Functions
  • Text Functions
  • Financial Functions
  • Statistical Functions
  • Lookup and Reference Functions
  • Formula Auditing
Arithmetic Functions
  • FACT & SQRT Functions
  • MOD Function
  • POWER & PRODUCT Functions
  • ROUND, ROUNDUP & ROUNDDOWN Functions
  • SUM,SUMIF & SUMIFS Functions
  • SUBTOTAL Function
Logical Functions
  • IF Function
  • Nested IF
  • IF error
  • OR Function
  • AND Function
  • NOT Function
Date and Time Functions
  • Today & Now Function
  • Date & Time Function
  • Finding difference between two dates
  • Calculate networkdays
  • Calculate Weeks in year
  • Find Weekday
Text Functions
  • Find and Search
  • Len, Trim and Exact
  • Left & Right Function with Find and Search
  • Mid Function with Find & Search
  • Replace and Substitute
  • Clean and Concatenate
Financial Functions
  • Present Value (PV) Function
  • Futute Value (FV) Function
  • Calculate Per Month installment (PMT) Function
  • Calcutate rate of interest
  • Calcutate NPER
Statistical Functions
  • AVERAGEA, AVERAGEIF, AVERAGEIFS
  • COUNTA,COUNTBLANK, COUNTIF and COUNTIFS
  • LARGE and SMALL
Lookup Functions
  • VLookup Function
  • HLookup Function
  • MATCH
  • INDEX function
  • CHOOSE function
  • Left Lookup
  • Right Lookup
  • Reverse Lookup
  • Double Lookup
  • Multiple Lookup
  • Exact Match
  • Approximate Match
  • Lookup Tricks
Cell Reference
  • Relative Reference
  • Absolute Reference
  • Mixed Reference
  • 3D Reference
  • External Reference
Data Analysis
  • Sorting data in ascending or descending order
  • Data Filter
  • Advanced Filter
  • Creating Charts
  • Pivot Tables
  • Data Tables
  • What If Analysis – Goal Seek and Scenario Manager
  • Removing Duplicates
  • Grouping the Data and Subtotals
  • Converting Text to Column
  • Importing Data from other Sources
Data Validation
  • Creating Data Validation
  • Understading Validation Rules
  • Validation Message
  • Error Alert Message
  • Reject Invalid Dates
  • Prevent Duplicate Entries
  • Creating Drop Down List
  • Dependent Drop Down Lists
More About Excel
  • Apply Conditional Formating
  • Group Worksheets
  • Consolidate
  • View multiple Worksheets
  • Share Worksheet
  • Calcutate Electricity Bill
  • Set budget limit