BIS 155 Course Great Wisdom / tutorialrank.com BIS 155 Course Great Wisdom / tutorialrank.com | Page 42

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.

STEP 1: Import Your Data Into Excel
The ultimate goal is to prepare a memo to management, using the
Week 6 iLab Memo Template. Before you begin working with Excel, it
might be a good idea to take a look at this template, so that you can
envision your end results.
In this first step you will open Excel and import the data from Week 6
iLab Sales Data. This is a comma delimited file with column headers,
and you should be sure to format the "Order Date" as a date type
column. Remember to save the file as an Excel workbook, using the
naming convention shown above. I don't believe there is any reason
to perform a spell check, as there are just too many unique names of
products in this data.
Using a company name of your choice, format this data sheet in a
professional looking manner. Given the fact that you have a unit
price and quantity, it might help you to create another column to
show the gross revenue.
STEP 2: Convert Data to a Table Format
In this step, create a new worksheet, using a copy of your original
data. Convert the data to a table format. You may choose to use this