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

Ted Learning Logo

High Impact PowerPoint Presentation

This course covers the essential features of ms powerpoint. It is meant for users wanting to learn how to create, enhance & customise their presentations. Concept & design tips on creating an effective presentation to capture the audience attention will be discussed in this course.

by Ted Learning [Claim Listing ]
Intellects Global Learning Logo

Microsoft Excel (Amazing Macro)

Microsoft Excel training is offered by Intellects Global Learning. We are committed to continually improve the effectiveness and efficiency of our processes, so as to provide outstanding consulting and training services to our customers.

by Intellects Global Learning [Claim Listing ]
IPA Training Logo

Powerful PowerPoint Presentation & Data Storytelling

Microsoft PowerPoint is a presentation software that enables users to create engaging presentations. PowerPoint enables users to add animation and effects to slideshow elements.

by IPA Training [Claim Listing ]
Knowledge Hub Logo

Using Microsoft Application to Enhance Office Administration

This course is designed for people who have a basic knowledge of Using Microsoft Application to Enhance Office Administration and who want to increase their knowledge and know the practical uses of Using Microsoft Application to Enhance Office Administration.

by Knowledge Hub [Claim Listing ]
Sunway College Kuching Logo

Using The Internet

This course will guide the learner through the main uses of the Internet. The learner will understand and be able to efficiently use search engines, Email, E-Commerce and Web pages.

by Sunway College Kuching [Claim Listing ]

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