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.

GHS 270

Fee includes certificate, lunch and course material

Syllabus

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:

Email: hello@opmax.co.uk

Phone: +233 24 240 5302 

Address: Awudome Cres, North Kaneshie (Near TV Africa), Accra, Ghana

Apply now

Application form: Excel for non-finance professionals
Employment status *