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!
SUMMARY:
- For Windows: Click on New, then type Planner in the search bar to browse the available templates. Choose a template and click Create.
- For Mac: Go to New and type in Planner in the search bar. Pick a template and select Create.
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.
Note: If you are looking for more variety, feel free to check out Template.net for more Excel planner templates.
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
Simple Goal Planner Template
Business Travel Itinerary Planner Template
Simple Budget Planner Layout
Event Planner Quotation Template
Simple Monthly Budget Planner Template
Printable Daily Budget Planner Template
Simple Workout Planner Calendar
Blind Staffing Labor Schedule Planner Template
Sample Hourly Planner Template
Personal Budget Planner Spreadsheet Template
Creative Wedding Planners Invoice Template
Annual Budget Planner Template
Financial Budget Planner Design
More in Blog
