Excel Advent Calendar No Macros

December is only 2 days away, so it's time for an Excel Advent Calendar! I've made two new versions this year, and they don't use macros, just basic Excel features. Even if you don't need an Advent calendar, take a look to see how they're set up . You might find a use for these techniques in other projects.

Continue reading "Excel Advent Calendar No Macros"

Excel Mileage Lookup With Total Distance

If you're planning a vacation trip, Excel can help. It's a great place to keep your packing lists, and you can track your vacation spending too (if you really want to know the total!). I've just uploaded a new sample file that will show how far you'll travel. Select cities, and formulas do a mileage lookup, with total distance from start to end.

Continue reading "Excel Mileage Lookup With Total Distance"