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
From India, Pune
From India, Pune
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
From India, Pune
Call- 8802579388
From India, Pune
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
From India, Pune
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
From India, Pune
Community Support and Knowledge-base on business, career and organisational prospects and issues - Register and Log In to CiteHR and post your query, download formats and be part of a fostered community of professionals.
VBA with Advc. Excel.pdf
Excel with VBA.doc