IT and Computing (Live Online) > Useful Formulas and Functions

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).

VIEW PROFILE

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

VIEW PROFILE