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

Corporate Frontier Logo

Be Innovative With Microsoft Excel

Microsoft Excel is one of the most widely used spreadsheet and data management programs in organisations today. An understanding of Excel can be a critical factor in being able to carry out a variety of responsibilities.

by Corporate Frontier [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 ]
Sarawak Skills Logo

Microsoft Excel (Basic & Intermediate)

Microsoft Excel course is offered by Sarawak Skills. Sarawak Skills is the preferred provider of Technical and Vocational Education and Training (TVET) for industrial workers and school leavers. 

by Sarawak Skills [Claim Listing ]
FAME International College Logo

IT Training

This training programme is designed for those who are interested to strengthen IT functionality in Microsoft Excel, Microsoft Access and Microsoft Power Point for business functions, lead date analysis, productivity measurement and etc.

by FAME International College
Impact Volution Logo

Microsoft Word (Foundation, Intermediate, Advanced Level)

Microsoft Word  course is offered by Impact Volution. Impact-Volution Training and Consultancy Sdn Bhd (IV) and our group of affiliates always striving toward creating impact to the clientele across Asia Pacific that we served.

by Impact Volution [Claim Listing ]

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