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
February 23, 2018
8:30 am - 4:30 pm
10% discount for University of Arkansas faculty, staff and current students. To receive the discount, you must register with your uark email address and enter coupon code 'UA10' at checkout. Status will be verified and correct rate will be applied. Additional discounts do not apply.
No refunds of the UA 10% discount, or any other discount, will be granted once registration is complete.
Global Campus - Rogers
3300 Market Street
Rogers, AR 72758