Excel 2007 for Retail Link® Users

Overview

Have you recently upgraded to Excel 2007?  If so, you quickly noticed several significant differences from Excel 2003 and have quite possibly become frustrated more than once by the extra time it’s taking to get the same things done.

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