Shopping Cart

Microsoft Excel Automation Online Training

Summit-Solutions-Training-Excel-Automation-Banner

Download Details

Price

R 2,150

Get Started

4.2/5

4.2/5

5 Reviews

Course Overview

Course Length: 80 Lessons | 11 hours of Videos.

Total course duration: 9 – 11 hours

This course takes the automation concepts introduced in the Advanced course to the next level and beyond!

  • Recorded Macros
  • Power Query
  • Power Pivot
  • Word and Power Point Integration
  • Visual Basic for Application

This course comes into its own is when we start applying these automation components on your own data. When you start to see your manual processes that seem to take forever, now being automated in a matter of minutes, it truly is mind blowing!

4-Excel-Automation-800

Course Content

Understanding how Excel stores Text, Numbers and Dates as well as the importance of using Data Ranges. Key Essentials that are not often taught but critical in understanding how Excel interprets and works with our Data
Working through the most efficient ways to enter, check and edit your Data. This will include: Cell navigation; The correct use of the Tab, Enter and esc Keys; Cut, Copy & Paste; Undo & Redo; Spell Checker.
Maximising the use of the Excel Autofill feature to populate an Excel Spreadsheet. I.e. Copying cells, generating a Series and replicating Formulas.
Basic Cell Formatting of Font, Fill, Borders, Alignment (Merging & Wrapping) and Numbers. We’ll also show you some neat shortcuts that many advanced users are unaware of, such as: Format Painter, Repeat Formatting and the difference between Delete and Clear All.

Intro to creating Graphs and using Conditional Formatting.

Intro to Excels Golden Rule and the subsequent requirement to lock a cell reference in a Formula by using Absolute Cell References. ($A$2)

A sneak peek at this most Powerful Excel Tool.

VBA has been around almost as long as Excel itself, and unlike Power Query, which specifically helps us to acquire and manipulate data, VBA enables us to automate absolutely anything in Excel. As “Visual” and “Basic” as it is, it is still a coding language, which can be a little tricky to get your head around. In this section we help you understand some Key Coding components, such as Variables, Properties and Methods. Plus some useful coding practices such as For-Loops and If-Statements. We then use this knowledge, to modify some downloaded Code Snippets off the Web, and pop them into our very own Customised Ribbon! This last section is pretty straight forward and enables us to leverage the advantages of existing VBA Code without having to really understand it.

Course Reviews

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

Thank you, one of the most useful courses I’ve attended.

KERRY MOFFET, INDIVIDUAL

MS Excel Advanced Course

R 1,550

Course Length: 79 Lessons | 7.5 Hours of Videos

Content Covered

  • Key Essentials
  • Spreadsheet Integrity
  • Cell References
  • Forecasting
  • CSV Import
  • Merging Data
  • Splitting Data
  • Data Validation
  • Worksheet Protection
  • Advanced Formula
  • Text Formula
  • Date Formula
  • Logical Formula
  • Lookup Formula
  • Maths Formula
  • Pivot Tables & Charts
  • Excel Automation (Macros)

MS Excel Intermediate Course

R 1,350

Course Length: 55 Lessons | 5.5 Hours of Videos

Content Covered

  • Key Essentials
  • Series Generation
  • Advanced Copy and Paste
  • Formula
  • Cell Referencing
  • Rounding
  • View Optimization
  • Find and Replace
  • Sort and Filter
  • Graphs
  • Conditional Formatting
  • Ranges vs Tables
  • Pivot Tables
  • VLOOKUP
  • Data Manipulation
  • Keyboard Shortcuts
  • Tips and Tricks

MS Excel Beginner Course

R 1,150

Course Length: 56 Lessons | 4 Hours of Videos

Content Covered

  • Excel Overview
  • Key Essentials
  • Data Input
  • Excel Autofill
  • Formatting Cells
  • Number Formatting
  • Formatting Worksheets
  • Formulas
  • Printing
  • Basic Sort and Filter
  • Visualizing Data
  • Excel’s Golden Rule
  • Pivot Tables Sneak Peek
  • Keyboard Shortcuts
  • Tips and Tricks

This draw is closed. Keep checking back, for the next draw.