Kenji Explains on MSN

Create a dynamic calendar from a list of events in Excel

In this video, learn how to transform a simple list of events in Excel into a fully dynamic monthly calendar. The tutorial covers: - Setting up dates with the SEQUENCE and WEEKDAY functions - Making ...
How-To Geek on MSN

Creating drop-downs from table headers in Excel seems impossible—but this trick fixes it

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