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
  • Home
  • Online courses
    • MS Excel Beginner Course
    • MS Excel Intermediate Course
    • MS Excel Advanced Course
    • MS Excel Automation
    • FAQs
  • Onsite Corporate Training
  • Public Training Courses
  • Consulting
  • Blog
    • Recent articles
    • Excel Tips
  • Contact
Menu
  • Home
  • Online courses
    • MS Excel Beginner Course
    • MS Excel Intermediate Course
    • MS Excel Advanced Course
    • MS Excel Automation
    • FAQs
  • Onsite Corporate Training
  • Public Training Courses
  • Consulting
  • Blog
    • Recent articles
    • Excel Tips
  • Contact
Facebook
Linkedin
  • Home
  • Online courses
    • MS Excel Beginner Course
    • MS Excel Intermediate Course
    • MS Excel Advanced Course
    • MS Excel Automation
    • FAQs
  • Onsite Corporate Training
  • Public Training Courses
  • Consulting
  • Blog
    • Recent articles
    • Excel Tips
  • Contact
Menu
  • Home
  • Online courses
    • MS Excel Beginner Course
    • MS Excel Intermediate Course
    • MS Excel Advanced Course
    • MS Excel Automation
    • FAQs
  • Onsite Corporate Training
  • Public Training Courses
  • Consulting
  • Blog
    • Recent articles
    • Excel Tips
  • Contact
Facebook
Linkedin

MS Excel Beginner Course

Current Status
Not Enrolled
Price
R699
Get Started
Pay & Enroll
 4.5/5

4.84

(1154 reviews)

Course Overview

Grasp the key components that make Excel tick, reduce your Excel frustrations and become a lot more efficient when working with Spreadsheets!

Course Length: 56 Lessons | 4 Hours of Videos.

Total course duration: 6 to 8 hours

Skills Level: No prior knowledge of Excel is required, but a basic understanding of computers is expected.

Download Course Outline

Course Content

Expand All
Introduction
01 – Welcome to our Excel Beginner Course
02 – How did you find out about this course? 1 Survey
Expand
Lesson Content
How did you find out about this course?
03 – How to get started
04 – Download the Excel Beginner Work Book
Section 1 - Excel Overview
01 – Excel Components
02 – Ribbons and Commands
03 – Right Click Pop Up Menus
04 – Intro to Keyboard Shortcuts
05 – Highlighting, Replicating & Moving Cells
06 – Excel Overview Recap
Section 2 - Key Essentials
01 – Understanding Numerical Values
02 – Understanding Dates
03 – Understanding Data Ranges
04 – Key Essentials Recap
Section 3 - Data Input
01 – Efficient Data Entry Methods
02 – The Honesty Book – e.g. Intro
03 – Data Entry e.g., plus Tips and Tricks
04 – Spell Checker
05 – Data Input Recap
Section 4 - Autofill
01 – Excel Autofill by Data Type
02 – Excel Autofill on Multiple Cells
Section 5 - The 5 Formatting Cells Categories
01 – The 5 Formatting Cells Categories
02 – Using the Formatting Dialogue Box
03 – Tips and Tricks on Selecting a Range
04 – Formatting Tips & Tricks
05 – The 3 different Delete Options
Section 6 - Formatting Worksheets
01 – Formatting Worksheets Intro
02 – Adjusting Row Height and Column Width
03 – Formatting entire Rows and Columns
04 – Inserting and Deleting Rows and Columns
05 – Moving Rows and Columns
06 – Hiding Rows and Columns
07 – Inserting and Deleting Cells
08 – Freeze Panes
Task 1
Task 1 – Annual Conference Timetable
Section 7 - Number Formatting
01 – Key Number Formats
02 – Pre-formatted Cells
03 – The 5 Quick Access Commands
04 – Custom Formats
Section 8 - Formulas
01 – Intro to Formulas
02 – The SUM Function
03 – More Functions (COUNT, AVERAGE, MAX & MIN)
04 – Replicating Formula
05 – Recap Exercise 1
06 – Recap Exercise 2
Section 9 - Printing
01 – Printing Options
02 – Print Example 1
03 – Print Example 2
Task 2 - Stationary Invoice
Task 2 – How to Video
Section 10 - Sort and Filter
01 – Sorting
02 – Filtering
Section 11 - Data Visualisation
01 – Graphs and Conditional Formatting
Section 12 - Excels Golden Rules
01 – Absolute Cell References
02 – Applying the Golden Rule
Section 13 - Pivot Tables
01 – Sneak peak at Pivot Tables
Section 14 - Course Evaluation
01 – Download the completed Excel Beginner workbook
02 – Short Feedback Questionnaire 1 Survey
Expand
Lesson Content
Excel Beginner Course – Short Feedback Questionnaire

Course reviews

This is the most informative Excel course I’ve ever done.  Excellent, excellent, excellent.
Tanya – King Price

I was blown away by the way the course was set out. Small bites enabling easier practice and retention. My Excel knowledge was self taught and I thought I was quite quite efficient and got by, but realise now I actually knew a fraction of it’s uses. I will definitely be doing the Intermediate Course. Thank you!!
Karen

I have used EXCEL for a long time, without knowing what I was really doing. It was mostly trial and error. This was an outstanding presentation and has energized me to participate at the next level.
Chris

Incredible course! So well executed and thought out. Thanks Mark for not assuming that I know the basic basics – I feel empowered. So looking forward to the Intermediate course next.
Emma

This was amazing. I cant believe how much I struggled in the past trying to get things done manually  or doing a spreadsheet or invoice in word. Wish I took the course years ago.
Sajid – King Price

This is such a good interactive course. I have used excel for a few years now and have learnt so many new tricks. I will definitely do the Intermediate course as well.
Pamela

This was absolutely brilliant! Coming from a background where I have been working with excel for many years, I learnt a lot in this course that I had no clue of. Very easy to understand and the lecturer explains perfectly. The content explained here will surely be of great value to me in my career.
Muhammed – The Husqvarna Group

Even though I have quite a good understanding of Excel, this course gave me some excellent shortcuts as well as options that I did not know about. Mark is an excellent teacher as he works methodically through the lesson, fully explaining as he goes along. What I also enjoyed was when he repeated some of the information learnt in a previous section to remind one of the shortcuts and options.

Janet

I have to thank you from the bottom of my heart. Never thought that at 63 I would even try something like Excel. It is not something I use every day but now and again I use the basics. Now I understand the how it works and the shortcuts. Thank you so-so much.
Sarie – King Price

 

The course was so informative. I realise just how much I’ve only been plodding along with excel all these years. Am excited to put many of the new tricks I’ve learned in to practice. Thank you so much!!
Gillian

Was exactly what Ive been wanting to learn for the last 7 years.
Ashleigh – Safire Insurance Company Limited

 

Brilliant! Excellent presentation.
Jaco – Husqvarna SA

 

I really loved it, it’s very informative.
Ulrisha

Good course for everyone including intermediaries.
Emmanuel – Entsika Consulting

 

Brilliant course. Ive been working on Excel for over 20 years and found some very interesting shortcuts and even a few new functions I was a little scared to use. The training was clear and informative.
Sylvia

Very detailed,  easy to follow, excellent.
Fathima – The Husqvarna Group

 

The course was very informative and explained well with examples. I would definitely recommend this course.
Avinash

This was a very good course for me, eye opening and very informative, giving me the fundamental basics of excel.
Andile – Wildocean

 

As someone that works quite a bit with excel, taking this course opened my mind up a lot to the efficiency and the power that Excel has.
Bavershan – Huge Telecom

 

Very informative. I have always wanted to learn how to calculate formulas and now I have.
Ashvani – Safire Insurance

 

Thank you for an extremely well put together course , to be honest our employer instructed us to do this during the lockdown I was reluctant as I never really understood how Excel worked, the pace and explanation was excellent, I also liked the fact that I could go back if I didnt really understand something.
Carryne – Brokoop Insurance Brokers

 

Couldnt ask for a better way to learn and spend my time .
Damian – Royal Cape Yacht Club

 

I though that I would be wasting my time on the beginners course, however it was interesting to see how little I actually new! Great to have learn so many new things.
Deidre

Awesome presentation, I could follow the videos easily and practice on the worksheet, some useful tips to work smart. Thank you for the course
Tembiso

It was the best course ever, I discovered many things I did not know about excel.            Busisiwe

Really enjoyed the course. Well presented and easy to follow. Excellent!
Renier – Brokoop Insurance Brokers Pty Ltd

Excellent for self-taught Excel users! Easy to follow and the worked examples helped to make the information usable and practical!
Shanaaz

Really well explained .I have used Excel for the past 25 Years , but have learned a lot more now.
Neville – Husqvarna South Africa

 

Enjoyed the course. Well presented and structured, the info boxes on the side helps a lot. Looking forward to the intermediate course.
Itumeleng

I thoroughly enjoyed this course. It was very informative and also easy to understand. What also made a difference is the course instructor/narrator was really good at capturing your interest. I really appreciated the fact that you could practice on the workbook whilst watching the videos and pause them if needs be. Thank you.
Pinkie – Safire Insurance Company Limited

 

Great course. Very informative and well explained. I would recommend this course to anyone who is interested in/needs excel for work.
Casper – Good Earth Developments

 

This course was very helpful to me and i will definitely apply it to my work.
Roslynne – Safire Insurance Company

Fantastic course. I have been using Excel for years but this improved my efficiency substantially.
Magda

Great introduction. I work with Excel daily but still learned a few new tricks and the shortcuts were quite helpful to me.
Clarisa – Safire Insurance

Really found this informative and cant wait to do the Intermediate course.
Jonathan – Hsystems

I think the course was excellent, very informative, well presented and easy to follow.
Safire – Shereen Jaggernath

 

This is very helpful, I have been working with Excel a while and still got very good pointers through this videos. Thank you.
Lezelle – Global Learning Services

 

I am a regular user of Excel but still found some interesting tips in the course material. Looking forward to completing the Intermediate course.
Wendy – Safire Insurance Company Limited

I am an Excel user, but found it very refreshing to do the course again. Cant wait to do the next two courses. Would love to do a PowerPoint and Access course the same way.
Graesen

 

Well done for keeping my attention so well, you have an interesting and clear way of presenting Ian

I found the course very informative and enjoyed the humour.
Shannon

 

Very good course. thoroughly enjoy it. Took me a while to finish it, but I worked on it for a few hours over 2/3 days. Knew most of the basics, but really enjoyed the formulas, printing, formatting cells and worksheets. They were all interesting and worthwhile. Thank you
Genna

 

Wow that was amazing, there was so much that I learnt. Awesome job Guys.
Mallisa – Aeroklas Duys (Pty) Ltd

 

I learnt so many new tricks and shortcuts that I did not know before. the printing lessons were the most valuable to me.
Roneeth

 

I really enjoyed the beginners course, it was explained carefully so that I could understand. I definitely learnt a lot completing this course and cannot wait to start the Intermediate excel course.
Kayla

 

Thoroughly enjoyed the course. Clearly informative. Cannot wait to do the Intermediate Course! Jennifer – Royal Cape Yacht Club

Very nifty and useful to anyone from beginner to intermediate. Even an advanced user could pick up a few tips.
Paul

 

Great content and very easy to follow.
Tian – Private

 

Awesome! Thank you so much for this training. I have been using Excel for years and I have discovered so many things I wasnt aware of.
Sthembiso – Barloworld

 

Very informative, cannot wait to continue with the Intermediate course
Lenie

 

What a surprise, I thought I would already know all this , but still learned a lot.
Freda

 

Excellent course, I have learnt a lot more about formulas and formatting .
Anisha – RB Logistics

 

The course is excellent! I always use to avoid Excel but now I feel a bit confident in doing it. Mark is good. Thank you.
Unice – International Budget

 

Was precise and too the point. Picked up a lot of handy short cuts.
Constance – Cape Union Mart

 

Everything was explained really well.
Jamie – Keedo Kids

 

The course has definitely taught me a lot compared to what I had known (short cuts, formulas and formatting). It is easy and straight forward. I would recommend it to other people.
Sphumelele

 

Before I started with this course I knew nothing about excel and now I know so much, I’m excited on going over to the intermediate course!
Chelsea

 

I’m working every day with Excel and there was still so much shortcuts and new items to learn.
Belinda – King Price

 

Nice and simply explained. Perfect for beginners like me.
Kemsley – Agvise

 

It was amazing, I have been working in excel for years but there was stuff I did not know. Thank you!
Debra-Ann

I highly recommend this course for people who are really struggling with excel. The way the content is broken down is really helpful.
Liyema

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

FAQs
Contact us

Contact us

  • 086 167 3923
  • hello@summitsolutions.co.za
  • Head Office: Hilton Quarry Office Park, 400 Old Howick Road, Hilton

Sign up for our newsletter

Receive our monthly Excel tips and news to your inbox!

Quick links

  • Home
  • Online courses
    • MS Excel Beginner Course
    • MS Excel Intermediate Course
    • MS Excel Advanced Course
    • MS Excel Automation
    • FAQs
  • Onsite Corporate Training
  • Public Training Courses
  • Consulting
  • Blog
    • Recent articles
    • Excel Tips
  • Contact
Menu
  • Home
  • Online courses
    • MS Excel Beginner Course
    • MS Excel Intermediate Course
    • MS Excel Advanced Course
    • MS Excel Automation
    • FAQs
  • Onsite Corporate Training
  • Public Training Courses
  • Consulting
  • Blog
    • Recent articles
    • Excel Tips
  • Contact
Facebook
Linkedin

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

Scroll to top
Login
Accessing this course requires a login. Please enter your credentials below!

Lost Your Password?