Lesson 1: Essentials of Spreadsheet Application Development

• What is a Spreadsheet Application?
• Steps for Application Development
• Determining User Needs
• Planning an Application that meets user needs
• Determining the most Appropriate User Interface
• Concerning yourself with the end user
• Other development issues

Lesson 2: Introducing Visual Basic For Applications

• Getting a Head Start with Macro Recorder
• VBA Programming Fundamentals
• Deep Dive: Working with Range Objects
• Essential Concepts to Remember

Lesson 3: VBA Programming Fundamentals

• VBA Language Elements
• Variables, Data Types, and Constants
• Assignment Statements
• Arrays
• Objects Variables
• User Defined Data Types
• Built In functions
• Manipulating Objects and collections
• Controlling Code Execution

Lesson 4:Working With VBA Sub Procedures

• About procedures
• Executing Sub Procedures
• Passing Arguments to procedures
• Error- Handling Techniques
• A Realistic Example that uses Sub Procedures

Lesson 5: Working with UserForms

• Sub procedures versus functions procedures
• Introducing UserForms
• UserForm Examples
• Advanced UserForm Techniques
• Why create custom functions
• An introductory function example
• Function Procedures
• Function arguments
• Function examples
• Emulating Excels SUM function
• Extended Date Functions
• Debugging Functions
• Dealing with the Insert Function Dialog box
• Using Add Ins to store Custom Functions
• Using the windows API

Lesson 14: Userform Examples

• Creating a Userform “Menu”
• Selecting ranges from a userform
• Creating a splash screen
• Disabling a userforms size
• Zooming and scrolling a sheet
• Listbox techniques
• Other development issues
• Using the multipage control in a userform
• Using an external control
• Animation a label

Lesson 15: Advanced Userform techniques

• A modeless dialog box
• Displaying a progress indicator
• Creating wizards
• Emulating the MsgBox Function
• A userform with movable controls
• A userform with no title bar
• Simulating a toolbar with a userform
• Emulating a task pane with a userform
• A resizable userform
• Handling multiple userform controls with one event handler
• Selecting a colour in a userform
• Displaying a chart in a userform
• Making a userform semitransparent
• A puzzle on a userform
• Video poker on a userform

Lesson 16: Creating and using Add ins

• What is an Add-In?
• Understanding excels add in manager
• Creating an add in
• And add in example
• Comparing XLAM and XLSM Files
• Manipulating Add ins with VBA
• Optimizing the performance of add ins
• Special problems with add ins

Lesson 17:Working with ribbon

• Ribbon basics
• Customizing the ribbon
• Creating a custom ribbon
• Using VBA with ribbon
• Creating an old style toolbar

Lesson 18: Working with shortcut menus

• CommandBar overview
• Using VBA to customize shortcut menus
• Shortcut menus and events

Lesson 19: Providing help for your applications

• Help for your excel applications
• Help systems that use excel components
• Displaying help in a web browser
• Using a HTML help system

Lesson 20: Leveraging class modules

• What is a class module?
• Creating a Numlock class
• Coding properties, methods, and events
• Exposing a query table event
• Creating a class to hold classes

Lesson 21: Understanding Compatibility issues

• What is compatibility?
• Types of compatibility problems
• Avoid using new features
• But will work on a mac?
• Dealing with 64-Bit Excel
• Creating an international application