BUY EXCEL BOOKS ONLINE: 1. VBA & Macros      2. VBA for Modelers      3. Excel 2013 VBA and Macros     
4. Excel VBA for Dummies      5. Excel with VBA & .NET      6. Mastering VBA      7. Excel 2013 Programming

MS Excel & VBA: Contact for Corporate Trainings


What makes us one of the best Corporate Excel Trainer?

1. Our Course Content (as given below)
2. Microsoft Certified Professionals / Microsoft awarded "Most Valuable Professional"
3. Training exposure to all industries. viz. Electronics to Finance.
4. Ready spreadsheets for hands on experience.
5. Step-wise example workbooks.
6. Understanding of real needs.
7. Quality assessment
8. Relevant examples.

We're flexible with training hours and course content. Please go through our standard course content given below and feel free to contact us anytime for your queries and confirmations.

Call us: 09999-40-48-43 / 09968-615-632
E-Mail: training@OpenExcel.com 


MS Excel 2007/2010


Beginner

Content:
Introduction to Excel
Open, Close and Save
Manipulating Text
Styling and Formatting
Playing with Numbers
Date and Time Operations
Dealing Hyperlinks
Introduce Formulas
Duration: 08 Hrs


Intermediate

Content:
Formulas
Functions
Sum and Count
Daily use functions
Named Ranges
Filter and Sort
Printing
Import Text files
Organizing Data
Duration: 20 Hrs


Advanced

Content:
Pivots tables
Charts
Subtotals
Goal seek
Scenarios
Data Consolidation
Group and Outline
Security and Protection
LOOKUP Functions
Duration: 12 Hrs




Visual Basic for Automation (VBA)




Beginner

Content:
Introduction to VBA
Introduction to VBE
Creating Sub routine
Creating Function
Excel Object Model
Using EOM
Using Macro recorder
Examples
Exercises
Duration: 08 Hrs




Intermediate

Content:
Variables and Constants
Conditional statements
Loop statements
Error handling
Debugging
Using Excel Functions
Event Macros
Using Forms
Interactive Charts
Dealing with Pivots
Examples
Exercises
Duration: 20 Hrs




Advanced

Content:
Connect to Web
Class Modules
Connect to SQL/Access
Using Windows API
Commandbars/Toolbars
RibbonX
Examples
Exercises
Duration: 16 Hrs








Visual Studio Tools for Office (VSTO)




Beginner

Content:
Introduction to VSTO
New Features
Running VBA project with VSTO
Variables and Constants
Conditional statements
Loop statements
Make and Run First Project
Examples
Exercises
Duration: 04 Hrs




Intermediate

Content:
Create VSTO add-in
Create and Use Dlls
Error handling
Debugging
Using Excel Functions
Event Macros
Using Forms
Charts and Pivots
Security
Examples
Exercises
Duration: 16 Hrs




Advanced

Content:
Connect to Web
ODBC Connection
Using Windows API
RibbonX
Crystal Reports
Examples
Exercises
Duration: 20 Hrs