How to Make a Planner in Excel

Planners enable people to prioritize and organize their days and routines. From weekly calendars, budget planners, to meal plans, it is one of the most versatile documents there is. Sure, store-bought planners are more convenient but creating one using basic Microsoft Office applications is free and relatively easy to do- especially with the help of a template. So whatever you’re looking for a in a planner, be it simple or detailed, Excel has a collection of predesigned planners that’s sure to meet your needs and preferences. Follow the easy instruction guide below and start customizing a planner now!

How to Make a Planner Using Templates in Microsoft Excel

Templates can make tasks easier and faster to accomplish. The basic and quick guide below will help you customize your own planner with the use of an Excel template.

1. Open the Microsoft Excel application, then select New. Type in ‘planner’ in the search bar.

2. Click on your preferred template and hit Create. The template below is a simple meal planner.

3. Keep the template photo or change it whatever your want. To replace the photo, just select the image and right click. Click Change Picture to upload a photo from your files or an online source.

4. A template may come with different designs in the same document, as seen in the example below. Start by choosing a weekly meal planner design that suits your tastes. Then indicate all your meals for each day of the week. In the template below, the planner consists of breakfast, lunch, dinner, and snacks.

5. After inputting all your data, save the Excel file. If you want to modify or make changes to your plans, simply edit the spreadsheet as needed.

How to Create a Planner for Mac Using Microsoft Excel

Use this easy step-by-step guide to customize your very own planner! The guide applies to most Excel versions including MS Excel for Mac 2011 and MS Excel for Mac 2016.

1. Open Microsoft Excel and click New. Look for ‘planners’ using the search bar. Pick your desired template and click Create.

2. The sample template below is a baby shower party planner. Make sure to input the basic details of the event such as name of the host, the date and time, and location of the baby shower. List down the names of invited guests and their corresponding attendance status under the RSVP column. You can personalize all of these details as needed. Feel free to delete a column too if you don’t need it.

3. Planning an event can be a fun and challenging task. You want to cover as many details as you can. Note down everything you need for your event such as food, drinks, decorations, and other supplies. Once you’ve identified these items, provide the cost of each item.

4. Create a mini task list within your planner. In another column, assign the corresponding date or deadline, and any additional notes for each task.

5. After you’re done editing, save the Excel document; then print it out or share the file with your contacts.

Modern 24 Hours Planner Template

Download

Simple Goal Planner Template

Download

Business Travel Itinerary Planner Template

Download

Simple Budget Planner Layout

Download

Event Planner Quotation Template

Download

Simple Monthly Budget Planner Template

Download

Printable Daily Budget Planner Template

Download

Simple Workout Planner Calendar

Download

Blind Staffing Labor Schedule Planner Template

Download

Sample Hourly Planner Template

Download

Personal Budget Planner Spreadsheet Template

Download

Creative Wedding Planners Invoice Template

Download

Annual Budget Planner Template

Download

Financial Budget Planner Design

Download

More in Blog