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
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
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
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