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
Learn how to connect to your data sources and import.
Learn how to shape and transform your data ready for analysis
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)
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.