Course Hive
Search

Welcome

Sign in or create your account

Continue with Google
or
Google Sheets for Excel Users Tutorial
Play lesson

Google Sheets Full Course - Google Sheets for Excel Users Tutorial

4.0 (1)
21 learners

What you'll learn

This course includes

  • 5.3 hours of video
  • Certificate of completion
  • Access on mobile and TV

Summary

Keywords

Full Transcript

Google Sheets for Excel Users Tutorial Get Ad-Free Training by becoming a member today! https://www.youtube.com/channel/UCqyBfm_H9ugGirk1ufYA2YA/join Join Learnit Anytime for ad-free training, exams, certificates, and exclusive content: https://www.learnitanytime.com Exercise Files: https://tinyurl.com/3yzb7ukw Who it's for: This accelerated class is meant for experienced users of Excel, who know how to create formulas and apply functions, and who want to learn how to do the same and more in Google Sheets. What it is: Google Sheets is the spreadsheet application in Google's cloud-based office suite. What you'll learn: By the end of this course, you’ll learn how to take stock of the knowledge you’ve accumulated in Microsoft Excel over the years and successfully transfer those skills to the world of Google Sheets. In 2+ hours of comprehensive training, learn how to do the following tasks in Google Sheets: create conditional formatting, use privacy tools to limit what users can add or edit in a spreadsheet, share spreadsheets and collaborate in real-time, make interactive sheets and forms to collect information, get real-time financial data from sources like the stock market, create Macros to automate repetitive actions, and build visuals like charts, sparklines, and QR Codes. Start 0:00 Introduction 0:03 Overview 0:57 Data Validation 3:40 Conditional Formatting 10:37 Named Ranges 15:58 Protected Sheets and Ranges 22:42 Filter Views 28:47 File Version History 34:56 Charts and Sparklines 39:30 Checkboxes 51:33 Forms and Responses 59:22 Importing HTML 1:18:31 Introduction to Queries 1:26:42 SQL and Google Query Overview 1:30:13 SQL Statements 1:42:41 Financial Data 2:00:58 Financial Data Dashboard 2:06:31 Introduction to Macros 2:09:32 Absolute vs Relative Macros 2:13:44 Formatting Macros 2:19:34 Sorting Macros 2:24:21 Apps Script Editor 2:29:23 Conclusion 2:33:59 #GoogleSheets #GoogleWorkspace #Excel Learnit is no longer associated with this channel/video. (C) 2025 Bomberry Productions Any illegal reproduction of this content will result in immediate legal action.

Course Hive

Continue this lesson in the app

Install CourseHive on Android or iOS to keep learning while you move.

Related Courses

FAQs

Course Hive
Download CourseHive
Keep learning anywhere