Course No: RHWE-1451

Format: HANDS-ON ONLINE WORKSHOP

Duration: 4 Hours plus breaks for a maximum of 4 hours and 30 minutes

PRICE:  Individual Registrations @ $240 per person. Discounts available for Organizational or Group booking.  Contact us

Key Learning Outcomes

MODULE 1 – MANAGING AND EFFECTIVELY DEALING WITH DATA
• Understand data types, dates, and other kinds of data
• Learn tools like Text to Column for managing data inconsistency
• Briefly explore the newer TABLE feature and its importance as a dynamic dataset

MODULE 2 – ANALYSIS WITH FUNCTIONS AND FORMULAS
• Introducing important Functions – The COUNTIFS and SUMIFS functions for conditional calculations
• Understand the VLOOKUP Function for extracting information and merging tables
• A brief introduction to XLOOKUP  – Office 365 only

MODULE 3 – ANALYTICAL TOOLS – PIVOT TABLES
• Working with PIVOT TABLES –
o Maintaining Data discipline
o Manipulating Pivot Table Fields
o Pivot Table tips and tricks for effective work

GENERAL MODULE – SPREAD THROUGHOUT THE WORKSHOP
o Tips and Tricks for reporting and speedy working

Important Instructions:
• Office 365 will be used in the workshop demonstration. Participants are welcome to use older versions, but some differences may exist. Microsoft Office Starter Edition will not be adequate

Test drive this workshop!

View this short clip of an actual Accelerated Intermediate Excel workshop recording of the Instructor’s Screen