VLOOKUP for Pictures
Something that can be very handy when you’re building a dashboard is to return a certain picture depending on a condition. We can use VLOOKUP to look up data in a table and return the corresponding value from a different
Something that can be very handy when you’re building a dashboard is to return a certain picture depending on a condition. We can use VLOOKUP to look up data in a table and return the corresponding value from a different
This is a personal post, but it was a HUGE weekend for me where some very cool things happened. If you’re a fan of Excelguru on Facebook, follow me on Twitter, or are connected to me on LinkedIn, you’ve already
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
Copyright © 2022-present Excelguru Consulting Inc. All rights reserved.
