Google Sheets Training for Excel Users

Who should attend

Advanced users of Excel

Team Pass by Learnit

Google Sheets Training for Excel Users

From $0
Two, 2-hour Modules (9am - 11:30am PT)

Google Sheets is the spreadsheet application of Google's cloud-based office suite. 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.

Learning Outcomes: 

  • Can create conditional formatting 
  • Ability to use limit what information users can add or edit 
  • Can share a spreadsheet and collaborate in real-time 
  • Be able to make interactive sheets and forms to obtain information 
  • Can get real-time financial data from stock market 
  • Ability to create Macros to automate repetitive actions 
  • Can create visuals like charts, sparklines, and QR Codes
Course ID
GOOGLEROlH
Available times
June 17 & June 18, 2021
9:00am-11:30am
June 17 & June 18, 2021
9:00am-11:30am
June 17 & June 18, 2021
9:00am-11:30am
June 17 & June 18, 2021
9:00am-11:30am
June 17, 2021
9:00am-11:30am
June 17, 2021
9:00am-11:30am
June 17, 2021
9:00am-11:30am
June 17, 2021
9:00am-11:30am
June 17, 2021
9:00am-11:30am

Course Outline

  • Conditional Formatting: setting rules for changing font and background colors based on cell values
  • Data Validation, Named Ranges and Dropdowns: Limiting users to only input dates, numbers, or text from a dropdown
  • Data Protection: Prohibiting users from editing certain ranges by setting parts of your spreadsheet to be "protected" from changes
  • Sharing Options: Restricting editing, viewing, and/or commenting to certain users
  • Filter Views: Allowing multiple users to sort and filter the same spreadsheet without affecting each other
  • Recovering from Mistakes: Accessing the spreadsheet's version history, seeing who made changes and restoring old versions
  • Creating Charts Instantly Using Google's AI Feature
  • Checkboxes: A simple way to create interactive sheets
  • Google Forms and Quizzes: Feeding user-inputted data into a spreadsheet (example)
  • Incorporating Real-Time Data: Accessing HTML tables and CSV files online to extract data from other web sites
  • Selecting data with SQL: running database commands gainst columns of spreadsheet data
  • Zapier Integration: Filling sheets with data from other web services (e.g., adding Twitter mentions to a Google Sheet)
  • Getting Financial Data: access real-time stock quotes, volume, and even cryptocurrency prices (example)
  • Macros and AppScript: Equivalent to VBA, AppScript allows developers to access the internal components of a Google sheet
  • Maps with Pins: with the GeoCode add-in, you can create Google maps with colored pins at address locations listed in your spreadsheet
  • Mobile Apps from Google Sheets Using AppSheet: If your spreadsheet has tabs, column headings, image URL refrences, and related data in each row, you can quickly turn it into an intuitive cell phone app using the AppSheet add-in (app / / data)
  • Visualizing and Transforming Data: Sparkline() for mini-charts, Image() for QR Codes, Translate() for foreign languages

Skills covered

No items found.