excel course - excel timesheet
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel course - Excel Timesheet

excel course - Excel Timesheet

resolvedResolved · Low Priority · Version Standard

replyReply Mon 25 Jun 2007, 12:44Delegate Jassiara said...

Jassiara has attended:
Excel Intermediate course

Excel Timesheet

I'm producing a master timesheet with around 50 architectural projects and I would like to know how is possible to add new projects at anytime in the master timesheet and have all the staff timesheets automatically changed.

Many thanks,

Jass Emmins

For upcoming training course dates see: Pricing & availability

replyReply Tue 26 Jun 2007, 12:57Trainer Tracy said...

RE: Excel Timesheet

Hi Jassiara,

Thank you for the question. What you could do is link the spreadsheets together so that when you change the source data the destination sheet will update. Remember though you need to press save for the system to work out the sheet has changed, it doesn't do it in real time or "as you type".

So to create links simply click into the destination cell (where you what the number to end up) and press = then navigate back to the worksheet containing source information. This links the two worksheets together and can give you a summary sheet of information in your destination sheet.

Hope this helps, let me know

Tracy

replyReply Tue 26 Jun 2007, 15:10Delegate Jassiara said...

RE: Excel Timesheet

Thanks a million!!!! It will help a lot in the future.

Regards,


Jass Emmins

 

Excel tip:

Remove unused toolbar buttons

Are there buttons on your Excel toolbars that you never use? Remove them from the toolbar by doing the following:

1. Go to Tools - Customise - Commands.
2. Select the toolbar button you wish to remove, then use your mouse to drag and drop the button into the Excel window. When you release your finger from the mouse, the button will disappear.

View all Excel hints and tips


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard