BEGIN:VCALENDAR X-WR-TIMEZONE:US/Eastern DTSTART:20180913T130000 DTEND:20180913T143000 VERSION:2.0 LOCATION:OnlinePRODID:-//Training Doyens //EN METHOD:REQUEST BEGIN:VEVENT UID:20180913T000000-1028601548-example.com DTSTAMP:20180913T000000 DTSTART;TZID="US/Eastern":20180913T130000 DTEND;TZID="US/Eastern":20180913T143000 SUMMARY:MS Excel - Automated Dashboards for Business Intelligence: How to Use Pivot Tables to Summarize Data, Create KPI Summaries, Visual Communication Using Charts and more. DESCRIPTION: No matter what business you are in, a dashboard is a critical tool in your communication armoury and as with any communication tool, presentation is everything. Although there are many tools that can be used to create a dashboard, MS Excel is commonly used due to its power, its flexibility and the fact that most people have it installed on their computer.  Thistraining focuses on what you need to know to create an interactive professional-looking dashboard using MS Excel.  You'll learn how to: make the Excel Dashboards maintenance-free when new data becomes available; create the pivot tables needed to drive the dashboard; create great looking visuals; add interactivity using slicers; automate elements of the dashboard with a macro and protect the cells containing critical formulas. PRIORITY:3END:VEVENT END:VCALENDAR