Excel Data Analysis Tutorial

• Inquire
• Formula Auditing
• Working with Multiple Sheets
• Financial Analysis
• Data Validation
• Data Visualization
• PivotTables
• Lookup Functions
• Quick Analysis
• Subtotals with Ranges
• Filtering
• Sorting
• Conditional Formatting
• Working with Time Values
• Cleaning Data Contains Date Values
• Cleaning Data with Text Functions
• Tables
• Working with Range Names
• Excel Data Analysis - Overview
• Data Analysis - Process
• Data Analysis - Overview
• Excel Data Analysis - Home

Advanced Data Analysis

• Key Performance Indicators
• Aesthetic Power View Reports
• Exploring Data with Hierarchies
• Exploring Data Power View Tiles
• Exploring Data PowerView Multiples
• Exploring Data Power View Maps
• Exploring Data Power View Charts
• Exploring Data with Power View
• Exploring Data with Powerpivot
• Exploring Data with PivotTables
• Data Model
• Importing Data into Excel
• Optimization with Excel Solver
• What-If Analysis with Goal Seek
• What-If Analysis Scenario Manager
• What-If Analysis with Data Tables
• What-If Analysis
• Data Consolidation
• Advanced Data Analysis - Overview

Excel Data Analysis Resources

• Excel Data Analysis - Discussion
• Excel Data Analysis - Resources
• Excel Data Analysis - Quick Guide

Selected Reading

• Who is Who
• Computer Glossary
• HR Interview Questions
• Effective Resume Writing
• Questions and Answers
• UPSC IAS Exams Notes