In this video I show you how to create a perfect annual calendar including holidays, calendar weeks and weekends in Excel. This calendar works for the years 1900 to 2203! Enjoy watching! ▒▒▒ File Excel annual calendar ▒▒▒ https://tatakaus.creator-spring.com/l... ▒▒▒ Subscribe ▒▒▒ ❤ Channel subscription: http://tiny.cc/subscribe ▒▒▒ online Excel course ▒▒▒ ► my paid Excel course for beginners - 12 hours of video material - practice files - certificate http://tiny.cc/excel-kurs ► 200+ Excel keyboard shortcuts on a laminated card - work more efficiently with keyboard shortcuts. Available on Amazon: http://tiny.cc/excel-shortcuts ▒▒▒ Videos ▒▒▒ ►Excel Top 30 Functions • Learn Excel for Beginners and Advanced... ►Excel Basic Course for Beginners • Learn Microsoft Excel for Beginners -... ►Excel Formulas and Functions • Excel Formulas and Functions: VLOOKUP... ▒▒▒ Time Stamp ▒▒▒ 00:00 The PERFECT Calendar Step 1: Create an annual calendar 01:19 Create a dynamic annual calendar 01:28 Create monthly headings 02:06 Explanation of the SEQUENCE function 03:24 SEQUENCE function for calendar days 05:22 END OF MONTH function 08:21 Mark weekends in gray (conditional formatting) 12:14 Insert frame (conditional formatting) 13:44 Formula and formatting on all cells transfer 14:16 Demonstration of dynamic calendar 14:31 Deactivate grid lines Step 2: Calculate public holidays 14:40 Calculate public holidays 14:58 Types of public holidays 15:33 Calculate fixed public holidays 16:52 Calculate Easter Sunday 17:38 Calculate movable public holidays 18:29 Calculate Repentance Day Step 3: Insert public holidays and weeks in the annual calendar 20:27 Insert additional columns 21:35 Adjust conditional formatting 25:04 Insert public holidays 28:44 Insert calendar weeks 30:37 Demonstration of final annual calendar ▒▒▒ About me ▒▒▒ As a graduate in business administration (FH), I worked as a consultant for tax consultancy and auditing. Since 2012 I have been creating videos on Excel and Word for beginners and advanced users. ❤ Channel SUBSCRIBE: http://tiny.cc/abonnieren ▒▒▒ Affiliate links ▒▒▒ ► Excel 2021: The big Excel manual. Introduction, practice, professional tips - the compendium for all Excel users. Also suitable for Microsoft 365* https://amzn.to/356gf9R The links marked with * are so-called affiliate links. If a purchase is made via such a link, I will receive a commission. There are no additional costs for you. Where, when and how you buy a product is of course up to you. ▒▒▒ Other ▒▒▒ This video is interesting for you if you are looking for the topics excel calendar 2023 nrw, excel calendar 2023 calendar weeks, calendar 2023 baden-württemberg excel, excel calendar 2023 bavaria, holiday calendar 2023 excel, annual calendar 2023 to print, calendarpedia 2023 excel and calendar 2023 with public holidays. #Excel #Calendar #Tutorial