Data Analysis with Excel is a comprehensive tutorial that provides a good insight into the latest and advanced features available in Microsoft Excel. It explains in detail how to perform various data analysis functions using the features available in MS-Excel. The tutorial has plenty of screenshots that explain how to use a particular feature, in a step-by-step manner.

This tutorial has been designed for all those readers who depend heavily on MS-Excel to prepare charts, tables, and professional reports that involve complex data. It will help all those readers who use MS-Excel regularly to analyze data.

The readers of this tutorial are expected to have a good prior understanding of the basic features available in Microsoft Excel.

Course Content

Excel Data Analysis Tutorial
Excel Data Analysis Home
Data Analysis Overview
Data Analysis Process
Excel Data Analysis Overview
Working with Range Names
Cleaning Data with Text Functions
Cleaning Data Contains Date Values
Working with Time Values
Subtotals with Ranges
Quick Analysis
Lookup Functions
Data Validation
Financial Analysis
Working with Multiple Sheets
Formula Auditing
Advanced Data Analysis
Advanced Data Analysis Overview
Data Consolidation
WhatIf Analysis
WhatIf Analysis with Data Tables
WhatIf Analysis Scenario Manager
WhatIf Analysis with Goal Seek
Optimization with Excel Solver
Importing Data into Excel
Data Model
Exploring Data with PivotTables
Exploring Data with Powerpivot
Exploring Data with Power View
Exploring Data Power View Charts
Exploring Data Power View Maps
Exploring Data PowerView Multiples
Exploring Data Power View Tiles
Exploring Data with Hierarchies
Aesthetic Power View Reports
Excel Data Analysis Quick Guide
Excel Data Analysis Resources
Excel Data Analysis Discussion

Student Feedback

Course Rating