You are the content you publish.
Sign up with Facebook
Sign up with Twitter
I don't have a Facebook or a Twitter account
Start a free trial of Scoop.it Business
I really like this great idea! Very useful!
Are you sure you want to delete this scoop?
One of the most useful formulas of Excel.
The basics of Getpivotdata.
In my practice, Getpivotdata is very-very useful for building reports.
An set of articles into mememory use, timing and multithreading in Excel
Very useful stuff to understand how things work in the dark depth of Excel. :-)
Use different data structures to create this chart: step-by-step tutorial.
formula to create a list of sheet names based on prefix without VBA
A really interesting formula solution to list sheet names based on a rule. Learn our tricks. :-)
Summary of The FrankensTeam's unique Excel work in year 2013
How and when Excel calculates the defined names? Explained using a chart with random data.
formule excel formattazione condizionale convalida formule matriciali
Hierarchical dynamic validation list with a plus: type the name of new element if you do not find it. It will be part of the list immediately!
Excel data validation with on-the-fly update without VBA
#microsoft #excel #training
Good to know when using calculated values in lookup-functions.
Frequently asked question.
Summarize monthly data into quarters.
Mmult in excel is one of a little used but very powerful set of functions. People have trouble grasping array based functions. On their site, krisztina and roberto continue to come up with practical and easy to understand applications for these useful functions. Highly recommended.
In this quick Excel tutorial we look at how to use the VLOOKUP formula with the CHOOSE function to look up columns to the left as an alternative to the INDEX and MATCH functions.
Easy! It will be a good material for my beginners.
Formula challenge for your mind, visualization for your eyes: play with the digits of pi and find the pandigital sequence.
Excel formula trick to sum product of matrix elements by rows using logarithm
Great mathematical trick in Excel formula.
Find out how to set up cascading dynamic dropdowns using Excel's Data Validation that users must manually clear if they later make changes - without VBA
Solution with only one named formula.
Ever wondered how to go from a bunch of cells with text to one big combined text? Like shown above. Well, there is a simple trick. One of our readers, Grant shared this with us. Read on to learn this.
Sumif from multiple sheets using excel formula
Today's conclusion: I will teach INDEX to all my colleagues.
Finding the first or last values or cell references in a range is easy with INDEX and MATCH.
One of the strengths of Tufte's graph (perhaps the most important) is that we can immediately read the ranking of both the data.
Easy-to-use dynamic solution.
An easy solution with explanation.
...a nifty little trick on how to make structured references absolute.
That is a great trick! Makes using tables easier - must remember!
Excel CLEAN Function will remove the non-printing characters typically brought in from other applications or web pages.
CLEAN - to remember :-)