Miracles Of Excel Formulas And Functions

by Training Asia Claim Listing

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.

Price : Enquire Now

Contact the Institutes

Fill this form

Advertisement

Training Asia Logo

img Duration

2 Days

Course Details

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
  • Petaling Jaya Branch

    No. 3 Jalan 215, Sec 51, Petaling Jaya

Check out more MS Excel courses in Malaysia

SIRIM Academy Logo

MS Excel (Beginner)

Microsoft Excel remains the go-to spreadsheet software for millions of people around the world. If you have been meaning to learn Excel for years but have not quite got around to it, or if you use Excel every day but feel lost when you log in, then this course is for you.

by SIRIM Academy [Claim Listing ]
Ted Learning Logo

Microsoft Excel Macro VBA Programming (Advanced)

This course covers aspects of developing macros for practical applications. New and advanced tools have been included in this course.

by Ted Learning [Claim Listing ]
PSDC (Penang Skills Development Centre) Logo

Interactive Business Presentation With Microsoft Powerpoint (Basic Level)

This is a beginner’s course and aims to give the new user who want to learn the beginning-level PowerPoint skills.

by PSDC (Penang Skills Development Centre) [Claim Listing ]
CitiPro Institute Logo

MS Office 365

MS Office 365 course is offered by CitiPro Institute for all skill levels. Our program is designed to fit your busy schedule while providing high-quality education and boosting your professional skills.

by CitiPro Institute [Claim Listing ]
Gem Consultancy Logo

Microsoft PowerPoint

Microsoft PowerPoint training is offered by Gem Consultancy. We emphasise on practical training through setting conditions for how learner can practice what they have learned and performance be evaluated.

by Gem Consultancy [Claim Listing ]

© 2024 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy