Use an Excel Template to Create 52 Weeks of Employee Time Cards

Опубликовано: 14 Декабрь 2011
на канале: Danny Rocks

42,864

This is the 2nd episode in my series of tutorials for creating 52 weeks of employee Time Cards.

I recommend that you begin by finding and downloading a Template for Time Cards. Next, working with a copy of the Template, examine it to understand the Formulas, Formatting and Protection used.

One way to customize the Template is to use Data Validation to create a drop-down list for the names of the employees and the starting date for each week in the year.

Finally, recalling one of the techniques that I demonstrated in Episode #1, I show you how to quickly replicate (make exact copies) of the template for the 52 weeks in the year.

I invite you to visit my online shopping website - http://shop.thecompanyrocks.com - to preview the many resources that I offer.

Danny Rocks
The Company Rocks

Смотрите видео Use an Excel Template to Create 52 Weeks of Employee Time Cards онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь Danny Rocks 14 Декабрь 2011, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 42,864 раз и оно понравилось 83 людям.