Tag Archives: Excel

Productivity tip: Excel tables!

I was recently asked to give a 5-minute presentation on any Excel topic for a “Lunch and Learn” session.  Five minutes?!?!?  That is not much time.  And besides, the Internet is chock-a-block full of Excel productivity tips, so how could I narrow it down to just one tip?  Also, I knew very little about the… Read More »

On starting a new Excel project

Whenever I start on a new project, if it’s anything like past projects, it will be a safe bet that there is no written documentation for the Excel files the client is using.  The users will do their best to explain it, then it will be up to me to go under the hood and… Read More »

An Excel formula to calculate Postage Weights

The Question (long version) Here’s the question as posed by the client in his own words: I want to use Excel to calculate the total postage needed to mail packages of stuff to customers.  So if they buy one medium T-shirt (10.7 oz) one large T-shirt (13.2 oz) and one pair of socks (2 oz) that all… Read More »