Microsoft-Excel-Online-Training-Courses-for-Beginners-and-Professionals_

Excel VBA Course

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