• Skip to main content
  • Skip to header right navigation
  • Skip to site footer

My Online Training Hub

Learn Dashboards, Excel, Power BI, Power Query, Power Pivot

  • Courses
  • Pricing
    • SALE 20% Off All Courses
    • Free Courses
    • Power BI Course
    • Excel Power Query Course
    • Power Pivot and DAX Course
    • Excel Dashboard Course
    • Excel PivotTable Course – Quick Start
    • Advanced Excel Formulas Course
    • Excel Expert Advanced Excel Training
    • Excel Tables Course
    • Excel, Word, Outlook
    • Financial Modelling Course
    • Excel PivotTable Course
    • Excel for Customer Service Professionals
    • Multi-User Pricing
  • Resources
    • Free Downloads
    • Excel Functions Explained
    • Excel Formulas
    • Excel Add-ins
    • IF Function
      • Excel IF Statement Explained
      • Excel IF AND OR Functions
      • IF Formula Builder
    • Time & Dates in Excel
      • Excel Date & Time
      • Calculating Time in Excel
      • Excel Time Calculation Tricks
      • Excel Date and Time Formatting
    • Excel Keyboard Shortcuts
    • Excel Custom Number Format Guide
    • Pivot Tables Guide
    • VLOOKUP Guide
    • ALT Codes
    • Excel VBA & Macros
    • Excel User Forms
    • VBA String Functions
  • Members
    • Login
    • Logout
    • Password Reset
  • Blog
  • Excel Webinars
  • Excel Forum
    • Register as Forum Member

Excel Advent Calendar 2015

You are here: Home / Excel / Excel Advent Calendar 2015
Excel Advent Calendar
November 24, 2015 by Mynda Treacy

Around this time last Year I created an Advent Calendar in Excel:

Excel Advent Calendar 2015

To Count Up or To Count Down?

Now, for me an Advent Calendar had always counted down to Christmas day, but to my surprise some people counted up, or rather counted the dates. That is they read the numbers on the calendar as the date as opposed to the number of days until Christmas.

So in the spirit of giving, this year I have created two calendars; one for those who want to count up and one for those who want to count down. I know, generous eh!

They're not those chocolate/candy filled calendars though, plus you actually have to do a bit of work to open the doors. It's nothing too Grinch inspired, just some fun Excel trivia to test your knowledge. Any tips you learn are my Christmas gift to you 😉

Enter your email address below to download the sample workbook.

By submitting your email address you agree that we can email you our Excel newsletter.
Please enter a valid email address.

Click here to download the Excel Advent Calendars file. Note: This is a .xlsm file please ensure your browser doesn't change the file extension on download.

Security Warnings

When you open the file make sure you Enable Editing and then Enable Content by clicking on the yellow messages above the formula bar like this one:

Enable Content warning

How it was made

The calendar is not password protected so feel free to pull it apart and learn how it works. Here's a list of the techniques I used and links to tutorials on those topics to help you get started:

Shapes and Images

Excel Tables

Radio Buttons

Combo Boxes

IF formulas

Nested IF formulas

CHOOSE formulas

VLOOKUP formulas

MATCH formulas

INDEX formulas

And some magical VBA!

More Excel Advent Calendars

If you want more Excel trivia frivolities then check out these (VBA Based) Excel Advent Calendars by Spreadsheet1.com and friends. Plus they're running an Advent Calendar contest where you can try your luck.

Excel Advent Calendar

More Excel Posts

excel templates

Where to Find Free Excel Templates

Where to find free Excel templates and how to create your own Excel templates. Using templates saves time and effort.
Easily Remove Password Protection from Excel Files

Easily Remove Excel Password Protection

How to remove Excel password protection when you’ve forgotten the password. Works for sheets, workbooks and read only files.
Import data from a picture to Excel

Import Data from a Picture to Excel

Import data from a picture to Excel. Works with pictures from a file or the clipboard and loads it to the spreadsheet.
excel online

5 Excel Online Features Better than Desktop

5 Excel Online Features Better than Desktop including searchable data validation, track changes, single line ribbon and more.

10 Common Excel Mistakes to Avoid

10 common Excel mistakes to avoid, including merge cells, external links, formatting entire rows/columns and more.
new Excel features

Cool New Features in Excel for Microsoft 365

Cool New Features in Excel for Microsoft 365 including the navigation pane, smooth scroling, unhide multiple sheets and more.
dynamic dependent data validation

Dynamic Dependent Data Validation

Dynamic Dependent Data Validation with dynamic array formulas like FILTER make it quick and easy to set up.
QAT

Excel Quick Access Toolbar

The Excel Quick Access Toolbar is not only a handy for your mouse, but it also enables some super easy keyboard shortcuts.

Share and Collaborate in Excel

Share and Collaborate in Excel just like Google Sheets! Show changes, custom views, threaded comments with @ mentions and more.
Workbook Protection

Excel Workbook Protection

Excel Workbook protection can prevent your users from breaking your reports while still allowing interaction with Slicers and refreshing.




Category: Excel
Previous Post:Excel Pivot CacheExcel Pivot Cache
Next Post:Error Handling in VBAerror handling in vba

Reader Interactions

Comments

  1. A.Maurizio

    January 18, 2016 at 5:32 am

    Good morning, everybody, my name is Maurice and I have a problem that I would like to solve in VBA. The problem is this: in an Excel form with office 2007, I entered this code:

    Private Sub Cmd_Apri_Telefonata_Click()
    ‘On Error Resume Next
    Call PhoneCall(PhoneNumber, DestName, Comment)
    End Sub

    Private Declare Function TapiRequestMakeCall Lib “Tapi31.DLL” (ByVal Dest As String, _
    ByVal AppName As String, ByVal CalledParty As String, ByVal Comment As String) As Long

    Function PhoneCall(ByVal PhoneNumber As String, ByVal DestName As String, _
    Optional ByVal Comment As String) As Boolean

    ‘On Error Resume Next

    If TapiRequestMakeCall(VBA.Trim$(PhoneNumber), App.Title, VBA.Trim$(DestName), Comment) = 0 Then
    PhoneCall = True
    ‘foglio1.range(“F1″).Value=””
    End If
    End Function

    Now this code should afford associated with a cell, which in my case is: Sheet1. range (“F1”). Value = “” where I put in a phone number that will change from time to time.
    But while not giving me any error apparent, I can’t get it to work; That’s why I ask you kindly to you self you could give me a hand in changing this Windows API so that it can function in VBA.
    Thank you in advance for any help you can give me about; Sincere greetings from a. Maurizio

    Reply
    • Philip Treacy

      January 18, 2016 at 9:04 am

      Hi,

      If you can open a Helpdesk ticket and send us the workbook, we can have a look at this for you.

      Regards

      Phil

      Reply
  2. Cath

    December 2, 2015 at 6:36 pm

    Hi Mynda

    Many thanks for this year’s advent calendar. I’ve downloaded it, checked it’s definitely an xlsm files and clicked on both the ‘enable editing’ and ‘enable content’ messages but am unable to tick the answer boxes. I just get the mouse pointer as if it’s in Edit mode. Can you help please?

    Reply
    • Mynda Treacy

      December 2, 2015 at 9:25 pm

      Hi Catherine,

      Sorry you’re having trouble using the calendar file. Are you able to send me a screenshot of the whole Excel window so I can see what you see after clicking Enable etc. You can upload it via the Help Desk.

      Hopefully that might give me some clues as to what the problem is.

      Thanks,

      Mynda

      Reply
  3. Petros

    November 30, 2015 at 7:04 pm

    UPDATE: VBA Chord Diagram with Hierarchical Edge Bundling

    This VBA chord diagram demonstrates a graphical method of displaying the inter-relationships between code procedures in the Advent Calendar VBA project powered by Ribbon Commander. The data is arranged radially around a circle with the relationships between the points drawn as arcs connecting the procedures together. The project name, module type and name is shown at the bottom of the chart when the mouse pointer hovers over a VBA procedure

    Read more @bottom of page: http://www.spreadsheet1.com/excel-advent-calendar.html

    Reply

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Current ye@r *

Leave this field empty

Sidebar

More results...

Course Sale

mynda treacy microsoft mvpHi, I'm Mynda Treacy and I run MOTH with my husband, Phil. Through our blog, webinars, YouTube channel and courses we hope we can help you learn Excel, Power Pivot and DAX, Power Query, Power BI, and Excel Dashboards.

Subscribe to Our Newsletter

Receive weekly tutorials on Excel, Power Query, Power Pivot, Power BI and More.

We respect your email privacy

Guides and Resources

  • Excel Keyboard Shortcuts
  • Excel Functions
  • Excel Formulas
  • Excel Custom Number Formatting
  • ALT Codes
  • Pivot Tables
  • VLOOKUP
  • VBA
  • Excel Userforms
  • Free Downloads

239 Excel Keyboard Shortcuts

Download Free PDF

Free Webinars

Excel Dashboards Webinar

Watch our free webinars and learn to create Interactive Dashboard Reports in Excel or Power BI

Click Here to Watch Now

Blog Categories

  • Excel
  • Excel Charts
  • Excel Dashboard
  • Excel Formulas
  • Excel PivotTables
  • Excel Shortcuts
  • Excel VBA
  • General Tips
  • Online Training
  • Outlook
  • Power Apps
  • Power Automate
  • Power BI
  • Power Pivot
  • Power Query
trustpilot excellent rating
 

Company

  • About My Online Training Hub
  • Disclosure Statement
  • Frequently Asked Questions
  • Guarantee
  • Privacy Policy
  • Terms & Conditions
  • Testimonials
  • Become an Affiliate

Support

  • Contact
  • Forum
  • Helpdesk – For Technical Issues

Copyright © 2023 · My Online Training Hub · All Rights Reserved

Microsoft and the Microsoft Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries. Product names, logos, brands, and other trademarks featured or referred to within this website are the property of their respective trademark holders.