Google Sheets for Excel Users Tutorial

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://bit.ly/3MNmiRD 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. Manuals: https://bit.ly/30xZb59 Username: manuals Password: password 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 (C) 2022 Learnit, Inc. Any illegal reproduction of this content will result in immediate legal action.