Excel VBA For Professionals

  1. 1

    • Module 2 Introduction

    • Module 2 VBA Fastrack Part 2 Practice Workbook

    • 14. Macro File Formats

    • 15. Developer Tab and Macro Security

    • 16. Modules, Macros and Relative References

    • 17. A first look at Buttons

    • 18. Charting driven by Macros

    • 19. Why Macros can go wrong and what to do about it

    • 20. Handling Errors and Sheet issues

    • 21. Dynamic Charting: Part 1

    • 22. Dynamic Charting: Part 2

    • 23. Dynamic Charting: Part 3

    • 24. End With

    • 25. Controlling Autofilters

    • 26. Controlling Formulas
  2. 2

    • Five levels of looping Part 1

    • Five levels of looping Part 2

    • Five levels of looping Part 3

    • Five levels of looping Part 4

    • Five levels of looping Part 5

    • VBA alternative: Gathering data with power query
  3. 3

    • Modules 3 and 4 Introduction

    • Module 3 Gathering Data Part 1 Practice Workbook

    • 1. Introduction to Information Gathering

    • Article - Six data gathering rules that will make you stand out

    • 2. Creating an Input Sheet Template

    • 3. Mass producing Input Sheets 1: Set the scene

    • 4. Mass producing Input Sheets 2: Worksheet Variables

    • 5. Mass producing Input Sheets 3: Autofilter revisited and Pastespecial

    • 6. Mass producing Input Sheets 4: Manipulating filter criteria

    • 6b. Mass producing Input Sheets 4b: Simplifying and bringing together

    • 6c. Mass producing Input Sheets 4c: Creating a worksheet

    • 7. Mass producing Input Sheets 5 Creating a unique list to prepare for looping

    • 8. Mass producing Input Sheets 6 Instantly creating 25 unique input Excel files
  4. 4

    • Module 4 Gathering Data Part 2 Practice Workbook

    • 9. Collating Data from Input Sheets 1 Starting the new process

    • 10. Collating Data from Input Sheets 2 Open up one file and copy data

    • 11. Introduction to the DO WHILE LOOP

    • 12. Collating Data from Input Sheets 3 Looping through all files in a folder and copying data

    • 13. Collating Data from Input Sheets 4 Setting up new data before we bring into our long boring list

    • 14. Collating Data from Input Sheets 5 Looking up latest data MANUALLY into our long boring list

    • 15. Collating Data from Input Sheets 6 Looking up latest data AUTOMATICALLY into our long boring list

    • 16. Collating Data from Input Sheets 7 Putting it all together

Pricing options

Explain how different pricing options might be valuable to different segments of your audience.