Google Sheets

Excel with Business

Programme Description

Google Sheets

Excel with Business

60429_GoogleSheets.png

Become a Google sheets master with this course.

In this course you will learn:

  • How to adjust the way data and information are displayed.
  • Use advanced tools like Macros, Import HTML and Scripts to replicate Excel’s functions.
  • How to write powerful formulas quickly and easily with the point-and-click method.
  • Use data tools like sorting, subtotaling, and filtering.
  • How to automate tasks with time-saving scripts and add-ons.
  • Discover Spreadsheets secrets and shortcuts.

Engage with this exciting new product and become a Google Sheets Master with this course. Google Sheets replicates many of Excel’s functions but has gone one step further. Expect to find charts, graphs, pivot tables, functions, and formulas, but you’ll also discover what makes Google Sheets unique, like file sharing, revision history, web-based scripts, macros, and much more. It’s not your typical spreadsheet.

If you are not 100% happy with your EwB course, you have 30 days to exchange or refund.

Syllabus

  • Section 1: The Basics
  • Section 2: Manipulating Data, Functions, and Formulas
  • Section 3: Charts and Graphs
  • Section 4: Lookups
  • Section 5: Pulling Data from a Spreadsheet
  • Section 6: Using Macros and Other Tools
  • Section 7: Course Ending

About the author

Justin Mares

Justin formerly ran growth at developer-tools company Exceptional (acquired by Rackspace in March of 2013). At Exceptional, he was responsible for growth and revenue across three separate developers tools products – Exceptional, Airbrake and RedisToGo.

While there, he built and managed an inside sales team in Vegas, cut churn by more than 60%, tripled organic traffic, improved conversion rates through a series of A/B tests and doubled average revenue per customer. In this role selling to developers, he also taught himself how to program (poorly), use tools like SQL and R, and familiarised himself with the entire stack of web technologies.

He has also founded two other companies, one of which was acquired.

Justin is also the co-author of Traction Book, a book about how startups can get traction. For the book, he interviewed Jimmy Wales (founder of Wikipedia), Paul English (founder of Kayak), Dharmesh Shah (HubSpot founder) and pulled together an actionable framework for how startups should think about getting traction and distribution.

This school offers programs in:
  • English


Last updated November 21, 2017
Duration & Price
This course is Online
Start Date
Start date
Open Enrolment
Duration
Duration
Part time
Full time
Price
Price
59 GBP
Information
Deadline
Contact school
Locations
United Kingdom - London, England
Start date: Open Enrolment
Application deadline Contact school
End date Contact school
Dates
Open Enrolment
United Kingdom - London, England
Application deadline Contact school
End date Contact school
Price
per year