Google Sheets for Excel Users Tutorial 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. Join Learnit Anytime for ad-free training, exams, certificates, and exclusive content: https://www.learnitanytime.com For Private Group Trainings please visit: https://www.learnit.com/private-group-classes-workshops Join Offsite for our online community of teachers and peers: https://www.offsitebylearnit.com 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.
Google Sheets Advanced Tutorial Exercise Files: https://bit.ly/3udealu Who it's for: Anyone looking to gather, format, and interpret data in a spreadsheet. What it is: Google Sheets is Google’s free, web-based spreadsheet application that mirrors the magic of Microsoft Excel, with some standout features and key differences as well. What you'll learn: First, students will be shown how to navigate the app. Then, they’ll learn the basics like creating and sharing spreadsheets. Next, they’ll learn how to calculate data with functions and formulas, as well as how to filter and sort all their data. Finally, users will get some hands-on time with popular features like Pivot Tables, AutoFill, VLOOKUP, Macros, and more. For ad free training and certificates please join Learnit Anytime: https://www.learnitanytime.com Enroll in our live, instructor-led Google Sheets classes: https://bit.ly/3zT2PcO For Private Group Trainings please visit: https://www.learnit.com/private-group-classes-workshops Start 0:00 Introduction 0:03 Single and Multi-Level Sorting 0:11 Filtering Records in a List 3:47 Search Filter and Filter by Condition 7:32 Custom Filter Views 10:07 Inserting Data Charts 13:15 Formatting and Editing Chart Elements 14:58 Adding and Removing Data from Charts 22:48 Inserting Sparklines 25:11 Alternating Colored Rows 30:46 Alternating Colors Button 34:08 Creating a Pivot Table 35:30 Creating a Pivot Chart 44:21 Filtering Within Pivot Tables Using Slicers 46:48 Using the IF Function 49:12 Introduction to Nesting Functions 57:13 VLOOKUP Function 1:00:39 Using the IFERROR Function 1:08:01 Creating and Applying Names in a Worksheet 1:11:02 Summary-Based Functions SUMIF(S) and AVERAGEIF 1:13:02 Text Functions Left, Right, Mid, Concatenate, and Split Text-To-Columns 1:19:41 Sharing and Managing Permissions 1:24:52 Macros 1:28:14 Conclusion 1:34:23 #GoogleSheets (C) 2021 Learnit, Inc. Any illegal reproduction of this content will result in immediate legal action.
Google Sheets Beginner Tutorial Who it's for: Anyone looking to gather, format, and interpret data in a spreadsheet. What it is: Google Sheets is Google’s free, web-based spreadsheet application that mirrors the magic of Microsoft Excel, with some standout features and key differences as well. What you'll learn: First, students will be shown how to navigate the app. Then, they’ll learn the basics like creating and sharing spreadsheets. Next, they’ll learn how to calculate data with functions and formulas, as well as how to filter and sort all their data. Finally, users will get some hands-on time with popular features like Pivot Tables, AutoFill, VLOOKUP, Macros, and more. For ad free training and certificates please join Learnit Anytime: https://www.learnitanytime.com Enroll in our live, instructor-led Google Sheets classes: https://bit.ly/3K2WnEK For Private Group Trainings please visit: https://www.learnit.com/private-group-classes-workshops Join our online community! - https://www.offsitebylearnit.com Start 0:00 Introduction 0:03 Start Page 0:28 Interface 2:10 Search the Menus 3:46 Navigating and Selecting Cells 5:51 Entering and Editing Data 8:37 Explore 11:49 Performing Simple Calculations 17:03 Saving 19:57 Introduction to Google Drive 21:04 Building Basic Formulas 24:22 Using Simple Functions 28:03 Copying Formulas and Functions with AutoFill 32:50 Relative vs Absolute Reference 37:15 Inserting Rows and Columns 43:30 Moving, Copying, and Pasting Data 46:57 Using AutoFill to Complete a Series of Values 49:54 Cell Formatting - Align, Text Rotation, Text Wrapping 53:07 Formatting Worksheet Data and Using Cell Design 57:19 Using Sheets Templates 1:00:29 Inserting, Deleting, Renaming, Moving, and Copying Worksheets 1:02:02 Freeze Panes 1:04:49 Currency Formatting 1:07:44 Hiding Rows and Columns 1:08:34 Spell Check 1:10:39 Using the Full-Screen View 1:12:00 Printing 1:12:55 Download Options 1:14:31 Publishing Sheets to the Web 1:15:16 Sending Sheets as Emails 1:16:21 Conclusion 1:18:14 #GoogleSheets (C) 2021 Learnit, Inc. Any illegal reproduction of this content will result in immediate legal action.



