Exena Website

Effective Data Analysis Using Excel

Categories: MS. Excel
Wishlist Share
Share Course
Page Link
Share On Social Media

About Course

Learning Unit 1 – Understanding Data Modelling and Visualization to Perform Data Analysis

Create Data Models using Power Pivot.
Develop Pivot Tables and Pivot Charts for forecasting and recognizing patterns and trends.

Learning Unit 2 – Using Excel Functions to Apply Techniques on Data Sets for Data Analysis

Introduction to Advanced Excel Functions and Features for Data Analysis.

Learning Unit 3 – Using Power Pivot for Data Modelling and Applying Data Integrity

Use Power Pivot Models to create business insight reports.
Apply Data Protection Rules in Excel.

Learning Unit 4 – Using DAX for Analysis to Provide Business Insights

Use DAX to summarize data for analysis and business insights.

Learning Unit 5 – Using Statistical Techniques and Data Analysis Tool Pak for Creation of Dashboard Reports

Introduction to Statistical Formulas and Techniques for Dashboard Reports.
Utilize the Data Analysis Tool Pak for business insight reports.

Learning Unit 6 – Using Excel Functions and Queries to Extract Data for Data Analysis

Join multiple tables to extract data for data analysis and visualization.

Learning Unit 7 – Transforming Data for Data Analysis Using Excel Functions and Formulae

Conduct data cleaning and validation of required dataset for visuals.”

Show More