Vlook ups and pivot tables

Resolved · Medium Priority · Version 2016

Thu 21 Feb 2019, 16:42 Delegate Whitney said...

Whitney has attended:
Excel Intermediate course

Vlook ups and pivot tables

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

Thu 21 Feb 2019, 19:46 Trainer Jens said...

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.

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Excel tip:

Quickly create a list of numbers

The fill handle in Excel has many uses. If a number is typed into a cell and then the fill handle is used, the number will be copied from one cell to the next.

If you wish to create a list of numbers that increment by one at a time, hold down Ctrl in conjunction with using the fill handle - this should give you a series of numbers (e.g. 1, 2, 3 etc) rather than copying a single number.

View all Excel hints and tips