Build engaged audiences through publishing by curation.
Sign up with Facebook
Sign up with Twitter
Sign up with Linkedin
I don't have a Facebook, a Twitter or a LinkedIn account
Start a free trial of Scoop.it Business
Easy way to create perfect square plot area and gridlines in Excel chart
Are you sure you want to delete this scoop?
Having your Excel data in a tabular format will make it easy to analyse with Pivot Tables and save you hours of frustration.
"You might think you’re saving time by skipping this step but it will eventually come back to haunt you".... so true...
Excel Tabular Data is the Ideal Format for PivotTables and Formulas
Excel stacked column chart with lines lying on the top of the columns.
You can easily choose where do you want to see lines to highlight the movement of the data.
formule excel formattazione condizionale convalida formule matriciali
Visualize science: gene expression patterns.
Combined stacked bar + xy scatter and stacked bar + area - with some tricks.
Excel CLEAN Function will remove the non-printing characters typically brought in from other applications or web pages.
CLEAN - to remember :-)
Funny visualization of percentage > 100%
...and, actually, this is the logo of the collection.
Excel lookup a range of cells and find the column containing a match and return the value in the first row.
How to find if a value falls between two limits.
Easy to solve the challenge using MEDIAN.
Some things to remember when using SUBTOTAL formula.
2013 is the year to handle the crap data hurt our businesses. Here are 4 steps to getting insight and peace.
I like it: "Data-scrubbing isn’t a data-entry level skill."
Today's conclusion: I will teach INDEX to all my colleagues.
The purpose was to give an overview, a total picture without focusing on anything in particular.
An easy but useful feature for stacked bar charts.
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!
Microsoft Excel charts and data visualization tools
Excel chart gallery opened. We would be happy if write your comments in the Visitor's book.
Check out these unique and interesting Excel charts. And be sure to comment in the visitor's book.
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.
by The Frankensteam
Excel data validation examples using custom validation; prevent duplicates, limit total amount, prevent leading spaces, prohibit weekend dates
Today this Custom validation was really useful - I limited the cell to two different text values without using List.
Creative uses of validation to cover common needs for cell restrictions and limitations.
How to use Advanced Filters in Excel. Find exact text using Advanced Filters with formula criteria.
Formulas in criteria - Great!
Knowing How to Make Amazing Excel Dashboards Will Take Your Career to the Next Level Excel Dashboards are the new buzzword employers are looking for.