Shopping Cart

Microsoft Excel Beginner Online & Live Training Course

MS Excel Beginner Course

4 hrs of videos

* Live Training is for groups of 6 or more - Prices Ex. Vat

Course Overview

An introduction to Excel covering the basics, ranging from Data Input and Spreadsheet Navigation to Formatting and Printing.

There is a key focus on understanding how Excel works with different Data Types, using Excel Formulas as well as improving efficiencies when Entering and Editing Data.

We also look at managing a larger dataset by using Sort & Filter and take a sneak peek at the intermediate content of Graphs, Conditional Formatting and Absolute Cell References.

Summit Solutions MS Excel Beginner Training Online Course

Course Content

Overview of the components that make up Excel, plus basic functions like Cut, Copy & Paste.

Not often taught, but critical to understanding how Excel interprets and works with our Data.

Maximizing the use of the Excel Autofill feature to populate an Excel Spreadsheet.

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 & Numbers, plus some cool Tips & Tricks.

Adjusting, Inserting, Deleting and Hiding Rows and Columns, plus how to Freeze Panes.

Puts Numbers into context, but can be frustrating if you don’t get that Formats can be façades.

NB! – say no more! Understanding the basics of how formulas work in Excel is key.

All the Printing Tips and Tricks. NB! Printing is only covered in the Beginner Course.

Using these features to manage large spreadsheets and view / extract specific data.

Intro to Graphs and Conditional Formatting to pick up trends and visualize your data.

Intro to Excel’s Golden Rule and Absolute Cells References ($A$2).

Over 25 Keyboard Shortcuts to increase those efficiencies.

Excel Overview:
Overview of the components that make up Excel, plus basic functions like Cut, Copy & Paste.
Key Essentials:
Not often taught, but critical to understanding how Excel interprets and works with our Data.
Data Input:
Working through the most efficient ways to enter, check and edit your Data.
Excel Autofill:
Maximising the use of the Excel Autofill feature to populate an Excel Spreadsheet.
Formatting Cells:
Basic Cell Formatting of Font, Fill, Borders, Alignment & Numbers, plus some cool Tips & Tricks.
Formatting Worksheets:
Adjusting, Inserting, Deleting and Hiding Rows and Columns, plus how to Freeze Panes.
Number Formatting:
Puts Numbers into context, but can be frustrating if you don't get that Formats can be façades.
Formulas:
NB! - say no more! Understanding the basics of how formulas work in Excel is key.
Printing:
All the Printing Tips and Tricks. NB! Printing is only covered in the Beginner Course.
Basic Sort and Filter:
Using these features to manage large spreadsheets and view / extract specific data.
Visualizing Data:
Intro to Graphs and Conditional Formatting to pick up trends and visualize your data.
Excels Golden Rule:
Intro to Excel’s Golden Rule and Absolute Cells References ($A$2).
Keyboard Shortcuts:
Over 25 Keyboard Shortcuts to increase those efficiencies.

What's Included?

  • A detailed follow-along Excel Workbook with Summary Notes
  • Self-marking quick questions to test your progress as you learn
  • Practical Tasks that will enable you to put your newly acquired Excel Skills into practice
  • Course completion Certificates
  • Lifetime access to course material and updates

Next Step ...

For further specific information for our various training options use the links below; or alternatively contact us on hello@summitsolutionstraining.co.za or 086 167 3923.

Excel Beginner Course Reviews

Want to learn more?

Receive our Excel tips and news to your inbox!

"*" indicates required fields

Choices*
This field is for validation purposes and should be left unchanged.

Request a Consultation

MS Excel Advanced Course

R 1,750

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 750

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