Excel with Business
No specific location
N/A

Google Sheets

N/A
£ 59

By applying, I confirm I have read and confirm Sales and Marketing Courses Terms and Conditions

Excel with Business
No specific location
N/A
Online | Advanced |   7Hours   

Online | Advanced |   7Hours   

£ 59

Google Sheets

£ 59

Send enquiry

Google Sheets

Google Sheets with Excel

Course Overview

Become a Google Sheets Master with this course.

Engage with this exciting alternative to MS Excel and become a Google Sheets Master.

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.
 
In this course you will learn:

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

More about us:

• We have nearly 1 million students in total
• Our training is personal. You can use the filter to show you which parts of the course to skip.
• Our platform is award-winning and improving all the time. We work with our authors on an ongoing basis to ensure our courses are up to date.
• All of our courses are certificated on completion – this course is also CPD Accredited. 

If you are not 100% happy with your EwB Google Sheets course, you have 30 days to exchange or refund.
 
About the author:

Justin Mares 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.

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.
 
Syllabus:
 
Section 1: The Basics
▸
Unit 1.1 - Introduction
▸
Unit 1.2 - Spreadsheet Basics

Section 2: Manipulating Data, Functions, and Formulas
▸
Unit 2.1 - Manipulating Data
▸
Unit 2.2 - Functions and Formulas

Section 3: Charts and Graphs
▸
Unit 3.1 - Charts and Graphs

Section 4: Lookups
▸
Unit 4.1 - Lookups

Section 5: Pulling Data from a Spreadsheet
▸
Unit 5.1 - Using ImportXML
▸
Unit 5.2 - Using ImportHTML

Section 6: Using Macros and Other Tools
▸
Unit 6.1 - Macros
▸
Unit 6.2 - Tools to Use with Google Docs

Section 7: Course Ending
▸
Unit 7.1 - Templates and Resources
▸
Unit 7.2 - Conclusion