Nasty little F Lock key…
No really, that is it’s name! I was trying to figure out why pressing F4 wasn’t toggling from relative to absolute referencing in my Excel formulas, and was starting to think I found a bug in Excel 2013. But then
No really, that is it’s name! I was trying to figure out why pressing F4 wasn’t toggling from relative to absolute referencing in my Excel formulas, and was starting to think I found a bug in Excel 2013. But then
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
It's been crazy busy over here the past couple of weeks. I've been hard at work creating 3 training videos for a client, (we shoot in Studio on Friday,) preparing for my next live course (this Saturday,) and trying to
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
Copyright © 2022-present Excelguru Consulting Inc. All rights reserved.
