Question Details

The purpose of this exercise is to use the Excel skills you have acquired thus far, and apply them to an analysis of a business scenario, of your choice. This will consist of preparing the groundwork in Excel (importing data, preparing the analysis using tables, charts, graphs, pivot tables, etc.) and preparing a memo to your management, explaining your three separate analysis.

This is different than prior iLab assignments, in that there are no specific instructions as to what type of analysis (i.e., Sales/Units/discounts by Country/Rep/Product/Date/Category, etc.) is to be performed. The general requirement is for you to prepare a minimum of three discrete analyses and perform a write-up to management, using the memo format provided.

Remember that you are making a professional analysis and presentation, so be sure to give some thought to what you are trying to recommend to management, and why.