THE PROS KNOW
About Microsoft Excel 2007
First edition published in 2011
© Copyright 2011
Train Up Now
All rights reserved. No reproduction, copy or transmission of this publication may be made without express prior written permission from the author. No paragraph of this publication may be reproduced, copied or transmitted except with express prior written permission from the author or in accordance with any applicable law in the country of origin. Any person who commits any unauthorised act in relation to this publication may be liable to criminal prosecution and civil claims for damage.
Although reasonable efforts have been made to ensure the accuracy of the information contained in this book, as of the date of publication, nothing herein should be construed as giving advice and no responsibility is accepted for any use or application of any information contained therein.
10 Techniques the Pros Know
2
Contents
Introduction ............................................................................................................................... 4
What’s in this book ................................................................................................................... 4
1. Setting the scene................................................................................................................... 5
2. VLOOKUP .............................................................................................................................. 6
Fetching data ........................................................................................................................... 6
How to use it ............................................................................................................................ 6
Putting it into action ................................................................................................................. 6
Your bonuses