Microsoft Excel Formulas & Functions

by Elite Indigo Claim Listing

Microsoft Excel is a powerful spreadsheet and data analysis program with wide-ranging capabilities. Attending a live Excel course is a good way to quickly and efficiently learn Excel. There are 3 primary reasons why you should learn Excel and how learning Excel is helpful for your career.

Price : Enquire Now

Contact the Institutes

Fill this form

Advertisement

Elite Indigo Logo

img Duration

2 Days

Course Details

Microsoft Excel is a powerful spreadsheet and data analysis program with wide-ranging capabilities. Attending a live Excel course is a good way to quickly and efficiently learn Excel. There are 3 primary reasons why you should learn Excel and how learning Excel is helpful for your career.

 

Objectives:

  • Learning Excel increases your value in the job market
  • Excel training makes you more efficient
  • Conditional formatting allows you to apply format to a cell or a range of cells based on a given criteria which will make data easier to read
  • Pivot tables and charts will allow you to quickly identify trends in large datasets and inform business decisions
  • Learning Excel prepares workers for Data centric positions

 

Course Outline:

  • Module A: About Formula
  • Operators in Formulas
  • Cell and Range Reference
  • Convert Formulas to Values
  • Hiding Formulas
  • Module B: About Range Names
  • Naming Methods
  • Create Multisheet Names
  • Working with Range and Cell Names
  • Problems with Range Names
  • Use Functions to Name a Range
  • Module C: About Worksheet Functions
  • Function Argument Types
  • Ways to Enter Functions
  • Text Functions
  • Data & Time-Related Functions
  • Counting & Summing Functions
  • Lookup Functions
  • Database Functions
  • Rounding Numbers
  • Module D: About Array
  • Introduction on Array Formulas
  • Dimensions of Array
  • Working with Array Formulas
  • Using Single-Cell and Multicell Array Formulas
  • George Town Branch

    51, Jalan Nuri 6, George Town

Check out more MS Excel courses in Malaysia

iLearnic Logo

Microsoft PowerPoint (2013)

Microsoft PowerPoint training is offered by iLearnic. iLearnic understands your training challenges and has solutions to match your specific needs, We analyse industry needs and spearhead innovative ideas with the same level of quality, energy and drive for success.

by iLearnic [Claim Listing ]
Anugerah HRM Consultant Logo

Microsoft Excel (Advance Functions And Formulas)

Microsoft Excel course is offered by Anugerah HRM Consultant. We are committed to provide world-class Consulting and Capability Building Services with highly qualified, experience consultants and trainers.

by Anugerah HRM Consultant [Claim Listing ]
Do Great SDN BHD Logo

Microsoft Office: Word/ Excel/ Powerpoint

A Microsoft Office: Word, Excel, and PowerPoint course is offered by Do Great SDN BHD.  We are an organization specifically established to provide training, coaching, and relevant support on all aspects in relation to management systems, improvement tools, technical skills, and soft skills.

by Do Great SDN BHD [Claim Listing ]
FMM Institute Logo

Microsoft PowerPoint 2010 (Advance)

Participants will learn how to enhance a presentation by using custom clip art, animation, and movies and work with embedded and imported objects by using Microsoft applications.

by FMM Institute [Claim Listing ]
Infotek Logo

Microsoft PowerPoint

Microsoft Powerpoint training is offered by Infotek. These programmes categories are for those students who are without any computer knowledge or so-called refresh programme.

by Infotek [Claim Listing ]

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