Excel Data Analysis Tutorial
Advanced Data Analysis
Excel Data Analysis Resources
Selected Reading
- 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
Selected Reading
- Who is Who
- Computer Glossary
- HR Interview Questions
- Effective Resume Writing
- Questions and Answers
- UPSC IAS Exams Notes
Excel Data Analysis - Home
![Excel Data Analysis Tutorial](/excel_data_analysis/images/excel-data-analysis.jpg)
Excel Data Analysis Tutorial
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.
Audience
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.
Prerequisites
The readers of this tutorial are expected to have a good prior understanding of the basic features available in Microsoft Excel.
Advertisements