How to Make Excel Write a Report
In this class, you will learn how to make Excel dynamically produce written textual summary observations based on a changing data set.
Businesses of all kinds rely on Excel for its ability to handle numbers. But, Excel can also be used to write sentences that change depending on an underlying dataset. In turn, dynamic sentences can be used to annotate charts and tables for inclusion in dynamic reports. This class teaches you how to use a set of lesser-known Excel functions for the creation of routine reports, email text, and other commentaries that can be both tedious and time-consuming to construct.
Participants should have completed the course Microsoft Excel Functions for Retail Analysts or be proficient in the following:
- Foundations of formulas and functions
- If() and other useful logical functions
- Nesting functions
- vlookup() and other reference functions
- Functions and associated data types
- An introduction to various text functions
- Important lookup and reference functions
- Nesting functions together
- Managing complex functions