excel training program - pivot table vlookup

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel training program - Pivot table & Vlookup

excel training program - Pivot table & Vlookup

resolvedResolved · Low Priority · Version Standard

Lawrence has attended:
Excel Advanced course

Pivot table & Vlookup

I would like to know how to use the Pivot Table & VLookup Functions

RE: pivot table & Vlookup

Hi Lawrence

Thank you for your question.

You can create a pivot table from a list (data stored in a series of columns) by clicking anywhere in your list and going to Data - PivotTable and PivotChart report and step through the wizard to create your pivot table.

The Vlookup function again is designed to work on data stored in a list format. It allows you to extract information from a list based on a lookup value. The lookup value must be something that can be found in the leftmost column of the list.

Amanda


 

Excel tip:

Recently used file list

Under the File menu, you may find a list of files at the bottom of the menu. These files represent the most recently used Excel spreadsheets. This file list provides a quick way for you to access your files.

You can disable the file list feature of Excel. This is done by

1. Choose Tools > Options menu. You will see the Options dialog box.
2. Ensure the General tab is selected.
3. Make sure the Recently Used File List check box is cleared.
4. Click on OK.

View all Excel hints and tips


Server loaded in 0.09 secs.