Excel Introduction to Data Analysis Tutorial
Offered By: Learnit Training via YouTube
Course Description
Overview
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.
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
Related Courses
Excel Statistics and Finance Function PlaybookPluralsight Top Excel Formulas for Accounting and Finance! Become more efficient at your job! Vlookup | Filters
Skillshare Excel Spreadsheet Formulas - Old School or Dynamic Arrays?
ExcelIsFun via YouTube Average, Moving Average at Different Granularity - DAX or Excel Formulas
ExcelIsFun via YouTube Average of Customer Total Sales by Product - Formulas, DAX or Array Formula?
ExcelIsFun via YouTube