Data Analysis With Excel

For many people who work with data, Excel is all they’ve got. But Excel has many great capabilities for cleaning and analysis of data. This session is a whirlwind tour of Excel’s data-related features including: Import and shape data with Power Query Combine tables with the new VSTACK() and HSTACK() functions The many advantages of Excel tables: Summarise data with the SUMIFS() function Linked data: what they are and how and when to use them You can download the Excel spreadsheet that has the demos from https://github.com/MarkWilcock/lbag-o... This is part of a series on Excel from the data perspective. Future sessions include: modern Excel functions, spill functions, and dynamic arrays What-if models (scenario modelling and sensitivity analysis) In Excel Monte Carlo models in Excel This is a recording of a meetup event on the 16th January 2023. The speaker, Mark Wilcock, is the organiser of the London Business Analytics group and a Microsoft MVP. Timestamps 00:00 Introduction to the sample dataset used in Power Query 01:30 Import and shape data with Power Query 11:12 Excel tables 19:28 Combine tables with the new VSTACK() and HSTACK() functions 23:50 Summarise data with the SUMIFS() function 34:07 Linked data: what they are and how and when to use them 39:30 Summary We run a full range of data analysis and generative AI courses in London and online. See our courses at zomalex.co.uk