The main purpose of the course is to give students the ability to add analysis capabilities to Excel spreadsheets and to provide students with a foundation to learn about more advanced data analytics with Excel or Power BI.
The main purpose of the course is to give students the ability to add analysis capabilities to Excel spreadsheets and to provide students with a foundation to learn about more advanced data analytics with Excel or Power BI.
This course is intended for anyone who wants to take the data analysis technologies in Excel beyond formulas and add more advanced capabilities such as dashboards, hierarchies, and relationships.
This module explains how to create a report in Excel.
Filtering and Formatting Data
Charts
Create an Excel report
Filtering Excel Data
Formatting Excel Data
Create excel Charts
Filter and format data.
Create charts.
This module explains how to create data tables in Excel.
Excel Data Tables
Summarizing Data
Create an Excel Table
Create an Excel Table
Summarize Excel Data
Explain what Excel Data tables are.
Sort, filter, and validate data.
Summarize data.
Format summarized data.
This module describes pivot tables and pivot charts and how to work with them.
Pivot Tables
Pivot Charts
Editing Pivot Tables and Pivot Charts
Importing Data from a CSV File
Creating a Pivot Table
Creating a Pivot Chart
Editing Pivot Tables and Pivot Charts
Describe pivot tables and how to create them.
Describe the various elements of a pivot chart.
Edit pivot tables and pivot charts.
This module describes Excel dashboards, how to create them and the role in data analysis in Excel pivot tables.
Creating a Dashboard
Data Analysis in Excel Pivot Tables
Create a Dashboard
Arranging Tables and Charts
Slicing Data
Data Analysis
Describe a dashboard.
Filter data using a slicer.
Add calculated columns to a dashboard.
Find anomalies.
This module describes hierarchies and time data.
Hierarchies
Time Data
Creating Hierarchies
Create a Hierarchy
Configure Time data
Create an Animated Time Chart
Describe hierarchies.
Create levels within a hierarchy.
Explain why time data is different and how to work with it.
This module explores the Excel data model and looks at ways of extending it.
Using an Excel Data Model
External Data
Explore an Excel Data Model
Add Multiple Tables
Create Relationships
Add External Data
Explain an Excel Data Model and how to use it.
Import External Data and use it.
Link out to external data.
Sign Up to our newsletter, and stay always up to date with latest IT certifications
View all the provided certifications and there relevant courses. Book online for a certification exam.
Copyright reserved to ICTC. Proudly Crafted by GTP Works