Miracles Of Excel Formulas And Functions

Excel functions are programmed formulas and tasks that simplify specific calculations and work. Excel includes hundreds of functions designed to save you time — but learning how to use ALL of them can be a challenge.

This HRD Corp Claimable Excel course provides a keen understanding of creating formulas from scratch and using built-in functions to speed through spreadsheet work.

Prerequisites:

• Knowledge of Microsoft Excel Intermediate is essential with the follow pre-requisites:
• Able to switch between task applications
• Able to “Create”, “Save”, “Open”, and “Print” spreadsheet
• Able to use the “Undo” function
• Insert and delete Row & Column
• Print a spreadsheet with headers and footers applied
• Insert, Delete and Rename a worksheet
• Able to create basic formulas like addition, subtraction, multiplication and division
• Able to use basic functions like Sum, Average, Count, Max and Min function

Learning Objectives:

• 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

Who Should Attend:

• This course is suitable for Executives, Business Development Officers, Managers, Department Head, Business Owners, Entrepreneurs, Sales & Marketing Personnel.

Methodology:

• Brain-friendly/Interactive Lectures
• Demonstration
• Practical Exercises

Key Contents:

• Module 1: Cell And Range References
• Module 2: Statistical Functions
• Module 3: Math And Trig Functions
• Module 4: The Wonders Of Text Functions
• Module 5: Logical Functions
• Module 6: Lookup & Reference Formulas
• Module 7: Date & Time Formulas
• Module 8: Useful Tips