Exploring the data analytic capabilities of Excel

Exploring the Excel Data Analytics. This podcast episode is part of a series "Analysis Cloud Talking Tech Sense" providing insightful tech discussions, from Ireland, exploring the latest software, news, and innovative ideas, focusing on how global tech developments impact the Irish market. Expect coverage on tech giants, AI, cloud development, and the intersection of world politics and technology. With a unique perspective as both a developer and business owner, the podcast aims to inform and inspire tech enthusiasts and professionals. Join the conversation, share your thoughts, and stay connected with the tech community. Tune in for valuable insights and practical tips to stay ahead in the ever-evolving tech world.The Topics covered in this episode are Data Management, Data Importing and Exporting, Data Cleaning, Sorting and Filtering, Power Query, Data Analysis and Calculations, Statistical Analysis, What-If Analysis, Solver, Power Pivot, Python Integration, Macros and VBA, User-Defined Functions (UDFs), Lambda Functions, VBA for Custom Functions, Excel Add-ins, Power Query for Large Datasets, Azure and SQL Integration Financial Modelling Automation with Office Scripts