YoVDO

Excel Introduction to Data Analysis Tutorial

Offered By: Learnit Training via YouTube

Tags

Microsoft Excel Courses Data Analysis Courses Data Visualization Courses Pivot Tables Courses Sparklines Courses AVERAGEIFS Courses

Course Description

Overview

Save Big on Coursera Plus. 7,000+ courses at $160 off. Limited Time Only!
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 Playbook
Pluralsight
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