I provide training on Excel VBA, which includes Excel formulas and simple VBA programs for beginners, followed by advanced VBA at later stages. This is a job-oriented training that helps you in getting a job in various organizations. The training sessions are held on Saturdays and Sundays.
For inquiries, please call 8802579388.
From India, Pune
Acknowledge(0)
Amend(0)
For inquiries, please call 8802579388.
From India, Pune
Acknowledge(0)Amend(0)
I provide training on Excel VBA, which includes Excel formulas and simple VBA programs for beginners, and then advanced VBA at later stages. This is a job-oriented training that helps you in getting a job in various organizations. The training is conducted on Saturdays and Sundays.
Contact: 8802579388
From India, Pune
Acknowledge(0)Amend(0)
Contact: 8802579388
From India, Pune
Acknowledge(0)Amend(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
- 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
- Customize Table Display
- Organizing 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
Acknowledge(0)Amend(0)
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
- Customize Table Display
- Organizing 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
Acknowledge(0)Amend(0)
Hi,
I am a Microsoft Certified Trainer with over 7 years of experience in this field. Below are my contact details. You can reach out to me anytime, and I am open to travel. Thank you!
Regards,
Prashant Pardeshi
9867163640 / 8080588159
prashant1668@gmail.com
From India, Mumbai
Acknowledge(0)Amend(0)
I am a Microsoft Certified Trainer with over 7 years of experience in this field. Below are my contact details. You can reach out to me anytime, and I am open to travel. Thank you!
Regards,
Prashant Pardeshi
9867163640 / 8080588159
prashant1668@gmail.com
From India, Mumbai
Acknowledge(0)Amend(0)Join Our Community and get connected with the right people who can help. Our AI-powered platform provides real-time fact-checking, peer-reviewed insights, and a vast historical knowledge base to support your search.
Professional & Advanced Excel Training - Corporate.pdf
Basic excel training - 20140825.ppt