Enrol for our Excel/VBA training programs for assured perfection in Microsoft Execl/VBA. These training programs will help you in becoming fast and efficient in your day to day Excel related work. The training programs have been designed by people with expertise in Microsoft products. Also the training programs are very economic which suits everyone’s pocket.

Topics Covered

Introduction to Excel Excel object hierarchy Essential keyboard shortcuts Cell Formatting essentials and shortcuts Absolute and Relative cell referencing Usage of IF formula with basic arithmetic functions Different count formulas Sumif, Countif formulas Match, Vlookup and Hlookup formulas Usage of Vlookup and Match formulas in combination Offset, Index formulas Formula debugging Basic and Advanced filters Conditional formatting Sorting Implementing charts and charting tips Sumifs, Countifs formulas Working with Dates Working with text Advanced formulas Indirect, Sumproduct, Subtotal Data tables Pivot Tables Connecting pivot tables to external sources Data Validation Importing data from text files and web Usage of special cells Defining and working with named ranges Dynamic named ranges Database formulas Dsum, Dcount, Daverage Protection of sheet and workbook Working with shared workbooks Form controls and making dynamic dashboards using the controls Calculation options Usage of Solver and Goalseek

Who should attend

Person with any profession

Pre-requisites

Microsoft Office 2003 onward installed on system

What you need to bring

Notepad and a Pen. Laptop if you have

Key Takeaways

Complete Excel knowledge Excel Tricks