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
Intermediate
Advanced
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
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
Content:
Formulas
Functions
Sum and Count
Daily use functions
Named Ranges
Filter and Sort
Printing
Import Text files
Organizing Data
Duration: 20 Hrs
Formulas
Functions
Sum and Count
Daily use functions
Named Ranges
Filter and Sort
Printing
Import Text files
Organizing Data
Duration: 20 Hrs
Content:
Pivots tables
Charts
Subtotals
Goal seek
Scenarios
Data Consolidation
Group and Outline
Security and Protection
LOOKUP Functions
Duration: 12 Hrs
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
Intermediate
Advanced
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
Introduction to VBA
Introduction to VBE
Creating Sub routine
Creating Function
Excel Object Model
Using EOM
Using Macro recorder
Examples
Exercises
Duration: 08 Hrs
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
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
Content:
Connect to Web
Class Modules
Connect to SQL/Access
Using Windows API
Commandbars/Toolbars
RibbonX
Examples
Exercises
Duration: 16 Hrs
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
Intermediate
Advanced
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
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
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
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
Content:
Connect to Web
ODBC Connection
Using Windows API
RibbonX
Crystal Reports
Examples
Exercises
Duration: 20 Hrs
Connect to Web
ODBC Connection
Using Windows API
RibbonX
Crystal Reports
Examples
Exercises
Duration: 20 Hrs
Comments