freeCodeCamp via YouTube Free video
In this project-based Google Sheets course from @EamonnCottrell you'll learn the fundamentals of Google Sheets. By the end of the course, you'll learn:
⟿ navigation
⟿ sharing
⟿ collaboration
⟿ functions
⟿ custom formulas
⟿ conditional formatting
⟿ dropdown lists
⟿ data validation
⟿ advanced function combinations
⟿ data visualization and charts
Grab the course spreadsheet here: https://docs.google.com/spreadsheets/d/1GCpuy607uIK_B0-uS6WZI-6IOA3Wk9wr6ewygbY1GFw/template/preview
Contents:
⌨️ (0:00:00) Course Overview
⌨️ (0:00:59) Module 1 - Interface
⌨️ (0:02:20) Navigation
⌨️ (0:07:31) Toolbar
⌨️ (0:10:09) Collaboration
⌨️ (0:13:29) Module 2 - Categories Table
⌨️ (0:15:55) Import Data
⌨️ (0:18:03) Basic Functions
⌨️ (0:22:53) Balance Formula
⌨️ (0:29:56) Module 3 - Formatting
⌨️ (0:31:08) Table Format
⌨️ (0:32:45) Conditional Formatting
⌨️ (0:37:27) Module 4 - Data Intro
⌨️ (0:38:25) Dropdowns
⌨️ (0:44:57) Module 5 - Advanced Functions
⌨️ (0:46:11) Type Column
⌨️ (0:52:40) Filtering
⌨️ (0:56:27) Slicers
⌨️ (0:58:48) Search Bar
⌨️ (1:02:13) Module 6 - Data Visualization
⌨️ (1:03:27) Balance IF Column Cleanup
⌨️ (1:05:36) Pie Chart
⌨️ (1:11:10) Column Chart
⌨️ (1:16:48) Line Chart
⌨️ (1:21:56) Module 7 - Apps Script
⌨️ (1:23:17) Custom Functions
⌨️ (1:29:14) Custom Menu
⌨️ (1:34:31) Got Sheet
🎉 Thanks to our Champion and Sponsor supporters:
👾 Drake Milly
👾 Ulises Moralez
👾 Goddard Tan
👾 David MG
👾 Matthew Springman
👾 Claudio
👾 Oscar R.
👾 jedi-or-sith
👾 Nattira Maneerat
👾 Justin Hual
--
Learn to code for free and get a developer job: https://www.freecodecamp.org
Read hundreds of articles on programming: https://freecodecamp.org/news
❤️ Support for this channel comes from our friends at Scrimba – the coding platform that's reinvented interactive learning: https://scrimba.com/freecodecamp
Some points apply to every course of this kind; see how we rank.
freeCodeCamp is in Tier 3: good universities, respected companies, nonprofits and well-known teachers of our institution ranking (78/100). Free full courses and certifications; practical, but not university-level depth.
MIT 18.650 Statistics for Applications, Fall 2016 View the complete course: http://ocw.mit.edu/18-650F16 Instructor: Philippe Rigollet This course offers an in-depth the theoretical foundations for statistical methods that are useful in many applications. The goal is to understand the role of mathe…
A curated collection of videos featuring top experts in artificial intelligence.
-Learn more and enroll in the program: https://online.stanford.edu/programs/generative-ai-technology-business-and-society-program Recent advancements in generative AI are reshaping industries, pushing technological boundaries, and revolutionizing creative processes. In this fast-changing landscape…
For more information about Stanford's Artificial Intelligence programs visit: https://stanford.io/ai Delve into the exciting world of Artificial Intelligence with insights and research from the world's top experts. This playlist offers a comprehensive journey, from foundational machine learning con…
Led by Andrew Ng, this course provides a broad introduction to machine learning and statistical pattern recognition. Topics include: supervised learning (generative/discriminative learning, parametric/non-parametric learning, neural networks, support vector machines); unsupervised learning (cluster…
View the complete course: http://ocw.mit.edu/6-034F10 Instructor: Patrick Winston In these lectures, Prof. Patrick Winston introduces the 6.034 material from a conceptual, big-picture perspective. Topics include reasoning, search, constraints, learning, representations, architectures, and probabili…
