20 Real VLookUp Exercises
Description
Excel VLookup Exercises
DESCRIPTION
This Excel practice consists of more than 20 Real Excel lookup exercises to practice the multiple use cases of the most important functions of Excel to match and retrieve data from different tables.
All Excel exercises are real, based on business cases. Although Vlookup is the most important function (there are 9 exercises just of Vlookup), you will also practice other types of lookup functions such as hlookup in the different scenarios that tend to occur at corporate level.
All practice exercises come with a real set of data and describe a regular situation or problem that you will have to solve using the most suitable Excel function. As a result, the exercises replicate real world problems or situations that you may encounter at any position of wide range of industries.
Moreover, the workload is mixed, some exercises are short, finished with just one formula, but others are rather mini projects where you will have to implement and combine several formulas to yield the expected outcome.
Once you finish all the exercises, you will be more confident with Excel and gain the expertise and knowledge required to succeed at any position.
WHAT YOU WILL PRACTICE
1) Find, match and retrieving values of multiple tables and/or sheets in order to get insights about a business. Not only vlookup but also other formulas used to retrieve values such as sumif, hlookup, index-match, ifna, indirect, sumproduct, offset, find.
2) Confront the situations when vlookup does not work and learn how to fix it.
3) Common Excel tools and tricks to handle and analyze data.
4) Tools and tricks to work with large data sets (more than 60 000 rows).
5) Problems about the following functions: vlookup,
6) Nested functions.
7) Text functions: len, wide, concat, substitute, left, lower, etc.
8) Conditional statements.
REQUIREMENTS
90% of Excel lookup exercises require an intermediate level of Excel. Students must have attended a complete course of Excel and feel confident with the tool. Five Excel practice questions are considered of advanced level.
The spreadsheets included in the project have been done with the latest Excel version. It is then compatible with Excel 2007, Excel 2010, Excel 2013 and Excel 2016.
DOWNLOAD
After purchase, you will receive a zip folder in the confirmation email. It also available on your Practity account.
The file includes the next files:
- PDF with the Excel problems description.
- PDF with the solutions (57 pages). It includes detailed explanations and print screens with the formulas required to solve each problem.
- 22 Excel files with the data required for each exercise.
- 20 Excel files with the solutions to each exercise.
INSTRUCTOR
Andrey Ampilogov, based in Rusia, currently works as SPSS programmer. He holds a Bachelor of Applied Science (BASc), Quantitative Economics. Andrey has held several positions as senior analyst at major financial institutions in Rusia and the US.
CONTACT
If you need additional information, do not hesitate to contact us.
Additional information
Specification: 20 Real VLookUp Exercises
|
Reviews (4)
4 reviews for 20 Real VLookUp Exercises
Only logged in customers who have purchased this product may leave a review.
rona –
After finishing all the exercises, I feel now much more confident about this crucial function. You end up practicing vlookup in lots of different scenarios. Quite different from the regular exercises and online tutorials.
I really liked to have all the data in different workbooks so you can focused on the problems rather than wasting time filling up a blank spreadsheet just to get started.
shiva –
I recently purchased these practice exercises and I must say that it has exceeded my expectations. The exercises are varied and practical, covering a wide range of scenarios where the VLOOKUP function can be applied. What’s more, the difficulty level of the exercises increases progressively, making the learning experience challenging yet rewarding.
Solutions provided for each exercise are clear and well explained. They come with visual aids and examples, making them easy to understand and straightforward.
Highly recommended
Xia Jones matt –
I liked a lot that the exercises are quite different and you have to solve them in a different manner. I didn´t know there were so many options when working with Vlookup.
Good investment!
Klaus O –
I’ve never quite understood when and how to use VLOOKUP, but these assignments have been very helpful to feel confident with the function.