Sync your drop-down menus with table headers using this robust, auto-expanding Named Range trick.

Replace manual Excel tasks with conditional columns, smart merging, the unpivot tool, and more.

Find historical weather by searching for a city, zip code, or airport code. Include a date for which you would like to see weather history. You can select a range of dates in the results on the next ...