![]() |
EXCEL--- HELP!!!!!
I am new to Excel and I have had no training but I am a fast learner. At my
new job, our scheduling system is through Excel. It is such a mess and so many scheduling mistakes are looked over. Does anyone have any advice or hints or anything?? ---- We fill out a master schedule on one page then we fill out the individual schedules on other separate pages. We make many overlap mistakes and even some gaps where something isn't covered. I want to know how to prevent that without buying scheduling software. PLEASE HELP! -- Leslie @ Maxxguard Security Inc. |
EXCEL--- HELP!!!!!
Leslie@MaxxGuard Security wrote:
I am new to Excel and I have had no training but I am a fast learner. At my new job, our scheduling system is through Excel. It is such a mess and so many scheduling mistakes are looked over. Does anyone have any advice or hints or anything?? ---- We fill out a master schedule on one page then we fill out the individual schedules on other separate pages. We make many overlap mistakes and even some gaps where something isn't covered. I want to know how to prevent that without buying scheduling software. PLEASE HELP! Not sure what you're looking for but you might try this link to an Excel template. It may give you some ideas. Watch for line wrap on the URL http://office.microsoft.com/en-us/te...CT101172751033 gls858 |
EXCEL--- HELP!!!!!
Leslie,
I may have a suggestion for you. If you link the master sheet to the individual sheet you can save yourself the time to copy your work over. In order to do this you place an = in the cell on the individual sheet and then scroll back to the master sheet and click in the cell where the information should come from and then click the green check mark in the upper left of the worksheet and the cell in the individual worksheet will now automatically populate from the master reducing your errors and repetive work. Chrisinct "Leslie@MaxxGuard Security" wrote: I am new to Excel and I have had no training but I am a fast learner. At my new job, our scheduling system is through Excel. It is such a mess and so many scheduling mistakes are looked over. Does anyone have any advice or hints or anything?? ---- We fill out a master schedule on one page then we fill out the individual schedules on other separate pages. We make many overlap mistakes and even some gaps where something isn't covered. I want to know how to prevent that without buying scheduling software. PLEASE HELP! -- Leslie @ Maxxguard Security Inc. |
All times are GMT +1. The time now is 06:50 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com