If you are working in Excel on a daily basis, then we will teach you VBA and Macros skills that will help you win back at least half of your precious time!
Course Curriculum
(Click for details)
Module 1: INTRODUCTION TO VBA & MACROS
1. Cells and Ranges 2. Copy And Paste 3. Controlling Fonts And Colouring Cells 4. Multiple Lines, Clearing And Column Widths 5. Building Logic With If 6. Building Logic With Select Case 7. The Importance Of Loops 8. Introduction To Automation 9. Loops And Selecting Ranges 10. Maneuvering And Macros 11. Constants And Variables 12. The Most Important Line In VBA You Need To Know! 13. Putting Together Everything So Far To Demonstrate Automation
Module 2: AUTOMATING THE WORKSHEET
1. Macro File Formats 2. Developer Tab And Macro Security 3. Modules, Macros And Relative References 4. A First Look At Buttons 5. Charting Driven By Macros 6. Why Macros Can Go Wrong And What To Do About It 7. Handling Errors And Sheet Issues 8. Dynamic Charting: Part 1 9. Dynamic Charting: Part 2 10. Dynamic Charting: Part 3 11. End With 12. Controlling Autofilters 13. Controlling Formulas
Module 3: GOING DEEPER INTO LOOPING
1. 5 Levels Of Looping Part 1 2. 5 Levels Of Looping Part 2 3. 5 Levels Of Looping Part 3 4. 5 Levels Of Looping Part 4 5. 5 Levels Of Looping Part 5 6. VBA Alternative: Gathering Data With Power Query
Module 4: AUTO-CREATE EXCEL FILES & TEMPLATES
1. Introduction 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 Paste special 6. Mass Producing Input Sheets 4: Manipulating Filter Criteria 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
Module 5: AUTOMATE DATA COLLATION & ANALYSIS
1. Starting The New Process 2. Open Up One File And Copy Data 3. Introduction To The Do While Loop 4. Looping Through All Files In A Folder And Copying Data 5. Setting Up New Data Before We Bring Into Our Long Boring List 6. Looking Up Latest Data Manually Into Our Long Boring List 7. Looking Up Latest Data Automatically Into Our Long Boring List 8. Putting It All Together
Module 6: CONTROLLING POWERPOINT FROM EXCEL
1. Why PowerPoint? 2. Introduction to the Object Model 3. Programming in PowerPoint 1: Basics 4. Programming in PowerPoint 1: Shapes 5. Programming in PowerPoint 1: Tables 6. Opening PowerPoint from Excel 7. Pasting an Excel range as an Image in PowerPoint 8. Translating Excel data into a table in PowerPoint 1 9. Translating Excel data into a table in PowerPoint 2: Multiple Slides 10. Drawing Shapes in Excel 11. Translating Excel data into Shapes in PowerPoint
Module 7: CONTROLLING WORD FROM EXCEL
1. Introduction and Creating an MS Word Invoice from Excel 2. Gathering Data from MS Word docs in to Excel (Change Control Form) 3. Purchase order system: part 1 – Excel to word 4. Purchase order system: part 2 – The word template 5. Purchase order system: part 3 – Save & print button 6. Purchase order system: part 4 – Excel to word
Bonus Module: THE VBA TOOLS & TEMPLATES VAULT
1. Resource Analysis: Good practice for managing data 2. Dynamic Charts 3. Charting Actual vs Forecast 4. Segmenting for deeper MI 5. Meaningful Resource Analysis 6. Interesting MI Aesthetics, automating folders and PDF files 7. Automate the creation of a PowerPoint slide deck 8. Combining PowerPoint with Information Gathering 9. Automating the production of a Project Summary front page in PowerPoint
We use cookies to ensure that we give you the best experience on our website. If you continue to use this site we will assume that you are happy with it.OkPrivacy policy