Войти
  • 155032Просмотров
  • 1 год назадОпубликованоfreeCodeCamp.org

Learn Google Sheets – Full Course for Beginners

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: 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: Read hundreds of articles on programming: ❤️ Support for this channel comes from our friends at Scrimba – the coding platform that's reinvented interactive learning: