213,717 views
Learn how to make a dynamic calendar that is dynamic by month and year. Not only that, but you can connect it with an agenda table to visualize the free and busy days! Join me to do this interesting exercise or download the template at: www.novatecscourses.com/plantillas_rapidas -------------------------------------------------------------------------------------------------------- Get to know our Excel course: https://www.novatecscourses.com Follow us on our social networks: TikTok: / novatecs_excel Instagram: / novatecs_ex. . Facebook: https://www.facebook.com/profile.php?... -------------------------------------------------------------------------------------------------------- 00:00 Introduction 01:30 Prepare a spreadsheet 04:12 Calendar formula 08:31 Calendar format and conditional formatting 13:51 Validated lists 15:20 Agenda table and connection