How to Make Excel Write a Report

Microsoft ExcelIn 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.


Prerequisites

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

Learning Objectives

  • 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

$199


REGISTER

Discount Information
Refund Policy
 

Global Campus - Rogers
3300 Market Street
Suite 402
Rogers, AR 72758


Instructor

David CooperDavid Cooper
Principal
Transactional Insights

view profile