Google Sheets - Working With Formulas and Functions (Udemy.com)
Learn how to use formulas and functions in spreadsheets to do some powerful and amazing things.
Created by: Joe Buchmann
Last updated October 2017
What you will learn
- Understand what functions are and how to apply them
- Full understanding of what various different functions do, and how to use them
How it compares
Against the other 459 rated Udemy courses in Office Productivity on CourseDuck:
- Rating4.6 out of 5higher than 67% of them
- Reviews156#369 of 460 by number of reviews
- Length1.1 hoursshorter than 89% of them
- Last updatedOctober 2017earlier than 93% of them
Course Description
If you've ever dreamed of using those really cool functions in your spreadsheets that you've seen other people use, then this course if for you. By the end of the course, you will be on your way to becoming a spreadsheet wizard!
In this course we'll start with the most basic function, learning how to write it and understand how functions work. Then we'll work our way up through more and more advanced functions, so that by the end of the course, you'll be able to use several functions together in powerful ways.
Don't worry if you have limited, or no experience with formulas and functions. This course will walk you through every step of the way. You should, however, have a basic understanding of how spreadsheets work before taking this course. If you are completely new to spreadsheets, you should check out the course, "Google Sheets and Forms - Beginner to Expert" first.
This course is done in Google Sheets, but the functions are all relevant to Microsoft Excel as well.
Instructor Details
- 4.6 Rating
156 Reviews
Joe Buchmann
Who I Am
Hi, I’m Joe, the creator of Digital Egghead.
I build practical, easy-to-follow courses that help people confidently use digital tools in real-world situations. Whether it’s productivity software, design tools, or online systems, my focus is always the same: make things clear, useful, and easy to apply.
What I Teach
Most courses focus on features. I focus on how things actually get used.
You’ll learn:
- Step-by-step workflows you can follow
- How tools connect and work together
- Practical skills you can apply immediately
My goal is to help you not just understand tools, but actually use them with confidence.
My Background
I’ve spent over two decades working across web design, development, and digital marketing. My career has included roles in design, development, marketing, and customer experience, all centered around solving problems and improving how people interact with digital tools.
Teaching was a natural extension of that.
I started creating online courses in 2015, and after stepping away for a period to build another business, I’ve returned with a renewed focus on building Digital Egghead into a modern, practical learning platform.
What to Expect
My courses are built around a simple idea:
Learn it clearly.
Apply it immediately.
Use it with confidence.
More courses by Joe Buchmann
More Office Productivity courses
AI-Powered Social Media Management: From Beginner to Pro (2025)
5.0 (211 Reviews)
Provider: Udemy
Time: 1.1h
$19.99
Microsoft Excel + AI: Go From Data Analysis to Visualization (2026)
4.9 (276 Reviews)
Provider: Udemy
Time: 3.8h
$10.99
Complete Introduction to Google Sheets Pivot Tables (2026)
4.8 (3,570 Reviews)
Provider: Udemy
Time: 2.9h
$64.99
Microsoft Excel - Managing Personal Finances with Excel (2024)
4.8 (810 Reviews)
Provider: Udemy
Time: 3h
$19.99
Reviews
By Atry Lerma on 10/31/2023
Great material and detiled explained for someone learning how to use basic functions. It's a good course.
By Madaline Harlan on 10/12/2023
Some of the quiz questions where confusing and one didn't have a correct answer. Otherwise the information was explained really well and made it easy to understand.
By Michelle Vail on 12/16/2021
Great things to learn however some tests weren't clear on what columns to set up information. Other than that it was great.
By Daniel Twynham on 1/20/2019
Hi, I enjoyed this short course, I learnt alot more than I expected. Can't wait to apply what I have learnt from this course to my work. Thank you.
By Rick Palmer on 12/26/2018
This is great as a beginner course or as a refresher. It is well organized and presented in a manner that works well with my learning style.
By Scott Barrett on 11/15/2018
So far the course has just reviewed sheets information that I already knew. I hope later classes cover information I do not know or give me more ideas of ways to use Google Sheets in my day to day work.
By Megan Morrow on 4/24/2018
This course got me up to speed in a short amount of time, easy to follow and he shows you exactly what you need to know.
By John Thrush on 3/19/2018
I would highly recommend Joe's Google Sheets course to my peers (beginner - intermediate skill level). I learned some critical functions that will help me improve my skills, such as =PROPER() and =VLOOKUP(). This is a perfect course for anyone who has limited time or a busy schedule.
By Emma Bennett on 2/20/2018
Really useful course with lots of variety and examples of how functions can be used in every day business
By Mattia on 11/27/2017
A good and short course for getting strong bases for all the future work with Google Sheets. Thanks Joe!
Quality Score
No CourseDuck member has rated this course yet. Taken it? Give each part a thumbs up or down.
Overall Score : 92 / 100








