Yesterday, Microsoft released a preview of Power Map; a geo-spatial mapping Excel add-in, formerly know as GeoFlow. It’s a pretty cool add-in that allows you to plot data based on geographic identifiers (longitude, latitude, country name, town names, postal codes,
I’m working on a spreadsheet where users will be able (required) to insert new rows at a later date. When they do so, it’s critical that the section subtotals always… well… subtotal correctly. The challenge, of course, is that you
David Hagar made a comment in my last blog post that I should add a userform to the code that I built there. Since I had to use it on 40 workbooks, and figured that it could come in useful
Yesterday I made a comment on Twitter that I was trying to figure out if it would be faster to check the conditional formatting formulas in 40 workbooks manually to ensure they were correct, vs writing a tool to do
A couple of weeks back I was approached by PackT Publishing, asking me if I’d be willing to read and post a review of Creating Data Models with PowerPivot How-to, by Leo Taehyung Lee. As I’m always interested to see
When I was down at Microsoft for the MVP Summit, I suggested that, as the “other most powerful part of Excel” that PowerPivot, like the Visual Basic Editor, should be given it’s own keyboard shortcut. Since Alt + F12 is
Some of the really cool charts that we can build in Excel involve the trick of combining multiple chart types together to make them happen. In this article, we’ll build one of those; a temperature chart that not only shows
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
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
Copyright © 2022-present Excelguru Consulting Inc. All rights reserved.
