Professional Excel Development – 2nd Edition
My wife sent me a message today to let me know that a review copy of Professional Excel Development – 2nd Edition had just arrived at my door. 🙂 The last version of the book was excellent: the only book
My wife sent me a message today to let me know that a review copy of Professional Excel Development – 2nd Edition had just arrived at my door. 🙂 The last version of the book was excellent: the only book
A little background My staff and spreadsheet users will tell you that any time I build a spreadsheet, there are always shaded cells on the grid. I preach that "Green means go", and make sure that any cell they enter
I recently taught a course and, while this wasn't actually covered in the course content, we did discuss it. I've found that every time I demonstrate this technique, it gets some "oohs" and "aahs", so I figured that I'd share
I really like the new icon sets that are in Excel 2007. They're kind of a neat way to format a cell to show interpretive information at a glance. One practical place to use these is as an alternative to
In a blog post last week, I was looking at the image formats to use when I snapped a picture of a chart. I'm kind of glad that Jon agreed with my assessment on EMF being the best image format
*Note:* The charts in this post are based on sample data and do not reflect any real financial performance. In setting up my first dashboard, I took a page out of Charley Kyd's book and placed a bunch of little
I'm not sure if the observation is weird, or the actual chart sizing is. I think this is a bug, but I'm curious if others see similar behavior. This is an Office 2007 thing (at least, I haven't tested it
So during my infatuation with converting my workbook to use IFERROR statements throughout, I suddenly realized that the reports I had to send to head office needed to work in Excel 2003. After a bit of… um… motivational speaking… I
I need to thank Joe Chirilov and Danny Khen, from the Excel team at Microsoft for this tip. We were discussing some Excel things while we were having dinner during the summit, and I was bemoaning the fact that it
I received an email today, asking how to compare two worksheets for differences. Of course, we could easily reach to VBA to do this, but we can also use Conditional Formatting to make these kind of comparisons. I figured that
Copyright © 2022-present Excelguru Consulting Inc. All rights reserved.
