Google Sheets for Excel Users Tutorial
Vložit
- čas přidán 12. 07. 2024
- Google Sheets for Excel Users Tutorial
Get Ad-Free Training by becoming a member today!
/ @learnittraining
Exercise Files: 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:
www.learnitanytime.com
For Private Group Trainings please visit:
www.learnit.com/private-group...
Manuals: 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.
Exactly what I was looking for! There's not many videos on Google sheets to excel for intermediate users.
Thanks so much.
You're very welcome!
In fact this channel is just amazing. With your excel VBA tutorials. I developed a fantastic and amazing school management system in excel and VBA with amazing features. Thank you very much for this amazing tutorials. With your tutorials, I developed a lot of applications using Excel on my CZcams channel.
Subscribed!
Дякую! це було цікаво, легко та корисно!
Ласкаво просимо!
incredibly useful guide! Using GTM to track the Thank You page is crucial for campaign success.
👍👍👍👍
This video is really useful. Many thanks
Glad it was helpful!
What a very informative vid!.... Thanks for the learning gained..... More power to you...
Thank you so much for watching!
Thank you for this!
Glad it was helpful!
🙂...Gracias por el interesante aporte...👍
¡De nada! ¡Gracias por verlo!
thank you very much for your great efforts
Our pleasure!
It's very helpful. I learned a lot tody.
We are glad!
Thank you 😊
Thank you for watching!
Thank you so much sir
Most welcome!
Wow very nice
Thank you so much
If it’s not too much to ask, can you do a detailed tutorial on how to use Google Sheets to keep track of stocks and investments? There are plenty of videos on how to use Excel for this purpose, but given that stock prices and other related information always change, using Google Sheets makes more sense because Google Sheets is always connected to the Internet to import data from websites like Finviz.
We will definitely look into it!
@@LearnitTraining Thank you for considering it. Many people use Excel to manage budgets and stock investments, but they need to know Google Sheets can do most of the same.
do we have a similar paste operations (sum, subtract, multiply) in excel function for google spreadsheets?
You can get help directly from our instructors at Offsite, our online community - www.offsitebylearnit.com
Nice video
Thanks!
How can I get the sheet for practice alongside with You as you walkthrough us ?...i have already downloaded the practice material but it only had the pdf with the slide deck ...it will be really helpful if you guide me here... thanks
Where I can get this file that you show on min 4? What link for this file?
Sir plz make tutorial of JDA software for supply chains of goods
We will take look a Blue Yonder and see what we can do!
👍
Hi, I am new to Google Sheets. How can I get the training document? I already click the exercise file, but it only showed me the acrobat file.
Hello Helmy! In the PDF there is a link to the exercise files, on the second slide
My google sheets does not have the template which i should use for trainning.
Exercise Files: bit.ly/3MNmiRD
please give a access to open google exercise sheet.
😊
Exercise Files: bit.ly/3MNmiRD
@@LearnitTraining it's going back as 403 Forbidden. Try to test open that link in incognito and you'll see. We can't really access the exercise file.
Please provide access to the Google Sheet training file. It is private.
It should be public now
Can anyone help to find this video's excuse file?
Exercise Files: bit.ly/3MNmiRD
how can i find google sheet file,
please help me
Exercise Files: bit.ly/3MNmiRD
What link? Where do I find the link?
Exercise Files: bit.ly/3MNmiRD
@@LearnitTraining there no files exist. please modify.
how to prepare mock exams on google sheet
This article may help: support.google.com/docs/answer/7032287?hl=en