English | June 3, 2018 | ASIN: B07DHZT1L4 | 142 pages | AZW3 | 2.73 MB

"THE ONLY EXCEL VLOOKUP FUNCTION BOOK YOU WILL EVER NEED" -  Sales Manager of an Oil Products Manufacturing Company

Did you know that being an Excel Champion increases your chances of getting promotions and better jobs? If you don't believe me, continue reading.

The person who is a Microsoft Excel Champion can perform better because that person knows how to use excel functions and formulas, acomplishing more, investing less time in front of the computer and 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 my Excel knowledge I was promoted.

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 (also a tool). A hammer can be used in different situations. Here you will learn to use VLOOKUP in different real life situations 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.

Here is the Table of Contents. You will learn EVERYTHING about VLOOKUP.

CHAPTER 1: WHAT IS VLOOKUP AND WHICH ARE ITS BENEFITS?

CHAPTER 2: THE VLOOKUP STRUCTURE

CHAPTER 3: BEGINNING TO BECOME A VLOOKUP CHAMPION

CHAPTER 4: COMMON ERRORS AND HOW TO SOLVE THEM

CHAPTER 5: VLOOKUP THROUGH DIFFERENT WORKSHEETS

CHAPTER 6: VLOOKUP FOR DIFFERENT REFERENCE VALUES

CHAPTER 7: VLOOKUP WHEN YOU NEED RESULTS OF MULTIPLE CELLS

CHAPTER 8: VLOOKUP AND IF “FUNCTION” (NESTED FUNCTIONS)

CHAPTER 9: VLOOKUP AND “IFERROR” FUNCTION (NESTED FUNCTIONS)

CHAPTER 10: INDEX AND MATCH. VLOOKUP ALTERNATIVE TO SEARCH FROM RIGHT TO LEFT (NESTED FUNCTIONS)

CHAPTER 11: QUICK FINAL TIPS