Search Courses  in 

Get COURSE FEES Instantly from vishamber gupta!


I need details for


My Name

My Mobile Number

My Email ID


vishamber gupta

vishamber gupta, Tilak Nagar Delhi-NCR



Address : Ashok Nagar, Near Tilak Nagar

Location : Tilak Nagar - Delhi-NCR

Postal Code : 110018

Phone :9899997872

Enquiry (24/7):80941 56781


Landmark :

Category : Training Institute

No Ratings0/5

Total Reviews - 0






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
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
Protect Ranges & Worksheets

Enter & Select Records Using The Input Form
Sort Data Into Lists
Filter Data - Autofilter, Advanced Filter
DataBase Functions
Validation Rules

Create Scenarios
Create Summary Report
Merge Scenarios
Protect Scenarios

Create Macros Record
Relative Referencing
Assign To Toolbars/ Keyboard
Make Available To All New Documents/ Current Document Only

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)
Add Sections
Specify Page Numbering
Vishamber Gupta
Email id:


List of Training Courses offered by vishamber gupta

MS Office
MS Excel 2007
MS Outlook 2007
MS PowerPoint
MS Word 2007
MS Windows 2007
Office 365
Advanced VBScript
Excel Macro
Excel Vbscript


High Technologies Solutions - Delhi,Noida,Gurgaon

TrainerDesk Training Jobs


Training course fee & Discounts