Excel for Retail Link® Users

Overview

What do you do with all of the information that you pull down from Retail Link?  Our Excel for Retail Link® Users course helps you analyze Retail Link data quicker and easier.  Participants will learn how to manipulate, share and present information to support decision making at all levels of the organization. The tools used will help with data analysis, multiple applications linking, simulation modeling and decision making under uncertainty.  By using a wide variety of examples and hands-on applications, you will learn to take a set of data from Retail Link®; and turn it into usable information.

In this course, you will learn:

  • Conditional formatting
  • Filters and Sorting
  • Group and Sub-totals
  • Formulas and Functions
    • If
    • Count
    • Max, Min
    • Countif
    • And, Or
  • VLookup
  • Cell References
  • Range name
  • Merging Shared Workbooks
  • Data Validations
  • Compare side to side
  • Auto fill
  • List
  • Graphic Charts
  • Pivot Tables and Reports
  • Macros
  • Scenarios
  • Goal Seek
  • Solver
  • Data Tables and Consolidation