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 Professional
How to use Advanced Filters in Excel. Find exact text using Advanced Filters with formula criteria.
Formulas in criteria - Great!
Excel Advanced Filters
If anybody asks me what is the best function in excel I am drawn between Sumproduct and Data Tables, Both make handling large amounts of data a breeze, the only thing missing is the Spandex Pants a...
I have to learn it.
The general variant for the Excel-Soccer Basic is a blank version and does not include any teams and matches. The other variants listed per country include the teams and matches for the specified league and season.
The ultimate Excel tool for soccer-fans!
AJP Excel information
New design - with lot of resources, tutorials, examples.
Waterfall charts (bridge charts) are not native to Microsoft Excel; this tutorial shows several ways to manually make waterfall charts of varying complexity.
All about waterfall charts. Approach Using Up-Down Bars is the best one.
I really like this great idea! Very useful!
Combine bubble and xy scatter line chart in excel - the trick is to use trendline
Useful, simple and ingenious idea!!
Nicely formatted vintage bar chart in Excel with highlighted data.
Easy vintage chart reproduction with some formatting.
If you don’t have Excel 2013 then this post will be a bit like window shopping with an empty wallet. You get to try stuff on and test drive it, you just don’t get to take it home. Window shopping
The Peltier Tech Chart Utility has a new Advanced Edition, which nearly doubles the capabilities of the Standard Edition.
Great tool! It makes very easy to create lots of clear, useful business charts.
This tutorial shows examples of code to update an Excel chart's axis scales on demand or on worksheet changes, using scale parameters from worksheet cells.
Two version of line chart in Excel to visualize small and large number on one chart.
A VBA based Microsoft Excel Template to create a Marimekko Chart aka Matrix Chart aka Mosaic Chart for free download
Really good solution for a simple chart which could not be done easily in Excel.
A generic template to create Motion Charts in Microsoft Excel and 2 examples to animate La Linea episodes in Excel
Convert numbers to words with Excel formula: Italian, English, Hungarian
Do you have formulas for other languages? Please share!
Today, lets learn how to create an interesting chart. This, called as network chart helps us visualize relationships between various people. Demo of interactive
Hover over the title bar for the PivotTable Field List.When your mouse changes to a four-headed arrow, click and drag it to the position where you would like it to appear and resize as needed.
I like it!!
A small bug in Excel 2013.
Vintage chart reproduction in Excel: arrows starting from one point.
Interactive drill up and down geographical hierarchies on a Choropleth Map in Microsoft Excel
Really awesome #Excel magic by Robert Mundigl.
This is an index of Pivot-Table-related posts on the Peltier Tech blog, and a list of three good Pivot Table books.
All about Pivot tables.
Download English version Deutsche Version herunterladen
Well, I am not interested in football, but this tool looks really eye-catching for a lady too. I really like the ribbon tool - that is amazing!
Let the game begin!
Generate QR code with google chart API using UDF in Excel
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.
How to create an interactive “Pivot-like” Marimekko Chart in Excel allowing the user to select the visualized dimensions and measure on the fly
One more solution form Marimekko charts.