Archives for: April 2015

Documentation for Excel Functions (2003, 2007, 2010, 2013)

Formulas, How-to's, Learn Excel, powerpivot
Hi there,   In my previous post, List of Excel Functions, I have listed all Excel Functions irrespective of versions (since 2013). But, I haven't provided description to all of the functions because there are almost 461 Excel Functions are available.… more »

CUSTOM Selection in GOTO SPECIAL

website updates, Applications
Hi there,   I am working on one of the report to my client and there is a scenario where I need to select particular word (which is placed in as column header)  more »

LOGNORMDIST Function

Formulas
Hi there,   PRE-HISTORY: LOGNORMDIST is basically a function which returns the F-Test results, which means there is an array1 and array2 variances that has not much significant differences.   Eg: This function actually finds the difference between… more »

Insert Rows in Pivot Table

Pivot Tutorial
Hi there,   In this post, we will see how to insert a column in pivot table. Actually, when you try to insert or delete any of the pivot row/column it throws an error which is more than a NH7 highway. ;)   There is a trick here when you need to inse… more »

FTEST FUNCTION

Formulas
Hi there,   PRE-HISTORY: FTEST is basically a function which returns the F-Test results, which means there is an array1 and array2 variances that has not much significant differences.   Eg: This function actually finds the difference between the di… more »

Shortcut Keys Used in PowerPivot

Shortcuts, Excel2013, powerpivot
Howdy, This article will help you to find the shortcuts used in PowerPivot. But, the tragedy is there is no shortcut to open PowerPivot as of now. (if there is any, please teach me using below comments.) Now, lets go ahead with the shortcuts more.. more »
Contact / Help. ©2019 by Abhilash VK. Design & icons by N.Design Studio. Skin by Tender Feelings / SkinFactory.