Excel VBA 24-Hour Trainer, 2nd Edition - KING OF EXCEL

Saturday, April 17, 2021

Excel VBA 24-Hour Trainer, 2nd Edition


Excel VBA 24-Hour Trainer, 2nd Edition

🎁Like Fanpage and Read online bellow⏬

by Tom Urtis
  • Length: 504 pages
  • Edition: 2
  • Publisher: Wrox
  • 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

#evba #kingexcel #etipfree #eama

No comments:

Post a Comment