Skip to ContentGo to accessibility pageKeyboard shortcuts menu
OpenStax Logo

A group of women are gathered around a conference table with laptops and notebooks.
Figure 11.1 Using the advanced tools in Excel can help businesses evaluate the effectiveness of their social media marketing efforts. (credit: modification of "Group of Women gathered inside Conference Room" by Christina Morillo/Pexels, CC0)

As with many corporations, at WorldCorp there is a need to share information internally across various business functions, such as marketing, accounting, and operations. This could include information about current customers and their purchasing patterns or price changes in shipping cost over the last five years. This type of information can then be used by each department to evaluate their performance or to identify opportunities. The data used by each group might vary and the analysis will also differ based on the needs of the department. The information gathered internally might also be shared with external stakeholders in the business, such as customers or investors. Data shared with external entities could include shipping volume per customer or overall profit calculations for key investors in the business.

Microsoft Excel can facilitate data analysis at various levels within WorldCorp and for external audiences. It is a useful tool for assisting management with decision making and to understand the business at a higher level. Excel’s advanced tools facilitate the management, interpretation, and presentation of data critical to managing a business or an organization.


This book may not be used in the training of large language models or otherwise be ingested into large language models or generative AI offerings without OpenStax's permission.

Want to cite, share, or modify this book? This book uses the Creative Commons Attribution License and you must attribute OpenStax.

Attribution information
  • If you are redistributing all or part of this book in a print format, then you must include on every physical page the following attribution:
    Access for free at
  • If you are redistributing all or part of this book in a digital format, then you must include on every digital page view the following attribution:
    Access for free at
Citation information

© Jan 3, 2024 OpenStax. Textbook content produced by OpenStax is licensed under a Creative Commons Attribution License . The OpenStax name, OpenStax logo, OpenStax book covers, OpenStax CNX name, and OpenStax CNX logo are not subject to the Creative Commons license and may not be reproduced without the prior and express written consent of Rice University.