Shop

009 USD-MODULE 2: ADVANCED EXCEL FORMULAS AND FUNCTIONS

009 USD-MODULE 2: ADVANCED EXCEL FORMULAS AND FUNCTIONS

On sale

30.00 USD 25.00 USD

MODULE 2: ADVANCED EXCEL FORMULAS & FUNCTIONS

This course introduces learner to the basics of creating simple formulas, with a gradual ascent to advanced & complex formulas. It lays the basic rules of mathematical operation & advanced functions. Welcome to a gamut of possibilities with Excel

It is available ONLINE and PHYSICAL

This is the second module of the complete package of Fundamentals of Microsoft Excel tutorials. It would require 6 hours tutorials to cover. The tutorial session is delivered in 3 sittings of 2 hours each.

The tutorial is delivered, adopting adult learning technique through a hands-on demonstration of the step-by-step principles guiding each topic covered with several life applicable scenarios that enhance learning and appreciation of the applicability in daily routines.

The hands-on tutorial is complemented with recorded videos of topics covered to reinforce understanding of the subjects. The participant is challenged with assessment exercises that help to sharpen learned skills and identify grey areas which are addressed.


Course Content (What you will learn):

Session One

  • Relative and Absolute Cell references
  • Simple Formulas
  • Complex Formulas & mathematical operation order

Session Two

  • Mathematical Functions
  • Statistical Functions

Session Three

  • Text Functions
  • Lookup & Reference Functions
  • Logical Functions


Learning flow:

  • Learner will read the introductory section to acquaint self with basic principles and operations.
  • Learner will then view the following videos that demonstrate what has been introduced in the introductory section.
  • Learner will then be ready for the tutorial sessions. The tutorial sessions will be real-time virtual calls either via Zoom, MS Teams or Google Meet.
  • At the end of each tutorial session, videos are released for learner to view and further enhance understanding of the topics covered in tutorial and previous sections.
  • Assignments for topics are made available for learner to attempt and submit for assessment.

Product Code: USD-AEFF
0
Click here to checkout