Category Archives: Excel

Tips and tricks plus comments about Microsoft Excel

Understanding VLookup

This gallery contains 9 photos.

Vlookup is a powerful function that can help you lookup information from a table or list of data. Suppose you have a list of 5000+ movies like the one shown below. The VLookup function will allow Excel to lookup an … Continue reading

More Galleries | Leave a comment

Excel PivotTable 101

This gallery contains 20 photos.

What is a PivotTable? A PivotTable is a useful tool for creating summary reports from Excel data. And the cool thing is you can “Pivot” or move the fields of the report. For example all of the following screen shots … Continue reading

More Galleries | Leave a comment

The keyboard is faster than the mouse

I confess, I am always in a hurry (except maybe when I am watching reruns of Star Trek with my family).  As a result, when I am on the computer I want to get as much done as I can. … Continue reading

More Galleries | Leave a comment

How to construct a useful and easy-to-understand spreadsheet

Have you ever received a poorly constructed and hard-to-understand spreadsheet?  The data is scattered all over the place, the fonts and colors are inconsistent… It’s just a pain to read and nearly impossible to use. Laying out a spreadsheet so users … Continue reading

Posted in Excel | Leave a comment