Duration: 2 Days
Course Overview
Please insert text
Course Content
Excel Level 2:
Module 5: Implementing Functions to Extract Data
• Identify a piece of data with MATCH, VLOOKUP, INDEX, XLOOKUP
• Extract subsets of data with FILTER, UNIQUE, TRANSPOSE, SORT
Module 6: Importing and cleansing data with Power Query
• Navigate the Power Query interface
• Import and transform data using Power Query
• Identify data errors
• Relate and combine datasets
Module 7: Analysing Data with PivotTables
• Gain an insight into data
• Quickly restructure data
• Group and aggregate the data
• Design a data model
• Introduction to PowerPivot
Module 8: Visualising Data with Charts
In this module, you will learn how design charts. You will:
• Quickly identify key points from data
• Create charts from Tables and PivotTables
• Manipulate the look and feel of a chart
• Implement SPILL ranges into a chart
EXAMPLES COVERED IN THE COURSE
• Identify differences in lists
• Develop dynamic tables of data
• Extract and replace text from an item in a list
• Design cascading data validation lists
• Calculate the number of distinct values
• Report on data from a list
• Combine data from another table
• Correct a poorly designed dataset
• Cleanse a dataset
• Audit the changes made to a dataset
• Automate applying changes to a dataset and multiple files
• Design reports
• Automate reports updating from a dataset
• Design adaptable charts that automatically update and are easy to manage
COURSE PREREQUISITES
It Is Important you have the knowledge of Level 1 that is:
• Working with mixed references
• Know how to Implement and read functions
• Nest a function within a function
• Apply error handling functions
• Create a data set correctly
• Define and use Names
• Design easily to manage and adaptable calculations
• Automate calculation references being updated
• Implement a Data Validation list with formulas
• Define Conditional Formatting with formulas