What-If Analysis
Learning Objectives By the end of this section, you will be able to: Having a backup plan is helpful when things do not go as expected. The plan offers an alternative course of action to pursue in case the first…
Statistical Functions
Learning Objectives By the end of this section, you will be able to: Data surrounds us. In business, there is always a need to better understand the company, the competitors, and the customers. You gain this understanding through data collection…
Understanding Data, Data Validation, and Data Tables
Learning Objectives By the end of this section, you will be able to: Data can come in a variety of forms. It can fit into specific categories, or it can be more general in nature. We can collect data in…
Chapter Scenario
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) Chapter Outline 11.1 Understanding Data, Data Validation, and Data…
Summary
Data Tables and Ranges More About Formulas Using Arithmetic, Statistical, and Logical Functions PivotTables Auditing Formulas and Fixing Errors Advanced Formatting Techniques
Advanced Formatting Techniques
Learning Objectives By the end of this section, you will be able to: It is important for organizations to use uniform branding and style, which can appear anywhere, from emails to invoice templates to Excel files. Having a uniform style…
Auditing Formulas and Fixing Errors
Learning Objectives By the end of this section, you will be able to: WorldCorp receives many client orders every day, and the corporation needs to have an accurate count of inventory to ensure that they have the capacity to deliver…
PivotTables
Learning Objectives By the end of this section, you will be able to: PivotTables help data analysts use raw data and organize it into an interactive tool for summarizing and analyzing the data points. WorldCorp can, for example, gather their…
Using Arithmetic, Statistical, and Logical Functions
Learning Objectives By the end of this section, you will be able to: The world has changed rapidly in the decades since the 1980s, as personal computers became commonplace in offices and homes. Business calculations that used to be done…
More About Formulas
Learning Objectives By the end of this section, you will be able to: Portland is a small city in Cumberland County, Maine, and is Maine’s most populous city. Its main commercial attraction is that it is a port city, and…