EXCEL PROJECTS FOR PRACTICE

INSTRUCTOR
Rhynard Prins is a Business Development Manager in an Asset Management company. Based in South Africa, he holds a Bachelor of Engineering, Industrial engineering.

DESCRIPTION
The practice includes 10 projects. Some of the projects are:

– Sales data analysis. You are given an Excel file (9000 rows)  with the sales data of an electronics company. You will have to calculate the revenue of the company based on several conditions and requirements.
– Budget & Costs: Given two spreadsheets with the budget and expenses of 20 different departments of a multinational corporation, your task is to compare them to find teams with the highest deficit. You will also have to disclose the most common type of expense among certain teams as well as other KPIs.
– Build a medal tracker to rank countries based on different rules (3 Exercises).
– Create a mortgage calculator. You will have to calculate monthly payments of a loan with fix interest rates and build the amortization schedule.
– Salaries: human resources or talent acquisition teams keep records of employees activity along with their personal data. You are given an excel file with that information to calculate statistics like gross average salary in the company, the most common degree among employees of a certain category,  the top earner of the company, the expected raise for the next year and so on. 9 exercises.
– Freelance satisfaction survey: You will have to build a survey template to measure freelances performance and yield a total final rating according to some conditions.
– BMI Index calculator: calculate the body index mass and display it in a pre-defined manner.

Some challenges are real, they simulate real world problems regular Excel professionals face on a daily basis at any position of a wide range of industries. Others are fun challenges adapted for educational purposes to make you practice important tools of the spreadsheet. That is the real advantage of this type of projects; you are told a problem and your task is to guess how to solve it with Excel or you are requested to measure/calculate/asses something and you job is to decide what is the most efficient function or formula and implement it.
You receive all the datasets necessary to carry out the tasks, so you can start working on each problem immediately.

WHAT YOU WILL PRACTICE:
– IF Statements.
– VLOOKUP.
– Filters.
– Statistic formulas: average, weighted average, etc.
– Pivot Tables.
– SUMIF()
– Drop-down menus, check boxes.
– Nested formulas.
– AND/OR conditionals.

REQUIREMENTS
Some of the projects are harder than the others, but as a whole they are aimed at intermediate Excel students that want to improve their Excel skills and ensure they are knowledgeable enough about Excel, the most common software in offices and universities.
Prior experience with Excel is recommended as well as some online/offline course.
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
You will receive a zip folder in the email confirmation after purchase.
The ZIP file contains:
– 1 PDF with the instructions.
– 1 PDF with the  solutions (40 pages). It includes detailed explanations about how to solve each problem and print screens  with the formulas required to solve each problem. There are also links to proper online tutorials.
– 2 Spreadsheets with the solutions.
– 8 Excel files with the data.

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

Image