DeVry University Text Import and X Game Calculator Macro
Step 1: Import and Clean Up Text FileDownload starting student Excel file and the text file. Open the starting Excel file …
DeVry University Text Import and X Game Calculator Macro
Step 1: Import and Clean Up Text FileDownload starting student Excel file and the text file. Open the starting Excel file and navigate to Sheet1.Import the text file by using the Get External Data function on the Data Ribbon. When the Text Import Wizard displays, select My Data has headers and use a comma delimiter to organize the data.Insert a new column in between A and B and use the Text to Columns command to separate first and last name. Be sure to revise or add appropriate column names.Insert a column to the right of the HOME ADDRESS column and use a function to capitalize just the first letter in the address names. Then hide the original Address column.Insert two new columns in between City State Zip and the Unit column, and then use Text to Columns to separate these fields. Adjust column widths appropriately.On the right of the Agent column, add a column and use the Substitute function to replace “JG” with “Jesse Gonzales,” and then hide the original Agent column and display the full name.Add statistics to add up all sales, and then apply a 7% commission to calculate the Gonzales commission.Change the sheet name to Gonzales.Under Page Layout, select Themes and choose a business-like theme and possibly a color combination to apply professional formatting and column widths to all of this data using the image below as a guide. Using the Gonzales sales data, create a Pivot Table showing his total sales by development. Format appropriately. Step 2: Create the Macro in the X Games Ticket CalculatorIn 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.Select the X Game Calc sheet.In order to have the Macro Tools available to you, you must have the Developer Tools. If you do not see the Developer Tab, click the File and select Options.Locate the Developer checkbox option in the Custom Ribbon tab in the Options menu, make sure it is checked, and then click OK.DeveloperYou will need to set the Macro Security level in order to develop Macro code. From the Developer Tab, click on Macro Security in the Code group. Check the Enable all macros and then click OK.Enable All MacrosRemember, a macro records every keystroke you perform while the Macro Recorder is turned on. For this Macro, we will clear the values from the ticket type and ticket quantity cells in our X Game Calculator sheet. We will turn on the Macro Recorder, delete the data in Cells E4 and E6, and then turn the Macro Recorder off.Click the Record Macro button from the Developer Tab, Code group. The Macro Recorder dialog window will open.Macro Name: Provide a user-friendly name for this recording such as CalcWipe. Note: Do not use spaces in the name.Shortcut key: Designate a shortcut key the user can press to start the macro. Try using the letter w as your shortcut key. Note: Avoid using a shortcut commonly used in Windows applications, such as CTRL-C or CTRL-P. The macro shortcut will overwrite the Windows shortcut and your users will not understand why the key combination is not copying or pasting.Store: Store the macro in this Workbook. Note: It can be stored in the Personal Macro Workbook so it can be used by other applications. Macros for common actions such as printing a workbook can be stored in the personal workbook, but they will only be available on the computer on which they are stored.Description: Provide an explanation of the functionality of the macro. Use something such as Clear input cells for X Game Calculator. See image below.Record MacroWhen you click OK, the Macro Recording begins. Select Cell E4, press the Delete key, and then select Cell E6 and press the Delete key.Then turn the Macro Recorder off by clicking the Stop Recording button from the Macro group.Step 3: View the Macro and Assign a Macro Button in the X Games Calculator SheetBehind the scenes, Excel has written a little Visual Basic for Applications (VBA) program, which you may access by clicking the Macros command. Select the Macro you just created, and then click the Edit buttonMacro NameVBA will open with your code.VBA CodeTranscriptIn later courses, you may learn more about programming; however, you can follow the code and see how it instructs Excel to select a range and clear its contents. Click the X in the top-right corner of this MS VBA screen to close macro editing and return to the Excel file.Begin to add a macro button to make it easy for users to run this code. Add a Button Shape to your application using the Insert Tab, Shapes.Add a Button ShapeDraw the shape onto the application, using your mouse or drawing tool.Draw the ShapeAdd a text description to the button: “Clear calculator values!”Associate this button with the macro. Right-click on the shape and select Assign Macro from the menu.Associate Button With MacroSelect CalcWipe and click OK to assign the macro to the buttonTo 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 SheetYou will need to save this file as a macro-enabled workbook. Click the File tab and select Save As.Select Excel Macro-Enabled Workbook, which is also the .xlsm file type.By default, all cells in a worksheet are locked. This means that when the worksheet is protected, the users will not be able to enter or change data in those cells. We will protect the worksheet, but first we must unlock the user input cells. Select cells E4 and E6. Right-click and select Format Cells from the menu. In the Protection tab, uncheck the box labeled Locked.Protect the worksheet. From the Home Menu Cells group, select Format, Protection, Protect sheet. DO NOT add a password. Protect SheetRemember to save the file as an .xlsm (Macro-enabled) file. Step 5: Create a Documentation Sheet and Apply a Footer With Watermark Ski ImageClean up the formatting of your Excel workbook, taking into account professional appearance. The Minimum Requirement (per the Grading Rubric) Insert a new sheet into the workbook, name it Documentation, and move it to be the first sheet.As always, properly document all contents of the workbook on this sheet including names and brief descriptions of each sheet.Apply a business such as formatting to all of these cells.Create a watermark footer containing an experts-only ski image by first searching the Internet for an appropriate free image and save it. Use something such as the following.Experts OnlySelect Page Layout and then open the Page Setup window.Page LayoutSelect Custom Footer and then use the icon on the right side to insert the image saved above into the Center section of the Footer.Once the &[Picture] is displayed in the Center section, the Format Picture icon on the far right will be available. Click it.In the Format Picture pop-up window, select the Picture tabUnder the Image control section, select the drop-down option by Color and select Washout, and then click OK to accept it. Click Print Preview on the Page Setup window to view the results!Print Preview TranscriptIMPORTANT: Remember to save this file as a Macro-enabled workbook.Step 6: Summarize and Write MemoReturn 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.The memo should be written to Jesse Gonzales. Your name should also be in the From portion of the memo. Include a summary of the analysis completed.Possible thoughts to include: target sales for new fiscal period, sales for new developments, sharing expertise with others in sales, and a thank you for good work. The memo needs to be written professionally and placed on the last sheet in the workbook. Name the last worksheet Memo. Finish and SubmitSave your Excel file as a Macro-enabled workbook!! Your Excel file should contain four worksheets.DocumentationGonzalesX Games CalcMemoSubmit one Macro-enabled Excel file. When submitting the file, provide a comment in the 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.PreviousNext
Central Washington University The Virgin Group Case Questions
For this case, refer to the textbook, Chapter 12, “Diversification Strategy,” especially the sections on “Competitiv …
Central Washington University The Virgin Group Case Questions
For this case, refer to the textbook, Chapter 12, “Diversification Strategy,” especially the sections on “Competitive Advantage from Diversification and “Relatedness in Diversification.”Your case analysis should typically be no shorter than two full pages in length, using Arial font 10, 1.5 spacing. (Target a word count of 800-1000, typically). Case QuestionsWhat common resources and capabilities link the separate Virgin companies?Which businesses, if any, should Branson consider divesting?What criteria should Branson apply in deciding what new diversification to pursue?What changes in the financial structure, organizational structure and management systems of the Virgin group would you recommend?
4 pages
Lululemon Case Study
Question 1: Analyze the impact of the general environment on Lululemon’s business. Highlight the demographic segment, glob …
Lululemon Case Study
Question 1: Analyze the impact of the general environment on Lululemon’s business. Highlight the demographic segment, global segment, political/legal …
Global Marketing
TOPIC 1: We already covered global brands and products and the continuum in other conferences, but I wanted to include a …
Global Marketing
TOPIC 1: We already covered global brands and products and the continuum in other conferences, but I wanted to include a brief discussion here so that we always and everywhere continue to see the connectedness of the marketing mix, or the four P’s, product, price, place and promotion. Let’s keep this one simple. What is the difference between a local, international and global product? Give examples of each and state the reasons for your choices. Comment on a classmate’s post. TOPIC 2:Remember our management orientations? In addition to being key to HOW a company expands internationally, those management orientations also have a lot to do with how products are priced in different countries.1. Ethnocentric pricing, essentially the same price is charged no matter where in the world the buyer is located. 2. Polycentric pricing, permits subsidiary or affiliate managers to establish whatever price they feel is most appropriate in their market environment. 3. Geocentric pricing, more dynamic and proactive than the other two, the price is neither fixed worldwide nor are subsidiaries or local disributors allowed to make independent pricing decisions. Generally, the price is controlled from headquarters but is based on local market factors. Explain the pros and cons of each pricing strategy. For example, the simplicity of ethnocentric pricing, especially for low end products sounds appealing. In addition, one price worldwide would eliminate the gray market for that good. Use at least two (2) references.TOPIC 3: How has the Internet revolutionized global place decisions? Be specific, use a reference and interact with another student!TOPIC 4: Pick one product marketed in at least two countries. See if you can find copies of ads from each country. Youtube is a pretty good source for this as well as company Web sites. Compare the two ads and discuss their similarities and differences in terms of message, how the product is positioned the same or differently, differences that may arise from cultural considersations, etc.Post a link to the ads and comment on a classmate’s post.
MGT 711 UP Business Discussion
PART 1 Write a 250- to 300-word response to the following: Discuss the external factors that impact organizations when e …
MGT 711 UP Business Discussion
PART 1 Write a 250- to 300-word response to the following: Discuss the external factors that impact organizations when expanding globally. How could you use Porter’s 5-Factor Model to formulate strategies for global expansion? Include your own relevant experience as well as 2 citations that align with or contradict your comments as sourced from peer-reviewed academic journals, industry publications, books PART 2 Reply in 150 words When it comes to external factor we need to be ready and on our toes in order to make sure it doesn’t affect us. According to Ran, (2019), “The global economy is one of the biggest external factors that will, at some time, affect your business.” Markets rise and fall based on politics, terrorism attacks, wars and currency depreciation eventually trickles down to most commercial companies. In today’s current global economy, according to WEO, (2021), we are at a, “projected to grow 5.9 percent in 2021 and 4.9 percent in 2022, 0.1 percentage point lower for 2021.” The good thing is that there are many benefits in a global economy and they include, free trade, which is an excellent method for countries to exchange goods and services. Also, the good thing is increased investment due to the presence of the global economy, it has become easier for countries to attract short-term and long-term investment. PART 3 (literature attached) Write a 250- to 300-word response to the following: Pose a question based on the literature. Provide background leading up the question, use supporting references, and answer your own question. Include your own relevant experience as well as 2 citations that align with or contradict your comments as sourced from peer-reviewed academic journals, industry publications, books, PART 4 Reply in 150 words How can identifying and evaluating external opportunities and threats have a positive outcome on an organization?
CU Laissez-Faire Team Management Essay
One question leaders have is how closely to manage team members.How much is too much?How much is too little?Find an articl …
CU Laissez-Faire Team Management Essay
One question leaders have is how closely to manage team members.How much is too much?How much is too little?Find an article about micromanagement or laissez-faire management.Summarize and analyze this article. Articles must be from a peer-reviewed journal and published within the last three years. Instructions: TITLE PAGE: Per APA format. DEFINITION: a brief definition of the key term followed by the APA reference for the term; this does not count in the word requirement. SUMMARY: Summarize the article in your own words- this should be in the 250-words. Be sure to note the article’s author, note their credentials and why we should put any weight behind his/her opinions, and research or findings regarding the key term. ANALYSIS: Using 500 words, analyze the article as it relates to the selected key term. A discussion is not rehashing what was already stated in the article, but the opportunity for you to add value by sharing your experiences, thoughts and opinions. This is the most important part of the assignment. Analyzing articles is an opportunity to delve into organizations to determine best practices. Organizations in and of themselves are just things. However, when you add people to them, they then become what are known as living and learning organizations – aka knowledge organizations. Leadership offers direction and support to groups or organizations and is multidimensional. Leadership is responsible for setting the tone that permeates throughout the organization.
QUALITY: 100% ORIGINAL – NO PLAGIARISM
(USA, AUS, UK & CA PhD. Writers)
CLICK HERE TO GET A PROFESSIONAL WRITER TO WORK ON THIS PAPER AND OTHER SIMILAR PAPERS
About Our Service
We are an online academic writing company that connects talented freelance writers with students in need of their services. Unlike other writing companies, our team is made up of native English speakers from countries such as the USA, UK, Canada, Australia, Ireland, and New Zealand.
Qualified Writers
- At ClassicWritersBay.com, most of our writers are degree-holding native speakers of English who are familiar with various writing styles. Our writers are proficient in many fields, including Economics, Business, Accounting, Finance, Medicine, Chemistry, Literature, Mathematics, Statistics, and many others.
- Making our customers happy is an important part of our service. So do not be surprised if you get your paper well before the deadline!
- We pay a lot of attention to ensuring that you get excellent customer service. You can contact our Customer Support Representatives 24/7. When you order from us, you can even track the progress of your paper as it is being written!
- We are attentive to the needs of our customers. Therefore, we follow all your instructions carefully so that you can get the best paper possible.
- It matters to us who writes for you, and we are serious about selecting the best candidates.
- Our writers are always learning something new, so they are familiar with the latest developments in the scientific world and can write papers with updated information and the latest findings.
Our Guarantees:
- Quality original papers that follow your instructions carefully.
- On time delivery – you get the paper before the specified deadline.
- Attentive Customer Support Representatives available 24/7.
- Complete confidentiality – we do not share you details or papers with anybody else.
