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
Great
Katlego Kekana – Sodecia
The Course was Good and Informative
Course was good.
Vuyiswa Bosman – Sodecia
Course was good.
A wonderful experience.
Pauline Tshwane – Sodecia
The content was relevant and meaningful. All of the learning objectives were met
Very insightful and beneficial
Mpho Makhanthisa – Sodecia
Very insightful
Mark was incredible in taking his time to explain all the courses and module breakdowns
It was amazing
Chayenn Alicia Naicker – Action Refrigeration and Airconditioning (Pty) Ltd
So wonderful and simply explained to understand be able to replicate.
Useful to start off
The course was very useful because there were a few shortcuts and tricks that i didn't really know or understand
Good Beginner course – easy grasp
Joseph Thompson – Maxtec
Good Course - Definitely helped.
It was very helpfull
Thavin Munsamy – Maxtec
It was very helpful and eye opening,and it educated me alot
