How to trace precedents in Excel formulas? [tip+music from Prague]
Dobré ráno That’s good morning in Czech. Hello from Prague. I am here as part of our Euro trip. Next stop is Munich before we go home to Wellington. So…
Articles
Dobré ráno That’s good morning in Czech. Hello from Prague. I am here as part of our Euro trip. Next stop is Munich before we go home to Wellington. So…
How can you get the last number in an Excel column? I needed to do that in one of my sample files, so here's the formula that I used. Then,…
A few weeks back Jhouz asked a question in the Chandoo.org Forums “Is is possible to create a doughnut chart like this one in excel?” This post will examine how…
For every column chart that is done right, there are a dozen that get messed up. That is why lets talk about 5 simple rules for making awesome column charts.…
Set up a Master sheet in your workbook, and add month sheets automatically, based on that Master sheet. The new sheets will be named for the month and year, in…
Time for another Excel formula / Power Query challenge. This is based on a common business data analysis problem. Say you have two tables – calls log and office hours.…
Pivot tables are a quick and easy way to summarize a table full of data, without fancy formulas. Occasionally though, things can go wrong. Today we'll figure out why you…
Recently, Microsoft Power BI introduced a very useful visualization, called key influencers visualization. As the name suggests, this is a chart of key parameters that effect a measure or outcome.…
Imagine you are in a life sustaining planet named Pearth, in another galaxy. One day you got to work, fired up Excel (hey, what else would you use? Excel is…
In the good old days of Excel, you could change a workbook setting, and see a preview picture of the file contents, before you opened it. That feature was available…