Get Excel Case #2: Marks Collectibles, Inc

This guide provides clear instructions on how to complete the Excel Case #2: Marks Collectibles, Inc online. By following these steps, you will effectively manage and analyze the data for Marks Collectibles, Inc, enabling insightful decision-making.

Follow the steps to complete the Excel Case #2 form online.

1. Click the ‘Get Form’ button to obtain the Excel Case #2: Marks Collectibles, Inc form and open it.
2. Begin by downloading the text file named SiteStatistics4v15.txt, which contains the data you'll need to import into your worksheet.
3. Open a new Excel workbook. Go to the Data tab on the ribbon. In the Get External Data group, select 'From Text', choose SiteStatistics4v15.txt, and press the Import button. Use the Import Wizard to set the Original Data Type as 'Delimited' and confirm the correct delimiter is a tab, then finish the import process.
4. Format the Entry and Exit columns to display date and time in an easily understandable format by applying the appropriate Custom number formats.
5. Add a new column at the leftmost position labeled 'Visitor Nbr.' Enter sequential numbers for the first few rows and use the fill handle to populate the rest of the column down to 93 visitors.
6. Create a new column titled 'Visit Duration' to calculate the length of visits using a formula that subtracts Entry times from Exit times. Format this column in h:mm:ss time format.
7. Construct summary tables at the bottom of the main worksheet, using statistical functions like Average, Median, Min, and Max to analyze Visit Durations, Bandwidth, and Viewed Pages.
8. Sort data by Entry date to create a table for tracking how many visitors added the site to their favorites each month using COUNTIF for analysis.
9. Add another table to display total visits and viewed pages by month using COUNTA and SUM functions.
10. Insert headers to enhance the appearance of the worksheet and specify that it is for Mark's Collectibles, featuring Site Statistics for the relevant time frame.
11. Create a new sheet called 'Visit Duration Averages' where you develop pivot tables and charts comparing the average Visit Duration by Operating System, Connection, and Browser.

Start filling out your Excel Case #2: Marks Collectibles, Inc online now.