(C) 2009 - 2014 by Mourad Louha · All rights reserved

Excel Advent Calendar

Categories: Calendar Templates
Comments: No

Petros Chatzipantazis asked me some days ago, if I was interested to translate his advent calendar to german and to publish it on my blog. I thought the idea for the advent calendar was great, so it took very short time to accept his suggestion. The advent calendar includes quizes from Petros, Chris Macro and me. Each day, you can answer to a question about Excel – some of these questions are relatively easy and others are more difficult. Each author provided some questions. I provided the questions in German. Petros and Chris provided questions in English. Petros also published a post Anticipate Christmas by counting down the days using Excel on his blog. The following screenshot shows the german version for the advent calendar

Advent

The advent calendar is available in two versions. The first version does not need anything else than the activation of macros. You can answer the questions by clicking on the buttons next to the questions, which appear in the ribbon tab “Advent calendar”. And you can select a question by clicking on the day numbers or by using the buttons “Next question” and “Previous question”. However, some of the buttons just only show a message box; for example is you try to choose an author. This is due to the fact, that’s not possible to change the ribbon tab at run time via VBA.

The second version of the advent calendar uses the Ribbon Commander Framework. This framework allows dynamic Ribbon UI development from VBA & .NET and therefore the second version of the advent calendar offers more possibilities. After downloading the framework (which can be freely tested for 30 days), you can download the advent calender from its integrated Add-In-Manager. The framework can be directly downloaded from the source site or you can use the web laucher, which is an Excel-Add-In and does all work for you via Excel.

Advent

This website offers some free multiyear calendar templates since mid-2012. The templates are quite popular and have been actually downloaded more than 100,000 times.

Recently, Damian Strojec provided a Polish translation of the multiyear calendar template, which also contains the most popular Polish holidays. Thank you very much, Damian!

Excel Calendar Polish

I added the Polish version to the table on the corresponding section for the multiyear calendar templates of the download page.

The Excel Formula Translator is now also available in a Greek version and extends the offer of the online tool and the website to 6 languages. The Online Tool recognizes all native Excel functions since version 2010 and translates these functions to all localized names offered by Microsoft.

Excel Formula Translator Greek

Many thanks to Petros Chatzipantazis and to Lydia Anyfantaki from the company ILYDA for supporting me in the translation to Greek. Petros is the managing director of ILYDA (UK) Ltd, the company behind the Ribbon Commander framework and a member of the practitioners board at the Council for Ubiquitous Intelligence (CUbInt), Emory Goizueta Business School. He publishes regularly free Excel tutorials and VBA Add-ins at Spreadsheet1.com. Lydia is an Excel enthusiast and a young entrepreneur, co-founder of the software development start-up company FLEXWARE Innovation Systems.

In early December 2012, I have released the new websites for the Excel formula translator. The site in a similar design to Excel Ticker is available in German, English, French, Italian and Hungarian and is also part of my planned network of websites focusing on Microsoft Excel.

Excel Formula Translator

The websites provide, in addition to the integration of the online tool, a reference to the translations of all Excel functions from Microsoft Excel. In case where the translation on an Excel function differs from one Excel version to another, these translations are listed separately. And all translations are linked to the Microsoft Online Help in the corresponding language. A few days ago, I did an update and released the websites in Italian and Hungarian.

Many thanks to Roberto Mensa and Krisztina Szabó for supporting and helping me to translate the sites. Roberto is an Excel e VBA enthusiast expert. He is mainly active on Italian online forums and he regularly publishes his work on his sites E90E50 and E90E50fx. Krisztina is the manager of Excel Hero LinkedIn Group and member of the Frankens Team.

If you would like to support us to translate the website into more languages, we welcome your comments here or write us an email to the address mentioned on our imprint page.

 

Someone in the US asked me, if it should be possible to modify my multiple year calendar template so that it reflects the current fiscal year by starting on August and ending on July. After I had done and tested the changes, I thought to share the special version here.

In the settings sheet, you will find new options for setting up the start month and the fiscal year. When entering notes and dates in the notes sheet, the year is automatically calculated according your settings. The holidays are also calculated for both years. For example, if you choose August 2012 as start month, the Easter holidays are calculated for 2013.

Multiple Year Calendar for fiscal years

Finally, I also modified the formulas used in the week, month, quarter and year views for showing the dates. You can download the Excel 2007 and above file from following link. Please note, that I have only changed the US Version of the calendar, but I am also planning to update the version for the other countries.

Tina Clarke, Expression Web MVP, recently created a Facebook group about Expression Web & Co. As I am occasionally using Expression Web for designing or modifying my blog templates and sometimes have questions about the software and its use, I thought, it should be a good idea to join the group for getting in touch with the experts for this software. Tina Clarke and Pat Geary are operating several sites about Expression Web and have also written several free e-books, which I would like to share here.

Expression Web

You can download the free e-books from the Microsoft Expression Gallery and get more help and support on Tina’s and Pat’s websites.