Hello!
I recently was promoted at my job and am now in charge of scheduling our employee's shifts on a weekly basis. Rather than having a program for it, they still do it paper and pen style. This is slightly problematic, considering our employee base is rather large, has people who are cross-trained in all sorts of different positions, and often has a lot of specific days requested off, making scheduling a micro-managing nightmare. I was struggling with it until I remembered how useful Excel is with handling a lot of data and posing If-Then queries, and thought I might give it a shot.
So MrExcel, I humbly come to you asking for help in this venture. I'm moderately savvy with Excel (I've handled large databases and have some computational experience between the Business and Economics classes I took in college), but was hoping for some guidance in the best way to approach this problem. Anything would be appreciated, really.
Much thanks in advance,
Gretto
I recently was promoted at my job and am now in charge of scheduling our employee's shifts on a weekly basis. Rather than having a program for it, they still do it paper and pen style. This is slightly problematic, considering our employee base is rather large, has people who are cross-trained in all sorts of different positions, and often has a lot of specific days requested off, making scheduling a micro-managing nightmare. I was struggling with it until I remembered how useful Excel is with handling a lot of data and posing If-Then queries, and thought I might give it a shot.
So MrExcel, I humbly come to you asking for help in this venture. I'm moderately savvy with Excel (I've handled large databases and have some computational experience between the Business and Economics classes I took in college), but was hoping for some guidance in the best way to approach this problem. Anything would be appreciated, really.
Much thanks in advance,
Gretto
