This Excel practice consists of three assignments with a total of 40 real Excel exercises for students at a beginner-intermediate level.

First Assignment (Beginner Level)

The exercises in 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 CONCATENATE(), EXACT(), 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.
• Print out spreadsheets.
• Conditional formatting.
• 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 (37 pages) with the Excel exercises explained. 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 the next step after our “Real Exercises for Absolute Beginners” pack. They are designed to refresh basic concepts and practice more advanced tools and functions. Students must have attended an introductory online/offline course of Excel.
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.