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

Ted Learning Logo

Financial Modelling in Excel

The most fundamental and widely sought after skills in the finance industry is financial modelling. The microsoft excel financial model depicts the financial statement and investment analysis

by Ted Learning [Claim Listing ]
G-Tec Computer Education Sdn. Bhd Logo

MS Word

A successful database is efficient, quick, accurate, and easy to use. This course covers how to create such a database with MS Word.

by G-Tec Computer Education Sdn. Bhd [Claim Listing ]
Malaysian Export Academy Sdn Bhd Logo

Microsoft Excel Intermediate

In this Microsoft Excel Intermediate training class, you will improve your skill set by learning to work with advanced formulas, lists, and illustrations. You will also work with charts and advanced formatting techniques, including styles.

by Malaysian Export Academy Sdn Bhd [Claim Listing ]
  • Price
  • Start Date
  • Duration
NexTrain Logo

Microsoft PowerPoint (Intermediate Level)

Microsoft PowerPoint training is offered by NexTrain. NexTrain Consultancy Sdn. Bhd. was established with the prime objective to train and upgrade the technical and management skills of the Malaysian workforce in manufacturing industries and commercial sectors.

by NexTrain [Claim Listing ]
AC Interactive Solutions Sdn Bhd (ACIS) Logo

Microsoft Office Specialist (Word)

Microsoft Office Specialist (Word) training is offered by AC Interactive Solutions Sdn Bhd (ACIS). Our passionate team of expert trainers is qualified and highly experienced in countless training fields.

by AC Interactive Solutions Sdn Bhd (ACIS) [Claim Listing ]

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