Excel Functions for Retail Analysts
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!
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