Subscribe to the newsletter for more Excel tips and tricks. Plus, your free ebook.This is part of the "Hired with Excel" series. Read the last post here.My StoryThis series is the guide I wish I’d had …
Hired With Excel: Introduction and Definition
The other day I mentioned that I would be starting a new series of tips on how to get "hired with Excel." This is my first post. I will lay out the goal of the book and an important definition. Every …
Continue Reading about Hired With Excel: Introduction and Definition →
Chandoo Blew My Mind: Here’s How
Purna Duggirala is known to Excel users worldwide as Chandoo. His site,Chandoo.org, is my go-to Excel resource. Chandoo has a variety of Excel media from blog posts and videos to full online …
10 Commandments for Spreadsheet Collaboration
Hell is other people's spreadsheets.There is a Russian proverb that you don't really know someone until you have shared a pound of salt with him. In the office, you don't really know someone you have …
Continue Reading about 10 Commandments for Spreadsheet Collaboration →
;;; And I’m Through With You
Here's a nice Excel shortcut. Say you want to leave data in a cell but wish to make it invisible. You can do this by going to the Format Cells menu (keyboard shortcut: Ctrl + 1), selecting Custom, …
Excel Tip: Freeze, Formula!
I promise I didn't post this just to use this great (free!) photo from Gratisography. No, it's because this is one of the niftier Excel hacks that doesn't get much publicity.Unwinding a formula in …