Excel VBA 24-Hour Trainer - KING OF EXCEL

Friday, April 16, 2021

Excel VBA 24-Hour Trainer


Excel VBA 24-Hour Trainer

🎁Like Fanpage and Read online bellow⏬

by Tom Urtis
  • Length: 432 pages
  • Edition: 1
  • Publisher: Wrox
  • Increase your productivity and save time and effort with Excel VBA

    This unique book-and-DVD package prepares you to get more out of Excel by using Visual Basic for Applications (VBA) to automate your routine or labor-intensive Excel tasks. Microsoft Excel MVP and author Tom Urtis walks through a series of lessons while the accompanying DVD provides demos to complement each lesson. Urtis takes an in-depth look at how manual tasks in Excel can be programmed with VBA for greater speed, efficiency, and accuracy. You’ll learn how to use VBA to manipulate Excel in ways you may never have thought possible.

    Excel VBA 24-Hour Trainer:

    • Introduces you to VBA and discusses topics including object oriented programming, variable declaration, objects and collections, and arrays
    • Teaches you how to write your own macros for programming loops, events, charts, pivot tables and pivot charts, and user-defined functions
    • Shows you how to customize the look and feel of Excel with User Forms, Input Boxes, Message Boxes, and embedded controls
    • Examines advanced topics including class modules, add-ins, and retrieving external data with ADO and SQL
    • Demonstrates how to interact with other Office Applications from Excel, including Word, Access®, PowerPoint®, and Outlook®

    Wrox guides are crafted to make learning programming languages and technologies easier than you think. Written by programmers for programmers, they provide a structured, tutorial format that will guide you through all the techniques involved.

    Note: As part of the print version of this title, video lessons are included on DVD. For e-book versions, video lessons can be accessed at wrox.com using a link provided in the interior of the e-book.

    Table of Contents

    Section 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

    Section 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. Making Decisions with VBA

    Section III: Beyond the Macro Recorder. Writing Your Own Code
    Lesson 9. Repeating Actions with Loops
    Lesson 10. Working with Arrays
    Lesson 11. Automating Procedures with Worksheet Events
    Lesson 12. Automating Procedures with Workbook Events
    Lesson 13. Using Embedded Controls
    Lesson 14. Programming Charts
    Lesson 15. Programming PivotTables and PivotCharts
    Lesson 16. User Defined Functions
    Lesson 17. Debugging Your Code

    Section IV: Advanced Programming Techniques
    Lesson 18. Creating UserForms
    Lesson 19. UserForm Controls and Their Functions
    Lesson 20. Advanced UserForms
    Lesson 21. Class Modules
    Lesson 22. Add-Ins
    Lesson 23. Managing External Data
    Lesson 24. Data Access with ActiveX Data Objects
    Lesson 25. Not Gone, Not Forgotten

    Section V: Interacting with Other Office Applications
    Lesson 26. Overview of Office Automation from Excel
    Lesson 27. Working with Word from Excel
    Lesson 28. Working with Outlook from Excel
    Lesson 29. Working with Access from Excel
    Lesson 30. Working with PowerPoint from Excel

#evba #kingexcel #etipfree #eama

No comments:

Post a Comment

Popular Posts