How to use excel formula?

Asked by Last Modified  

8 Answers

Learn Microsoft Excel Training

Follow 0
Answer

Please enter your answer

Nachiketa Bera

Advanced Excel, VBA Automations, Reporting Insight

Excel formula can be used from within the cell (just double click a cell to insert formula) or select the cell where you want to enter formula and click the formula bar on top which says fx. You can also click fx (Insert Function Button) to open the function window and search for the required formula...
Comments
Dislike Bookmark

Excel Basics, Excel Advance and Excel Dashboards professional trainer, Over 4 years training experience in MS Excel

To enter a formula, execute the following steps. 1. Select a cell. 2. To let Excel know that you want to enter a formula, type an equal sign (=). 3 for ex. = A1+A2
Comments
Dislike Bookmark

Tutor

Its more of a practical question you are asking. To use the formula you need to understand the language of excel as in the parameters asked in a formula. Like vlookup has 4 parameters /input values and similarly for every formula you have different parameters. Go and watch my website excelvbalover.com...
read more
Its more of a practical question you are asking. To use the formula you need to understand the language of excel as in the parameters asked in a formula. Like vlookup has 4 parameters /input values and similarly for every formula you have different parameters. Go and watch my website excelvbalover.com to know more on this. i have 180 plus free videos for you there. if interested in training , let me know please. read less
Comments
Dislike Bookmark

Expert in MS Excel

You can use formulae by below three methods: a) Directly Go to Formulae tab in menu bar b) Insert function by Clicking on fx c) If you remember the formulae you can directly use it by using " = "sign
Comments
Dislike Bookmark

Microsoft Excel

Depends upon the situation. Please elaborate your question more specificly
Comments
Dislike Bookmark

Finance & Accounts Expert

Navigate through this path: Formulas Menu -> Insert Function (fx) -> Search for a function / formula / Otherwise select from the list of functions available over there like SUM, AVERAGE, IF, COUNTIF, MAX, HYPERLINK etc.,
Comments
Dislike Bookmark

Tutor

Scroll through the list of excel formulas available in the tab "Formula", Select the formula you wish to use. Enter the fields available, and press ok.
Comments
Dislike Bookmark

Ganesh Pawar - Computer Training (Windows and Microsoft Products)

Start your formula by "=" Equalto sign
Comments
Dislike Bookmark

View 6 more Answers

Related Questions

What is shortcut to rename the spreadsheet name?
Alt+H+O+R
Umang
Are there any VBA tutors around Secunderabad?
Tell me your requirement. I shall guide u online.
V
How to create pivot table in excel?
If you wan to analyze the only data that is on your sheet. First be sure all columns has header after than select any cell from your data and go to insert tab and click on pivot table.
Rahul
0 0
6
Can you make a Software Base On Excel, that records Automatic Billing Information Just Like A POS System. Suppose our Customer requires following: An Excel Software for POS, with following functionalities: It should have an "Open List" for capturing product related information. It should have automatic bill numbering It should have Printable bill It should have a customer database form and recording It should take not more than 30 minutes of training to learn and operate Can you make that? How much time will it take to you to make it completely?
Maybe yes! I'll require a bit more information to deep dive in it.
Bikram Jeet
0 0
9
How to develop skill on Excel Macros VBA. I want to be perfect on VBA. As soon as I see the problem.. within minutes it should come in my mind what code i have to write for this situation...I know its not that easy.. but I feel that its not hard too. I need advise as to what I have to do.. Eagerly waiting for the encouraging responses from all the teachers& trainers..
You need to understand the grammar of VBA Language first like collections ,objects ,methods and properties,syntax of different objects and their uses etc ..Once you are clear with these concepts ,you can...
Sandeep

Now ask question in any of the 1000+ Categories, and get Answers from Tutors and Trainers on UrbanPro.com

Ask a Question

Related Lessons

HERE TODAY WE WILL USE THE SUMIFS FUNCTION.
A B C D 1 NAME PRODUCT NAME TOTAL AMOUNT 2 SAURABH WASHING MACHINE 4165 3 MANIPAL MI PHONE 4803 4 ANJALI SAMSUNG MOBILE 4610 5 UMA NOKIA PHONE 4441 6 SHANKER T.V 3765 7 NARESH ...

Saurabh Sharma

0 0
0
Advance Excel Training
This is reminder and follow database, ensure to priorities you work distribution
K

Kartik Dindi

0 0
0
Pivot table - Transform numbers in calculated field
How to convert the absolute numbers in pivot table into Lakhs, Millions, Trillions without adding a spare column in the data source. Name the field in the Calculated field and apply the formula by Double-clicking...

Phanitha P.

0 0
0
Cell Properties
G

Gagan G.

0 0
0
Shortcut for adding big data or Columns in MS excel
1. Simply click on the next cell of column where you want the sum. 2. Press Alt and = keys together. 3. It will show the sum and range of sum. 4 Click Enter key and you will get sum of the column.

Kimsi J.

0 0
1

Recommended Articles

Why Should you Learn Microsoft Office

Microsoft Office is a very popular tool amongst students and C-Suite. Today, approximately 1.2 billion people across 140 countries use the office programme. It is used at home, schools and offices on a daily basis for organizing, handling and presenting data and information. Microsoft Office Suite offers programs that can...

Read full article >

Learn Hadoop and Big Data

Hadoop is a framework which has been developed for organizing and analysing big chunks of data for a business. Suppose you have a file larger than your system’s storage capacity and you can’t store it. Hadoop helps in storing bigger files than what could be stored on one particular server. You can therefore store very,...

Read full article >

Why Should you Become an IT Consultant

Information technology consultancy or Information technology consulting is a specialized field in which one can set their focus on providing advisory services to business firms on finding ways to use innovations in information technology to further their business and meet the objectives of the business. Not only does...

Read full article >

Learn Microsoft Excel

Microsoft Excel is an electronic spreadsheet tool which is commonly used for financial and statistical data processing. It has been developed by Microsoft and forms a major component of the widely used Microsoft Office. From individual users to the top IT companies, Excel is used worldwide. Excel is one of the most important...

Read full article >

Find Microsoft Excel Training classes near you
Microsoft Excel Training classes in Bangalore
Microsoft Excel Training classes in Delhi
Microsoft Excel Training classes in Mumbai
Microsoft Excel Training classes in Hyderabad
Microsoft Excel Training classes in Chennai
Microsoft Excel Training classes in Pune
Microsoft Excel Training classes in Gurgaon
Microsoft Excel Training classes in Kolkata
Microsoft Excel Training classes in Noida
Microsoft Excel Training classes in Ghaziabad

Looking for Microsoft Excel Training classes?

Learn from the Best Tutors on UrbanPro

Are you a Tutor or Training Institute?

Join UrbanPro Today to find students near you