How to make printables in Microsoft Excel (step by step tutorials)
After I created a course on how to make printables in Microsoft Word, people started asking me how to make printables using Microsoft Excel.
If you’re one of those people, I’ve put together a beginners’ course to teach you how to get started making your own printables using Microsoft Excel!
No prior graphic design (or Microsoft Excel) experience is required.
Click here to enrol in the course!
By the end of the course you’ll be able to:
- Create a planner printable in a few minutes
- Create a complete planner from start to finish including daily planner, weekly planner, monthly calendars, to do checklist, important dates page, budget, bill due checklist etc.
- You can create a planner that is exactly to your liking – you get to choose if the week starts on a Sunday or Monday
- How to use a template (which I teach how to make in the ecourse) to create more printables
- Create planner printables at any size you like
- Make budgeting spreadsheets which you can print, or keep saved on your computer
- By the end of this course you’ll have a skill you can use to make your own planners year after year
Tutorials included in the course:
Introduction to Excel
- Handy keyboard shortcuts
- My Favorite Excel tools
- Tips for using Excel (downloadable 6 page guide)
Fonts
- Choosing fonts (and my favorite resources)
- Header & title ideas
Color Tools
- My favorite resources for color inspiration
- How to color match anything
- How to change colors in Excel
Page sizes
- Guide to page sizes
- Changing page sizes in Excel
Checklists
- How to make lines (2 methods)
- How to make checklists in different styles
- Creating a master task list
- 50 types of checklists you could create
Planning
- Horizontal weekly planners
- Categories weekly planners (student planners, family planners)
- Vertical weekly planners
- Vertical hourly weekly planners
- Weekly timeblock planner
- Daily planners
- Monthly calendars – 1 or 2 pages
- Weekly habit trackers
- Monthly habit trackers
- Important dates / annual overview page
Budgeting
- Bill tracker, spending log, income tracker, budget etc.
- How to make graphs in Excel
Bullet Journal
- Dot grid paper
- Graph paper
Using graphics
- How to add graphics to your designs
Printing Printables
- Prepping for printing in Excel
Who this course is for:
- If you need a planner to organize a specific area of your life: college, direct sales, kids, money management, health, medical, cleaning, blog, business, family documents etc.
- Anyone that is frustrated with not being able to find that exact planner they want
- Anyone that wants to learn how to make their own planner printables
- If you want to make budgeting spreadsheets and have Excel do the math for you!
- Bloggers that want to learn how to make their own printables to offer as an opt-in for their readers
