Google Data Analytics Professional Certificate Capstone Case Study In Excel

What if you only had 15 minutes to throw together an analysis? What if that analysis was one of the Google Data Analytics Professional Certificate program's Capstone Case Studies? In this video I give myself fifteen minutes to complete the Cyclistic Bike Share Analysis, and it was every bit as exciting as you'd imagine. (data here: https://divvy-tripdata.s3.amazonaws.com/index.html) 📢 NEW Want my FREE Excel Daily Most Ultimate Guide? Grab it here: https://www.tmbanalytics.com/excel-daily-guide-yt 🫵 Are you ready to take on the 7 Days to Excel Challenge and join the #nomouseclub❓ 👉 Click here if you dare: https://www.tmbanalytics.com/7-days-to-excel-challenge-yt VIDEO TOPICS: 0:00 - Intro and Background 4:00 - Review the case 6:20 - Timer Starts 11:00 - Data Cleaning 16:30 - Analysis 21:20 - Pencils Down and Discussion LEARN MORE ABOUT USING EXCEL FOR ANALYSIS: Excel for Analytics - Portfolio Project Series Video 1 - Quick Excel Tips https://youtu.be/45_yTM1HfTc?si=aePKgQeKUQqtH9qQ Excel for Analytics - Portfolio Project Series Video 2 - Data Cleaning in Excel https://youtu.be/_jEGuoXz02c?si=Yqgx_dzq7OfoXjrC Excel for Analytics - Portfolio Project Series Video 3 - Data Exploration and Analysis in Excel https://youtu.be/mCznZ_KMgWQ?si=DQJhQN_1N38Z6fSX Excel for Analytics - Portfolio Project Series Video 4 - Data Presenting in Excel https://youtu.be/BDbpJLp6zhI?si=LJ4Y2AOmC_YyqIB4 OTHER EXCEL TOPICS: The MOST Ultimate Excel LOOKUP Guide | Can you guess which is my favorite? https://youtu.be/Ck42XbpiC6I How to easily combine data into one cell in Excel (and why I stopped using CONCATENATE) https://youtu.be/CAgOT8kMuj0 #excel #pivottable #exceltips #spreadsheet