Excel VBA 24-Hour Trainer, 2nd Edition
- Length: 504 pages
- Edition: 2
- Language: English
- Publisher: Wrox
- Publication Date: 2015-03-30
- ISBN-10: 1118991370
- ISBN-13: 9781118991374
- Sales Rank: #278444 (See Top 100 Books)
Master VBA automation quickly and easily to get more out ofExcel
Excel VBA 24-Hour Trainer, 2nd Edition is thequick-start guide to getting more out of Excel, using Visual Basicfor Applications. This unique book/video package has been updatedwith fifteen new advanced video lessons, providing a total ofeleven hours of video training and 45 total lessons to teach youthe basics and beyond. This self-paced tutorial explains Excel VBAfrom the ground up, demonstrating with each advancing lesson howyou can increase your productivity. Clear, concise, step-by-stepinstructions are combined with illustrations, code examples, anddownloadable workbooks to give you a practical, in-depth learningexperience and results that apply to real-world scenarios.
This is your comprehensive guide to becoming a true Excel poweruser, with multimedia instruction and plenty of hands-onpractice. * Program Excel’s newest chart and pivot table object models * Manipulate the user interface to customize the look and feel ofa project * Utilize message boxes, input boxes, and loops to yieldcustomized logical results * Interact with and manipulate Word, Access, PowerPoint, andOutlook from Excel
If you’re ready to get more out of this incredibly functionalprogram, Excel VBA 24-Hour Trainer, 2nd Edition provides theexpert instruction and fast, hands-on learning you need.
Table of Contents
Part I: Understanding the BASICs
Lesson 1: Introducing VBA
Lesson 2: Getting Started with Macros
Lesson 3: Introducing the Visual Basic Editor
Lesson 4: Working in the VBE
Part II: Diving Deeper into VBA
Lesson 5: Object-Oriented Programming: An Overview
Lesson 6: Variables, Data Types, and Constants
Lesson 7: Understanding Objects and Collections
Lesson 8: Working with Ranges
Lesson 9: Making Decisions with VBA
Part III: Beyond the Macro Recorder: Writing Your Own Code
Lesson 10: Repeating Actions with Loops
Lesson 11: Programming Formulas
Lesson 12: Working with Arrays
Lesson 13: Automating Procedures with Worksheet Events
Lesson 14: Automating Procedures with Workbook Events
Lesson 15: Handling Duplicate Items and Records
Lesson 16: Using Embedded Controls
Lesson 17: Programming Charts
Lesson 18: Programming PivotTables and PivotCharts
Lesson 19: User-Defined Functions
Lesson 20: Debugging Your Code
Part IV: Advanced Programming Techniques
Lesson 21: Creating UserForms
Lesson 22: UserForm Controls and Their Functions
Lesson 23: Advanced UserForms
Lesson 24: Class Modules
Lesson 25: Add-Ins
Lesson 26: Managing External Data
Lesson 27: Data Access with ActiveX Data Objects
Lesson 28: Impressing Your Boss (or at Least Your Friends)
Part V: Interacting with Other Office Applications
Lesson 29: Overview of Office Automation from Excel
Lesson 30: Working with Word from Excel
Lesson 31: Working with Outlook from Excel
Lesson 32: Working with Access from Excel
Lesson 33: Working with PowerPoint from Excel
Donate to keep this site alive
1. Disable the AdBlock plugin. Otherwise, you may not get any links.
2. Solve the CAPTCHA.
3. Click download link.
4. Lead to download server to download.