EXCEL:Creating a Dashboard with Spreadsheet data and Pivot Tables
Course No: RHWE-1491
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: 3 hours. Participants will work on examples hands-on with the instructor
PRICE & BOOKING: Individual Registrations @ $90 per person. Discounts available for Organizational or Group booking. Contact us
Key Learning Outcomes
Pivot Table Techniques together with Pivot Chart Techniques
• A quick revision on Pivot Table options – GetPivotData, and Field Options
• Working with Slicers and multiple Pivot Tables
• Setting up Dashboard data from Pivot Tables
• Creating appropriate Pivot Charts and a Dashboard
• Including Non-Pivot Data into a Dashboard
• Exploring more Pivot Table options if time available
Important Instructions:
• Version 2013 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.