Google Guru Bundle

395 Enrolled
8 Courses & 26.5 Hours
Deal Price$29.00
Suggested Price
$705.00
You save 95%
Google Guru Bundle
$29.00$705.0095% OFF

What's Included

'Master Google Sheets' Course
  • Experience level required: All levels
  • Access 56 lectures & 3 hours of content 24/7
  • Length of time users can access this course: Lifetime

Course Curriculum

56 Lessons (3h)

  • Introduction
    What we'll cover in this course
  • Spreadsheet Basics
    Creating, Renaming and Sharing
    Formatting Basics
    Freezing Rows and Columns
    Conditional Formatting
    Formatting Quiz
  • Manipulating Data like a BOSS
    Sorting Data
    Filters and Filter Views
    Find and Replace
    Revision History
    Data Manipulation Quiz!
  • Functions and Formulas
    Building Formulas and Functions
    Overview of Formula Types
    List of All Formulas
    Math Functions
    Logical Functions
    Text Functions
    Left and Right
    Find, Replace, Search, Split and Substitute
    Assignment: Creating your own functions
    Functions and Formulas Quiz
    Questions?
  • Charts and Graphs
    Introduction to Charts and Graphs
    Different Kinds of Charts
    Creating our First Chart!
    Creating a Scatterplot
    Assignment: Create your own chart!
    Charts and Graphs Quiz
  • Advanced Google Spreadsheets
    Note from Justin
  • Lookups
    Kinds of Lookups
    Fun with VLOOKUP
    Exercise: Using VLOOKUP
    Answer to VLOOKUP Exercise
    VLOOKUP Additional Resources
    Fun with HLOOKUP
    HLOOKUP Exercise
    Lookups Quiz
  • Pulling Data a Spreadsheet with ImportXML and ImportHTML
    Introduction to ImportXML
    ImportXML Syntax
    Importing XML Data into Spreadsheets
    Importing Alexa Data with ImportXML
    ImportXML Resources
    ImportXML Quiz
    Using ImportHTML
    ImportXML and ImportHTML quiz
  • Macros
    Introduction to Macros
    Writing our First Macro
    Example: Write Your Own Macro
    Macros Quiz!
  • Tools to Use with Google Docs
    Spreadsheet Add-ons
    Using Spreadsheet Booster
    Advanced Spreadsheet Booster
  • Resources
    Google Spreadsheet Templates
    Official Google Spreadsheet Resource
    Bonuses
    What did you think of the course? Plus, bonus inside!

'Master Google Sheets' Course

JM
Justin MaresJustin Mares formerly ran growth at developer tools company Exceptional (acquired by Rackspace in March of 2013). While there, he taught himself how to become a technical marketer and use tools like SQL to run important analyses on customer data. He is also the co-author of Traction Book, which details how startups can get traction, and founded e-commerce company Kettle & Fire (which hit a multi-million dollar run rate in just a few months). For more details on the course and instructor, click here. This course is hosted by StackSkills, the premier eLearning destination for discovering top-shelf courses on everything from coding—to business—to fitness, and beyond!

Description

Google Spreadsheets is an amazing alternative to Microsoft Excel, and it's time you joined legions of satisfied Google converts. You'll find it a valuable tool for compiling, editing, and sharing spreadsheet data, whether you're drafting charts and graphs, utilizing sorting and filtering tools, or performing any other task.
  • Use Google Spreadsheets like you do Microsoft Excel w/ 3 hours of content
  • Visually represent your data w/ charts & graphs
  • Quickly write formulas & create powerful calculations
  • Use data tools like sorting, subtotaling & filtering
  • Write your own scripts & use Google addons to get more done
  • Create charts, tables, graphs & format data
  • Automate tasks w/ time-saving scripts & add-ons

Specs

Details & Requirements

  • Length of time users can access this course: lifetime access
  • Access options: web streaming, mobile streaming
  • Certification of completion not included
  • Redemption deadline: redeem your code within 30 days of purchase
  • Experience level required: all levels

Compatibility

  • Internet required

Terms

  • Instant digital redemption
Your Cart
Your cart is empty. Continue Shopping!
Processing order...