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
Yolandi Swanepoel – BikeInvention
Thank you
Easily understood!
Rozeena Chedie – NTE Company
This training was very informative and easily understood.
IMPROVED THE EFFICIECY OF DOING THINGS
SANELISIWE PROMISE SOSIBO – MBOVA CONSTRUCTION
THE TRAINING WAS VERY FRUITFUL THERE IS ALOT WE LEARNED AND HOPING TO DO BETTER GOING FORWARD WITH KNOWLEGDE WE GOT TODAY
Good experience learning
ZANELE MHLAMVU – MBOVA CONSTRUCTION
The facilitator was clear and would answer all the questions asked.
Good
sibusiso Cyril Sosibo – Mbova construction
course very useful and efficient.
fantastic
Lihle Mkhize – iThemba Projects
so much i did not know was so clear in this course
Interesting Informative Helpful Learning Great
Bernice Nieuwoudt – GVB Conservancy
I love that you can do the training in your own time, and practice what is being taught. The course is interesting and I have learned a lot about the shortcuts, and basic use of Pivot and graphs. I like the workbook and the fact that you always have sections and lessons to go back to. This Excel course is highly recommended.
Excellent course for beginners!
Jessi Venter – Grootvadersbosch Conservancy
Great course to get you started with Excel if you are a 'noob' like me!
Loved learning all the shortcuts I could use within Excel!
