Skillshare - Google Sheets For Teams II - Advanced Features and F...

Category Other
Type Tutorials
Language English
Total size 1.2 GB
Uploaded By freecoursewb

Downloads 192
Last checked 23 hours ago
Date uploaded 2 years ago
Seeders 1
Leechers 0

Infohash : 535FF223E420A12C9795C2C581E2BFDE62C57A97

Google Sheets For Teams II: Advanced Features & Formulas For Teams

https://CourseLala.com

Duration: 2h 1m | Video: .MP4, 1280x720, 30 fps | Audio: AAC, 48 kHz, 2ch | Size: 1.19 GB
Genre: eLearning | Language: English

Build advanced Google Sheets formulas for modeling and analysis
You're and advanced Google Sheets user and already know how to use VLOOKUP and PivotTables. This class dives into more advanced use cases and scenarios for high performing teams. Your team needs to do more advanced analysis on how to do things like optimize profit or analyze big data sets. This class teaches you the advanced formulas to features to help your team be more productive in Google Sheets. Are you a beginner to Google Sheets? Take the intro Google Sheets For Teams I class!
Note: this class moves fast and requires previous knowledge of Google Sheets. See the "Who this class is for" section below.
What you'll learn
Protecting your worksheets from accidental edits or deletions
How the QUERY function helps you sort through big datasets better
Building a user-friendly dashboard that the C-Suite can interact with
Finding optimal inputs for your models with Goal Seek and Solver
Syncing your Google Sheet with another Google Sheet at your company
and more!
Why you should take this class
Google Sheets is an integral part of your team, and you want to figure out ways to make your Google Sheet easier to use for everyone at your company. You'll walk away with skills to improve the user experience of your Google Sheet. The advanced formulas will also help you summarize and analyze data better so that your team can see the data that matters to them.
Google Sheet class file
You'll be using a Google Sheet file I've created for this class. Make a copy of the file here.
Who is this class for?
Advanced users of Google Sheets
You typically are the "project manager" of our team's Google Sheets file
Prerequisites: Understand how to work with common formulas like VLOOKUP and features like conditional formatting
Questions?
Please post your questions in the Discussions page of this class
Other advanced spreadsheet classes you might like

                Files: 

                [ CourseLala.com ] Skillshare - Google Sheets For Teams II - Advanced Features and Formulas For Teams
Get Bonus Downloads Here.url (0.2 KB)
~Get Your Files Here !01 Introduction.de.srt (4.5 KB)
Introduction.de.vtt (5.6 KB)
Introduction.en-US.srt (5.1 KB)
Introduction.en-US.vtt (4.9 KB)
Introduction.es-MX.srt (4.4 KB)
Introduction.es-MX.vtt (5.4 KB)
Introduction.fr.srt (5.8 KB)
Introduction.fr.vtt (5.6 KB)
Introduction.mp4 (46.4 MB)
Introduction.pt.srt (4.3 KB)
Introduction.pt.vtt (5.2 KB)
Fancy conditional formatting.de.srt (8.6 KB)
Fancy conditional formatting.de.vtt (8.6 KB)
Fancy conditional formatting.en-US.srt (8.0 KB)
Fancy conditional formatting.en-US.vtt (7.6 KB)
Fancy conditional formatting.es-MX.srt (8.7 KB)
Fancy conditional formatting.es-MX.vtt (8.4 KB)
Fancy conditional formatting.fr.srt (8.9 KB)
Fancy conditional formatting.fr.vtt (8.6 KB)
Fancy conditional formatting.mp4 (40.5 MB)
Fancy conditional formatting.pt.srt (8.7 KB)
Fancy conditional formatting.pt.vtt (8.4 KB)
Protect your Sheet from others making mistakes.de.srt (4.4 KB)
Protect your Sheet from others making mistakes.de.vtt (12.1 KB)
Protect your Sheet from others making mistakes.en-US.srt (10.8 KB)
Protect your Sheet from others making mistakes.en-US.vtt (10.3 KB)
Protect your Sheet from others making mistakes.es-MX.srt (11.6 KB)
Protect your Sheet from others making mistakes.es-MX.vtt (11.1 KB)
Protect your Sheet from others making mistakes.fr.srt (11.3 KB)
Protect your Sheet from others making mistakes.fr.vtt (12.1 KB)
Protect your Sheet from others making mistakes.mp4 (60.5 MB)
Protect your Sheet from others making mistakes.pt.srt (12.0 KB)
Protect your Sheet from others making mistakes.pt.vtt (11.5 KB)
Revert back to an old version.de.srt (12.2 KB)
Revert back to an old version.de.vtt (11.7 KB)
Revert back to an old version.en-US.srt (10.7 KB)
Revert back to an old version.en-US.vtt (10.1 KB)
Revert back to an old version.es-MX.srt (11.6 KB)
Revert back to an old version.es-MX.vtt (11.1 KB)
Revert back to an old version.fr.srt (3.9 KB)
Revert back to an old version.fr.vtt (11.7 KB)
Revert back to an old version.mp4 (81.4 MB)
Revert back to an old version.pt.srt (8.0 KB)
Revert back to an old version.pt.vtt (11.2 KB)
SORT & FILTER functions.de.srt (14.3 KB)
SORT & FILTER functions.de.vtt (17.9 KB)
SORT & FILTER functions.en-US.srt (16.9 KB)
SORT & FILTER functions.en-US.vtt (16.0 KB)
SORT & FILTER functions.es-MX.srt (11.7 KB)
SORT & FILTER functions.es-MX.vtt (17.1 KB)
SORT & FILTER functions.fr.srt (1.7 KB)
SORT & FILTER functions.fr.vtt (17.7 KB)
SORT & FILTER functions.mp4 (106.8 MB)
SORT & FILTER functions.pt.srt (11.9 KB)
SORT & FILTER functions.pt.vtt (17.3 KB)
TRANSPOSE & SWITCH functions.de.srt (12.1 KB)
TRANSPOSE & SWITCH functions.de.vtt (11.5 KB)
TRANSPOSE & SWITCH functions.en-US.srt (10.8 KB)
TRANSPOSE & SWITCH functions.en-US.vtt (10.3 KB)
TRANSPOSE & SWITCH functions.es-MX.srt (11.5 KB)
TRANSPOSE & SWITCH functions.es-MX.vtt (11.0 KB)
TRANSPOSE & SWITCH functions.fr.srt (5.3 KB)
TRANSPOSE & SWITCH functions.fr.vtt (11.9 KB)
TRANSPOSE & SWITCH functions.mp4 (43.1 MB)
TRANSPOSE & SWITCH functions.pt.srt (7.6 KB)
TRANSPOSE & SWITCH functions.pt.vtt (11.1 KB)
QUERY data like SQL.de.srt (8.3 KB)
QUERY data like SQL.de.vtt (22.7 KB)
QUERY data like SQL.en-US.srt (21.6 KB)
QUERY data like SQL.en-US.vtt (20.4 KB)
QUERY data like SQL.es-MX.srt (23.2 KB)
QUERY data like SQL.es-MX.vtt (22.1 KB)
QUERY data like SQL.fr.srt (24.1 KB)
QUERY data like SQL.fr.vtt (23.0 KB)
QUERY data like SQL.mp4 (146.7 MB)
QUERY data like SQL.pt.srt (18.3 KB)
QUERY data like SQL.pt.vtt (22.1 KB)
Error proof your data with dropdowns.de.srt (3.0 KB)
Error proof your data with dropdowns.de.vtt (17.2 KB)
Error proof your data with dropdowns.en-US.srt (16.4 KB)
Error proof your data with dropdowns.en-US.vtt (15.5 KB)
Error proof your data with dropdowns.es-MX.srt (17.5 KB)
Error proof your data with dropdowns.es-MX.vtt (16.7 KB)
Error proof your data with dropdowns.fr.srt (3.1 KB)
Error proof your data with dropdowns.fr.vtt (17.9 KB)
Error proof your data with dropdowns.mp4 (105.7 MB)
Error proof your data with dropdowns.pt.srt (0.4 KB)
Error proof your data with dropdowns.pt.vtt (16.7 KB)
User-friendly Slicers for your PivotTables.de.srt (0.7 KB)
User-friendly Slicers for your PivotTables.de.vtt (21.9 KB)
User-friendly Slicers for your PivotTables.en-US.srt (20.2 KB)
User-friendly Slicers for your PivotTables.en-US.vtt (19.1 KB)
User-friendly Slicers for your PivotTables.es-MX.srt (13.0 KB)
User-friendly Slicers for your PivotTables.es-MX.vtt (20.8 KB)
User-friendly Slicers for your PivotTables.fr.srt (15.4 KB)
User-friendly Slicers for your PivotTables.fr.vtt (21.9 KB)
User-friendly Slicers for your PivotTables.mp4 (125.9 MB)
User-friendly Slicers for your PivotTables.pt.srt (10.0 KB)
User-friendly Slicers for your PivotTables.pt.vtt (20.4 KB)
Superpower your sheet with add-ons & macros.de.srt (19.0 KB)
Superpower your sheet with add-ons & macros.de.vtt (18.0 KB)
Superpower your sheet with add-ons & macros.en-US.srt (16.9 KB)
Superpower your sheet with add-ons & macros.en-US.vtt (16.0 KB)
Superpower your sheet with add-ons & macros.es-MX.srt (18.0 KB)
Superpower your sheet with add-ons & macros.es-MX.vtt (17.1 KB)
Superpower your sheet with add-ons & macros.fr.srt (18.9 KB)
Superpower your sheet with add-ons & macros.fr.vtt (18.0 KB)
Superpower your sheet with add-ons & macros.mp4 (107.6 MB)
Superpower your sheet with add-ons & macros.pt.srt (0.1 KB)
Superpower your sheet with add-ons & macros.pt.vtt (17.1 KB)
Find the optimal input with Goal Seek.de.srt (11.5 KB)
Find the optimal input with Goal Seek.de.vtt (12.6 KB)
Find the optimal input with Goal Seek.en-US.srt (11.9 KB)
Find the optimal input with Goal Seek.en-US.vtt (11.3 KB)
Find the optimal input with Goal Seek.es-MX.srt (1.0 KB)
Find the optimal input with Goal Seek.es-MX.vtt (12.2 KB)
Find the optimal input with Goal Seek.fr.srt (1.1 KB)
Find the optimal input with Goal Seek.fr.vtt (12.8 KB)
Find the optimal input with Goal Seek.mp4 (65.1 MB)
Find the optimal input with Goal Seek.pt.srt (12.8 KB)
Find the optimal input with Goal Seek.pt.vtt (12.2 KB)
Optimizing under multiple constraints with Solver.de.srt (3.5 KB)
Optimizing under multiple constraints with Solver.de.vtt (21.0 KB)
Optimizing under multiple constraints with Solver.en-US.srt (20.0 KB)
Optimizing under multiple constraints with Solver.en-US.vtt (18.9 KB)
Optimizing under multiple constraints with Solver.es-MX.srt (21.2 KB)
Optimizing under multiple constraints with Solver.es-MX.vtt (20.2 KB)
Optimizing under multiple constraints with Solver.fr.srt (2.6 KB)
Optimizing under multiple constraints with Solver.fr.vtt (20.8 KB)
Optimizing under multiple constraints with Solver.mp4 (79.8 MB)
Optimizing under multiple constraints with Solver.pt.srt (15.6 KB)
Optimizing under multiple constraints with Solver.pt.vtt (20.1 KB)
Import data from other Google Sheet files.de.srt (4.5 KB)
Import data from other Google Sheet files.de.vtt (25.7 KB)
Import data from other Google Sheet files.en-US.srt (24.3 KB)
Import data from other Google Sheet files.en-US.vtt (23.0 KB)
Import data from other Google Sheet files.es-MX.srt (26.0 KB)
Import data from other Google Sheet files.es-MX.vtt (24.7 KB)
Import data from other Google Sheet files.fr.srt (4.6 KB)
Import data from other Google Sheet files.fr.vtt (26.2 KB)
Import data from other Google Sheet files.mp4 (186.3 MB)
Import data from other Google Sheet files.pt.srt (26.2 KB)
Import data from other Google Sheet files.pt.vtt (24.9 KB)
Final Thoughts + Class Project.de.srt (3.0 KB)
Final Thoughts + Class Project.de.vtt (2.9 KB)
Final Thoughts + Class Project.en-US.srt (2.8 KB)
Final Thoughts + Class Project.en-US.vtt (2.7 KB)
Final Thoughts + Class Project.es-MX.srt (3.0 KB)
Final Thoughts + Class Project.es-MX.vtt (2.9 KB)
Final Thoughts + Class Project.fr.srt (3.1 KB)
Final Thoughts + Class Project.fr.vtt (3.0 KB)
Final Thoughts + Class Project.mp4 (23.6 MB)
Final Thoughts + Class Project.pt.srt (2.9 KB)
Final Thoughts + Class Project.pt.vtt (2.8 KB)
Bonus Resources.txt (0.4 KB)

There are currently no comments. Feel free to leave one :)

Code:

udp://tracker.torrent.eu.org:451/announce
udp://tracker.tiny-vps.com:6969/announce
http://tracker.foreverpirates.co:80/announce
udp://tracker.cyberia.is:6969/announce
udp://exodus.desync.com:6969/announce
udp://explodie.org:6969/announce
udp://tracker.opentrackr.org:1337/announce
udp://9.rarbg.to:2780/announce
udp://tracker.internetwarriors.net:1337/announce
udp://ipv4.tracker.harry.lu:80/announce
udp://open.stealth.si:80/announce
udp://9.rarbg.to:2900/announce
udp://9.rarbg.me:2720/announce
udp://opentor.org:2710/announce