Webinar: Power Pivot and Dynamic Arrays in Excel
Dates: | 19 May 2020 |
Times: | 15:00 - 16:00 |
What is it: | Webinar |
Organiser: | Cathie Marsh Institute for Social Research |
How much: | Free |
|
When Excel changed to allow worksheets to have 1M rows, everyone thought ‘great’ won’t run out of space now! Then big data came along and even the 1M barrier became a potential problem again. However, for several years now many versions of Excel have included ‘Power Pivot’. Although integrated into Excel, it is a distinct processing system with its own set of commands for processing data. Yes, these have to be mastered but the benefits include being able to load datasets with millions of rows and being able to join datasets together in a more intuitive way.
This free webinar, organised by the UK Data Service, will demonstrate how Power Pivot can be used to accomplish both of these tasks. At the same time in Excel proper we will show how the new dynamic array functions can also be used to simplify Excel tasks.
Book a place at https://ukdataservice.ac.uk/news-and-events/eventsitem/?id=5594
About the webinar series: getting data, storing data, manipulating data
All projects need data. You either generate it yourself via surveys or the like, you get some from the UK Data Service, or you find some means to beg, borrow or steal it. If you didn’t generate it yourself, the chances are it is not quite what you wanted but you can adapt it to your needs. You adapt the data by a variety of means; cleaning the data, extracting parts of the data (and ignoring the rest) and trickiest of all joining data from different sources.
This series of three webinars will cover some ways of dealing with these data issues using both familiar software tools such as Excel and others that you be aware of but haven’t had any direct experience of.
Travel and Contact Information