Excel for Absolute Beginners

Program Overview

“The purpose of information is not knowledge; it is being able to take the right action” – Peter Drucker

Microsoft Excel is one of the tools that is best suited for working with data, which is available in almost every organisation. It’s powerful, flexible and easy to use. Yet, a lot of professionals are using it very little. This course focuses on the business users that need to save time and make better decisions. It will expand and strengthen your knowledge of Excel and help you keep track of your business, and reduce your bookkeeping load.  

In 3 hours, you will gain essential knowledge and skills and leave with a skill set that you can immediately use in your organisation and become more effective. Professionals will learn to use Excel to keep track of inventories, prepare budgets and sales reports,  to name some. In addition, they will see how to use Excel as a powerful tool for business decision-making. 

 The authors of this course have designed it based on their experience teaching Excel at higher education institutions and in the industry for over 15 years. They also contributed their own experience with data analytics and how it could benefit business users.

Learning Outcomes

After attending this program participants will be able to:

Intended Audience

Program Outline

  • The Importance of Excel and Excel Skills
  • Structure of the Session
  • Font and Cell Formatting
  • Format Painter
  • Conditional Formatting
  • Importing Files
  • Linking Directly to Other Software
  • Pitfalls to Avoid
  • Types of Cell References
  • Using Cell References in Formulas
  • Auditing Formulas – avoiding mistakes
  • Creating a Filter
  • Types of Filters – text, numbers, top and bottom
  • Advanced Filtering
  • Introduction to Functions
  • Types of Functions
  • Examples of Specific Functions – IF, SUM, AVERAGE, COUNT, MAX, MIN
  • Q&A
  • Comments
  • End

Other courses you may be interested in

Want to know more?

Please fill the form below if you would like to talk to us about this course and your needs. We will get back to you within 24 hours.

First Name*
Last Name*
Tel No
Leave a message