DP-080T00 Query and modify data with Transact-SQL

1 – Using VBA to Solve Business Problems

• Topic A: Use Macros to Automate Tasks in Excel
• Topic B: Identify Components of Macro-Enabled Workbooks
• Topic C: Configure the Excel VBA Environment

2 – Automating Repetitive Tasks

• Topic A: Use the Macro Recorder to Create a VBA Macro
• Topic B: Record a Macro with Relative Addressing
• Topic C: Delete Macros and Modules
• Topic D: Identify Strategies for Using the Macro Recorder

3 – Getting Help on VBA

• Topic A: Use VBA Help
• Topic B: Use the Object Browser to Discover Objects You Can Use in VBA
• Topic C: Use the Immediate Window to Explore Object Properties and Methods

4 – Creating Custom Worksheet Functions

• Topic A: Create a Custom Function
• Topic B: Make Decisions in Code
• Topic C: Work with Variables
• Topic D: Perform Repetitive Tasks

5 – Improving Your VBA Code

• Topic A: Debug VBA Errors
• Topic B: Deal with Errors
• Topic C: Improve Macro Performance

6 – Controlling How and When Macros Run

• Topic A: Prompt the User for Information
• Topic B: Configure Macros to Run Automatically

7 – Developing Custom Forms

• Topic A: Display a Custom Dialog Box
• Topic B: Program Form Events

8 – Using VBA to Work with Files

• Topic A: Use VBA to Get File and Directory Structure
• Topic B: Use VBA to Read Text Files
• Topic C: Use VBA to Write Text Files

9 – Using VBA to Clean and Transform Data

• Topic A: Automate Power Query
• Topic B: Transform Data Using VBA and Workbook Functions
• Topic C: Use Regular Expressions
• Topic D: Manage Errors in Data

10 – Extending the Programming Environment Beyond the Workbook

• Topic A: Run Other Programs and Commands
• Topic B: Share Your VBA Projects