List of Excel Functions (2003, 2007, 2010, 2013)

Formulas, Excel2013

Hi there,

 

When compared to Excel Functions with human parts, we can compare it with Human Brain. See what others are. There are many reasons why I compared and why we can accept. However, lets proceed to see the list of functions in all versions from 2003 to 2013 (461 functions).

 

COMPATIBILITY FUNCTIONS:

BETA.DIST

BETAINV

BINOMDIST

CHIDIST

CHIINV

CHITEST

CONFIDENCE

COVAR

CRITBINOM

EXPONDIST

FDIST

FINV

FTEST

GAMMADIST

GAMMAINV

HYPGEOMDIST

LOGINV

LOGNORMDIST

MODE

NEGBINOMDIST

NORMDIST

NORMINV

NORMSDIST

NORMSINV

PERCENTILE

PERCENTRANK

POISSON

QUARTILE

RANK

STDEV

STDEVP

TDIST

TINV

TTEST

VAR

VARP

WEIBULL

ZTEST

 

Pages: 1· 2· 3· 4· 5· 6· 7· 8· 9· 10· 11· 12· 13

Meet Our Excel MVP's (110)

weekend-special

Hi there,

 

Every Excel Enthusiast dreams.

Every Excel Geek Works.

Every Excel user Learns.

 

list of mvp's in excel


I am speaking about EXCEL MVP's. MVP is defined as "Most Valuable Professional". This is an award given to all the excel users who contribute their knowledge to the world of people. This award is not only for Excel but for all the products of Microsoft.

 

This is a prestigious award which is valid for 1 long year where the awardee can display the logo of MVP on their community or blog or website. Every enthusiast will have a dream to achieve this level, which is the highest level any one can reach. 

 

There are 127 Excel MVP's in this world for the year 2014-2015. However, you have an opportunity to meet or to speak or to talk about with 110 Excel MVP's in this blog.

 

After choosing Excel as my profession, I just thought where will I land after few years from now. And, that is where I got to know about MVP (Most Valuable Professional) award. This is even my big dream like you all have. I am still working towards to achieve my goal however, there are already 127 Excel MVP's who has achieved their goal and still looking forward to help many others like you and me in sharing their knowledge to the world of Excel.

Full story »

TRIMMEAN FUNCTION

Formulas

Hi there,

 

How was your experience working on excel to find the mean for a set of values? I hope it will be good because you are passionate on Excel. Here is a new function which exactly works like a mean but with a condition. AVERAGEIF or AVERAGEIFS are the functions which you were using till date to find the mean for a given condition.

TRIMMEAN function in excel

 

However, TRIMMEAN is an another statistical function which helps to find the average of values based on the percentage of exclusions. Which means,

MEAN: Mean is nothing but the average of values divide by count of values ( SUM / COUNT).

TRIMMEAN: This means the average of values will be calculated based on the percentage criteria.

SYNTAX: =TRIMMEAN(ARRAY,PERCENT)

Full story »

Hidden Tip About SUMPRODUCT

Formulas

Hi there,

 

SUMPRODUCT and SUMIFS are the most powerful functions which extracts filtered data. SUMPRODUCT is the most powerful function where as SUMIFS is the fast best function to pull the data because of the impact on file size.

 

As per the documents, SUMPRODUCT will multiplies the array values and sum's each of them. But, it also does the calculation based on the explicit value for each array given in the function.

 

=SUMPRODUCT(array1,array2,array3,array4,array5...)

Full story »

Lane Discipline Using Excel Custom Formatting

Excel Tips

Hi there,

 

Enjoy your shopping with genuine happiness (www.deepshika.in)


Today, let's learn an important but short tip on how to make our numbers to follow lane decipline?

confused?

How to align numbers when there is single decimal in one cell and two decimals in another cell using excel?

Format Cells Window Describes How to CUSTOM FORMAT cells

Full story »

Convert Number to Words (100 = One Hundred Rupees Only) (no VBA)

Formulas, How-to's, Tutorial

Hi there,

 

Explain this formula and win exceltoxl goodies (choose the t-shirt which you want)

In this post, I will be sharing excel howto's.

 

How to convert Rs.100 = "One Hundred Rupees Only" through Excel Formulas?

 

This is our challenge for today.


Due to short of time, I am publishing only the formula in two currencies. And, I am leaving you the explanation of the formula. 


You can also download the working file.xls in the bottom of this post.

 

1. Indian Currency (Rs. = Rupees)

   a. Crores as the base

Full story »

Contact / Help. ©2017 by Abhilash VK. Design & icons by N.Design Studio. Skin by Tender Feelings / Evofactory.