filmov
tv
How to Create a Simple Work Schedule in Excel

Показать описание
In this Excel Tutorial I'm going to show you how to create a professional and automated work schedule in Microsoft Excel!
Whether you're a beginner just starting out or an experienced user looking to streamline your process, this video has something for you.
Stick around until the end for some advanced formatting tricks that will take your schedule to the next level!
⌚ TIMESTAMPS
00:00 INTRODUCTION
00:34 SETTING UP THE CALENDAR
01:12 ADJUSTING COLUMN WIDTH
01:34 ADDING WEEKDAYS
01:55 EMPLOYEE NAMES AND MERGING CELLS
02:56 ADDING BORDERS
03:11 ENTERING WORK HOURS
03:56 AUTOMATING END TIME CALCULATION
04:44 COPYING WORK HOURS
05:01 ADDING DAYS OFF
05:53 FORMATTING FOR CLARITY
07:11 CALCULATING NUMBER OF EMPLOYEES PER DAY
08:13 CALCULATING TOTAL WORK HOURS
🎓 Join 60,000+ professionals in our courses for ONLY $9.99 !!
🎓 BEST-SELLING COURSES
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
🔽 CONNECT WITH ME
🎁 SHARE this video and spread the Excel love.
Or if you’re short of time, please click the 👍
#excel
Whether you're a beginner just starting out or an experienced user looking to streamline your process, this video has something for you.
Stick around until the end for some advanced formatting tricks that will take your schedule to the next level!
⌚ TIMESTAMPS
00:00 INTRODUCTION
00:34 SETTING UP THE CALENDAR
01:12 ADJUSTING COLUMN WIDTH
01:34 ADDING WEEKDAYS
01:55 EMPLOYEE NAMES AND MERGING CELLS
02:56 ADDING BORDERS
03:11 ENTERING WORK HOURS
03:56 AUTOMATING END TIME CALCULATION
04:44 COPYING WORK HOURS
05:01 ADDING DAYS OFF
05:53 FORMATTING FOR CLARITY
07:11 CALCULATING NUMBER OF EMPLOYEES PER DAY
08:13 CALCULATING TOTAL WORK HOURS
🎓 Join 60,000+ professionals in our courses for ONLY $9.99 !!
🎓 BEST-SELLING COURSES
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
🔽 CONNECT WITH ME
🎁 SHARE this video and spread the Excel love.
Or if you’re short of time, please click the 👍
#excel