peltier tech utilities
Learn how to create Excel dashboards.

Categories

30 Excel Functions in 30 Days

Archives

Running Totals Are Easy With Excel Pivot Tables

This week I'm working on a client's sales plans for the upcoming fiscal year. They forecast sales per month by product and customer, and we use some pretty complicated formulas to sort things out. Of course, anywhere that it makes sense to use a pivot table, I create one. It's a great way to summarize [...]

Related Posts Plugin for WordPress, Blogger...