“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.
After attending this program participants will be able to:
- 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