Useful Formulas and Functions

Course Objectives

After completing this course, students will be able to:

    • Apply Formula and Functions Basic
    • Statistical and Logical Functions
    • Lookup and Reference Formulas
    • Text Formulas
    • Date and Time Formulas
    • Array and Database Functions
    • Efficiency Tips

Audience 

  • This course is intended for users of Microsoft Office Excel who want to learn about useful formulas and functions.

METHODOLOGY

This program will be conducted with interactive lectures, PowerPoint presentations, discussions and practical exercises

Course Modules

Module 1 – Making Data Work For You

Module 2 – Statistical And Logical Functions

Module 3 – Lookup And Reference Formulas

Module 4 – Text Formulas

Module 5 – Date And Time Formulas

Module 6 – Array And Database Functions

Module 7 – Efficiency Tips

Get To Know The Trainer

Trainer Beatrice

 4.5

Beatrice has been in the training industry for the past 27 years being one of the pioneer trainers of Microsoft Office training programs. She has vast experience having trained many people from various corporate sectors. She is a certified Microsoft Office training consultant and is accredited by Pembangunan Sumber Manusia Berhad (PSMB/HRDC).

Trainer Jarina

 4.5

Managing and maintaining a Microsoft Windows Server 2003 Environment - educate the IT professionals who implement, manage, and troubleshoot existing network and system environments based on the Windows Server 2003 platform. Implementation responsibilities include installing and configuring parts of systems. Management responsibilities include administering and supporting systems

Chat with us LIVE to get a

FREE QUOTATION!

THIS PUBLIC COURSE INCLUDES

CLASS DETAILS

ALL IN FROM ONLY

RM0/PAX

*T&C Applies

4.7

  • 67%
  • 33%
  • 0%
  • 0%
  • 0%
  • JR
    JACQUELINE LILLIE JAMES RAGAI
    Senior Executive, Operations

    5

  • MI
    MOHD SHAHRIL BIN ISMAIL
    Executive, Marketing / Design

    5

    👍🏼👍🏼👍🏼
  • MJ
    Mohd Suhaimi bin Jusoh
    Manager / Supervisor, Sales

    5

  • AA
    Ahmad Nazri Raithol Afthal
    Senior Executive, Marketing / Design

    5

  • NT
    Nick Looi Kok Timg
    Manager / Supervisor, Engineering

    5

  • TS
    Tan Eng Same
    Junior Executive, Engineering

    5

  • TP
    Tong Choy Ping
    Manager / Supervisor, Operations

    4

  • lt
    law siew teen
    Junior Executive, Accounting and Finance

    4

  • YK
    Yoon Chee Kheong
    Senior Executive, Engineering

    4

Courses you may like

MEMBERS ONLY FEATURE

Kindly sign-up or log-in to get access.

LOGIN

Login with your social account

or

Don’t have an account with us?

FREE FOR LIFE

Sign Up to Bookmark your Favourite Course
or Request for a Quotation instantly

Sign in with your social account

or

By signing up, you agree to our Terms of Use and Privacy Policy

Have an account with us already?