Free Training & Career Tips... Subscribe to Get Weekly Career Tips
By Subscribing You are Agreeing to Terms and Conditions
Don’t be terrified of spreadsheets! You don’t need to be a numbers boffin to master the basics of Excel. This is one of several Excel courses we offer which cater to all levels of expertise, from beginners to intermediate through to advanced.
Welcome to the world of Excel. Microsoft Excel is perhaps the single most important software program used in business today. Particularly in the field of information systems, Excel is an essential end-user computing tool. Many business professionals use Excel to perform everyday functional tasks and an increasing number of people rely on Excel as a decision support tool.
Excel enables users to unlock the potential of their data by using formulas across a grid of cells. Data is inserted into individual cells in rows or columns which allows sorting and filtering.
The first part of this power course focusses on showing you how to create a spreadsheet from a given specification, manipulate data using cells, label cells and formula cells and perform basic sums such as addition, subtraction, multiplication, division and sum.
In the second part you will learn how to develop a solution to a specified problem using formulas and built-in functions.
In part three we teach you how to create and edit graphs and charts using features that enable you to add colour, dimension and visual context to a set of data values.
Unlock data potential, solve problems and create visual context with this power packed Excel course for winning formula spreadsheets. You will learn how to:
Upon successful completion of this course you will become adept at performing a number of different functions and operations and learn about the various functions of Excel including:
To win with Excel you need the right formulas. BOTI offers Excel training courses, Excel short courses and computer short courses. Enrol now to kick-start your Excel training with BOTI’s Excel to the power of 3: Beginners + Problem solving + graphs/charts = winning formula course. BOTI offers business training programmes across South Africa.
This course is suitable for those individuals who are seeking to improve their working knowledge of Excel.
Amanda Cunningham – Endeavour, Gold Mining
‘I gained better insight and understanding of Excel and am more comfortable operating the app. I learnt formulas, pivot tables and consolidating. The course was relaxed and informative.’
Bianca Steytler – Meridian Agrochemical Company (Pty) Ltd
‘I learnt a lot of new formulas and tricks to automate processes. What went well for me was hands-on learning with examples from our own work put into perspective. The best thing about this course was formulas and actual examples to practice on.’
Kelly-anne Smith – Meridian Agrochemical Company (Pty) Ltd
‘What went well for me was the use of formulas and pivot tables and I now have more knowledge on how to use Excel better.’
Katrien de Ridder – Meridian Agrochemical Company (Pty) Ltd
‘I learned new skills regarding formulas, functions and pivot tables..
Diederick Klopper – Meridian Agrochemical Company (Pty) Ltd
‘I can now easily set up my data into Excel.’
This Unit Standard course is aligned to:
Unit Standard 116937: Use a Graphical User Interface (GUI)-based spreadsheet application to create and edit spreadsheets
Unit Standard 116940: Use a Graphical User Interface (GUI)-based spreadsheet application to solve a given problem
Unit Standard 116943: Using a Graphical User Interface (GUI)-based spreadsheet application, enhance the functionality and apply graphs /charts to a spreadsheet