Blogging Tips

How To Create A Calendar Template Using Excel

I have finally figured out how to make a professional looking calendar using Excel. And I couldn’t wait to show it to you guys. So read on and watch the video for an easy tutorial! 

 

This is a tutorial of how to create a calendar template using excel. It includes a video that walks you thru the process plus a checklist that you can print out to use that has the exact steps that I take you thru in the tutorial. I am so glad that I figured this out and now I can print my own calendars out. Design them how "I " want to. And use them for home, work, or whatever I need it for. Come on over to watch the video & grab your checklist!

I have to add this in here for legal purposes: (*This post contains affiliate links. If you click thru the link AND make a purchase, I may receive a commission. You will never pay more for a product by using the links. But you will be helping out by supporting this blog & its efforts! So Thank you!!* )

Hey guys! And thanks for stopping by the blog. If you don’t know who I am, my name is Amy & I am the blogger behind I Heart LOA. Where we talk about all things Law of Attraction, Manifesting & Personal Development. And from time to time, I do post tutorials on how I do things behind the scenes on my blog. And that is what today’s post is all about.

Picture of the blogger of I Heart LOA Amy Morton

Today’s Post Is How To Create A Calendar Template Using Excel

I am so glad that I finally figured out how to make my calendars for my binders/planners using Excel. I have been trying to figure this out for a while now. lol.  I am by no means an expert on how to do this. But I did figure it out using a website that I found that explained it easy enough for me to understand.  I will be linking that site in this post so that you can visit it and/or bookmark it for your own use too down below.

Instead of me sitting here typing out exactly how I did it. I am just going to post a video tutorial of exactly how I did it down below. I hope you enjoy it and I hope I explained it good enough for you to understand. I can’t wait to make all 12 months.

Another thing that you can do once you make your calendar template is to take it over to Canva or PicMonkey  and use their features to make it as pretty as you want to. That is what I am doing with mine. Ok, guys here is the video. If you have any questions or comments just leave them down below in the comment section. And I will try to answer them for you.

Tutorial: How To Create A Calendar Template Using Excel

This is me explaining how I create my calendar templates using Excel. I learned how to do this from another blogger. And he has a really great site. I linked his info down below this video.Update: I just created a checklist for you to go by as you watch this video. I really think it will help. It is 5 pages. But you can print it out or save it on your computer so it will make it easier for you to understand.

Make Sure You Download Your Checklists & Print Out.

Remember to download your checklist as this will definitely make it easier for you. I hope you get some use out of them. You can find it below.



After you watch the video, if you would like to bookmark the site that helped me, you can find it at Make Use Of. It is an awesome site and I am so grateful that I found it. Because now I can make my planners/binders even that more awesome looking!

Here is the link to make your pdf into a png file (PDF 2 PNG) so that you can edit it with Canva or PicMonkey. You can add colorful designs, change the fonts for the months & days, etc to make your calendar pop by using a photo editor. There are so many things that you can do to make your calendar look amazing! And the way you want it to look. 🤩 Have fun with it!

*Here’s A Pic Of One That I Made After Editing It On Canva

Creating calendar pages in Excel. There are just some examples to give you an idea of what you can do.

And another one

Creating calendar pages in Excel. There are just some examples to give you an idea of what you can do.

I am working on a Binder/Planner package.

It’s called (for now) Home/Biz Management Binder (Self-Care Edition) and it has sections in the Binder. It’s going to be a very pretty & detailed binder that will help you get your home life & business (if you have one) in order. And help you stay on top of your self-care. Also, there are motivational quotes pictures that you can either leave in your binder or print out & place in a frame. They are so cute if I do say so myself. The sections that I have are:

  • Self-Care
  • Home
  • Biz

The self-care section has pages for you to check off:

  • Morning Self-Care Routine (gratitudes, journaling, prayer, etc)
  • Morning affirmations
  • Evening Self-Care Routine
  • Gratitudes For The Day
  • etc

The Home Section will have pages:

  • monthly calendar pages
  • weekly pages
  • daily pages
  • to do lists (these are broken down into have to do, need to do, want to do)
  • cleaning schedule
  • personal goals

The Biz Section will have pages:

  • vision
  • your “why” with prompts
  • Top 3 goals & why are these your goals
  • etc (still a work in progress as I am trying to make this the best planner ever to help you in all areas of your life)

Here’s a Sneak Peek Into What It Looks Like So Far.

And I did this using Canva and am doing the monthly calendars using Excel.

This is a sneak peek into the binder series that I am creating. It is the self-care edition. This has sections for your self-care, home/biz management. It is a printable package that you can use every day to help you stay focused on what you really want to do in your life/biz. Why self-care? Because when you get in touch with your inner most being and allow your intuition to lead your life, your life will get into "flow" and alignment. Click the link to learn more about this planner package that is coming soon!

This is a sneak peek into the binder series that I am creating. It is the self-care edition. This has sections for your self-care, home/biz management. It is a printable package that you can use every day to help you stay focused on what you really want to do in your life/biz. Why self-care? Because when you get in touch with your inner most being and allow your intuition to lead your life, your life will get into "flow" and alignment. Click the link to learn more about this planner package that is coming soon!

This is a motivational quotes image that is included in the Home/Biz Management Binder Self-Care Edition that is coming soon! Be on the lookout for it!

This is a sneak peek into the binder series that I am creating. It is the self-care edition. This has sections for your self-care, home/biz management. It is a printable package that you can use every day to help you stay focused on what you really want to do in your life/biz. Why self-care? Because when you get in touch with your inner most being and allow your intuition to lead your life, your life will get into "flow" and alignment. Click the link to learn more about this planner package that is coming soon!

This is a motivational quotes image that is included in the Home/Biz Management Binder Self-Care Edition that is coming soon! Be on the lookout for it!

 

This is a sneak peek into the binder series that I am creating. It is the self-care edition. This has sections for your self-care, home/biz management. It is a printable package that you can use every day to help you stay focused on what you really want to do in your life/biz. Why self-care? Because when you get in touch with your inner most being and allow your intuition to lead your life, your life will get into "flow" and alignment. Click the link to learn more about this planner package that is coming soon!

To see more sneak peek’s into the binder package, you can find them on my facebook page at I Heart LOA

I get all of my graphics from Creative Fabrica. They have so many awesome graphics, fonts, you name it over there on their site. It’s a great place to get some beautiful graphics for your next project. And you do get a commercial license so that when you make your next project you can use the graphics however you like. You just can’t sell the files. To grab some cool freebies or really good discounts, go check them out Creative Fabrica.

You Get The Idea 😉

I am brainstorming right now to make this the best planner/binder that will be useful to you. Especially with your self-care because I think that is the most important part. When you take care of yourself on the inside and feed your spirit, it allows you to get in touch with your intuition & your higher self. And when you are showing up as your higher self in all aspects of your life, you can’t help but flourish!

So thank you for reading this post.

I hope it was helpful to you. And I can’t wait to continue to create things that are of use to you and add value to your life.

When I think back on all the blogs that I have read over the years and all the value & knowledge that they have added to my life, it’s amazing.

Because I know if I had not had this information I wouldn’t be where I am today. Because of the internet, we have the chance to open our minds up and to really get our hands on useful information that can enhance our lives. I for one love being online and learning. That’s what growth is all about. Learning and implementing the information that you learn into your daily life.

Thank You So Much For Reading The Blog

And I hope you will come back. If this information was of use to you, please consider sharing it out. I would really appreciate it.

If you have any questions/comments about the tutorial or anything, just leave them in the comment section. Or just let me know that you stopped by. Say hi! I love to see who is actually on the other side of this screen.

For more blog posts that have to do with blogging, check out some of these.

How To Make Easy Printables For Your Blog Using Canva

How To Make Your Blog Images Pop By Using Beautiful Stock Photos

How I Use PowerPoint To Make Videos For My Blog

And to read some inspiring & motivating articles on Law of Attraction or Manifesting, you should check out these:

5 Reasons Your Manifestation Hasn’t Shown Up Yet

How To Use Scripting To Manifest What You Want

How Learning About The Law Of Attraction Has Changed My Life

3 Easy Ways To Make Gratitude An Awesome Habit

Till next time,

xoxo

~Amy

 

 

You may also like...

Leave a Reply

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

This site uses Akismet to reduce spam. Learn how your comment data is processed.