Get 20% OFF Napkin with the discount code KEN20: https://www.napkin.ai/ Make an employee work shift schedule in Excel step by step. ๐ DOWNLOAD Free Excel file for this video: https://careerprinciples.myflodesk.com/d20f1589u5 In this video, you'll learn how to make an automated employee work schedule in Excel. First, we'll set up the structure, including adding the dates with SEQUENCE and EOMONTH, the titles, and the employee names and details of each shift. Second, we'll add all of the shift details for each employee with data validation. We will also add conditional formatting so each shift can be differentiated. Thirdly, we'll create some checks including the number of shifts per day and making sure all of the shifts are covered in a day. To do this, we'll use the COUNTA and COUNTIF functions. Fourth, we'll create a totals report, where we can see which shifts each employee is working and their total number of shifts per month. For this, we'll use the COUNTIF function and some data bars. Finally, we'll show you how to extend this schedule to other months of the year. LEARN: ๐ Excel for Business & Finance Course: https://www.careerprinciples.com/courses/excel-for-business-finance ๐ The Complete Finance & Valuation Course: https://www.careerprinciples.com/courses/finance-valuation-course ๐ฅ Power BI for Business Analytics: https://www.careerprinciples.com/courses/power-bi-for-business-analytics ๐ All our courses: https://www.careerprinciples.com/all-courses SOFTWARE: ๐ Ever wish Google Sheets had Excel features like Shortcuts, Trace Precedents, or What-If Analysis? SheetWhiz brings them straight into Google Sheets. Sign up for free or get 30% OFF the Pro plan with code KENJI30: https://www.sheetwhiz.com/pricing?utm_source=youtube&utm_id=kenji โฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌ Chapters: 0:00โ -โ Intro 0:35โ - Setting up the Structure 4:46โ - Adding the Schedule 8:45โ - Employee Checks 11:30โ - Totals Report 14:41โ - Tracking Today and Extending to
Original Description
Get 20% OFF Napkin with the discount code KEN20: https://www.napkin.ai/
Make an employee work shift schedule in Excel step by step.
๐ DOWNLOAD Free Excel file for this video: https://careerprinciples.myflodesk.com/d20f1589u5
In this video, you'll learn how to make an automated employee work schedule in Excel. First, we'll set up the structure, including adding the dates with SEQUENCE and EOMONTH, the titles, and the employee names and details of each shift. Second, we'll add all of the shift details for each employee with data validation. We will also add conditional formatting so each shift can be differentiated. Thirdly, we'll create some checks including the number of shifts per day and making sure all of the shifts are covered in a day. To do this, we'll use the COUNTA and COUNTIF functions. Fourth, we'll create a totals report, where we can see which shifts each employee is working and their total number of shifts per month. For this, we'll use the COUNTIF function and some data bars. Finally, we'll show you how to extend this schedule to other months of the year.
LEARN:
๐ Excel for Business & Finance Course: https://www.careerprinciples.com/courses/excel-for-business-finance
๐ The Complete Finance & Valuation Course: https://www.careerprinciples.com/courses/finance-valuation-course
๐ฅ Power BI for Business Analytics: https://www.careerprinciples.com/courses/power-bi-for-business-analytics
๐ All our courses: https://www.careerprinciples.com/all-courses
SOFTWARE:
๐ Ever wish Google Sheets had Excel features like Shortcuts, Trace Precedents, or What-If Analysis? SheetWhiz brings them straight into Google Sheets. Sign up for free or get 30% OFF the Pro plan with code KENJI30: https://www.sheetwhiz.com/pricing?utm_source=youtube&utm_id=kenji
โฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌ
Chapters:
0:00โ -โ Intro
0:35โ - Setting up the Structure
4:46โ - Adding the Schedule
8:45โ - Employee Checks
11:30โ - Totals Report
14:41โ - Tracking Today and Extending to
DeepCamp AI