Conditional formatting is a great tool in Excel. It sounds fancy, but if you've ever color-coded anything before, you know how conditional formatting works. Given the rules you provide Excel, it …
Ctrl + ~ : An X-ray of your spreadsheet
This is one of my favorite Excel keyboard functions, used in frequency only after Ctrl + S, but not many know about it. Excel is great for easy data analysis, but it is hard to check for errors. …
Continue Reading about Ctrl + ~ : An X-ray of your spreadsheet →
Review: “The Milennial Game Plan”
I came to this short e-book from Forbes, where author Laura Shin writes regularly. While it took less than half a day to read (and is priced appropriately), the book has permanent take-aways.Shin …
Avoid Excel Lookup Errors Forever
We've all had that nasty feeling -- our vlookup formula returns an error, leaving a screaming #N/A where you had expected to see numbers. This is usually because of some loophole in your dataset -- …
Use this Excel Print Formatting Every Time
Even in the digital age, much of what is created on the computer gets printed. You can make a great spreadsheet, but if it doesn't look good in print, it loses credibility. Here is the formatting I …
Continue Reading about Use this Excel Print Formatting Every Time →
Filter Multiple Pivot Tables with One Slicer
Note: This is my first Excel post! I have improved since then, both in my blogging and Excel skills. I've made some modifications to the post, but the first paragraph remains for sentiment's …
Continue Reading about Filter Multiple Pivot Tables with One Slicer →