Vacation & Attendance Tracker Dashboard in Microsoft Excel

   Watch Promo

In this course, you will learn how to create a visually appealing and functionally effective Dashboard that can be used to track employee or student attendance and vacation.

I will start with a blank Excel workbook and build the various components step by step in the video tutorials. Not even a single step is left out.

There will be no programming/VBA/Macros.

You will learn the true power of Excel formulas and conditional formatting to deliver simple and effective Dashboards in Excel.

By the end of this course, you will learn how to build the Dashboard yourself.

Along the way, you will also learn several useful Excel features, tips and tricks that will be handy for you to build other Excel applications as well.

You will be on your way to become an Excel Dashboard Expert.

Watch how the template is made!

What you will learn about Excel

Apart from learning how to build the Vacation and Attendance tracker, you will learn the following about Excel.

  1. Data Input Techniques - Excel Tables, Drop Down List, Check Box
  2. Named Ranges
  3. Writing Simple and Advanced Formulas (nested functions)
  4. Conditional Formatting using formulas
  6. 10-Point Formatting Checklist
  7. Release Checklist

Requirements for Course


Since I will walk through each step involved, there is no pre-requisite knowledge for this course. However, if you are completely new to Excel, then I would recommend the free Useful Excel for Beginners course first.

If you have used Excel before and written simple formulas, then you should be able to follow this course.


You will need Microsoft Excel installed in your computer, preferably Excel 2013 or later version.

Most of the features used are compatible with Excel Online (free web version of Excel), but when a feature is not compatible, it will be specified along with an alternative technique.

Your Instructor

Dinesh Natarajan Mohan
Dinesh Natarajan Mohan
I, Dinesh Natarajan Mohan, have been working with Microsoft Excel since 2001. I have experience leading Reporting and Analytics teams in different domains such as Finance, Marketing and Operations in the U.S. LinkedIn Profile

From 2013, I have been publishing Excel templates on my website As of writing this, I have published more than 50 Excel templates, both free and premium. The templates have been downloaded and appreciated by users from more than 100+ countries. So far, there have been more than 7000 premium customers and more than 500,000 downloads of the free templates.

I also publish video demos of all my Excel templates in my YouTube Channel which has more than 10,000 subscribers and been viewed more than 2 Million times. I have published more than 235 free videos.

I have spent on average more than 50 hours on each template start to finish, including concept, market research, design, development, testing, documentation and publishing. From the numerous lessons I have learned in the last 6 years of building Excel templates, I have been able to simplify the process of creating templates.

This Vacation Tracker template required several hours of work and many iterations to arrive at a solution that was simple and effective. In this course, you will be able to learn those techniques and build the template in less than 5 hours. I am very excited to share what I know with you.

Introduction to the Course

Course Structure and Organization

The course begins with the Introduction chapter which presents the scope of the template we will build.

In the second chapter, we learn how to set up the inputs for the template.

We learn how to build the Team Dashboard step by step in the third chapter and the Employee Report in the fourth chapter. These chapters are the heart of the course where we will write simple and advanced formulas, apply conditional formatting using formulas and a thorough 10-Point Formatting checklist.

In the fifth chapter, we go through the release checklist that I personally went through before publishing each of my 50+ Excel templates on

The sixth chapter is allocated for Frequently Asked Questions, where I will be adding videos on questions asked by students of this course. If you have questions on any of the video tutorials, post them in the comments for that video. I will be reviewing and answering them. If needed, I will create a new video solution.

You will see below the detailed list of videos that are part of the course. Some of the videos are available for free preview. Please take a look. If you have any questions, please email [email protected]

Course Curriculum

Get started now!


In addition to more than 4 hours of on-demand video tutorials on how to build the Vacation & Attendance Tracker Dashboard, you will also receive the following.

1. Download the fully developed Vacation & Attendance Tracker Dashboard Excel template

2. Download step by step User Guide eBook (PDF) that walks through the tutorials with explanations and screenshots.

Download a free preview of the first 2 chapters

Scope of the Template you will build

Frequently Asked Questions

When does the course start and finish?
The course is available now. It is a completely self-paced online course - you decide when you start and when you finish.
After purchase, how long do I have access to the course?
After enrolling, you will have unlimited access to this course for as long as you like - across any and all devices you own.
What if I am unhappy with the course?
If you are unsatisfied with your purchase, contact us in the first 30 days and we will give you a full refund. No questions asked.
Which version of Excel is required?
You will need Microsoft Excel installed in your computer, preferably Excel 2013 or later version. Most of the features used are compatible with Excel Online (free web version of Excel), but when a feature is not compatible, it will be specified along with an alternative technique.
Where can I get the bonus materials - Template and e-Book?
Once you enroll, you can download them in the first chapter's resources, inside the course.
I have more questions. How can I contact you?
Please email [email protected] and I will reply to you as soon as possible.

Get started now!