Vacation & Attendance Tracker Dashboard in Microsoft Excel

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
5. Functions: DATE, MONTH, EOMONTH, WEEKDAY, ROW, INDEX, MATCH, IF, COUNTIFS, SUMPRODUCT, IFERROR, OR, SUM
6. 10-Point Formatting Checklist
7. Release Checklist

Skill

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.

Software

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.

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.

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 indzara.com.

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]