UrbanPro

Learn Microsoft Excel Training from the Best Tutors

  • Affordable fees
  • 1-1 or Group class
  • Flexible Timings
  • Verified Tutors

Search in

What are the top excel functions management consultants use?

Asked by Last Modified  

Follow 0
Answer

Please enter your answer

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

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

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

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

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

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

View 4 more Answers

Related Questions

What does the VLOOKUP in MS Excel function do?
Basically, VLOOKUP lets you search for specific information in your spreadsheet. For example, if you have a list of products with prices, you could search for the price of a specific item.
Nayana
1 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
What is the use of Format painter in MSExcel?
In Microsoft Excel, the Format Painter is a tool that allows you to quickly copy formatting from one cell or range of cells and apply it to another cell or range. It helps you maintain a consistent...
Kirthi
0 0
5
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

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

Ask a Question

Related Lessons

What Are Macros?
i. Macros are little programs that run within Excel and help automate common repetitive tasks. Macros are one of Excel's most powerful, yet underutilized feature. Using macros, you can save hours and boost...

Four Things You Can Do With Enter Key In Excel
You will save a lot of time on a daily basis by using the Enter key in these 4 ways. You may think, what is more to learn in using the Enter key in Excel? Read further to know what are the 4 ways and...

Excel Database Functions List
Excel Database Functions List Database Functions DAVERAGE Calculates the average of values in a field of a list or database, that satisfy specified conditions DCOUNT Returns...
U

Uma Sahu

0 0
0


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,...

Nagadarshan

0 0
0

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 >

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 >

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 >

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
X

Looking for Microsoft Excel Training Classes?

The best tutors for Microsoft Excel Training Classes are on UrbanPro

  • Select the best Tutor
  • Book & Attend a Free Demo
  • Pay and start Learning

Learn Microsoft Excel Training with the Best Tutors

The best Tutors for Microsoft Excel Training Classes are on UrbanPro

This website uses cookies

We use cookies to improve user experience. Choose what cookies you allow us to use. You can read more about our Cookie Policy in our Privacy Policy

Accept All
Decline All

UrbanPro.com is India's largest network of most trusted tutors and institutes. Over 55 lakh students rely on UrbanPro.com, to fulfill their learning requirements across 1,000+ categories. Using UrbanPro.com, parents, and students can compare multiple Tutors and Institutes and choose the one that best suits their requirements. More than 7.5 lakh verified Tutors and Institutes are helping millions of students every day and growing their tutoring business on UrbanPro.com. Whether you are looking for a tutor to learn mathematics, a German language trainer to brush up your German language skills or an institute to upgrade your IT skills, we have got the best selection of Tutors and Training Institutes for you. Read more