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

IC Training & Consultancy ICTC Logo

MS Excel (Level 1)

MS Excel course is offered by IC Training & Consultancy ICTC. Our experts have years of experience working with Microsoft Office and Google Suite, and we’re passionate about helping others make the most of their Microsoft Office and Google Suite software.

by IC Training & Consultancy ICTC [Claim Listing ]
De Novo Training And Consultancy Logo

Mastering Microsoft Excel (Intermediate)

Microsoft Excel has emerged as a financial tool, providing high spreadsheet capabilities for managing financial data and accounting tasks effectively.

by De Novo Training And Consultancy [Claim Listing ]
Professional IT Academic Sdn Bhd Logo

Microsoft Access (VB Applications)

Microsoft Access course is offered by Professional IT Academic Sdn Bhd. Professional IT Academic Sdn Bhd ensures that Pro IT programs and activities are properly regulated in keeping with its vision and motto as “Creative, Innovative & Productive” PROIT, through its programs.

by Professional IT Academic Sdn Bhd [Claim Listing ]
New Horizons Malaysia Logo

Microsoft Access Training

Learn the basics, such as how to create a database, navigate the Access application environment or organize data stored within Access tables. Or, graduate to more advanced skills like form customization, querying and sharing data across applications.

by New Horizons Malaysia [Claim Listing ]
Plast Koncept Training & Konsultancy Plt Logo

Microsoft PowerPoint (Intermediate / Advanced Level)

Microsoft PowerPoint training is offered by Plast Koncept Training & Konsultancy Plt. We provide highly customized In-house programs according to organizational requirements are available. 

by Plast Koncept Training & Konsultancy Plt [Claim Listing ]

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