I recently went to Sydney to conduct some training programs on Advanced Excel and Power BI. While I was there, I met my good friend Danielle, who runs Plum Solutions,…

Last week, someone asked if I could stop zipping the sample Excel files that you can download from my website. Well, I thought about it carefully, and decided to leave…

Say you want to combine multiple Excel files, but there is a twist. Each file has few tabs (worksheets) and you want to combine like for like, ie , all…

You can add a UserForm to your Excel file, so it's easy for people to enter data, without going to the table where the historical data is stored. Usually, I…

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.…