Description

Book Synopsis


Table of Contents

Introduction

1. Unleash the Power of Excel with VBA

2. This Sounds Like BASIC, So Why Doesn't It Look Familiar?

3. Referring to Ranges

4. Looping and Flow Control

5. R1C1-style Formulas

6. Creating and manipulating Names in VBA

7. Event Programming

8. Arrays

9. Creating Classes and Collections

10. Userforms: An Introduction

11. Data Mining with Advanced Filter

12. Using VBA to Create Pivot Tables

13. Excel Power

14. Sample User-Defined Functions

15. Creating Charts

16. Data Visualizations and Conditional Formatting

17. Dashboarding with Sparklines in Excel

18. Reading from the Web using M and VBA

19. Text File Processing

20. Automating Word

21. Using Access as a Back End to Enhance Multiuser Access to Data

22. Advanced Userform Techniques

23. Windows Application Programming Interface (API)

24. Handling Errors

25. Customizing the Ribbon to Run Macros

26. Creating Excel Add-Ins

27. An Introduction to Creating Office Add-ins

28. What's New in Excel 365 and What's Changed


Microsoft Excel VBA and Macros Office 2021 and

    Product form

    £28.89

    Includes FREE delivery

    RRP £33.99 – you save £5.10 (15%)

    Order before 4pm today for delivery by Tue 28 Jul 2026.

    A Paperback / softback by Bill Jelen, Tracy Syrstad

    3 in stock

      Trusted by thousands of customers. See 2,385+ Customer Reviews

      View other formats and editions of Microsoft Excel VBA and Macros Office 2021 and by Bill Jelen

      Publisher: Pearson Education (US)
      Publication Date: Publication Date: 30/05/2022
      ISBN13: 9780137521524, 978-0137521524
      ISBN10: 0137521529

      Description

      Book Synopsis


      Table of Contents

      Introduction

      1. Unleash the Power of Excel with VBA

      2. This Sounds Like BASIC, So Why Doesn't It Look Familiar?

      3. Referring to Ranges

      4. Looping and Flow Control

      5. R1C1-style Formulas

      6. Creating and manipulating Names in VBA

      7. Event Programming

      8. Arrays

      9. Creating Classes and Collections

      10. Userforms: An Introduction

      11. Data Mining with Advanced Filter

      12. Using VBA to Create Pivot Tables

      13. Excel Power

      14. Sample User-Defined Functions

      15. Creating Charts

      16. Data Visualizations and Conditional Formatting

      17. Dashboarding with Sparklines in Excel

      18. Reading from the Web using M and VBA

      19. Text File Processing

      20. Automating Word

      21. Using Access as a Back End to Enhance Multiuser Access to Data

      22. Advanced Userform Techniques

      23. Windows Application Programming Interface (API)

      24. Handling Errors

      25. Customizing the Ribbon to Run Macros

      26. Creating Excel Add-Ins

      27. An Introduction to Creating Office Add-ins

      28. What's New in Excel 365 and What's Changed


      Recently viewed products

      © 2026 Book Curl

        • American Express
        • Apple Pay
        • Diners Club
        • Discover
        • Google Pay
        • Maestro
        • Mastercard
        • PayPal
        • Shop Pay
        • Union Pay
        • Visa

        Login

        Forgot your password?

        Don't have an account yet?
        Create account