UrbanPro
Login Ask & Answer Success Stories Paid Courses Free Classes Tuition & Classes Fees Write a Review All Categories Help Center
Post your Learning Need Signup as a Tutor
✕

Popular Cities

Bangalore

Hyderabad

Delhi

Mumbai

Chennai

Pune

Kolkata

Gurgaon

Ahmedabad

Jaipur

Noida

✕

Learn Microsoft Excel Training from the Best Tutors

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

Book a Free Demo

Microsoft Excel > Learn Microsoft Excel Training > What are the top excel functions management consultants...
✕

Search in

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

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

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

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

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

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

View 4 more Answers

Related Questions

How do I perform the basic functions of Microsoft Excel, such as Open, Save, and Print?
ctrl+O - Open, ctrl+S-save, ctrl+P-print
Jitendra
0 0
5
Do u know Power Pivot Deeply ? If Yes, Kindly reply... Regards
yes
Himanshu

Make A Excel Software Challenge: To Track Time Records To Enhance Daily Output Of Staff
Through Time Sheets
Bikram Jeet
0 0
7
How to write square in excel?
Format > Cells > Font > check Superscript then type '2' which will appear as superscript Format > Cells > Font > uncheck Superscript
Dharmendra
0 0
9
What is Microsoft Excel?
It is an Application which consist of Spread Sheet for creating Document based on requirement
Swati
0 0
5

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

Ask a Question

Related Lessons

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
What Are Olap, Molap, Rolap, Dolap, Holap?
1. OLAP: On-Line Analytical Processing: Designates a category of applications and technologies that allow the collection, storage, manipulation and reproduction of multidimensional data, with the goal...

ITech Analytic Solutions

0 0
0
Excel Tip: VLOOKUP formula limitations
1. Vlookup is not case-sensitive 2. If Lookup value has duplicates in the lookup column, then it returns 1st found value 3. Vlookup cannot pull values which are on the left side from Lookup column 4....

Karthik Dale

0 0
0
VBA Function - RIGHT
RIGHT function in VBA returns the Specified number of characters from the end of a text string Syntax: Right(String,Length) Sub RIGHT_1() Dim mystring As String mystring = "Narendra Modi" MsgBox Right(mystring,...

Karthik Dale

0 0
0
What Is Phython?
Python is a general-purpose interpreted, interactive, object-oriented, and high-level programming language. It was created by GuidovanRossum during 1985- 1990. Like Perl, Python source code is also available...

ITech Analytic Solutions

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 Delhi
Microsoft Excel Training classes in Bangalore
Microsoft Excel Training classes in Mumbai
Microsoft Excel Training classes in Hyderabad
Microsoft Excel Training classes in Pune
Microsoft Excel Training classes in Chennai
Microsoft Excel Training classes in Kolkata
Microsoft Excel Training classes in Gurgaon
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
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

ThinkVidya Learning Pvt Ltd © 2010-2024All Rights Reserved