What are the common and popular formula, necessary to learn ms excel?

Start networking and exchanging professional insights

Register now or log in to join your professional community.

Next Question:
Could you please specify any situation you have applied conditional formatting i...
Posted by:
Muhammed Muzammil
29-September-2013

Data Entry Microsoft Office

Question added by MUHAMMAD SHAKEEL AKHTAR , Vehicle inspector , BSL pvt ltd
Date Posted: 2014/01/03

Upvote (1) Views (4) Followers (0) Answers (2) Report Question

Write an Answer
Register now or log in to answer.

2 Answers

Mohammed Yaseen MBA PMP®

by Mohammed Yaseen MBA PMP® , Commercial Officer , Hayat Communications

Conditional

Create conditional formulas

Check if a number is greater than or less than another number

Display or hide zero values

Hide error values and error indicators in a cell

Lookup

Look up values in a range

Date and Time

Calculate the difference between two dates

Calculate the difference between two times

Count days before a date

Show dates as the day of the week

Insert the current date and time in a cell

Insert Julian dates

Financial

Calculate a running balance

Calculate a compound annual growth rate (CAGR)

Statistical

Calculate the average of numbers

Calculate the median of a group of numbers

Calculate the mode of a group of numbers

Math

Subtract numbers

Multiply numbers

Calculate percentages

Raise a number to a power

Calculate the smallest or largest number in a range

Calculate the factorial of a number

Create a multiplication table

Upvote (4)

Downvote Reply () Report

Amir Mahmoud - CPIM

by Amir Mahmoud - CPIM , Planning Lead , Americana Group

You can visit "www.Freelearn110.com" it's a great website that enable you to learn anything you want in Microsoft office or photoshop .... ETC without instructor.

Upvote (0)

Downvote Reply () Report

Popular Searches

Engineers Jobs Sales Executive Jobs Accountant Jobs Engineering Technicians Jobs Software Engineer Jobs

Write Your Answer

More Questions Like This

What is the function of Macros in MS Excel ?
Top Answer: If you have to repeat same set of tasks on daily basis in excel for example fathering data or etc then it ... See More

Answers (154)
What is the function of Macros in MS Excel ?
Top Answer: If you have to repeat same set of tasks on daily basis in excel for example fathering data or etc then it ... See More

Answers (154)
What is the function of Macros in MS Excel ?
Top Answer: If you have to repeat same set of tasks on daily basis in excel for example fathering data or etc then it ... See More

Answers (154)
How to change date format from dd-mm-y to dd-mm-yy in formula bar of ms-excel?
Top Answer: <p>On format cell you can select an option which date format and this format cells can be found in ... See More

Answers (3)

Do you need help in adding the right keywords to your CV? Let our CV writing experts help you.

Get Help