POWERPIVOT ADVANTAGES

Excel2013, powerpivot

Hi there,

In this post, you will learn the advantages of power pivot in Excel. If you are new to PowerPivot here is an introduction to PowerPivot. If you already know then you can continue with the post.

Hoping you know basics of PowerPivot, here are the advantages of using PowerPivot in your daily work. 

 

PowerPivot Icon in Excel 2010 and above


ADVANTAGES OF USING POWERPIVOT:

Full story »

New DAX FUNCTIONS for Excel 2016

Excel 2016, powerpivot

Hi there,

 

Today, I just noticed New DAX FUNCTIONS for Excel 2016. Do you know what I mean? There are few functions which are added in upcoming office which is in EXCEL (POWER PIVOT) 2016.

If you are new to DAX FUNCTIONS. Then, here you go:


ABOUT DAX:

DAX is defined as Data Analysis Expressions. This is not a programming language (coding) however, it is a formula language which is available as an add-in in Excel (Power Pivot), (from 2010 onwards) more.

Full story »

EXPONDIST FUNCTION

Formulas

Hi there,

 

PRE-HISTORY:

EXPONDIST is basically a function which returns the exponential distribution value for the given x value.

 

Eg: This function actually finds the time between the events such as ATM machine gives the money so, this function helps us to find the exact time taken to deliver the money from the ATM to the customer.

The other example can be, the time taken between the click of a button on a camera to a photo still to capture into a camera. (Ridiculous example but true &#59;) )

 

This function is available in compatibility functions in Excel 2010 version. Before the users are using this function however, we can also use the latest function (2010 and above) EXPON.DIST.

Full story »

CHIDIST FUNCTION

Formulas

Hi there,

 

PRE-HISTORY:

CHIDIST is basically a function which calculates the right tailed probability of chi-squared distribution

 

Eg: Comparing the observed results with the predicted results. In other words, In 2014 elections, the expected seats for each parties vs the actual seats won by each parties.

 

This function is listed in COMPATIBILITY FUNCTIONS of Excel 2010 version. Now, the users are using CHISQ.DIST.RT function which is similar to CHIDIST with slight improvements in the function.

Full story »

6 Mind Blowing Games in Excel

weekend-special, Applications

Hi there,

 

Many of us know Excel is just an application to use for calculating, analysing, manipulating, presenting and backing up data. But you know, we can also use Excel for entertainment. Yes, Entertainment!

 

Here are the six mind blowing games which are created in Excel by six great Excel Lovers.

Full story »

BETA.DIST Function

Formulas

Hi there,

 

PRE-HISTORY:

BETA.DIST is basically a function which calculates the cumulative beta distribution or to study variation in the percentage of something across the activities.

 

Eg: Percentage of people spend their fraction of day on our blog (www.exceltoxl.com).

 

This function is introduced in Excel 2010 version. Before the users are using BETADIST function which is less accuracy than BETA.DIST

Full story »

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