Excel Templates Practice

Add to wishlistAdded to wishlistRemoved from wishlist 2
Add your review

$9.95

Description

Excel Practice Projects to Create Templates

 

DESCRIPTION

The goal of these four Excel practice projects is to build templates with applications in the real world. Creating templates is a fantastic exercise to improve your Excel skills and boost your confidence with the spreadsheet. Not only you will have implement and combine conditional statements and functions like VLOOKUP or SUMIFS, but also you will practice how to edit spreadsheets with a professional look and feel.
The advantage of this type of Excel challenges is that you gain experience with the spreadsheet since you will have to solve the same regular problems any analyst encounters when working with Excel. These assignments ask the student to provide a solution to a requirement or problem. You task is to decide and implement what functions and formulas are the most suitable to get the best possible solution.
The Excel templates to build are the following:
1) Invoice generator: Given a spreadsheet with 20 000 invoices, you will be requested to create a template to retrieve and display in a professional manner the information of any invoice based in just one field.
2) Budget: Build a tool to provide quotes to clients of a car garage.
3) Excel Dashboard: Create a tool to retrieve employees sales figures from a database and display them in a graph.
4) Metrics breakdown: Given a sheet with several items metrics across 66 columns, build a summary table to display metrics of a selected item during specific months.
The four Excel assignments have a guidelines section where each template assignment is broken down into short exercises. This way, you create the template step by step solving one problem at a time.

INSTRUCTOR

Michael Liew has worked in the IT industry for more than 15 years in several areas like Data Analyst, Senior Programmer, or Technical Analyst. He is based in the UK and holds a Bachelor Degree in Computer Science.

WHAT YOU WILL PRACTICE

1) Find, match and retrieving values from different sheets.
2) Editing the spreadsheet with a professional layout.
3) Nested functions (ie vlookup + conditionals).
4) Checkboxes.
5) Real applications of the following functions: VLOOKKUP, SUMIF,INDEX/MATCH, IFERROR, etc.
6) Create charts, insert images, Drop-down lists.
6) Text functions.

REQUIREMENTS

These Excel practice projects require a minimum knowledge of Excel. Students must have attended an intermediate course of Excel.
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 is also availbale on your Practity account.
The Zip file includes 3 PDFs and 8 Excel files:

  1. A PDF with the instructions, including the Escel assignments description, guidelines and the expected outcome.
  2. PDF with an appendix. Explanations on how Excels formulas work.
  3. PDF with the Excel problems solved and explained  (34 pages). It includes detailed explanations about how to build every template and how functions work.
  4. Spreadsheets with all Excel exercises solved.

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

  •  
Picture

Additional information

Specification: Excel Templates Practice

Difficulty

Time Estimate

2 Days

Reviews (0)

User Reviews

0.0 out of 5
0
0
0
0
0
Write a review

There are no reviews yet.

Only logged in customers who have purchased this product may leave a review.

Python and Excel Projects for practice
Register New Account
Shopping cart