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.


Prerequisites

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

$199


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.

REGISTER


 

Location

view map

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


Instructor

David CooperDavid Cooper
Principal
Transactional Insights

view profile