Microsoft Excel course for Intermediate trainees by Anee Infotech

ALPHA INFO MATRIX
VB Macros
Module I: Programming in Excel VBA
The Basics
Variables, Arrays, Constants and Data types
Modules, Functions, Subroutines
Programming Basics: Decisions and Looping
Strings and Functions and Message Boxes
Operators
Debugging
Errors and the error function
Dialogs
Common Dialog Control
Command Bars and Buttons
Module II: Object Models
The Excel Object Model
The Excel Object Model-Main Objects
Using Excel to Interact with other office programs
Module III: Advanced Techniques in Excel VBA
Charts and Graphs
Working with Databases
API Calls
Class s
Animation
Working with XML Files
The Ribbon
Pivot tables
Module IV: VBA in Action
Converting Labels to Numbers and Numbers to Labels
Transposing a Range of Cells
Adding formula Details into Comments
Calculating a Range
Reversing a Label
Who Created the Workbook?
Evaluating a Cell
Sorting Worksheets into Alphabetical Order
Replacing Characters in a String
Timed Events
Auto-Totaling a Matrix of Numbers
Absolute and Relative Formulas
Coloring Alternate Rows and Columns of the Spreadsheet
Coloring Cells Containing Formulas
Summing Cells by Reference to a Master Cell
Globally Changing a Range of Values
Displaying Hidden Sheets without a Password
Searching Multiple Sheets and Workbooks
Brighten Up Your Comments
Importing a CSV File Containing Leading Zeros
Working with Shapes
Turning Your VBA Code into an Add-In