Create Digital Menu Boards with PowerPoint

(3 votes, average: 5.00 out of 5)

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 coffee shops and restaurants. They include pictures and prices of menu items. It is easy to update and can be connected to databases to automatically update across all the locations within a few minutes. In this article, we will show the exact steps that are used to create a menu board like the one below, how to add pictures, pricing, and videos and how to connect to a central database.

For more information on the advantages of digital menus, read Amy Nichol Smith’s article on How to Use Digital Menu Boards for Your Restaurant or Grocery.

Create a New Slide show

Open PowerPoint and start with a new blank presentation.
Create a new slide.
Right-click anywhere on the slide, choose Layout and then Blank.

Change the Background

In the Ribbon, select the Design tab.
Click the Format Background icon.
Select Solid Fill or Gradient fill.
Open the Color sub menu and choose a color.
If the user is using Gradient fill, the user will have to choose a color for each of the Gradient stops. Click stop to select it.

Add Digital Menu Boxes

Turn on the grid; hold Shift, press F9. Snap objects to grid:

From the Ribbon, click on View, then in the Show group, click on the small object at the right side of the box.
Put a check beside Snap objects to grid.
Click OK.

Next, place boxes for the menu boards on the grid:

In the Ribbon, select the Insert tab.
Click the Shapes icon, choose a rectangle shape.
Click and drag to place a rectangle.

Place as many rectangles as needed.

Color the Digital Menu Boxes

Once the user has the placeholder shapes for the menu boxes, set the background colors for each of the shapes that the user was created. How to change rectangle colors:

Right-click a rectangle, click Format.
A menu will come up on the right with options.
Choose the color that the user wants.

How to make a rectangle transparent:

Right-click a rectangle then click Format Shape.
In the right menu, look under the Shape Options tab, drag the Transparency slider to 100%.

How to Add Images to Digital Menu Boards

How to insert an image:

In the Ribbon, select the Insert tab, click the Pictures icon.
Find picture, and click Insert.

How to copy an image: While holding Ctrl, click and drag the image. If the user wants to update images and other data in multiple locations, see the menu boards data connection instructions further down.

Adding Text to Digital Menu Boards

How to add a text box:

In the Ribbon, select the Insert tab.
Click the Text Box icon.
Click and drag to place a text box.
Place as many text boxes as needed.

How to change text size and color:

Select the text, right click on the selection.
Use the Font Size and Font Color icons.

How to Add Video to Digital Menu Boards

How to add a video:

In the Ribbon, select the Insert tab.
Click the Video icon. Choose Online Video or Video on My PC.
Hold click the video and drag it to where the user like to place it.

Connecting to a Data Source

Connecting to a data source lets the user edit a data file to change all the menu items to all the locations via the Internet. The user will need the DataPoint PowerPoint add-in to connect the menu board to a database. The user can download this add-in on the PresentationPoint site. Another useful plugin for multiple locations is the digital signage player software, iPoint, also from PresentationPoint.

Create a Data Source

Create the data source. The user data can be sourced from:

Excel spreadsheet,
Microsoft Access database,
XML file,
RSS feed,
Oracle,
MySQL,
and many more

Here is an example of a data source we created for our digital menu – an Excel spreadsheet.

As the user can see, the data spreadsheet just includes the item name, description, and price along with a link to where the picture is we want to use.

To Add a Data Connection

Click on the DataPoint tab of the Ribbon, and then the List button.

Next, Add a Connection

Choose the type of connection, which would be Excel in this case.
Click on the Add Connection button.
Browse to the data file the user created and click OK.

Then, Add a Query

Click on the Add Query button. Now, it will show the data within the spreadsheet.
Tick the box called The first row contains field names, if applicable.
Set how often the user wants the data to refresh on the menu board.

Add Query

Review Data Preview

The data from the spreadsheet should show now. Click OK.

Connecting a Text Box to Data

Click on the text box to connect.
Click on the DataPoint tab of the Ribbon, and then the Text Box button.

Choose Data for Text Box

Choose the Column and Row.
The preview will show what will be added.
Click OK.

The user will see the text box data updated, as shown below.

Connect Menu Board Images to Data Source

The user can connect images for the digital menu boards to the data source, the same way as the connected text box. Once done, the user has digital menu boards that the user can update from a central location just by updating the spreadsheet or other data source.

Kurt Dupont is a solution provider who would go out of his way just to ensure he brings out the best when it comes to issues that have to deal with data-driven presentations, data visualization, and digital signage software.

He started by working at airports worldwide to set up airport databases and flight information screens. This evolved to become the basis for PresentationPoint.

The views and opinions expressed in this blog post or content are those of the authors or the interviewees and do not necessarily reflect the official policy or position of any other agency, organization, employer, or company.

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...
Show Websites in PowerPoint
By Kurt Dupont There are tools available to show websites on PowerPoint slides like LiveWeb and LiveSlides. I’m recommending them often. You can use t...