Prerequisites: Excel Fundamentals or equivalent
The Excel Data and Visualisations workshop series teach you the Excel skills necessary to know how to perform big data analysis and produce clear visualisations without the need to learn programming.
Excel 4b: Pivot Tables
Pivot tables are widely used, to summarise and present large amounts of data as succinct tables, taking into account only the data that is relevant for your analysis. In Excel 4b you will learn to use pivot tables not only to organise data, but also manipulate it by looking more in depth at various pivot table settings.
Excel 4c: Sorting and Filtering
In Excel 4c you will learn how to manipulate large tables of data: sorting to determine the order of the data, and filtering to manipulate what you see based on specific constraints you have set.
Excel 4d: Charting Data
In Excel 4d, you will learn how to visualize data sets by creating various types of charts and graphs. You will look at column charts, trend line predictions, pie charts, combo charts (charts combining multiple data sets), and scatter plots. You will also learn how to customize the look of the charts.
Excel 4e: Data Tools
This Excel 4e you will learn how to extract data from a table based on selected criteria, present predefined choices and reduce input errors. More specifically, you will learn how to create static and dynamic drop-down lists, display input and error messages and restrict invalid user inputs.
Excel 4f: What-if-Analysis
This Excel 4f, you will be introduced to What-if analysis. You will learn to use this type of analysis to compare different scenarios, perform reverse calculations (to see what is needed to achieve specific goals) and carry out sensitivity analysis (to examine the effects of variables on the same formula).
Click on the link below to check availability and book your place:
Excel Data and Visualisations Workshop Series
If you complete all skill sets you will have a good working knowledge of how to summarise large amounts of data as succinct tables or visualisations, create static and dynamic drop-down lists allowing consistent data input from numerous users, compare scenarios, make reverse calculations and perform sensitivity analysis.