EXCEL
VLOOKUP
CHAMPION
(Excel Champions Series)
HENRY E. MEJIA
EXCEL VLOOKUP CHAMPION
Copyright 2018 HENRY E. MEJIA
All rights reserved. No part of this publication may be reproduced, stored in any data retrieval system or transmitted in any form or by any electronic, mechanical, photocopying, recording or other means, without the prior written permission of the author, except in the case of brief reviews used in literary reviews and certain non-commercial uses provided by the Copyright Law.
CONTENTS
Welcome to a new Excel Champions Series book!
What characterizes this series of written courses is that you will learn while you practice because they are full of exercises, examples explained step by step, and real life applicable situations. I also include Excel files so you can practice all the book exercises at home. In fact, you will have 30 exercises to practice with.
Did you know that being an Excel Champion increases your chances of getting promotions and better jobs? If you do not believe me, continue reading.
In fact it is very simple to explain: The person who is an Excel Champion can complete the work better and investing less time in front of the computer, as a result has more time available to tackle other activities that need attention and achieve a better outcome at the end of the day.
I know this because I have personally experienced it. Thanks to Excel I was able to get a better job and also thanks to Excel I was promoted. In case you're thinking about it, it was not in any Business Intelligence department nor in Corporate Finance (where Excel is extremely indispensable), it was in the Accounting department and the Sales department. Why did my bosses give such importance to Excel knowledge?
Actually Excel is used in almost any department of any company, private or government. Wherever you work, being an Excel Champion will give you a clear advantage over your other co-workers and will put you in a position to move up or look for a better place.
HOW CAN THIS BOOK HELP YOU BECOME AN EXCEL VLOOKUP CHAMPION?
To be an Excel Champion it is necessary that you master several tools and formulas. In this book I will teach you in detail and step by step the VLOOKUP formula.
VLOOKUP is a search formula that, if used in the right way, helps drastically reduce the time you use in front of the computer when working with databases.
Let me tell you a story, a person who had the position of Warehouse Coordinator in a retail company didnt use VLOOKUP to build a monthly report of merchandise shipments. How much time did he spend every month? 3 hours.
One day that person asked me if there was any faster way (Im glad he asked!) And I taught him how to use VLOOKUP in a very basic way. How much time did use later in the same report? 45 minutes! In case you havent noticed, that's 4 times faster. Not bad for a simple formula, dont you think?
That happens with a basic domain of VLOOKUP, but when you have giant databases and you are a VLOOKUP Champion you can expect even better results.
HOW CAN THIS BOOK HELP YOU TO HAVE A BETTER LIFE?
Can you imagine being able to leave the office at 5pm almost everyday? Can you imagine being able to have most of the reports in order and ready without delays? What would you do if that happened? Would you go running, to the gym, to dinner with your family, to the movies, would you learn to play a musical instrument?
All that is possible if you manage to become an Excel Champion. Excel can do the heavy lifting of calculating and finding data for you. The repetitive tasks that you do can be automated by creating templates. In some cases Excel can even make decisions for you if you organize your requirements beforehand.
Less time in front of the computer means more time for important tasks of your work and more time for important people like your family.
SO, WHAT WILL I LEARN EXACTLY?
In a few words, you will learn to use VLOOKUP in many different ways in your job or business. VLOOKUP is a tool, think of it as a hammer, that is also a tool. Both can be used for different situations. Here you will learn to use VLOOKUP in different situations of real life so that none of them take you by surprise.
You will learn in a practical and straightforward way, with this course full of exercises and examples. You can also use the . xlsx files to practice.
You will learn quickly and in an easy to understand way. You can achieve a basic level from the first 3 chapters of the book, while in the following chapters you can become an Excel VLOOKUP Champion and be the best in your workplace using this powerful tool.
I want to thank you for allowing me to share this knowledge with you. I sincerely hope that you apply everything you learn and that you get the positive results in your job or business.
It's time for you to start your journey as an Excel Vlookup Champion.
Before starting Chapter 1 I recommend you get your 30 practice spreadsheets. Those exercise files are included for everyone who purchases this book. They will serve you at the end of each chapter to reinforce what you have learned and make sure you have learned it well.
All you have to do is to send me an email to:
ems.online.empire@gmail.com
With the Subject VLOOKUP PRACTICE SPREADSHEETS and saying:
"Hello, I bought your book EXCEL VLOOKUP CHAMPION and I need the 30 practice spreadsheets"
I will gladly reply your email and send you the files.
Now you are ready to start Chapter 1. Lets go!
WHAT IS A FUNCTION?
An Excel function is a tool used to make calculations, searches, changes or logical reasoning with the data you provide, with the objective of returning a result.
In a simple way, using functions saves you the hard work and it is Excel who works hard to give you the result you are looking for. Less work for you and less time in the office!
"Using functions (formulas) saves you hard work."
Excel is one of the most powerful software, it has many functions and many tools, and in this book you will learn one of the most useful: VLOOKUP
WHAT IS VLOOKUP?
Vlookup is one of the most useful Excel functions. You can use it in different ways but basically it helps you find information within a giant amount of data.
Sometimes, you need to find the exact price (or any other information) of a certain Product ID, but you have many products. What someone who is not a Vlookup Champion does is to search the price of each product in their database and copy it manually, one by one. What a waste of time! What a Vlookup Champion does is to use the formula to get the right prices from the database and in 30 seconds all the prices along with their respective Product ID are in place, with zero errors.
Next page