Couldn't focus in class? Stressed for your upcoming exam?
Perfect, you're in the right place. Sit back, relax, and let me teach you everything about Excel in 30 minutes!
The goal
I will give you all the Excel knowledge you need for your upcoming exam in the shortest amount of time.
Throughout this guide, we'll be covering the following topics:
- AND vs. OR
- HLOOKUP
- IFERROR
- Nested IF vs. IFS
- Excel tables
- PivotTables
- COUNTIF, SUMIF, AVERAGEIF
- SUMPRODUCT
- 3D Cell References
Why learn here?
I was behind "enemy lines" for 2 years as a teacher assistant for an undergraduate-level coding course. I know exactly what you need to be prepared for!
Over my time as a teacher assistant, I gathered the most effective teaching methods to make Excel concepts stick. Not only that, but I have extensive experience with Excel, tutoring many struggling students in it over my years in college.
Ultimately, I've been in your shoes. I entered my first coding class as a complete beginner only 4 years ago, so I'm familiar with your current level of understanding and know exactly what you need in order to pass your Excel exam.
The plan
Each article in this series, I'm going to...
1) Explain the concept with simple, real-world explanations.
2) Show you how to apply that concept in Excel.
3) Give you a practice problem to solidify what you just learned.
Why do it this way?
First, I want to put these Excel concepts in terms that a 3rd grader would understand. That way, there's no doubt it will make sense to you before we start coding.
Second, practice makes perfect. I want to show you how to apply what you've learned!
Excel (Exam 2) Follow-along Guide
It's no secret you retain info better when you write it down. That's why I created the Excel (Exam 2) Follow-along Guide for you!
As you come upon key concepts highlighted in yellow, like this sentence here, you can fill-in-the-blanks on your Follow-along Guide so that you remember all the important stuff for later!
You can obtain the Excel (Exam 2) Follow-along Guide for FREE by entering your email below!
Start Learning!
We'll start with learning the difference between AND vs. OR. If you want to start with a different topic, go for it!