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
On this page of the site you can watch the video online Data Analysis With Excel with a duration of hours minute second in good quality, which was uploaded by the user London Business Analytics Group 16 January 2023, share the link with friends and acquaintances, this video has already been watched 2,033 times on youtube and it was liked by 34 viewers. Enjoy your viewing!
