Excel - Putting it all together
Build an Excel app from scratch: the cooking calculator (by Oz du Soleil)
Watch Intro
With this course, you immerse yourself into real world Excel.
You create a simple, real app.
No stand-alone tips and tricks here!
Everything in this course has a context and purpose.
You'll see Tables and Dropdown lists functioning together to control inputs, ensure the integrity of the data, and keep everything tied together.
You'll see VLOOKUP, IF, OR and nested formulas that retrieve data and automatically do our calculations.
We look at spreadsheet layout and use worksheet protection to prevent accidental corruption of our hard work.
This course was put together by my online Excel MVP colleague Oz du Soleil, which means:
It's delivered Oz style!
If you know his YouTube channel, you know what that means:
It's real, it's usable and it's fun.
When you take a Basics course, you learn how to use different Excel features on their own.
But how do you combine them to get a fully functioning application?
That's what you learn here.This is your starting point.
Get started now!
"Oz reached into my brain, grabbed my problems, put them on his screen and ... poof! ... They were gone!"
"Great! Oz is relatable, fun, and knowledgeable. He also makes me feel like he's patient in his explanations."
"Your solution was quick to implement and very easy to follow. Thanks again."
Your Instructor
Oz du Soleil is an Excel MVP who's been working with Excel for 20 years. He's known for his brash, overly dramatic YouTube channel Excel on Fire where you can see Oz's true passion for Excel.
Course Curriculum
-
PreviewIntroduction (3:09)
-
StartLayout (3:54)
-
StartDropdown Lists & Tables (6:59)
-
StartAdding Formulas (5:51)
-
StartError Handling & Formula Triggers (4:05)
-
StartReview (1:44)
-
StartSheet Protection: Protecting our hard work (2:58)
-
StartControlling Inputs: Assuring legitimate entries (2:39)
-
StartFinal Touches (2:39)
-
StartThe Workbooks
-
StartLeave a Review
Who is right for this course
- You are an advanced beginner or slightly intermediate Excel user who wants to learn a lot of Excel through hands-on development. By building this cooking calculator, you will be immersed and see a lot of valuable features of Excel.
- You're curious about Excel and want to know what's possible. You might not do the hands-on but follow along because you want to know what Excel can do.
- You'd like to learn how to quickly assemble a simple Excel model.