From Static to Dynamic Interactive Excel Charts | Carlos Barboza

In this meetup, Carlos Barboza presented on creating dynamic and interactive Excel charts. What to Expect Learn how to create interactive Excel charts using the dynamic array functions in Excel. With these functions, we can implement interactive charts easier than before. The only thing you must learn is the logic of spilled ranges so you can easily reference them to your charts. Learn some chart tips and Excel tricks along with some graphs types and pro tips. About the Speaker Carlos Barboza is a bilingual data consultant with 6 years of experience. He started his career in analytics using Microsoft Excel as his swiss army knife. He holds a Bachelor in Economics and Finance from University of Hartford. Currently, as consultant with Microsoft tools, Carlos is interchangeably switching between Power BI and Excel to analyze large volume of data thru data visualization, interaction and exploratory visual analysis. His current main interest today is the science of data visualization for analysis of information. Here are the files that Carlos used in the presentation. File 1 - https://computergaga.com/_excel/files/london-excel-meetup/carlos/example.xlsx File 2 - https://computergaga.com/_excel/files/london-excel-meetup/carlos/example_with_eu.xlsx Office Scripts course https://bit.ly/3pKjzT0 (Use code LEM100 for a huge 45% discount) Get involved and attend future London Excel Meetups - https://www.meetup.com/London-Excel-Meetup-Group/