Create a Dynamic Countdown in PowerPoint

Create a Dynamic Countdown in PowerPoint

Created: Wednesday, November 22, 2017 posted by at 9:30 am

Kurt Dupont of PresentationPoint explains how you can create a dynamic countdown using PowerPoint and one of his add-ins.

1 Star2 Stars3 Stars4 Stars5 Stars (8 votes, average: 4.00 out of 5)

By Kurt Dupont

Do you have something significant coming up? Is there an important product release, a groundbreaking conference, a huge merger, the opening of a new office, or something else that is happening? Or maybe, you just want to welcome the New Year or some other holiday in style?

What if you could create a dynamic countdown and display it in your office lobby or any other suitable location?

This may be a great idea, but how do you start? Keep reading to learn more.

We are using PresentationPoint’s add-in products for PowerPoint, and Kurt Dupont of PresentationPoint will explain how you can create a countdown for the New Year. Of course, as we said earlier, the New Year is just a date. Change the date to something more eventful in your organization so that you can create a buzz, and make colleagues and co-workers await the big day!

To create your own DIY PowerPoint presentation that counts backward automatically to a happening date is so much easier than you may imagine. We are using the New Year as an example, and don’t be limited by that day. Just set any target date, and follow along. Let us imagine that your date is January 1st, 2018, and we then run your slideshow. The slide will count down the number of days, hours, minutes and seconds.

To make this happen, you will need Microsoft PowerPoint, coupled with our DataPoint add-in for PowerPoint, or our easier Dynamic TIME add-in. You can choose whichever one you want. Both add-ins will allow you to countdown to a given date. If you only need to display a countdown clock, and nothing more, then use our Dynamic TIME add-on. On the other hand, if you want to display more dynamic information like news, weather, announcements, promotions, etc. from various data sources, then use DataPoint. In this article, we will use DataPoint. You will also need Microsoft Access to use as a data source—and if you have Microsoft Office, you probably have Microsoft Access installed too.

Follow these steps to proceed:

  1. This starts with a small Microsoft Access database that you can download here. This database contains a table to store the target date (New Year’s day) and a query to calculate the difference between now and New Year. You can change the date to any other date that you want.
  2. Open the Access database and open the only table in there, called TableTargetDate. Open the table by double-clicking its name. This opens a new window with the current table content or row information. At the column named Target, enter the date for New Year, 1/1/2018, and close the table window again. Again, you can change the date to any other date that you want. This will save the value to the database file.Countdown to New Year set date

Kurt Dupont

Kurt Dupont
Kurt Dupont, based out of Belgium heads PresentationPoint, a company that creates several amazing PowerPoint add-ins. After his Computer Science studies, Kurt started with Andersen Consulting (Accenture nowadays) in Brussels. After three years he moved to the Brussels Airport Terminal Company that runs the Brussels airport – this last placement inspired the start-up of Take-off (now known as PresentationPoint) in 1998.

This post is based on an original post that was published earlier on the PresentationPoint site.

Related Posts

  • Create Digital Menu Boards with PowerPoint
    By Kurt Dupont What is a Digital Menu Board? Digital menu boards are menus displayed on computer monitors or TV screens. These are commonly used in co...
  • Real-Time Data from PowerPoint on Television Screens
    By Kurt Dupont Would you be watching screens and channels for a long time when you assume that they are just showing old content on their digital sign...
  • Dynamic Text in PowerPoint
    By Kurt Dupont Learn about using dynamic text in PowerPoint Today, you will learn a great trick for a PowerPoint presentation. You can make your Power...
  • Weather in PowerPoint
    By Kurt Dupont The question most often asked: What will the weather be today? Weather is omnipresent in our society. You see weather information in yo...

Microsoft and the Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries.

Plagiarism will be detected by Copyscape

© 2000-2022, Geetesh Bajaj - All rights reserved.

since November 02, 2000