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

vlook ups and pivot

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Vlook ups and pivot tables

Vlook ups and pivot tables

ResolvedVersion 2016

Whitney has attended:
Excel Intermediate course

Vlook ups and pivot tables

Can you sum up how to do vlook ups and pivot tables?

RE: Vlook ups and pivot tables

Hi Whitney,

Thank you for the forum question and for the nice feedback. I am happy that you found the course useful.

I have found a couple of very good videos explaining the two tools. The first video show how to create a PivotTable the second explain how to use the Vlookup.

Both tools are on our Excel Advanced course.


https://www.youtube.com/watch?v=qu-AK0Hv0b4


https://www.youtube.com/watch?v=-WAEzokHSJM

Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector

Thu 28 Feb 2019: Automatically marked as resolved.

Excel tip:

Shortcut for accessing recently opened files

To get into recently opened Excel files without using your mouse, hold down Alt + F to open the File menu.

Recently opened files are listed down the bottom of the File menu - type in the number next to the file you wish to open and it should appear on your screen.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.11 secs.