MS Excel Beginner Course
* 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.
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.
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.
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
VERY HELPFUL
LYRELLE KRUGER – MABONDELA FORESTRY
THERE WERE SOME INTERESTING TIPS THAT I WAS NOT AWARE OF THAT WILL DEFINITELY HELP ME IN MY USE OF EXCEL GOING FORWARD
very clear and well explained
Ashleigh Pretorius – Squirt
I completed the beginner Excel course, which was an incredibly smooth and enriching experience. I found the content easy to follow, and the practical exercises helped me gain hands-on experience. I learned a lot about organizing data efficiently and using shortcuts to save time. The lessons were well-structured, and I had no negative experiences throughout the course.
excellent
Thembelihle Mkhwanazi – The Domino Foundation
I learned a lot from this Excel course; I'd always wanted to know how to create formulas, but had no prior experience doing so. After completing this course, I now understand and can even create graphs, which will be useful in my current position, particularly in reporting.
Thank you so much for the chance, which I greatly appreciate.
Great
Ntombifuthi Esther Madikane – The Domino Foundation
Very informative and very easy to follow and apply and fun.
ideal for what was needed
Goodman Thabiso Mlita – The Domino Foundation
It has expanded my knowledge of excel , I am grateful to be given this opportunity to do your course. ill highly recommend summitsolutions to anyone who is will to learn this course.
Excellent and fun!
Thank you - it was very easy to follow and very good detailed training! I enjoyed every part of this course.
Amazing
Jade Pietersen – HrTorque
Refreshing, fun and interesting you really learn a lot.
Amazing
Jade Pietersen – HrTorque
Fun, interesting, you really learn a lot it’s exciting and enjoyable.
