How can we enter a formula in MS Excel?

Asked by Last Modified  

3 Answers

Follow 2
Answer

Please enter your answer

Civil Engineer trainer with 10 Years Experience

It's depends on which formula you have to type... In general select a cell and type the formula that's all For ex. To sum all number A1 to A5 Then formula will be =Sum(A1:A5)
Comments

Personalised training for your needs.

Hi Ashwini, There are two ways to use formulas in Excel. 1. In any cell, put an = sign and start typing initial letters of the operation you want to perform for e.g. =count(range) 2. Use the RIbbions menu and click on Formulas tab. After that use the Insert Function and search for the forumula you...
read more
Hi Ashwini, There are two ways to use formulas in Excel. 1. In any cell, put an = sign and start typing initial letters of the operation you want to perform for e.g. =count(range) 2. Use the RIbbions menu and click on Formulas tab. After that use the Insert Function and search for the forumula you want to apply. Let me know if you need additional clarification and I will be happy to teach. Regards/ read less
Comments

I am online Quran teacher 7 years

Hi Ashwini, There are two ways to use formulas in Excel. 1. In any cell, put an = sign and start typing initial letters of the operation you want to perform for e.g. =count(range) 2. Use the RIbbions menu and click on Formulas tab. After that use the Insert Function and search for the forumula you want...
read more
Hi Ashwini, There are two ways to use formulas in Excel. 1. In any cell, put an = sign and start typing initial letters of the operation you want to perform for e.g. =count(range) 2. Use the RIbbions menu and click on Formulas tab. After that use the Insert Function and search for the forumula you want to apply. Let me know if you need additional clarification and I will be happy to teach. Regards/ read less
Comments

View 1 more Answers

Related Questions

Are there any VBA tutors around Secunderabad?
Tell me your requirement. I shall guide u online.
Profile Photo
V
I am looking to learn immediately Advanced Excel & VBA Macros. Please provide the Institute contact details and tutor availability in week ends ( Sat- Sun) .
Hi Pratap, Would you please let me know your educational background as to know VBA Macros , you must have good hands on Programming...and if you are novice or not from it background then I suggest you...
Profile Photo
Prathap
Excel formulas in advance level?
In excel we have lot of staff and formulas, we can learn based on your requirement, in excel vlookup, hlookup, pivot table if condition, sumif ifs, countA, if ifs, data validation, etc. and we have to...
Profile Photo
ManojGS
Is there any free software to convert a word file to PDF?
You don't need any software. Just go to "Save as" and when the save window pops up, below the file name you will find the option to select file type, here click on the drop down arrow and change from...
Profile Photo
Gaurang
0 0
View Comments7

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

Ask a Question

Related Lessons

Advanced Excel and VBA concept
In this video, learn about Advanced Excel: - Data Input and Hidden Features, - Worksheet Navigation, - Excel Formulas & Functions, - Data Cleaning and Formatting. VBA and its useful Built-in Functions,...
N

Nagadarshan

0 0
View Comments0

Cell Properties
G

Gagan G.

0 0
View Comments0

Excel Keyboard Shortcuts Daily Usefull Keys
Excel KeyBoard Shortcuts Daily Usefull keys: CLTR A-Z Shift SELECT.ETC ALT All Tool Keys CLTR A Select All Shift+F11 Add New Sheet CLTR C Copy ALT...
Profile Photo

SQL Join Types
There are four basic types of SQL joins: inner, left, right, and full. The easiest and most intuitive way to explain the difference between these four types is by using a Venn diagram, which shows all...
Profile Photo

Learning Microsoft Excel
All Excel courses that are currently being offered online as well as classroom sessions have a lot in common – In fact they are all the same thing. Beginner, Intermediate, Advanced, VBA etc. The...
Profile Photo

Recommended Articles

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 >

Business Process outsourcing (BPO) services can be considered as a kind of outsourcing which involves subletting of specific functions associated with any business to a third party service provider. BPO is usually administered as a cost-saving procedure for functions which an organization needs but does not rely upon to...

Read full article >

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 >

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 >

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