Available dates

​

►​​  New post-Covid dates coming soon!

• experienced Excel users who want to advance their skills to elite level

• potential Power BI users who want a firm grounding in Excel's data mining and reporting features.

​​

​

​

​

• learn about Excel's powerful data aggregation, management and reporting tools

• see how macros can automate tasks from mundane to complex

• advance your financial modelling skills to elite level

• start building powerful and interactive dashboards

Advance your Excel skills to elite level

• modify Excel options

• protect data in worksheets and workbooks

• import data into Excel and export data from Excel

• use data linking to create more efficient workbooks

• group cells and use outlines to manipulate the worksheet

• create summaries in your spreadsheets using subtotals

• use the Data Consolidation feature to combine data from several workbooks into one

• create, use and modify data tables

• create and work with scenarios and the Scenario Manager

• understand and create simple PivotTables

• construct and operate PivotTables using some of the more advanced techniques

• create and edit  PivotCharts

• use advanced filters to analyse data in a list

• use a variety of data validation techniques

• create and use a range of controls in a worksheet

• share workbooks with other users

• create recorded macros in Excel

• Tips & Techniques

• Help & Support Resources

Our skilled and experienced trainers will guide you through an interactive, hands-on session.

REGISTER HERE

Excel Intermediate