COVID-19 Update: Course bookings are now being taken with a reduced class size of 4 and extra course dates. Delegates can also choose to attend by live webinar.
Learn how to import data from many sources e.g. CSV, Text, Access etc. and how to shape and transform the data as you import it. Learn how to easily add calculated fields to your data in PivotTables
Learn how to use Power Query, Power Pivot and DAX to transform and build powerful reports from your data.
Import and transform your raw data in preparation to produce PivotTables that display meaningful information to help with sales, marketing, managing and decision making.
If you analyse data from many sources e.g. CSV, Text, Access etc. or you have too much data to fit on a traditional worksheet then understanding how to use the most up to date features of Excel will benefit you and your staff.
This course provides a solid foundation and understanding of Power Query, Power Pivot and DAX.
Learn how to import raw data from
Excel - CSV - Text etc.
Learn how to create relationships between your data.
Learn how to add more calculated columns to your data
Learn how to how to use the new powerful formula language
Learn how to aggregate your data using Data Analysis Expressions (DAX)
Learn how to connect to your data sources and import.
Learn how to shape and transform your data ready for analysis
The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.