MOF 003 – Microsoft Excel (Intermediate), 8 & 9 May 2024

This course introduces participants to the Basic ,Intermediate of Microsoft Excel. Participants will learn the basics skills necessary to create and edit basic worksheets and workbooks, enter data, formulas, format and print workbooks. Participants gain knowledge on working with Name Ranges, more complex formulas and functions, They will learn how to manage their data by working with tables, sorting and filtering, highlight important data using conditional formats. Participant will also learn to validate, analyze and summarize their data. At the end of the course, the participant will be able to demonstrate the ability to perform complex calculation and manage data efficiently with Microsoft Excel.

The overall outcome of the module is designed to achieve the terms of the skills and knowledge that participants will be able to demonstrate upon completion:

• Discuss on how Microsoft Excel can be an appropriate tool to run a day-to-day business.
• Illustrate the different components of the Excel worksheet and demonstrate advanced practical skills using Excel to perform data analysis, expenses analysis and forecasting in a business.