Excel Data Analysis Tutorial

• All Tutorials
• Job Search

What is Excel Data Analysis Tutorial?

Data analysis with Excel is a complete tutorial that provides a good perception into the latest and advanced functions available in Microsoft Excel. It explains in detail how to perform various data analysis functions using the functions to be had in MS-Excel. The tutorial has plenty of screenshots that explain how to use a selected feature, in a step-through-step manner.

Audience

This tutorial has been designed for all those readers who rely heavily on MS-Excel to prepare charts, tables, and professional reviews that involve complex data. it will assist all those readers who use MS-Excel regularly to analyze data.

Prerequisites

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

Excel Data Analysis Tutorial: List of Topics

• Excel Data Analysis
  • Data Analysis Overview
  • Data Analysis Process
  • Excel Data Analysis Overview
  • Working With Range Names
  • Excel Data Analysis Tables
  • Cleaning Data With Text Functions
  • Cleaning Data Containing Date Values
  • Working With Time Values
  • Excel Data Analysis Conditional Formatting
  • Excel Data Analysis Sorting
  • Excel Data Analysis Filtering
  • Excel Data Analysis Subtotals With Ranges
  • Excel Data Analysis Quick Analysis
  • Excel Data Analysis Lookup Functions
  • Excel Data Analysis Pivottables
  • Excel Data Analysis Data Visualization
  • Excel Data Analysis Data Validation
  • Excel Data Financial Analysis
  • Working With Multiple Sheets
  • Excel Data Analysis Formula Auditing
  • Excel Data Analysis Inquire
  • Advanced Data Analysis Overview
  • Advanced Data Analysis Data Consolidation
  • Advanced Data Analysis What If Analysis
  • What If Analysis With Data Tables
  • What If Analysis With Scenario Manager
  • What If Analysis With Goal Seek
  • Optimization With Excel Solver
  • Importing Data Into Excel
  • Advanced Data Analysis Data Model
  • Exploring Data With Pivottables
  • Exploring Data With Powerpivot
  • Exploring Data With Power View
  • Exploring Data With Power View Charts
  • Exploring Data With Power View Maps
  • Exploring Data With Power View Multiples
  • Exploring Data With Power View Tiles
  • Exploring Data With Hierarchies
  • Aesthetic Power View Reports
  • What Are Key Performance Indicators?