tutorial assignment 1 data management
There are 3 files attached which will help you complete Tutorial Assignment :
- Data Management Tutorial – Step by Step Instructions for Tutorial Assignment
- C1 Table – Excel file with some data to get you started. Please complete the process of entering the data.
- Pivot Table – Excel file with some data to get you started.
Please go through the tutorial document attached and follow all the steps outlined in each section. The two excel files attached will help you go through the step by step instructions. Those instructions will help ensure you understand how to perform these functions using Excel.
Once you have completed the tutorial, answer the questions on page 20. In order to answer the questions you should have completed the step by step instructions on the previous 19 pages and it will also require you to create a new spreadsheet using the information provided to you in question 5.
Your final submitted document can be in word format and contain “screen captures” of the excel file with your solution to each question. If you are on a MAC then press “Command+Shift+4” in order to take a screen shot and if you are on a PC please use the printscreen function or a program like “Snipping Tool”.
video Guide: https://www.youtube.com/watch?time_continue=295&v=Ny60XY2oTEI