YoVDO

10 Essential Excel Techniques for Dynamic Charts and Pivot Tables

Offered By: Simon Sez IT via YouTube

Tags

Microsoft Excel Courses Business Intelligence Courses Data Analysis Courses Data Visualization Courses Data Management Courses Spreadsheets Courses Pivot Tables Courses

Course Description

Overview

Save Big on Coursera Plus. 7,000+ courses at $160 off. Limited Time Only!
Learn essential Excel skills in this comprehensive tutorial video covering ten key topics for beginners and intermediate users. Master creating Excel tables, utilizing recommended pivot tables, building pivot tables from scratch, and designing pivot charts. Explore advanced techniques like creating dynamic pivot chart titles, using GETPIVOTDATA function, implementing Excel slicers, and generating heat maps. Discover how to create Venn diagrams and graph functions in Excel. Navigate easily through the one-hour video using provided timestamps to focus on specific areas of interest or skip familiar topics.

Syllabus

- Excel Table
- Using Recommended Pivot Tables
- Creating Pivot Table from Scratch
- Pivot Chart
- Dynamic Pivot Chart Title
- GETPIVOTDATA in Excel
- Excel Slicer
- Heat Map in Excel
- Venn Diagram
- How to Graph a Function in Excel


Taught by

Simon Sez IT

Related Courses

Intro to Statistics
Stanford University via Udacity Introduction to Data Science
University of Washington via Coursera Passion Driven Statistics
Wesleyan University via Coursera Information Visualization
Indiana University via Independent DCO042 - Python For Informatics
University of Michigan via Independent