From the course: Excel Tips Weekly

Unlock this course with a free trial

Join today to access over 22,400 courses taught by industry experts.

Custom formats, relative addressing, and conditional formatting

Custom formats, relative addressing, and conditional formatting - Microsoft Excel Tutorial

From the course: Excel Tips Weekly

Custom formats, relative addressing, and conditional formatting

- [Instructor] Imagine you're going to be taking a trip 2 in a few months 3 and you've got your departure dates lined up. 4 You might consider any one of these different days 5 as the departure date and you're thinking 6 of returning on one of these three days 7 and you've got some flexibility. 8 So you've put in those different dates 9 and you've gone to the airline website, 10 perhaps, or called them. 11 You've got these prices for the different amounts here. 12 Also, you've checked out rental car prices 13 and the unusual one of these days here, 14 it's a lot pricier for some reason. 15 That's not the same day where 16 the charges over here are pricey. 17 But nevertheless, you're curious about some 18 of the combinations here. 19 Now this is kind of a setup based on a real life experience 20 of just using different features in Excel 21 to make this more readable and more usable. 22 And you could easily imagine expanding…

Contents