I’m willing to pay someone $30.00 to do this assignment for me. Thank you in advance!

Your manager could not be happier with the help you’ve provided to all of those departments requesting Excel assistance within the resort. He is now very confident handing over complex tasks to your capable hands. This week he is requesting that you exercise some expert skills. It seems he has some data that needs to be imported and cleaned up so that it is useful to the resort. He has quite a list of tasks he needs done with this data. Once the data are presentable, the analysis needs to be summarized in a short memo and placed on the last sheet in the workbook.

Additionally, your manager has also heard that macros can be added to a worksheet. He wants to make the X Games calculator even more efficient and foolproof for all those using it.

Just like traversing a double black diamond slope, you have the Excel knowledge to maneuver all of these tasks with excellence. This lab is for experts only.

Deliverables

NOTE

Submit your assignment to the Dropbox, located at the top of this page. For instructions on how to use the Dropbox, read these step-by-step instructions.

(See the Syllabus section “Due Dates for Assignments & Exams” for due dates.)

After completing the steps below, turn in one Excel 2016 workbook. Rename the workbook with your lastname_first initial_Week7_Lab. xlsx. Example: If your name were Jane Doe, your workbook would be Doe_J_Week7_Lab.xlsx.

LAB 6 – What-If-AnalysisStepTaskPoints PossiblePoints ReceivedComments1Import and Organize Data1a – bImport Data5  1c -iProfessional Clean up & Formatting5  2Create Macro for X Games Calculator2a – lCreate & Record Macro6  3Assign Macro3a – fDraw Macro button5  3g – iAssociate Macro with button5  4Save Macro enabled file & Protect Calculator4a, bSave as .xlsm file type3  4cunlock user input cells4  4dAssociate Macro with button4  5Create a Documentation Sheet – Apply Watermark5a-cInsert and create documentation sheet4  5d-jCreate watermark4  6Summarize and Prepare Memo6a – dSummarize and write memo on last worksheet10  Comment in Dropbox: What you learned from completing this Lab5  TOTAL POINTS600 

Week 7 Grading Rubric

Lab Resources

Microsoft Office: Excel 2016

Options for Accessing Microsoft Excel 2016

Lab Steps

Preparation

You will be using Microsoft Excel 2016 for this lab.

Be sure you have read the required chapter materials and reviewed the hands-on exercise videos located on the Lesson page before you begin the lab.

Please do not rely solely on the hands-on exercise videos to complete this week’s lab. The videos provide detailed examples walking you through the hands-on exercises. Applying the hands-on exercise examples will provide both practice and instruction of what to complete.

Begin: Open and Save

Download the spreadsheet Week 7 Lab – Summit Ridge Mountain Resort Student.xslx. You will be prompted to save the file. Click yes.

Download the spreadsheet Week 7 Lab – Import.txt. You will be prompted to save the file. Click yes.

Note: If you are using the Remote Lab environment, you will need to follow the instructions for uploading the file. These instructions can be found on the Lab page when you click on the Lab icon on Course Resources.

To save the spreadsheet with a new file name,

Step 1: Import and Clean Up Text File

Cleaned Up Import

Step 2: Create the Macro in the X Games Ticket Calculator

In this section, we will actually build a macro. A macro is simply a recording of every keystroke you perform while the Macro Recorder is turned on. You are quite simply automating keystrokes and building efficiency into your Excel file.

Step 3: View the Macro and Assign a Macro Button in the X Games Calculator Sheet

Behind the scenes, Excel has written a little Visual Basic for Applications (VBA) program, which you may access by clicking the Macros command.  

Transcript

Associate this button with the macro. Right-click on the shape and select Assign Macro from the menu.

Associate Button With Macro

Select CalcWipe and click OK to assign the macro to the button.

To prepare to test the macro, provide input into cells E4 and E6 by selecting a ticket type in cell E4 and enter a quantity in cell E6 for starting values. Then test your macro by simply clicking the button. Did it clear the contents of your input cells? If yes, congratulations on creating your first macro. If no, please return to Step 2, Part E to build the macro again.

Step 4: Save the Macro-Enabled File and Turn on Protection in the X Games Calculator Sheet

Step 5: Create a Documentation Sheet and Apply a Footer With Watermark Ski Image

Clean up the formatting of your Excel workbook, taking into account professional appearance.

The Minimum Requirement (per the Grading Rubric)

Transcript

Step 6: Summarize and Write Memo

Return to the worksheet named Gonzales. The analysis on this worksheet needs to be summarized in a short memo. Here are some details and ideas about the memo to be written.

Finish and Submit

Save your Excel file as a Macro-enabled workbook!! Your Excel file should contain four worksheets.

Submit one Macro-enabled Excel file to the Dropbox. When submitting the file, provide a comment in the Dropbox comments area explaining what you learned from completing this lab activity. File naming convention: If your name is Jane Doe, then your file should be named very similar to Doe_J_Week7Lab.xlsm.

Our website has a team of professional writers who can help you write any of your homework. They will write your papers from scratch. We also have a team of editors just to make sure all papers are of HIGH QUALITY & PLAGIARISM FREE. To make an Order you only need to click Ask A Question and we will direct you to our Order Page at WriteDemy. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.