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-online/blob/master/Excel%20Series/Data%20Analysis%20With%20Excel.xlsx

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