Dive into a comprehensive tutorial on data analysis using Microsoft Excel. Learn essential techniques for organizing, analyzing, and visualizing data, including table formatting, conditional functions, charting, and Pivot Tables. Master list design basics, data filtering, conditional formatting, and advanced functions like IF, SUMIF, and AVERAGEIF. Explore recommended charts, adjust visualizations, create sparklines, and harness the power of Pivot Tables for in-depth data exploration. Ideal for Excel users with basic knowledge seeking to enhance their data analysis skills and draw meaningful insights from their datasets.
Excel Introduction to Data Analysis Tutorial
Overview
Syllabus
Start
Introduction
List Design Basics
Inserting Tables for Analysis
Filtering Data in Tables
Using the Total Row
Conditional Formatting
IF Function
SUMIF and AVERAGEIF
SUMIFS
Inserting Recommended Charts
Adjusting Charts
Sparklines
Inserting Pivot Tables
Displaying Data as Count
Filtering Pivot Tables
Inserting Pivot Charts
Conclusion
Taught by
Learnit Training
