Shopping Cart

Microsoft Excel Beginner Online Training

Summit-Solutions-Training-Excel-Beginner-Banner

Download Details

Price

R 1,150

Get Started

4.7/5

4.7/5

276 Reviews

Course Overview

Course Length: 56 Lessons | 4 hours of Videos.

Total course duration: 6 to 8 hours

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 various components that make up Excel. Workbooks and Worksheets. Cells, Columns and Rows. Name box and Formula Bar. Office Ribbon and Menus. In addition, we will look at key concepts that are essential to understanding and working with Excel. Such as: The Active Cell; Keyboard Shortcuts; The difference between Highlighting, Replicate and Moving Cell content; Entered Values vs Formula and making the most of your mouse right-click function.
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.
Numbers, Dates, Currency and Percentage. Understanding that Number Formats can be a façade, i.e. what you see is not what you get. Working with Excel can be very frustrating if you don’t understand this!
Adjusting Row height and Column width. Ways to auto-adjust all column headers at the same time. Inserting, Deleting and Hiding Rows and Columns, plus being able to Freeze the Top Row so that it’s always visible when scrolling.

The basic operations of Adding, Subtracting, Multiplying and Dividing. Remember BODMAS? If not, we’ll remind you, it’s important! Explanation of the difference between Formulas and Functions. Intro to the 5 basic functions of Auto-Sum, Average, Count, Max and Min. Copying and Replicating Formula and understanding the critical difference between empty and zero value cells. Again, this is key to understanding calculations in Excel, which even many Advanced users get wrong…

Difference between using Page Layout and Print Preview to set and change Print settings. Details on adding Custom Headers / Footers, Repeating header Rows, printing gridlines, Page Numbers and Print Scaling, plus setting Print Areas and Printing Selection.

Using a combination of these features to make working with large spreadsheets a lot more manageable and easier. Using Filters to extract specific Data and copy this to a New Spreadsheet. (A combo of 4 shortcuts can do this in seconds!)

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.

Over 25 Keyboard Shortcuts covered throughout the course to increase those efficiencies. A printable 1-pager, of all these shortcuts and more, is provided with the follow-along Workbook.

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

Course Reviews

Very informative and will be extremely useful in my workplace. Could not have had better. Very valuable.

KARON, ENERGY PARTNERS HVAC & R (PTY) LTD

Absolutely informative and recommended for anyone. Definitely going to assist me with my efficiency at work. Mark is a super star!!

TUMI, RESOLUTION CIRCLE (PTY) LTD

Even though I work on excel extensively every day I still found value and learnt new things on the beginner course.

ROXANNE, TD ADMINISTRATIVE SERVICES

Well presented and prepared. I would love to attend the follow-up training. Trainer was very patient and helpful and kept to times. I learnt a lot.

BERNADETTE, VENDANGE

Each topic was extremely useful and detailed. Very valuable information to use not just in the workplace but on a daily living/basis.

ZANDILE, KERRY INGREDIENTS

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.