Start: October 24, 2020
Excel for non-finance professionals
What you will learn
About this course
Today, knowing how to use Microsoft Excel is a requirement for many job roles. You may have even lost a job or business opportunity due to your lack of knowledge of Microsoft Excel. Microsoft Excel mastery is required across a number of job functions such as sales, marketing, finance, fundraising, administration, HR, operations among others. This is an introductory course in the use of Excel and is designed to give you a working knowledge of Excel. This class is appropriate for those who have very little or no functional knowledge of Excel and those with intermediate skills.
Fee includes certificate, lunch and course material
Module 1 - Excel basics (for beginners)
Lesson 1: Getting Started with Excel; Lesson 2: Data Entry, Data Editing, and Number Formatting; Lesson 3: Data Formatting; Lesson 4: Working with Cells and Ranges in Excel; Lesson 5: Managing Worksheets
Module 2 - Excel essentials
Lesson 6: Introduction to Excel Tables; Lesson 7: Auto-fill, Custom Lists, and Flash Fill; Lesson 8: Number Formatting in Excel;
Module 3 - Excel formulas
Lesson 9: Excel Formula Basics; Lesson 10: Logical Formulas in Excel; Lesson 11: Math Formulas in Excel; Lesson 12: Lookup and Reference Formulas in Excel; Lesson 13: Stats Formulas in Excel; Lesson 14: Text Formulas in Excel; Lesson 15: Date and Time Formulas in Excel; Lesson 16: Formulas Mix and Match (10 Examples)
Module 4 - Data analysis
Lesson 17: Named Ranges in Excel; Lesson 18: Data Validation in Excel; Lesson 19: Data Sorting and Filtering in Excel; Lesson 20: Using Conditional Formatting in Excel
Module 5 - Introduction to excel charting
Lesson 21: Introduction to Excel Charting; Lesson 22: 10 Advanced Excel Charting Examples; Lesson 23: Dynamic Charts in Excel
Module 6 - Pivot table
Lesson 24: Overview of Excel Pivot Table
Module 7 - Excel extras
Lesson 25: Protection in Excel; Lesson 26: Introduction to Macros and VB Editor
Start: October 24, 2020
Almost 90% of jobs today require basic or advanced knowledge of Excel. Your employability increases for the following job functions or roles: sales manager/officer, marketing manager, account manager, HR, business development, accounting and finance, admin, retail manager, data journalist/analyst; project manager, business analyst, researcher, shop attendants, secretarial services among others.
This course runs for a total of six weeks, once a week every Saturday.
Saturday: 9:00 am – 3:00 pm
Start date: Oct. 24, 2020
End date: Oct. 25, 2020
This course is delivered by a Chartered Accountant who has been using Excel in various job functions for the past 10 years.
Course fee: GHS 270
You will receive a course certificate for this program. The certificate is provided by Opmax.
If you have any question about this course or require more information, please contact our Accounts Manager:
Phone: +233 24 240 5302
Address: Awudome Cres, North Kaneshie (Near TV Africa), Accra, Ghana