Archive | Spreadsheets

Microsoft Excel

Excel Review Questions

Have you ever had someone tell you they know Excel?  Of course, one might ask, “What does it really mean to say you know Excel?” It is true that the program has so many features that it is almost impossible to know all there is to know about Excel. Even so, perhaps you can use […]

Continue Reading 0
Microsoft Excel

Understanding VLookup

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 ID number and return the corresponding title, year, category, rating, etc. The following slides, used […]

Continue Reading 0
Microsoft Excel

Excel PivotTable 101

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 are from PivotTables that were created from an Excel list of 5406 movies. Figure 1: […]

Continue Reading 0

Ask us how we can service your company's training requirements.

©2014 Snippet Training, all rights reserved.

Home   |   Sitemap   |   Contact us