This course includes:
- Video lessons
- Quiz assessment
- Survey lessons
- Certificate of completion
Mastering Spreadsheets for Data Analysis
Created by Youtube External
Last updated: April 2025 | Language:
About this course
This course focuses on advanced spreadsheet techniques for analyzing and interpreting data. It covers complex functions, data manipulation, pivot tables, advanced charting, and automation with macros. Students will learn how to handle large datasets, perform statistical analysis, and create dynamic reports. The course equips learners with the skills to efficiently analyze data and make informed decisions using spreadsheet tools like Excel or Google Sheets.
Course content
Author: @KenjiExplains
Description: Learn all the fundamentals of Data Analysis on Excel in 10 minutes!
Main Video Resource
Supplementary Video
Additional resource
Author: @KevinStratvert
Description: In this step-by-step Microsoft Excel tutorial, learn how to use Formulas and Functions. We start with the fundamentals of entering formulas into Excel. Then we advance to the most common formulas and functions that you'll encounter in Excel. This video is perfect for beginners who are new to formulas and functions, and even more advanced users who want to pick up a new trick or two
Main Video Resource
Additional resource
Author: @AlexTheAnalyst
Description: In this series we will be walking through all of the most important topics that Data Analysts need to know in order to be proficient in Excel.
Main Video Resource
Supplementary Video
Additional resource
Author: @LeilaGharani
Description: Learn how to gain full control over your data filtering with practical and detailed instructions, exploring everything from basic filtering to complex criteria settings.
Main Video Resource
Supplementary Video
Additional resource
Author: @ExcelCampus
Description: In this video series you will learn how to create an interactive dashboard using Pivot Tables and Pivot Charts.
Main Video Resource
Supplementary Video
Additional resource
Author: @KevinStratvert
Description: . In this video, we will cover the basics of creating, formatting, and modifying charts in Excel, as well as some tips and tricks to make your charts more effective.
Main Video Resource
Supplementary Video
Additional resource
This document provides additional resources to deepen your understanding of the topics covered in this program. Below, you’ll find links to articles related to each lesson to support your further reading.
Welcome to the quiz section. Before you begin, please make sure you have watched the lesson videos thoroughly, as the questions are designed to test your understanding of key concepts discussed.
Here are a few things to keep in mind:
1. This is a timed quiz, so you’ll need to manage your time effectively.
2. Read each question carefully and choose the best answer based on the material covered in the lesson.
3. The quiz is an excellent opportunity to test your knowledge and reinforce what you’ve learned, so try your best!