Skip to content

086 167 3923
hello@SummitSolutions.co.za

Login
Sign up for online courses

Menu

Login
Sign up for online courses

086 167 3923
hello@SummitSolutions.co.za

Login
Sign up for online courses

Menu

Login
Sign up for online courses

<img width="382" height="142" src="https://summitsolutionstraining.co.za/wp-content/uploads/2020/10/0405b4_f660cdef617e49439497444c8b9167fbmv2.png" class="attachment-full size-full" alt="" srcset="https://summitsolutionstraining.co.za/wp-content/uploads/2020/10/0405b4_f660cdef617e49439497444c8b9167fbmv2.png 382w, https://summitsolutionstraining.co.za/wp-content/uploads/2020/10/0405b4_f660cdef617e49439497444c8b9167fbmv2-120x45.png 120w, https://summitsolutionstraining.co.za/wp-content/uploads/2020/10/0405b4_f660cdef617e49439497444c8b9167fbmv2-310x115.png 310w" sizes="(max-width: 382px) 100vw, 382px" />

Home
Online courses
Corporate Training
Public Training
Consulting
Blog
Tips
FAQs
Contact

Menu

Home
Online courses
Corporate Training
Public Training
Consulting
Blog
Tips
FAQs
Contact

Facebook Linkedin

Home
Online courses
Corporate Training
Public Training
Consulting
Blog
Tips
FAQs
Contact

Menu

Home
Online courses
Corporate Training
Public Training
Consulting
Blog
Tips
FAQs
Contact

<img width="382" height="142" src="https://summitsolutionstraining.co.za/wp-content/uploads/2020/10/0405b4_f660cdef617e49439497444c8b9167fbmv2.png" class="attachment-full size-full" alt="" srcset="https://summitsolutionstraining.co.za/wp-content/uploads/2020/10/0405b4_f660cdef617e49439497444c8b9167fbmv2.png 382w, https://summitsolutionstraining.co.za/wp-content/uploads/2020/10/0405b4_f660cdef617e49439497444c8b9167fbmv2-120x45.png 120w, https://summitsolutionstraining.co.za/wp-content/uploads/2020/10/0405b4_f660cdef617e49439497444c8b9167fbmv2-310x115.png 310w" sizes="(max-width: 382px) 100vw, 382px" />

Facebook Linkedin

MS Excel Automation

Current Status

Not Enrolled

Price

R1699

Get Started

Course Overview

By combining Excels Advanced Tools of Power Query, Power Pivot and Macros (VBA), this course will expose you to the time saving world of Excel Automation.

Course Length: 80 Lessons

“The team are totally pumped at what they learnt and are already putting it into practice which is saving them hours if not days of time.”
Patrick – The Kerry Group

Download course outline

Course Content

Expand All

Section 1 - Automation Introduction

Introduction to the Automation Course

Section 2 - Source-to-Report

01 – Source-to-Report Example

Section 3 - Source-to-report - Recorded Macro

01 – Recording a Macro – Intro

02 – Recording a Macro – Rows

03 – Recording a Macro – Columns

04 – Recording a Macro – Testing & Correcting

05 – Recording a Macro – Using it

Section 4 - Source-to-Report - Power Query

01 – Power Query – Intro

02 – Power Query – Rows

03 – Power Query – Columns

04 – Power Query – Testing, Correcting & Using

Section 5 - Power Query Basics

01 – Installing Power Query – For Excel 2010 & 2013

02 – The differences between Excel Versions

03 – Different Data Sources

04 – Diff between Load, Load To and Transform

05 – Transform Basics

06 – Editing a Query

07 – Refreshing Data

08 – Modifying the Loaded Table

Section 6 - The Transform Toolset

01 – Transform Intro

02 – Rows and Columns

04 – Formatting

05 – Replace Values

09 – Column from Example 1

10 – Column from Example 2

11 – Column from Example 3

12 – Transform Recap

13 – Troubleshooting – Content Change

14 – Troubleshooting – Structure Change

15 – Transform Extension Challenge

16 – Transform Extension Solution

Section 7 - Different Data Sources

01 – From Text CSV – Understanding Regional Settings

02 – From Text CSV – with the same Locale Regional Settings

03 – From Text CSV – with different Locale Regional Settings

04 – From Text CSV – with Customised Regional Settings

05 – From Folder – Intro

06 – From Folder – The Sample File

07 – From Folder – File Filters

08 – From Folder – Recap Example

09 – From Folder – Using From File Code

10 – From an Access DB – Basics

11 – From an Access DB – that is Password Protected

12 – From Table-Range – Basics

13 – From Table -Range – Disguised Table

14 – From Table-Range – Transposing Data

Section 8 - Matching Data

01 – On Rows – Merge

02 – On Columns – Append

Section 9 - Power Pivot

01 – Adding the Power Pivot Ribbon

02 – Loading to the Data Model

03 – Std Pivot – using Index-Match

04 – Power Pivot – using the Data Model

05 – Power Pivot v Std Pivot – Duel 1

06 – Power Pivot v Std Pivot – Duel 2

07 – Power Pivot v Std Pivot – Duel 3

08 – Power Pivot – Summary

Section 10 - Integrating with Word and Point

01 – Integration Intro

02 – Linking Charts

03 – Linking Tables

04 – Formula driven tables

05 – Linking Charts & Tables Summary

06 – Updating Linked Data

Section 11 - VBA

01 – VBA Intro

02 – VBA Editor Window

03 – VBA Objects

04 – VBA Worksheets

05 – VBA Ranges

06 – VBA Variables

07 – VBA Properties

08 – VBA Methods

09 – VBA Last Row and Column

10 – VBA For Loop

11 – VBA If Statement

12 – Code from Scratch Example

13 – Code from Web Example

14 – Creating a My Macros Ribbon

Section 12 - Course Evaluation

01 – Short Feedback Questionnaire 1 Survey

Expand

Lesson Content

Excel Automation Course – Short Feedback Questionnaire

Have a problem you’re struggling to resolve? Feel free to ask us a question!

Contact us

086 167 3923
hello@summitsolutions.co.za
Head Office: The Junction, 49 Garlick Avenue, Garlington, Hilton, 3245

Sign up for our newsletter

Receive our monthly Excel tips and news to your inbox!

First name

Email

Quick links

Home
Online courses
Corporate Training
Public Training
Consulting
Blog
Tips
FAQs
Contact

Menu

Home
Online courses
Corporate Training
Public Training
Consulting
Blog
Tips
FAQs
Contact

Facebook Linkedin

© 2020 Summit Solutions | All Rights Reserved | Website by Yellow Door Collective

Login

Accessing this course requires a login. Please enter your credentials below!

Username or Email Address

Password

Remember Me

Lost Your Password?