Find online courses made by experts from around the world.
Take your courses with you and learn anywhere, anytime.
Learn and practice real-world skills and achieve your goals.
Google Sheet is an extremely powerful alternative to Microsoft's Excel spreadsheet software. Jon will teach you step-by-step how to create a basic spreadsheet and analyze the. This course covers all the essentials that will help you manipulate and analyze large sets of data. Of course, you will learn the fundamentals such as the basic calculations, formulas, creating charts, and tips & tricks that will get you started quickly.
By the end of this introductory course, you will feel confident maneuvering around Google Sheets and gain instincts to use it effectively for data analysis, and ultimately adding value to your company or to your own personal life.
In this course you will learn how to:
As a fun bonus material, you will also learn how to create art with Google Sheets!
Enroll today in this course! We are 100% confident that you will learn
Not for you? No problem.
30 day money back guarantee.
Learn on the go.
Desktop, iOS and Android.
Certificate of completion.
|Section 1: Welcome!|
Creating Your First SpreadsheetPreview
|Section 2: Menu Items & Tool Bar|
Summary of Menu Items & Tool BarPreview
|Section 3: Basic Formulas|
Overview of Formulas
Adding, Subtracting, Multiplying, and Dividing
COUNT and COUNTA
Minimum and Maximum
Rounding Your Numbers!
Sumif(s), Countif(s), and Averageif(s)
Len, Find, Left, Mid, Right, what?!
Concatenate & Ampersand
|Section 4: Lookup Functions & Data Manipulation|
Vlookup and Hlookup
Match Function, used with Vlookup and Hlookup
|Section 5: Charts|
Let Google Sheets Do the Charts for You!
Creating and Customizing Your Own Charts
|Section 6: Other Functions and Know-Hows!|
Business & Statistics Formulas
Sharing Your Projects
Commenting on Your Google Sheet
Navigating Efficiently through Google Sheets
|Section 7: Common Uses for Google Sheets & Templates!|
Overview of Kinds of Templates
Where to Get Templates
|Section 8: Bonus|
Bonus: Creating Art with Google Sheets
|Section 9: Graduation|
Graduation & Congratulations!
As someone who loves learning, cooking, building, and tinkering with all things technology, art, and entrepreneurship, Jon spends his time reading voraciously and crafting his skills on various online projects, including teaching courses online. He loves teaching and helping other people understand topics he has learned himself.
Some of his favorite books includes The Great Divorce and Freakonomics.
He is also a Cal alumni. Go Bears!