fbpx
Search
Close this search box.

All articles with 'templates' Tag

How to compare two Excel sheets using VLOOKUP? [FREE Template]

Published on Jul 3, 2024 in Excel Howtos
How to compare two Excel sheets using VLOOKUP? [FREE Template]

You are the boss of ACME Inc. And one day, both of your accounts receivables team members Sara and James come to you with two versions of the customer payment data. How do you compare these two Excel sheets and reconcile the data? In this article, let me explain the step by step process.

Continue »

Loan Amortization Schedule in Excel – FREE Template

Published on Feb 20, 2024 in Financial Modeling, Learn Excel
Loan Amortization Schedule in Excel – FREE Template

Do you want to calculate loan amortization schedule in Excel? We can use PMT & SEQUENCE functions to quickly and efficiently generate the full loan amortization table for any number of years.

Continue »

Beautiful Staff Roster Excel Template [FREE Download]

Published on Feb 6, 2024 in Learn Excel, Templates
Beautiful Staff Roster Excel Template [FREE Download]

Do you want to manage your staff’s allocations, shift schedules and view the results in a 4 week grid fashion (like below)? Then you are going to love my FREE Staff Roster Excel Template. What can you do with this template? Template Compatibility This template is designed to work with modern Excel only. You need […]

Continue »

FREE Calendar & Planner Excel Template for 2024

Published on Jan 7, 2024 in Learn Excel, Templates
FREE Calendar & Planner Excel Template for 2024

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 »

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 »