Excel VBA Training (Beginner To Advanced Level) - Delhi

I provide training on Excel VBA which includes Excel formulae and simple VBA programs for beginners; then advanced VBA at the later stages. This is a job oriented training that helps you in getting job in various organisations. This training is done on Saturdays and Sundays. Call-8802579388

I provide training on Excel VBA which includes Excel formulae and simple VBA programs for beginners; then advanced VBA at the later stages. This is a job oriented training that helps you in getting job in various organisations. This training is done on Saturdays and Sundays
Call- 8802579388

Advanced MS Excel Course Content

Advanced Functions

IF Function & Nested IF Statements

And & Or Functions

Lookup Functions (Horizontal And Vertical Lookup

Index Function

Array Function

Subtotals

Conditional Formatting

3D Ranges

Create & Maintain (Within Worksheets In a Single File & Between External Files)

Consolidate Data (via 3D Ranges & Using The Consolidate Tool)

Pivot Tables

Create Pivot Table

Work With Row/ Column Fields

Data Fields

Customise Table Display

Organising Workbooks

Create Templates

Styles

Protect Ranges & Worksheets

Data

Enter & Select Records Using The Input Form

Sort Data Into Lists

Filter Data - Autofilter, Advanced Filter

DataBase Functions

Validation Rules

Goal Seeking

Solver

Goal Seeking With Charts

What-If

Scenarios

Create Scenarios

Create Summary Report

Merge Scenarios

Protect Scenarios

Macros

Create Macros Record

Relative Referencing

Assign To Toolbars/ Keyboard

Make Available To All New Documents/ Current Document Only

Outlines

Group Row/ Column Data To Create Outline Levels Based On Worksheet Formulae

Display Summary Rows And Summary Styles

Custom Views

Create, Modify, Delete

Include Hidden Rows, Columns, Filter Settings

Report Manager

Create, Modify, Delete

Create Sections (Sheet, View1, Scenario)

Contact : -

Sujeet Kumar

8802579388

Hi,
I am Microsoft Certified Trainer and have an experience more than 7 year in this field. Below is my contact details. You can contact me any time and I am open to travel. Thank you!
Regards,
Prashant Pardeshi
9867163640 / 8080588159
prashant1668@gmail.com