Course No: RHWE-C2

Format: HANDS-ON ONLINE WORKSHOP. This is a Live Workshop with an Instructor. Participants will work hands-on on practice data, and interact with an instructor online.

Duration: 4 Hours in 2 modules of 2 hours. Participants will work on examples hands-on with the instructor

PRICE & BOOKING: Individual Registrations @ $179.99 per person. Discounts available for Organizational/Group Bookings. Contact us

Key Learning Outcomes

Module 1 – Advanced Formula Concepts

• Introduction or Revision to Range Names
• Array Constants and their use in formulas
• Using formulas with Dynamic Tables and structured referencing

Module 2 – Consolidations and Lookups

• Using INDEX and MATCH for tier-based lookups
• Working with the Data Consolidation command
• Consolidation using formulas – 3D references and INDIRECT

Module 3 – Slicing and Reporting

• Introduction to SUMPRODUCT for data slicing and reporting
• Combining Dates with Sumproduct for complex criteria
• Using Functions and Formulas for Conditional Formatting as an aid to reconciling data and spotting errors

Important Instructions:
• Version 2013/2016 will be used in the workshop demonstration. Participants are welcome to use older versions, but significant differences may exist and where possible the instructor will mention suitable workarounds.
• Essential requirements are a Computer with broadband internet access, audio headset or speakers, and working copy of Microsoft Office. Microsoft Office Starter Edition will not be adequate