This practice contains 50 real Excel exercises to practice the tools and functions needed to help you achieve an intermediate user level. It is the continuation of our basic Excel exercises bundle. The objective is for you to face the most common problems and issues in the professional world and become accustomed to using the most commonly used formulas and functionalities of the spreadsheet.

TYPES OF EXERCISES

The project is divided into four assigments composed of between 10 and 12 exercises each. All include their own Excel data. The problems are designed to solidify the basic and essential concepts of Excel as well as to advance in the use of key tools and functions so that you can progress and evolve to more professional Excel handling. The advantage of this type of problems is that they simulate the situations and scenarios of the corporate world in which Excel is always the tool by default.

First Assignment (Beginner Level)

The practice questions of this part focus on data validation and data manipulation in finance. There are 15 Excel problems about classic reconciliation and validation tasks that every finance professional has to carry out on a daily basis.

• Clean, edit, and prepare the worksheet to execute validations.
• Analyze and validate/reconcile data. You will have to compare columns to find differences or retrieve data from one sheet to another.
• Modify and manipulate data.

Second Assignment (Beginner – Intermediate Level)

You are given an Excel file with data from 700 purchase orders of one of the most important products of a chemical company. You will have to gather, analyze, and manipulate the data in four sheets to check controls, discover useful information, manage risk, and draw conclusions for company decision-making. With a focus on essential concepts such as conditional statements, counts, duplicates, SUMIF, VLOOKUP, and more, this Excel challenge provides a hands-on approach to learning how to combine and implement these functions to solve real-world problems and calculate KPIs.

Third Assignment (Intermediate Level)

You will have to create a template to query a warehouse table with data about multiple products. The goal is to select a product ID from a drop-down menu and automatically display key information about the product. The advantage of these types of exercises is that you practice real-life scenarios where you are provided with a desired output in the spreadsheet, and you must think of what tools or functions are most suitable to achieve that outcome.

WHAT YOU WILL PRACTICE?

• Data querying formulas. You will learn about the business applications of VLOOKUP as well as the different situations where you may execute it.
• Key Excel functions like  COUNTIF(), SUMIF(), etc.
• Cell editing and formatting features.
• Navigation on the spreadsheet, keyboard shortcuts, filters, etc.
• Tools to create spreadsheets with a professional look and feel.
• Conditional formatting.
• Excel Tables.
• Pivot tables.
• Basic charts.

DIGITAL DOWNLOAD / CONTENT

After purchase, you must download a ZIP folder with the following files:

• One PDF with the instructions.
• Solutions: One PDF (38 pages) with the exercises explained step by step. You will find detailed explanations and screenshots of each Excel practice problem. Each image shows the function, the expected outcome, and how to find the requested options and tools.
• Five Excel files with data.
• Three spreadsheets with the Excel exercises solved.

REQUIREMENTS

These Excel exercises for practice are aimed at Excel students who have already completed introductory courses and basic problems and now wish  to progress to an intermediate level.  They are designed to refresh basic concepts and practice more advanced tools and functions.
All spreadsheets included in the project have been created in the latest version of Excel. They are compatible with Excel 2007, Excel 2010, and Excel 2016.

CONTACT

If you need additional information, do not hesitate to contact us.