Level - Advanced
This course concentrates on creating PivotTables and PivotCharts to present business data for analysis. It also focuses on how best to manage the underpinning business data using List Management techniques.
1 Day
The Excel Pivottables and Pivotcharts course will give you an understanding of how to set up the data to be analysed using Tables. After completion of this course you will be able to create PivotTables and PivotCharts, group items and filter data and build formulas to better analyse your business data.
Participants should be able to:
Level - Advanced
This course builds on the Power BI Desktop - Level 1 course. It introduces you to more advanced DAX (Data Analysis Expressions) concepts including variable and advanced functions.
Level - Advanced
This course concentrates on Excel’s advanced functions that will allow you to work more efficiently with business data.
Level - Advanced
This course will introduce and extend VBA programming within Microsoft Excel. Participants will be able to create and manage complicated macros.
Level - Advanced
This course is all about time-savers in Microsoft Word. It shows how to automate standard documents and how to create your own shortcuts for frequently used tasks which you then can add to your toolbar or ribbon. This course is for you, if you are a confident Word user.