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