Excel Functions for Retail Analysts

Microsoft Excel

If you’re an analyst hoping to improve the quality of your output, there’s no substitute for a solid understanding of Excel functions.

This class teaches the utility of Excel functions from the perspective of the retail analyst. You’ll learn how to combine and nest functions in a way that will help you transform static spreadsheets into dynamic tools.

Don’t miss this chance to learn some of the most useful tricks David Cooper has accumulated over the past fifteen years as a working analyst!

Lesson Contents

Topic 1: If() and other useful logical functions.
Topic 2: Nesting functions.
Topic 3: Taking the drudgery out of vlookup().
Topic 4: How the search() function can make your life easier.
Topic 5: Creating dynamic titles for charts and graphs.
Topic 6: A trick for making complex functions easier to write.
Topic 7: You may have overlooked the utility of text functions.
Topic 8: Using sumproduct() as a basis for an alternative to a filter.
Topic 9: Using Excel functions to write entire summary reports.


To ensure success in this class, students should be familiar with the following

  • Foundations of formulas and functions in Excel
  • Order of operations
  • Analyzing data with functions and conditional formatting
  • Organizing and analyzing data set

October 17, 2017

8:30 am - 4:30 pm
Lunch is on your own
11:30 am - 12:30 pm



Discount Information
Refund Policy


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


David CooperDavid Cooper
Transactional Insights

view profile