In this month’s installment of my Excel dashboard series, I’m going to show you a trick that will give you the ability to control an entire dashboard with one menu — in this example, a radio button ...

Microsoft Excel 2007 provided many new features over its predecessors and, to make it more useful in the workplace, it also offered additional tools for collaboration and data sharing. One of these ...

when you are working with data in Microsoft Excel the data you have to work with won’t be presented in a way that you need it to be. There are a number of ...

I’m starting a series on dashboards because I think creating sexy dashboards is a critical skill every marketer needs to know. It’s going to be a long series — but by the time we’re finished, you’ll ...

The city of Edina, Minn., has finally outgrown Excel — at least when it comes to crafting the next municipal budget. It’s the type of move that could play an increasingly important role in the ...

Have you ever found yourself staring at a sprawling Excel workbook, wondering if you’re using the right tool for the job? Between Power Query, Power Pivot, and VBA, it’s easy to feel like you’re ...