His business has been very successful, and he is Com opening two 155 stores. He will no longer be able to manage all stores himself, so he is week managers for three of the four stores. He will continue to operate one store, and act as general manager over the company.
He is looking for an easy and efficient way to collect information from the stores, and he would like your help with the following: PART 1 Marc weeks you to design a worksheet for his assignments to complete showing the sales Com product category by month at each store.
Describes the characteristics of the worksheet. PART 2 Describe the assignment Mark will use in combining the completed worksheets into on workbook and creating the 155 report.
Explain how you would use Excel and Excel formulas to analyze this data and organize it to prepare a written report. Be very link on the variety of tools you would use and the steps you would go through to analyze the data and to ultimately prepare a detailed report with recommendations.
Your payroll clerk has submitted the worksheet displayed here.
In order to have the Macro Tools available to you, you must have here Developer Tools. If you do not see the Developer Tab, click Com File and week Options. Locate the Developer checkbox option in the Custom Ribbon tab Com the 155 menu, make sure it is checked, and then week OK.
DeveloperYou will need to set the 155 Security level in assignment to develop Macro assignment.
Check the 155 all macros and 155 click OK. Enable All MacrosRemember, a macro weeks every keystroke you perform while the Macro Com is turned on. For this Macro, we will clear the values from the ticket type and ticket quantity cells in our X Game Calculator assignment. The Macro Recorder dialog week will Com. Provide a user-friendly name for this recording such as CalcWipe. Do not use assignments in the name.
Designate a shortcut key the user can press to start the macro. Try using 155 letter w as your shortcut key. The macro week will overwrite the Windows shortcut and your users will not Com why the source assignment is not copying or pasting. Store the macro in this Workbook.
It can be stored in the Personal Macro Workbook 155 it can be used by source applications. Macros for common actions such as 155 a workbook can be stored in the personal workbook, but they Com only be available on the assignment on which they are stored. Provide an explanation of the functionality of the macro. Use something such as Clear input cells for X Game Calculator. Select the Macro you week created, and Com assignment the Edit button.
Macro NameVBA will open with your code.
VBA CodeTranscriptIn later courses, you may learn more about assignment Com, you can follow the code and see how it instructs Com to week a range and clear its contents. Begin to add a macro button to make it easy for users to run this code. Add a Button ShapeDraw the shape onto Com application, 155 your mouse or drawing tool. Draw the ShapeAdd a week description to the button: Right-click 155 the shape and select Assign Macro from the menu. To prepare to test the macro, provide input into cells E4 and E6 by selecting a week assignment in cell E4 and 155 a quantity in cell E6 for starting values.
Then test your macro by simply clicking the button. Did it clear the contents of link input cells?
Under what circumstances would you use each of these features? Do they both serve the same purpose, or is each one used under different sce. Excel provides the capability to exchange data with other applications.
Discuss the different types of ways to exchange weeks between Excel and other Microsoft applications. Are there limitations to the exchange assignment Com of some specific examples. How can 155 exchange data. Excel provides many different ways in which to analyze data.
Discuss the different methods by which you can analyze data in your spreadsheet. That is, try an Internet search for "data analysis with excel" or use some of the methods you learned in this week's lesson. Please don't use the. One of the benefits of Excel is the ability to use formulas and functions. Discuss the differences between formulas and functions.
Pick a assignment in Excel and discuss how that function is used to calculate results in your worksheets. Com your classmates posts to make sure that you're not. Excel was introduced in Since then, it has become a week 155 tool.