MS Excel Toronto

In this session, we will explore some awesome tips on Data Storytelling. Dynamic and interactive charts are very important for Excel Dashboards to make the entire executive report interactive and meaningful. Explore 5 awesome tips & tricks for creating these dynamic and interactive charts in Microsoft excel. Data Storytelling is more than just visualizing data effectively. It is about communicating your insights effectively, giving your data a voice. --------------------- About the Speaker: Rahim Zulfiqar Ali Microsoft Certified Trainer (MCT) Microsoft Office Specialist Expert & Master Excel 2013, 2016 & 2019 (MSOM) Founder & CEO at EXCEL BASEMENT PRIVATE LIMITED 8+ years of experience as Corporate Trainer for Excel & 5 years for POWER BI Find more about Rahim's work on the links below: LinkedIn: https://www.linkedin.com/in/rahimzulfiqarali/ Website: https://excelbasement.org/ YouTube: https://www.youtube.com/c/ExcelBasementPvtLtd Twitter: https://twitter.com/ExcelBasement Facebook: https://web.facebook.com/excelbasement/ --------------------- AGENDA: (Eastern Time) 5:30 PM - 5:40 - Introduction 5:40 - 6:40 PM - "Five Awesome Dynamic & Interactive Charts in MS Excel & Data Storytelling Tips " by Rahim Zulficar Ali 6:40 PM - 7:00 PM - Q&A + Closing by Celia Alves and MS Excel Toronto Team We are looking forward to meeting you there!

Ken Puls will be demonstrating how Excelguru's Monkey Tools add-in can help you build better Excel BI models faster, and audit models that you receive from others. Monkey Tools is targeted at modellers and analysts who work primarily in Excel, but also push their models into Power BI. The broad set of features included in Monkey Tools will help you deal with things like • Diagnosing the issues behind the irritating “Relationships May Be Needed” error when building a Power Pivot-based PivotTables • Viewing queries by load destination and changing multiple query load destinations at one time • Injecting dynamic parameter tables and dynamic calendars into your data model with only a few clicks • Tracing query and DAX dependency trees • Indenting both M and DAX queries • Timing your query refresh speeds • Documenting your Excel or Power BI based models • And more! While we won’t be able to show all the functionality in one single meetup, you’ll get a good understanding of how this tool can help make your data modelling life easier! --------------------- About the Speaker: Ken Puls, FCPA, FCMA, is the president of Excelguru Consulting Inc, a company dedicated to helping users get the most from their data. His passion lies in exploring tools to turn data into information, and teaching others how to benefit from them. Ken is a blogger, author and trainer with over 20 years of corporate accounting and IT experience. He is one of the world’s leading experts in Microsoft Excel, Power Query and Power BI, and provides live and online training to clients around the world. In recognition of his contributions, Ken has held the prestigious Microsoft MVP distinction since 2006 in both the Excel and Data Platform categories. Learn more about Ken at www.excelguru.ca and https://ca.linkedin.com/in/kenpuls, and follow him on Twitter (@kpuls) and Facebook (@xlguru). LinkedIn: https://ca.linkedin.com/in/kenpuls Website: www.excelguru.ca Blog: www.excelguru.ca/blog YouTube: https://youtube.com/channel/UCUuuh6NHXovJb4xF374fFOw Twitter: www.twitter.com/kpuls Facebook: https://www.facebook.com/xlguru Courses: www.skillwave.training --------------------- AGENDA: (Eastern Time) 5:30 PM - 5:40 - Introduction 5:40 - 6:40 PM - "Build Better Excel Models Faster " by Ken Puls 6:40 PM - 7:00 PM - Q&A + Closing by Celia Alves and MS Excel Toronto Team We are looking forward to meeting you there!

Have you ever wanted to use information from your Excel data model without needing to put it into a pivot table? Are you frustrated by the limited formatting options that are available in Pivot Tables? Maybe cube functions are for you! This session will introduce cube functions, a powerful way to extract data from the Excel data model without needing a Pivot Table! There will be some basic DAX functions used, but most of the session will be focused on the 4 cube functions needed to build a non-pivot data-driven dashboard in Excel. --------------------- About the Speaker: Brent Allen Brent Allen is a freelance Excel consultant based in Toronto, blogging from his company website at Macrordinary. He has a CPA designation, as well as an MBA from Queen’s University. Prior to starting his consultancy, he worked in financial and business analysis roles in financial and real estate firms primarily focusing on improving spreadsheet processes through automation. He has taught courses on financial spreadsheets and spreadsheet automation on the e-learning sites Pluralsight and DataCamp. Find more about Brent's work and connect with him on the links below: LinkedIn: https://www.linkedin.com/in/brentalleninto/ Blog: https://macrordinary.ca/blog/ Twitter: https://twitter.com/MacrordinaryCA --------------------- AGENDA: (Eastern Time) 5:30 PM - 5:40 - Introduction 5:40 - 6:40 PM - "Extracting from the Data Model with Cube Functions" by Brent Allen 6:40 PM - 7:00 PM - Q&A + Closing by Celia Alves and MS Excel Toronto Team We are looking forward to meeting you there!