This course is intended for managers of small businesses and accountants who want to learn how to use Microsoft Excel in order to improve their productivity and reduce their workload. Participants will learn to create and practise useful formulas for budgets, using labels and names in formulas, using absolute and relative referencing in formulas, logical formulas, working with different functions, creating simple charts, selecting ranges, filling a series and using Excel for record-keeping and human esources purposes such as maintaining sick and recreation leave. Some basic knowledge of Excel is required. This course is perfect for those who have already completed a basic introductory excel course and/or who use Excel daily in their work.
This course also includes some of the powerful uses of excel such as:
• Lookup functions
• Validations
• Pivot table reports
• Scenarios
• Macros