fbpx

All articles with 'templates' Tag

FREE Calendar & Planner Excel Template for 2023

Published on Jan 2, 2023 in Learn Excel, Templates
FREE Calendar & Planner Excel Template for 2023

Here is a fabulous New Year gift to you. A free Calendar & Activity planner made entirely in Excel. A fully customizable and flexible calendar for all your planning needs.

Continue »

How to create a fully interactive Project Dashboard with Excel – Tutorial

Published on Jun 10, 2021 in Charts and Graphs, Learn Excel, Project Management
How to create a fully interactive Project Dashboard with Excel – Tutorial

Do you manage projects? You are going to LOVE ? this one. In this in-depth tutorial, learn how to create a fully interactive & dynamic Excel Project Management dashboard. Sample files & video instructions are also provided.

Continue »

How to embed Excel files, calculators on your website? – Step by step instructions

Published on Mar 3, 2021 in Learn Excel, Templates
How to embed Excel files, calculators on your website? – Step by step instructions

Here is an awesome way to enhance your website and impress clients. Embed an Excel calculator on your webpage. Check out below demo and if this is what you want, read on.

Continue »

Project Plan – Gantt Chart with drill-down capability [Templates]

Published on Jul 29, 2020 in Learn Excel, Templates
Project Plan – Gantt Chart with drill-down capability [Templates]

Create a gantt chart with ability to filter by levels. This drill-down gantt chart in Excel is useful for seeing activities by module or team. Read on for full instructions + downloadable template.

Continue »

Free 2020 Calendar Template & Daily Planner

Published on Jan 6, 2020 in Learn Excel, Templates
Free 2020 Calendar Template & Daily Planner

Happy New Year to all our readers. Let’s kick start 2020 with an awesome calendar, daily planner and monthly calendar template. Please visit the post page to download the 2020 Calendar Excel Template.

Continue »

FIFA Worldcup 2018 Excel Tracker – FREE Download

Published on Jun 7, 2018 in Power Query, Templates
FIFA Worldcup 2018 Excel Tracker – FREE Download

FIFA world cup 2018 is around the corner. I love soccer, I love Excel, Let’s marry them. Here is an awesome, free FIFA world cup Excel Tracker to help you follow this year’s games in Russia.

Click here to download the FIFA worldcup 2018 tracker.

What you can do with this FIFA world cup Tracker Excel?

You can use this tracker to,

  • View schedules in your local time for group and knockout stages
  • View summary and detailed points table
  • Refresh live points table. When you refresh, the tracker show updated points based on latest results (You need Excel 2016, Office 365 or older versions of Excel with Power Query)
  • View knockout stage matches as a bracket
  • See timeline of the matches
Continue »

Maths worksheets for your kids – teach addition, subtraction & multiplication with these

Published on Apr 9, 2018 in Templates

Nishanth & Nakshatra, my kids are now 8 years old and learning mathematics at school. Very soon (from this Saturday), they will have 2 weeks of school term break. As a stay at home dad, I shudder at the thought of school holidays. So this time, I have an evil plan. I made maths worksheets for them. Everyday, I will print one and ask them to complete.

If you are a stay at home parent and want to keep your kids busy for a few minutes every day, grab a copy of this and give it a go. Keep in mind that the workbook uses RANDBETWEEN(), so the numbers change every time. If you have multiple kids, print multiple copies. There are no answer sheets, so when you need to check the answers, you too must calculate them by hand.

Continue »

Stay on top of money with this awesome household budget spreadsheet [downloads]

Published on Mar 1, 2018 in Learn Excel, Templates

I believe in frugal living and paying yourself first. One of the simple ways to achieve this is by using a budget. You know how much money you get. Once you can track (or estimate) how much you are spending, it is easy to see how much you are paying your future self and what wiggle room you have. So in the spirit of making you awesome in life, not just Excel, let me share a simple but elegant household budget spreadsheet.
Here is a screenshot of the budget.

Continue »

2018 Calendar, daily planner Excel templates [free downloads]

Published on Jan 3, 2018 in Learn Excel

Here is a New year gift to all our readers – free 2018 Excel Calendar & daily planner Template.

This calendar has,

  • One page full calendar with notes, in 4 different color schemes
  • Daily event planner & tracker
  • 1 Mini calendar
  • Monthly calendar (prints to 12 pages)
  • Works for any year, just change year in Full tab.
Continue »

Road Trip Planner Template [Excel Downloads]

Published on Feb 1, 2017 in Learn Excel
Road Trip Planner Template [Excel Downloads]

We recently went on a road trip around parts of New Zealand’s north island. We have been to Taupo, Rotorua, East Cape and Napier. It took us 2 weeks, we drove more than 2,000 km and spent almost NZ $3,000 on the trip. Of course, being a data nerd, I made a plan of the trip in Excel and that helped us budget for this.

After getting back to home, I thought it would be fun to polish the planner workbook and share it with you all so you too can plan a fabulous road trip. So here we go.

Continue »

Make a quick funnel chart in Excel to track sales performance [video]

Published on Aug 29, 2015 in Charts and Graphs, Learn Excel
Make a quick funnel chart in Excel to track sales performance [video]

Funnel charts are useful to visualize sales & marketing performance. In this brief video, let’s understand how to make a quick funnel chart in Excel.

Read on to learn how to make funnel charts & to download a template for your funnel analysis needs.

Continue »

Monthly Planner Template [downloads]

Published on Aug 28, 2015 in Templates
Monthly Planner Template [downloads]

Here is an awesome planner template to help you manage activities over a month. It is useful for charity drives, activity planning, school schedules, marketing initiatives, project planning etc.

Read on to download a copy of the template & learn how to use it.

Continue »

Use mail merge to create custom letters, invoices, labels and more

Published on Aug 17, 2015 in Excel Howtos
Use mail merge to create custom letters, invoices, labels and more

The idea of mail merge is simple & powerful. Imagine you handle recruitment at a large company. You just hired 300 analysts for the big data division. The next job – generate employment offer letters for each of them. Of course, you don’t want to type these letters one at a time. You have the details of all the 300 offers (name, email, address, offer code, role, benefit package details and date of joining etc.) in a spreadsheet. You also have a template of the offer letter.

Enter mail merge. This powerful feature of MS Word combines (Excel) data with Word document contents to generate all the 300 letters in just few minutes.

Continue »

Export iPhone contacts to Excel using this free template

Published on Dec 2, 2014 in Excel Howtos, Learn Excel, Templates
Export iPhone contacts to Excel using this free template

Recently my iPhone 4 crashed. It is 3.5 years old. And just like any other 3 year old, it started acting weird & crazy one night. The next morning it went silent. It won’t go beyond the Apple logo whenever I start it. Since I couldn’t wait for the phone to start, I took out the SIM card (the phone is unlocked, if you are wondering) and placed it in my old Nokia phone. But alas, none of my contacts are on the SIM. They are in “cloud”.

After a day of answering phone calls from everyone including my mom as “Chandoo here”, I’ve decided to get my contacts back. So I logged in to iCloud to download a backup. And the backup was a .VCF file.

Since I wanted to have all my contact numbers in a spreadsheet, I did what any Excel nerd would do. I built a template that can convert VCF data to Excel worksheet.

Continue »

Download today – Introducing Excel Dashboard Templates from Chandoo.org

Download today – Introducing Excel Dashboard Templates from Chandoo.org

Friends and readers of Chandoo.org, my newest download, Excel Dashboard Templates are available for your consideration. Click here if you are ready to get them. Read on to know more.

What are Excel Dashboard Templates?

As the name suggests, these are ready to use Excel templates for creating awesome, informative, easy to understand & quick dashboards with your data. You just enter your data, set up few calculation options, decide how your dashboard should look & bingo, a beautiful & insightful dashboard will be created for you. These dashboards are optimized to look great, convey key information & prompt correct action.

Who should buy these templates?

Analysts, managers, reporting professionals, business owners & executives. These templates are designed to help anyone preparing Excel based dashboards, scorecards or KPI reports.

Benefits for you

  • Design awesome dashboards in minutes, not months: Don’t waste hours trying to figure out formulas, chart settings and layouts. Instead focus on what your users want, how your business works and use those insights to tell the ‘Excel Dashboard Template’ what you want. Save time and look awesome.
  • Accommodate change elegantly: People change. Businesses change. What your boss wanted last month is no longer what she wants today. So when someone asks you, “hmm, can you show me YTD data instead of last 13 months”, or “Can I see top 10 KPIs instead of all”, you just smile and tap a few clicks and bingo, the new dashboard will be ready. These templates are designed to handle change (data, requirements, design preferences and insights).
  • Beautiful & Informative: These templates are designed with a delicate balance of beauty & insight. Everything is seamlessly designed, perfectly aligned and precisely calculated so that you & your boss can focus on the insights & decisions. Time tested and well honored visualization principles & guidelines are observed thru-out the reports.
  • Built for starters, built for pros: Whether you are just starting with Excel or a seasoned pro, you can find the templates right up your alley. For advanced users, we have many customizations to whet your appetite. Want to build a custom calculation or include another type of sorting, you can do it by tinkering with ‘calculations’ sheet.
Continue »