Solving problems with Excel

It is a common misconception that many people view Excel as a tool that is used solely for business applications.  Yet, all types of problems can be solved using Excel.  Yet, for business purposes you may need functions that are a little more sophisticated.  Formulae for calculations or macro programming to automate the processing of data.  Whatever the problem may be, Excel has the capability to help you solve it using functions such as formulas, subtotals and text formatting.

This course will see you will on your way to mastering the functions of Excel in that you will learn how to develop a solution to a specified problem using formulas and built-in functions.  You will master working with multiple worksheets and create a visually appealing presentation using special effects.  You will also learn how to use formatting techniques and adjust the settings to create a customized view.

Get the winning formulas right in solving problems with Excel when you enrol now for BOTI’s Solving problems with Excel course.  BOTI offers Excel training courses, advanced Excel training and Excel for beginners.   BOTI offers business training programmes across South Africa.

Course duration

1 day

Master problem solving with Excel when you learn how to:

• Prepare and produce a spreadsheet to provide a solution to a given problem.
• Adjust settings to customise the view and preferences of the spreadsheet application.
• Work with multiple worksheets.
• Apply formulae to worksheets to provide alternative solutions to a problem.
• Apply simple built-in functions of the spreadsheet application to the given problem.
• Apply formatting to a spreadsheet applicable to the given problem.
• Use special effects to improve the presentation of the spreadsheet.
• Evaluate a spreadsheet.

Get the winning formulas right in solving problems with Excel when you enrol now for BOTI’s Solving problems with Excel course.  BOTI offers Excel training courses, advanced Excel training and Excel for beginners.   BOTI offers business training programmes across South Africa.

Benefits of attending:  Solving problems with Excel course

Upon successful completion of this course you will become adept at performing a number of different functions and operations in solving problems using Excel including:

• Adjusting the toolbar menus in Excel.
• Changing the size of view in Excel.
• Changing the view of a spreadsheet.
• Freezing cells, rows and columns.
• Changing file location.
• Changing the username and altering properties.
• Altering the view options.
• Working with multiple worksheets.
• Changing names and altering cells in a worksheet.
• Entering, altering, adjusting and manipulating formulas in Excel to achieve a specific outcome.
• Using the SUM function to add values in cells.
• Using the IF function to determine whether a condition is true or false.
• Using the LOOKUP function to look in a single row or column to find a value from the same position in another row or column.
• Using the VLOOKUP function to find things in a table or a range by row.
• Using the MATCH function to search for an item in a range of cells.
• Using the CHOOSE function to select one of up to 254 values based on the index number.
• Formatting sheets in Excel.
• Formatting cells for numbers, currency and percentages and copying formatting.
• Applying special effects to a spreadsheet to improve presentation.

Who is this course suitable for?

This course is suitable for those individuals who are seeking to improve their computer skills.

Get the winning formulas right in solving problems with Excel when you enrol now for BOTI’s Solving problems with Excel course.  BOTI offers Excel training courses, advanced Excel training and Excel for beginners.   BOTI offers business training programmes across South Africa.

Testimonials from similar courses

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.’

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.’

This Unit Standard course is aligned to Unit Standard 116940:  Use a Graphical User Interface (GUI)-based spreadsheet application to solve a given problem

Public Course Schedule and Costs

Please click on link below for related public course/s:

BOTI offers Excel training courses, advanced Excel training and Excel for beginners.  Book your seat now on BOTI’s Solving problems with Excel course.  BOTI offers business training programmes across South Africa.

You might also enjoy:  MS PowerPoint for beginners

MS Word for beginners

MS Outlook for beginners