Excel Workshop Series: Working with Data Efficiently

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.

Prerequisites: Learners should have completed or have knowledge of all the skills covered in Excel 1 to 4a before attending these workshops.

The Excel Expert workshops teach you the Excel skills necessary to know how to create powerful layered formulas and automate processes without the need to learn programming.

Excel 5: Complex Calculations

In Excel 5, you will build on the skills that you learned in Excel 1-4a. Using an This course an example of advanced calculations using lookup functions commonly used in a professional setting, you will construct complex formulas that incorporate data from multiple tables by using nested functions.

Excel 6: Using Macros

Excel 6 will show you the fundamentals of macros and introduce you to VBA. Macros are used to automate repetitive tasks and can help you quickly organise large amounts of data. VBA is Excel’s programming language, and, in this task, you will use it to do basic macro troubleshooting and editing. 

Click on the link below to check availability and book your place:

Excel Expert Workshop Series

We recommend completing both topics as this will give you a working knowledge of how to utilise Excel functions as part of complex formulas and create Excel Macros to automate repetitive or intricate tasks.