Google Sheets for Beginners - Advanced Data Management and Analysis - Lesson 2

Google Sheets for Beginners - Advanced Data Management and Analysis - Lesson 2

Teacher's Tech via YouTube Direct link

- Transposing Data: Easily shift data layout for better analysis.

8 of 14

8 of 14

- Transposing Data: Easily shift data layout for better analysis.

Class Central Classrooms beta

YouTube videos curated by Class Central.

Classroom Contents

Google Sheets for Beginners - Advanced Data Management and Analysis - Lesson 2

Automatically move to the next video in the Classroom when playback concludes

  1. 1 - Introduction to Google Sheets for Beginners: Kickstart your journey into the world of Google Sheets.
  2. 2 - Autocomplete Data Techniques: Learn about the Fill handle and Smart Fill options for faster data entry.
  3. 3 - Upcoming Enhanced Smart Fill: A sneak peek into the advanced features coming to Google Sheets.
  4. 4 - Combining Cells - 4 Methods: Discover multiple ways to merge data in cells for better organization.
  5. 5 - Quick Text Splitting: Simplify the way you divide text across cells.
  6. 6 - Data Cleanup: Efficiently delete duplicate rows to maintain clean sheets.
  7. 7 - Cell Referencing Explained: Understand the difference between Absolute and Relative referencing.
  8. 8 - Transposing Data: Easily shift data layout for better analysis.
  9. 9 - Importing Web Data: Step-by-step guide to bring external data into your spreadsheet.
  10. 10 - Sorting Data Effectively: Organize your data for clarity and better insights.
  11. 11 - Sort a Range: Focus on sorting specific sections of your data.
  12. 12 - Creating Filters to Sort Data: Learn to filter and sort your data seamlessly.
  13. 13 - Creating a Filter View: Advanced filtering for collaborative work.
  14. 14 - Using the IF Function: Master one of the most powerful functions in Google Sheets.

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.