My Workbook Got Stuck in a Cyclone!
I thought I actually posted about this some time back, but I don't see it. It's driven me nuts before, and is doing it again. I have to print out our massive financial model for a meeting tomorrow. It's almost
I thought I actually posted about this some time back, but I don't see it. It's driven me nuts before, and is doing it again. I have to print out our massive financial model for a meeting tomorrow. It's almost
This drives me crazy. I'm not sure if it was the move to Excel 2013, or if it was something else… I have this massive model, and we print it out on 11x17 paper. Somewhere, sometime, Excel decided that this
Conditional formatting in Excel is a powerful tool that allows you to dynamically format cells depending on the values of that or other cells’ data. In Excel 2007 the conditional formatting engine was re-written, opening things up to allow more
As an accountant, I build financial reports, and one of the issues that we have to deal with is getting the numbers to display in a friendly format. Because of the way that debits and credits are stored in databases
The method for hiding items with zero totals in a PivotTable is different if you're working with a regular PivotTable or a PowerPivot PivotTable. This article focusses on how to accomplish this goal in the PowerPivot version. (If you're working
Mike Alexander has a great blog post on how to Add Column Spacing In A PivotTable. We can also accomplish the same thing through a PowerPivot solution, but using DAX. And in this case, DAX is even easier to use
As many readers of this blog will know, I am a huge fan of PowerPivot, and honestly believe that this is THE most important feature to hit Excel since VBA was introduced to the product. And anyone who has ever
It's always nice when you go to a forum and someone gives you a nice bit of VBA code that is supposed to accomplish your goals. But if you've never used VBA code before, it's kind of hard to know
One of the things that always struck me as odd about using subtotals is that only the words in the subtotals turn bold, and not the actual subtotals themselves. With a long list of data this can make it hard
I've been doing a lot of work with PowerPivot where I connect to databases. My normal development cycle is as follows: Connect to a view or table, pulling in ALL columns Work through my data scenario until I've worked out
Copyright © 2022-present Excelguru Consulting Inc. All rights reserved.
