Excel 2007 Advanced

Resolved · Urgent Priority · Version 2007

Wed 5 Feb 2014, 10:40 Delegate Rupert said...

Rupert has attended:
Excel Advanced course

Excel 2007 Advanced

In December 2012 I attended the above course through you.

I have the course notes (handbook) from the classroom. I am trying to work through this and compete the 'Practice Activity Units'. I do not seem to be getting the correct answers.

I was wondering if you would be kind enough to send me these
(Practice Activity Unit 2-6) answers. I have an interview early next week which is largely based around a test on excel advanced. These answers would help me enormously, and would help me return to would after a period of unemployment. Kind Regards

Rupert

Wed 5 Feb 2014, 13:33 Trainer Gary said...

RE: Excel 2007 Advanced

Hi Rupert

Thanks for getting in touch. Attached are the answers for the VLOOKUP questions.

Please have a look through and if you have any questions please get in touch.

Kind regards

Gary Fenn
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
Best 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

Attached files...

Sales invoice_solution.xls

Wed 12 Feb 2014: Automatically marked as resolved.

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Excel tip:

Creating custom lists

In Excel if you type in January in a cell, you can then copy this cell to replicate Febraury, MArch, April etc.

This list has come from Tools- options and Custom lists.

Therefore to save time and create your own list you can click on New (in Tools and custom list tab) and type out the lsit that you want copied quickly.

All you have to do is then type in the 1st word and you will be able to copy the rest of the list quickly.

View all Excel hints and tips