(08) 9383 8000
Excel - PivotTables and PivotCharts
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
Overview
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.
Content
- Work with business data using List Management (Tables)
- Create PivotTables
- Group items
- Filter data using Slicers
- Add formulas to the PivotTable using Calculated Fields
- Create PivotCharts
- Format PivotCharts.
Learning Outcomes
Participants should be able to:
- Set up the data to be analysed using Tables
- Create PivotTables and PivotCharts
- Build formulas to better analyse the business data.
Level - Advanced
This course introduces additional skills to develop your knowledge of Microsoft Excel by focusing on advanced functions and productivity tools.
Level - Advanced
Working with long documents in Microsoft Word can be a challenge. We will show you how to format documents quickly and consistently, how to add numbered headings, create a table of contents, an index, table or figure captions and cross-references.
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.
Level - Advanced
This course introduces Power Query to discover, connect to and import data into Microsoft Excel. It also focuses on using PowerPivot to remodel and enhance the imported data by writing queries through Power Query M language.