Excel Tips
Summarize Data with Advanced Filter »
April 11, 2018
Your manager needs a summary of total revenue, cost, and profit for each customer in a large data set. Today I look at Advanced Filter and SUMIF to solve the problem.
Summarize Data with Remove Duplicates »
April 10, 2018
Your manager needs a summary of total revenue, cost, and profit for each customer in a large data set. Adam from one of the large oil companies in Dallas provides a faster way using Remove Duplicates.
Summarize Data with Subtotals »
April 9, 2018
Your manager needs a summary of total revenue, cost, and profit for each customer in a large data set. I typically solved this using the Subtotals command. But during a recent seminar in Dallas, an attendee suggested there is a faster way. This week is Summarize Data week and I will look at five different ways to solve the problem.
Excel Sort by Color with VBA »
April 5, 2018
Previously in Podcast 2093, I showed a simple VBA sort that works if you are not sorting by color. Today, Neeta asks for the VBA to sort Excel data by color.
Learn Excel By Playing This Game »
April 2, 2018
There are many different ways to learn Excel, and each of them have its own advantages as different people have different learning styles. For those who like to learn with fun and real experience involved there is a gamified tool to learn Excel – Hot Key Excellence (www.hotkeyexcel.com).
I Am Not a Fan of Excel Tables »
March 31, 2018
Press Ctrl+T on a data set and all sorts of wonderful happens. While I can spend an hour telling you how wonderful Excel Tables are, a few annoying incompletions make me avoid them. Learn why in today's article.
Early Dates in Power Query are Off by a Day »
March 30, 2018
Power Query is the hot, young, new feature in Excel. Remember that it was not created by the Excel team. The Power Query team decided that they are not going to be bound by a decades-old mistake in VisiCalc. Here is why that can cause problems for you.
Insert a Screen Clipping From Another Application In To Excel »
March 29, 2018
If a picture is worth a thousand words, grabbing a screen capture to document where I found some fact will help me later. While I used to use SnagIt or WinSnap for this, Excel 2010 and newer offers to insert a screen clipping.
Fast Excel Summary Reports with Pivot Tables »
March 28, 2018
Microsoft says that 80% of people using Excel have never used a pivot table. As I near the end of my series of 40 Days of Excel, an introduction to pivot tables.