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

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