What are the top excel functions management consultants use?

Asked by Last Modified  

6 Answers

Learn Microsoft Excel Training

Follow 0
Answer

Please enter your answer

BPO Project Manager

there are more than 600 functions inbuilt in excel, with or without a add on. most consultants turn towards kudos its much simpler and GUI friendly as they wont have time to write complicated functions. mostly they use vlookup, pivot, if , else, or , and , sum, count, proper, concatenate etc..
Comments
Dislike Bookmark

IF and vlookup and concenrate and sum and avg and count and sumifs and countifs
Comments
Dislike Bookmark

Software Professional Trainer with 26+ years of Experience in Software Design and Development

Index Match Index with Match function ( 2D lookup) Lookup Choose Left Right Mid Find Search Trim Still more functions are there. Combination of excel function will make more powerful functions.
Comments
Dislike Bookmark

B Pharm,M.S.

You can calculate NPV and IRR to determine the feasibility of project : NPV(rate, value1, , …) Determine the net present value using cash flows that occur at regular intervals, such as monthly or annually. Each cash flow, specified as a value, occurs at the end of a period. If there is...
read more
You can calculate NPV and IRR to determine the feasibility of project : NPV(rate, value1, [value2], …) Determine the net present value using cash flows that occur at regular intervals, such as monthly or annually. Each cash flow, specified as a value, occurs at the end of a period. If there is an additional cash flow at the start of the first period, it should be added to the value returned by the NPV function. See Example 2 in the NPV Help topic. XNPV(rate, values, dates) Determine the net present value using cash flows that occur at irregular intervals. Each cash flow, specified as a value, occurs at a scheduled payment date. IRR(values, [guess]) Determine the internal rate of return using cash flows that occur at regular intervals, such as monthly or annually. Each cash flow, specified as a value, occurs at the end of a period. IRR is calculated through an iterative search procedure that starts with an estimate for IRR — specified as a guess — and then repeatedly varies that value until a correct IRR is reached. Specifying a guess argument is optional; Excel uses 10% as the default value. If there is more than one acceptable answer, the IRR function only returns the first one it finds. If the IRR doesn't find any answer, it returns a #NUM! error value. Use a different value for the guess if you get an error or if the result is not what you expected. Note A different guess might return a different result if there is more than one possible internal rate of return. read less
Comments
Dislike Bookmark

Tutor

Vlookup,Index, match ,trim ,count and sum family plus data validation - you must know these functions else wont be able to produce great results. Pivot and charts are evergreen. You can visit my website www.excelvbalover.com to see 180 plus free videos and you will love excel like never before. let me...
read more
Vlookup,Index, match ,trim ,count and sum family plus data validation - you must know these functions else wont be able to produce great results. Pivot and charts are evergreen. You can visit my website www.excelvbalover.com to see 180 plus free videos and you will love excel like never before. let me know if you also need training on that. Details are available on my website read less
Comments
Dislike Bookmark

Finance & Accounts Expert

Be it a consultant or any corporate employee who deal with financials at majority, here are the functions they do use in day to day life: 1. Sum 2. If 3. VLOOKUP 4. Sumif 5. Subtotal
Comments
Dislike Bookmark

View 4 more Answers

Related Questions

How to use the h look up in excel worksheet ???
Horizontal lockup
Sandeep
Linear Programming in Excel ?? Can someone can solve just 1 question of Linear Programming in Excel ?? I am ready to pay. Thanks
Hi Gary I might be able to help you please share your question with me and hopefully would be able to help you on the same.
Garry
0 0
5
What is the difference between an MS word, an MS Excel, and an MS PowerPoint?
All three are applications of Microsoft office. MS Word is a word processing application, where you can type anything you want, primarily used for creating documents, brochures etc. MS Excel is a spreadsheet...
Krishna
0 0
5
Do u know Power Pivot Deeply ? If Yes, Kindly reply... Regards
yes
Himanshu
Are there any excel and VBA coaching centres at As Rao Nagar?
nope
V

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

Ask a Question

Related Lessons

Some Excel Functions
You need to know about these following functions which are based on Microsoft Excel 2010.1. Speedily Move and Copy Data in Cells:-If you want to move one column of data in a spreadsheet, the fast way...
I

Icreative Solution

0 0
0
Microsoft Outlook
Microsoft Outlook is the preferred email client used to access Microsoft Exchange Server email. Not only does Microsoft Outlook provide access to Exchange Server email, but it also includes contact, calendaring...

Itech Analytic Solutions

0 1
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
Importance of dash board in Business/org
A business intelligence (BI) dashboard is a data visualization tool that consolidates and displays the current status of metrics and key performance indicators (KPIs) for an organization, department or...

Shashank Maheshwari

2 0
0
VLOOKUP and LIST Creation Explained
.) This table is in the range A1:D4. You want to find the salary of employee with ID 102. Excel =VLOOKUP(102, A1:D4, 4, FALSE) 102: The Employee ID (your lookup_value). A1:D4: The table containing...
G

Ganesh S.

0 0
0

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 >

Make a Career as a BPO Professional

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 >

8 Hottest IT Careers of 2014!

Whether it was the Internet Era of 90s or the Big Data Era of today, Information Technology (IT) has given birth to several lucrative career options for many. Though there will not be a “significant" increase in demand for IT professionals in 2014 as compared to 2013, a “steady” demand for IT professionals is rest assured...

Read full article >

What is Applications Engineering all about?

Applications engineering is a hot trend in the current IT market.  An applications engineer is responsible for designing and application of technology products relating to various aspects of computing. To accomplish this, he/she has to work collaboratively with the company’s manufacturing, marketing, sales, and customer...

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