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

United Vision Academy Logo

Microsoft Excel

You’re beyond the basics, so dive right in and really put Excel formulas and functions to work! This supremely organized program help participants increase their data analysis capabilities using Excel 2003, 2007, or 2010—and challenge yourself to new levels of mastery.

by United Vision Academy [Claim Listing ]
New Horizons Malaysia Logo

Microsoft PowerPoint

Use PowerPoint designer to communicate your stories or ideas in a compelling way. Regardless of your design or technical capabilities, PowerPoint empowers you to captivate and persuade audiences with beautiful built-in themes, animation features and a professional presentation mode.

by New Horizons Malaysia [Claim Listing ]
Modoku Tech Sdn Bhd Logo

Microsoft PowerPoint 2019 Advanced

This Advanced Microsoft PowerPoint 2019 training class is for PowerPoint 2019 users who want to build upon their basic skills. Students will use advanced techniques such as working with Masters and Special Effects within their presentations.

by Modoku Tech Sdn Bhd [Claim Listing ]
G-Tec Computer Education Sdn. Bhd Logo

MS Office Basic

This course mainly focuses on people who don't have any knowledge of computers. The basics of computers and MS Office are covered in this course. Also making the students familiar with Internet and emailing.

by G-Tec Computer Education Sdn. Bhd [Claim Listing ]
MindMapper Solution Sdn Bhd Logo

Analyzing Database With MS Access (Level 1)

Analyzing Database with MS Access course is offered by MindMapper Solution Sdn Bhd. Our team has more than 15 years of experience in management and training. We have extensive skills in all aspects of implementation and operation to meet your requirements.

by MindMapper Solution Sdn Bhd [Claim Listing ]

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