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
Exellent
Yolandie Beneke – Coastal Macadamia
Was very helpfull, Mark did a good job explaining everyhing.
Execllent and Skillful
Ayamthanda Khayakazi Ngqono – Coastal Macadamia
This was a very insightful training, a lot of skill aquired
Brilliant
Sibongile Nzimakwe – Coastal Macadamia
Great experience on learning new tricks around Excel.
Very intuitive and informative
Rayno Holl – Coastal Macadamia
Great course! I would definitely recommend this course to anyone even if you have been using excel for 10 years!
awesome
Marc Peskens – coastal Macadamia
very well done and loved it, helped me out alot
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.
