Vacation and Attendance Tracker Dashboard in Excel
4.3 (2 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
66 students enrolled

Vacation and Attendance Tracker Dashboard in Excel

Become an Excel Dashboard Expert
4.3 (2 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
66 students enrolled
Created by ind zara
Last updated 12/2018
English
English [Auto]
Price: $24.99
30-Day Money-Back Guarantee
This course includes
  • 4.5 hours on-demand video
  • 2 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • Building an Excel Dashboard to track Vacation and Attendance
  • Step by Step Guide to create a visually appealing and functionally effective Dashboard
  • Learn the true power of Excel formulas and conditional formatting to deliver simple & effective Dashboards
  • Learn several useful Excel features, tips and tricks that will be handy to build other Excel templates
  • You will be on your way to become an Excel Dashboard Expert
  • Download the fully developed Dashboard Template to follow along
  • 100+ Page eBook in PDF with color screenshots and step by step instructions
Requirements
  • Microsoft Excel Software
  • Beginner level knowledge of Microsoft Excel
Description

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.

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.


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


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.

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/chapters 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 support@indzara.com

Who this course is for:
  • Microsoft Excel Analysts who would like to enhance their skills to build Dashboard
Course content
Expand all 32 lectures 04:19:19
+ Setting up Inputs
5 lectures 37:01
Company Holidays
04:38
Employee Data
06:10
Employee Vacation Data
11:43
+ Building Team Dashboard
14 lectures 02:00:17
User Inputs
04:03
Employee List
09:38
Dates of Month
09:39
Calendar Data - Named Ranges
06:12
Calendar Data
22:39
Conditional Formatting
07:49
Conditional Formatting - Vacation Types
05:57
How to Copy and Paste Data
03:16
Monthly Summary - Headers
05:00
Monthly Summary - Monthly Totals
09:13
Monthly Summary - Work Days
03:28
10-Point Formatting Checklist - Part 1
14:33
10-Point Formatting Checklist - Part 2
16:18
+ Building Employee Report
9 lectures 01:08:51
User Inputs
04:40
Months and Dates
05:39
Start and End Dates
05:51
Calendar Data - Formula
20:19
Conditional Formatting
06:58
Monthly Summary
06:39
Annual Summary
02:20
10-Point Formatting Checklist
14:51