Question

In: Statistics and Probability

Week 1: Getting Familiar With Excel 15 15 unread replies. 18 18 replies. Excel was introduced...

Week 1: Getting Familiar With Excel

15 15 unread replies. 18 18 replies.

Excel was introduced in 1985. Since then, it has become a standard business tool.

Discuss and explain at least six different (unique) features of Excel that make it a valuable business tool.

Discuss what type of Excel skills would be important in today’s job market and why. Be specific.

Note: In addition to the Microsoft Excel 2016 overview in the Course Home section, there are many Excel resources in addition to your text on the Web. For example, try an Internet search on "top ten Excel 2016 features" and sift through some of the resources. Be sure to read your classmates' posts, and see how many features you can find that haven't been listed yet.

Solutions

Expert Solution

Unique features of Excel that make it a valuable tool:

1. Pivot Table: It can summarise lot of data in form of unique table form that be sorted and read as per convinience. This helps in analysing large volumes of unsorted data.

2. Power View: Helps in making reports quickly.

3. Data can be analysed using charts and tables.

4. Chart tools: Excel is very helpful in making charts. There are lots of chart templates and also suggestions for appropriate charts based on the data set to be analysed.

5. Sorting and filtering data. Excel has "sort" feature, which can be used in sorting and arranging large amount of data in a structred manner.

6. Excel has a vast range of functions for performing simple tasks to complex formulas for addition, multiplication, mean, average, subtraction, division and many numerous statistical and scientific formulae.

7. Look-up formulas (VLOOKUP, HLOOKUP, INDEX, MATCH etc.): Lookup formulas help you locate any information in your workbooks based on input criteria. By knowing how to write lookup formulas, one can build dashboards, make interactive charts and create effective models.

Excel skills important in today's job market.

1. VBA, Macros and Automation: VBA stands for Visual Basic for Applications, is a special language that Excel speaks. By learning this language, one can generate and email reports automatically.

Macros are little VBA programs written to achieve this. Once you learn VBA, suddenly your company will find you invaluable, thanks to all the time & effort you will be saving due to automation.

2. Pivot Tables: They save you lots of time, let you create complex reports, charts & calculations all with few clicks.

Pivot tables are ideal tools for managers & analysts who always have to answer questions like,

  • What is the trend of sales in last 6 months?
  • Who are our top 10 customers?
  • Which button do I press for strong latte?

Pivot tables can answer almost any business question if you throw right data at them. When presenting data in form of charts and graphs, users are able to notice the key emerging trend from the information at hand.

3.  Lookup formulas (VLOOKUP, HLOOKUP, INDEX, MATCH etc.): Lookup formulas help you locate any information in your workbooks based on input criteria. By knowing how to write lookup formulas, you can build dashboards, make interactive charts, create effective models. Excel helps to bring similar data of related entities together.

4. Excel charts help you communicate insights & information with ease. By choosing your charts wisely and formatting them cleanly, you can convey a lot.

5. Conditional formatting is a hidden feature in Excel that can make your workbooks informative. By adding some conditional formatting to highlight your data, you can turn boring into interesting. With new features like data bars, color scales & icon sets, conditional formatting is even more powerful. Excel is used for conditional formatting which predicts changes likely to take place in future.

6. PowerPivot, Data Explorer & Data Analysis features: Excel add-ins like PowerPivot, Data Explorer and Analysis tool packs let Excel do more like

  • Combining multiple tables and creating reports from them
  • Processing data from difference sources and getting output to Excel
  • What if analysis, scenarios & optimization.

These are very sought after skills in business.


Related Solutions

Week 13 | Discussion 1: Empathy - The Misunderstood Skill 5757 unread replies.7878 replies. In the...
Week 13 | Discussion 1: Empathy - The Misunderstood Skill 5757 unread replies.7878 replies. In the classic novel, To Kill a Mockingbird, Atticus Finch says to his daughter Scout: “If you can learn a simple trick, Scout, you’ll get along a lot better with all kinds of folks. You never really understand a person until you consider things from his point of view – until you climb into his skin and walk around in it.”1 Reference: Empathy: The Misunderstood Skill...
Week 2: Faith No unread replies. No replies. Faith Interviews: Ask two people to share their...
Week 2: Faith No unread replies. No replies. Faith Interviews: Ask two people to share their views on faith, do they believe, why do they believe, what has helped or hindered their experience of faith? Submit their answers to discussion board by midnight, Thursday. Respond to other two students’ posts by Sunday. Based on your own experience and on the interviews, what are some of the factors that lead people to lose faith and what are some things that help...
Discussion Board Week 4 Day 1 No unread replies.No replies. A. Explain what it means to...
Discussion Board Week 4 Day 1 No unread replies.No replies. A. Explain what it means to serve as the patient’s advocate. B. Discuss the importance of advocating for the patient. C. Why is treating patients with dignity and respect important? D. Why is trust a key to preventing lawsuits? E. What may you write about your clinical assigned patient on Facebook? F. How is the HIPAA Privacy Rule different from the Security Rule?
Chapter 18 Discussion and Lecture Comments 23 23 unread replies. 23 23 replies. The Rebuilding Decision...
Chapter 18 Discussion and Lecture Comments 23 23 unread replies. 23 23 replies. The Rebuilding Decision After Tom and Elise Ryan finished veterinary school in the early 2000s, they spent several years working for other veterinary clinics. By 2007, they felt it was time for them to start their own practice. They considered several towns in the south-central United States, visiting local chambers of commerce and studying each town’s demographics. They finally settled in Wardston, a small city in Arkansas....
Week 3 Discussion: Implementation of EHR 33 unread replies.33 replies. Due: Post your initial response by...
Week 3 Discussion: Implementation of EHR 33 unread replies.33 replies. Due: Post your initial response by Wednesday night at 11:59pm Pacific Time. Respond to at least two of your fellow students’ posts by Sunday night at 11:59pm Pacific Time. Implementation of EHR Discuss the advantages and disadvantages associated with implementing and using a regional and national EHR. Response Posts: In addition to your original post, be sure to provide a meaningful response to at least two of your peers’ posts...
Discussion: States of Consciousness No unread replies. No replies. Sleep Stages STEP 1: Respond to the...
Discussion: States of Consciousness No unread replies. No replies. Sleep Stages STEP 1: Respond to the following in a primary post of at least 150-200 words: What are the stages of sleep and what is the importance of sleep? Most of us feel like we never get enough sleep. What can you do to improve your sleep and improve your consciousness during waking hours?
Week 4 Discussion: Telehealth Adoption 1313 unread replies.2121 replies. Due: Post your initial response by Wednesday...
Week 4 Discussion: Telehealth Adoption 1313 unread replies.2121 replies. Due: Post your initial response by Wednesday night at 11:59pm Pacific Time. Respond to at least two of your fellow students’ posts by Sunday night at 11:59pm Pacific Time. Telehealth Adoption Why has telehealth adoption taken so long in the health-care industry when Skype, cell phones, and other video conferencing applications have been used in personal and business interactions for decades? Response Posts: In addition to your original post, be sure...
Discussion: Sensation and Perception No unread replies. No replies. Cultural Influences on Perception STEP 1: Respond...
Discussion: Sensation and Perception No unread replies. No replies. Cultural Influences on Perception STEP 1: Respond to the following prompt in a primary post of at least 150-200 words: Sensation refers to an actual event; perception refers to how we interpret the event. What are some cultural differences that might affect responses to particular stimuli? Create a post using examples from the text as well as your own experiences.
Discussion Board - Unit 6, Lesson 1 9999 unread replies.9999 replies. 1) Discuss the purpose of...
Discussion Board - Unit 6, Lesson 1 9999 unread replies.9999 replies. 1) Discuss the purpose of academic standards? How do teachers use them to plan for instruction? What are your personal thoughts on how standards are used to plan and assess student learning? 2) What are some of the key benefits of using academic standards for planning? What are some of the arguments that critics have to say about academic standards? Explain using evidence from the text. FOR EDUCATION
Week 10 DB: Misleading Statistics No unread replies.No replies. 1. Where can you find misleading statistics?...
Week 10 DB: Misleading Statistics No unread replies.No replies. 1. Where can you find misleading statistics? 2.Why do you believe misleading statistics are used in our everyday lives? 3. Find an example of a misleading statistic.Identify where you found it and provide us with either a link or a picture of it. Make sure to state what information from your example makes it misleading and how you were about to identify this. 4.Can you think of another way to illustrate...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT