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

Excel formulas in advance level?
Hi Manoj, There are over 500+ formulas in Ms Excel. Ms excel is very vast application. There is no basic & advanced level in Excel but we have divided into it. That is depends on work type, even we can...
ManojGS
VBA Training institutes in Bangalore?
Yes we are providing training of VBA. CBK Infotech India pvt Ltd, near MSREC Road, Infron of Biriani House. Mathikere Bangalore
Lekhnath Bhandari
My name is Kartik, I have 6 years of experience in Data analysis. I have experience on BI, Trackwise, Siebel and Oracle, Ms Access for fetching reports and for visualisation of data we use MS excel. Could please suggest me a certification or course, which can help me in career growth and to improve my skill set? I have a bent towards Analytics.
Hi Kartik, It is very good to know your experience in the field of Data Analytics. You just master those skills so that it is easy to sell your skill. I believe you are good at BIG DATA. If you possess...
Kartik
0 0
5
Hi I want to use conditional formatting for 4 cell and where they have - value too. So, I want anything in the range which are in - in a colour and positive in one single colour. How can that happen so can anyone please help me on it?
1. First you have to select the range of cells where you want to apply conditional formatting 2. You have to select conditional formatting from Home tab in Excel window 3. There will be many categories,...
Charan
Which course can be related to MIS executives, Since I have past experience in data base related job I want to try for MIS profile. So kindly suggest me which course suits me for the same profile.
Hi, You can check our course - Analyse and Visualize with Excel. Excel is the most popular tools used by analyst and MIS manager for getting insights from data. Create powerful Dashboards to enable data driven decision making.
Martin

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

Ask a Question

Related Lessons

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

Ninety-nine Excel Academy

0 0
0
How to do Advanced filter in Excel

Ujjal Goswami

0 0
0
Cell Properties
G

Gagan G.

0 0
0
Data Analysis with MS Excel Filter - Top Performers, Bottom Performers, Above Average Performers, Below Average Performers!
In the following, You would find lesser-known, unexplored yet Powerful Features of Filter. Please refer to sample dataset below: To do Data Analysis:Step 1) Apply Filter on the dataset.Step 2) In Sales...

Ankur Sharma

1 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