Course Overview - Analytics, Speed Up Tricks & AI in ExcelLearning objectivesBy the end of workshop participants should be able to:1. Build PivotTables to aggregate data by category without formulas2. Create interactive dashboards using slicers & PivotTables3. Understand which of Excel’s data visualisations should be used when4. Use Excel’s built in AI tool to auto-analyse data using prompts5. Use Excel’s AI tools Flash fill/formula by example to clean up text or dates6. Understand the built in AI vs what costs extra (i.e. Copilot for Excel)7. Automatically colour cells based on conditions8. Learn how Excel’s little known “Format as Table” feature can be game changing9. Use keyboard shortcuts and other speed up tricksPre-requisitesThis workshop will be useful for anyone using Excel for 3 or more hours per week interested in doing things more efficiently and robustly.Formulas are a big part of Excel, but modern Excel has several ways to achieve equivalent things without them.Take home materials and documentationPost training website featuring all post course resources like this one with:Written notes on the key points coveredYouTube videos from the trainer’s 12,000+ subscriber tutorial channelSlides which were covered in classThe completed exercise filesInvestment £299 including light lunch, or £549 if combined with course on Formulas, Macros & Power Query on the following day.
For queries or special dietary/accessibility requirements please contact Jo on rocklearninggib@gmail.com or call +44 7419 993491.
