Excel: Data Analysis and Dashboad
Learn to use advance features of Excel for data analysis and developing Dashboard.
Prerequisites
- Knowledge of writing basic formulas and fucntion in Excel or completed Excel Intermediate course.
Learning Objectives
By the end of the course, you should be able to:
- Access the Power Pivot add-in
- Load data from various source
- create a dashboard
- Develop data model
- Use Relationships tool to build relationship between tables
- Use Power Query
- Grouping data
Topics
- Working with Data Analysis Tools
- Creating Scenarios
- Using What If analysis
- Using Goal Seek
- Using Solver
- Generating report with alternate solutions
- Introduction to Pivot Table
- Formatting Pivot Table
- Calculating PivotTable Values
- Updating PivotTable Data
- Introduction to PowerPivot
- Using Data Model Tool
- Using Power Query to acess data from various sources
- Getting data from Web page, Excel, XML and Access Database
- Building data model
- Managing Relationships
- Writing Formula for Calculation
- Grouping Data
- Creating Hierarchy
- Adding column to Hierarchy
- Using Slicer
- Creating Dashboard
- Visualize data using Power Map and Power View
- Use Power View to create interactive charts
- Using cloud-based PowerBI Tool
Request Information
CLEP
Hands-on Training
Online Courses
Testimonial
Java Programmer
After a long search for an advanced programming mentor for my son, I came across NR Computer Learning Center (NRCLC). We got to know Vazi Okhandiar, the founder of the center. She assessed my son’s computer programming skills and soon recommended him to obtain an Oracle Certification. At the time,...
Angel T.