Google Sheets is unfortunately unavailable

Google Sheets

at AcademyX - FINANCIAL DISTRICT

(63)
Course Details
Price:
$695
Start Date:

This class isn't on the schedule at the moment, but save it to your Wish List to find out when it comes back!
If you're enrolled in an upcoming date, this simply means that date has now sold out.

Location:
FINANCIAL DISTRICT
601 Montgomery St #409
Btwn Merchant & Clay Streets
San Francisco, California 94111
(Map)
Share:
Purchase Options
Description
Class Level: Advanced
Age Requirements: 18 and older
Average Class Size: 4

What you'll learn in this google training:

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.

Topics covered:

  • 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
  • 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
  • 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
  • Visualizing and Transforming Data: Sparkline() for mini-charts, Image() for QR Codes, Translate() for foreign languages

Prerequisites:

  • Intermediate-level knowledge of Excel: functions, formulas, vlookup or similar grounding in spreadsheets.


Still have questions? Ask the community.

Refund Policy
If you need to reschedule or cancel a class, it's usually no problem. We will move you to a different session, or give you a full refund as long as you give us at least 7 days' notice. If, however, you notify us less than one week before the class (a "late-cancellation"), we do not offer a refund and you only qualify for a late-reschedule. We charge $25 for any reschedule, $50 for reschedules with fewer than 72 hours' notice, and $100 for reschedules with fewer than 24 hours' notice (or no-shows)
Students may withdraw from any course (except when they have late-rescheduled) after instruction has started within 2 hours and receive a full refund, provided the reason for their withdrawal is dissatisfaction with the course. In the case of multi-day and multi-evening courses, students may withdraw after any session before the course's half-way point and receive pro-rated refund for the unused portion of the tuition.

Map

Google Map

AcademyX

All classes at this location

Start Dates (0)

This class isn't on the schedule at the moment, but save it to your Wish List to find out when it comes back!

Benefits of Booking Through CourseHorse

Booking is safe. When you book with us your details are protected by a secure connection.
Lowest price guaranteed. Classes on CourseHorse are never marked up.
This class will earn you 6950 points. Points give you money off your next class!
Questions about this class?
Get help now from a knowledge expert!
Questions & Answers (0)

Get quick answers from CourseHorse and past students.

Reviews of Classes at AcademyX (63)

School: AcademyX

AcademyX

AcademyX offers hands-on, instructor-led training in MS Office, Adobe web and graphic design apps, web technologies, programming languages and servers.  In business since 2000, we have trained over 15,000 students. We use contract trainers that practice in the field when they're not teaching classes....

Read more about AcademyX

CourseHorse Approved

This school has been carefully vetted by CourseHorse and is a verified SF educator.

Want to take this class?

Save to Wish List
Taking this class for work? Get exclusive perks & discounts for free.