Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

YouTube

Statistical Analysis and Data Visualization with Excel - Tips and Tricks

Great Learning via YouTube

Overview

Coursera Flash Sale
40% Off Coursera Plus for 3 Months!
Grab it
Learn essential statistical analysis techniques using Microsoft Excel in this comprehensive 3-hour video tutorial. Master fundamental Excel functions, formulas, and cell referencing before diving into advanced features like conditional formatting, data bars, and icon sets. Explore data cleaning methods, validation techniques, and pivot table creation while building practical skills in data organization and visualization. Progress from basic statistical concepts through hands-on exercises in both Excel and Google Sheets, covering everything from date/time functions to color scales. Develop proficiency in data analytics project phases, including sorting, filtering, and creating impactful visualizations that transform raw data into meaningful insights. Perfect for beginners seeking to enhance their data analysis capabilities using spreadsheet tools.

Syllabus

- Overview of Excel for Statistical Analysis
- Introduction To Statistics
- What is Statistics.mp4
- Types of Statistical Analysis
- Introduction to Excel
- Cell Referencing
- What is a Formula in Excel
- How to Enter a Formula
- Tables and Borders in Excel
- Date and Time Functions in Excel
- Introduction to Conditional Formatting - Formatting in Excel
- Cells That Contain Specific Values
- Greater Than Comparisons
- Top and Bottom Values
- Unique and Similar Values
- Data Bars
- Color Scales
- Icon Sets
- Formula-Based Conditional Formatting
- Additional Rule Types
- Introduction to Google Sheets
- Using Color Scales in Google Sheets
- Phases of Data Analytics Project
- Data cleaning using Excel
- Functions in Excel
- Types of Functions in Excel
- Sort and Filter
- Data Validation in Excel
- Pivot Table in Excel
- Data Visualization using Excel
- Summary

Taught by

Great Learning

Reviews

Start your review of Statistical Analysis and Data Visualization with Excel - Tips and Tricks

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.