From the course: Excel: Advanced Formulas and Functions
Unlock the full course today
Join today to access over 23,100 courses taught by industry experts.
Writing 3D formulas
From the course: Excel: Advanced Formulas and Functions
Writing 3D formulas
- [Instructor] 3-D formulas, they can simplify your life, immensely, if everything is set up right, and let's take a look at that. We want to make an overview tab, and that's where we are right now, and we've got these other five tabs. Let's look at 'em. Trip one, we've got gas, that word in B2 and then the amount that was spent on gas in C2, right? Gas, lodging, destination, days. Go to the trip two tab, same order, everything starts in cell B2. Good. Trip four and then trip five. Right, let's go back to the overview. Now it is time. No more waiting. 3-D formula, I want a total of the number of days equals sum open parentheses, go to trip one. I'm going to hold down the shift key and go to five. Okay and I want the number of days. I'm going to select C5, enter. 43 total days. So look at that formula. So we are doing a sum of cell C5, and then we look at trip one colon trip five. So we've got everything…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
-
-
-
(Locked)
Use Alt+Enter to make formulas more readable4m 35s
-
(Locked)
Formula vs. lookup table4m 38s
-
(Locked)
Formula vs. helper columns8m 31s
-
(Locked)
Build complex formulas in steps6m 12s
-
(Locked)
Writing formulas for "future you"1m 52s
-
(Locked)
Compatibility functions8m 21s
-
(Locked)
Writing 3D formulas3m 56s
-
(Locked)
Volatile functions5m 8s
-
(Locked)
LET function overview11m 4s
-
(Locked)
Error handling: IFNA and IFERROR4m 11s
-
(Locked)
-
-
-
-
-
-
-
-
-