Main features:
- Developed on a professional basis and drawn from 'real world' experience.
- There are 10 Workbook examples, and each lesson is between 5 and 10 Word Document pages long.
- Lesson 10 of Excel VBA contains hundreds of Time Saving Microsoft Excel Solutions. It is a downloadable book in Windows help file format is freeware.
- EXCEL LEVEL 3 OUTLINE: Advanced Formulas, Advanced Filters, Text To Columns, Importing Text Files Pivot Tables 1, Pivot Tables 2, Pivot Tables 3, Scenarios, Goal Seek, Data Tables and Consolidation, Excel on the Web, Macros 1, Macros 2.
- EXCEL VBA OUTLINE: The Fundamentals of Excel VBA, The Visual Basic Editor, Objects and Properties, Excel Objects, Object Hierarchy, Application, Workbook, Worksheet, Range, Command Bars, Variables and Constants, Data types, Variable Levels, Declaring Variables, Constants, Loops, Types of Loops, Loop Pitfalls, Effective Decision Making, If/And/Or, Select Case, Dates and Times, Workbook and Worksheet Events, Debugging and Error Handling, Prevention, Good Habits, Runtime Errors, Excel Worksheet Functions in VBA, Specific Examples, Excels Built-In Features, User Defined Functions, Good vs. Bad, Arguments, Calculation, Controls, ActiveX, Control Toolbox, Control Properties, Control Parent.
|
