excel

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel

Excel

resolvedResolved · Low Priority · Version 2007

Heather has attended:
Excel Intermediate course
Word Intermediate course
Excel Advanced course
Word Advanced course

Excel

please help with a formula to show when our computer equipment needs replacing after 3 years of purchase

RE: excel

Hi Heather. We're happy to help, but we'll need a lot more information first. When you say "needs replacing", what are you measuring? Life span of the hardware components, software licenses, or wear and tear? Do you want to develop a formula to produce a countdown to a specific time based on your current hardware specs or a series of reminders? As you can see, it's thorny subject. Let us know if you want to proceed.

Hope this helps,

Anthony

Wed 29 Apr 2009: Automatically marked as resolved.


 

Excel tip:

New Normal Worksheet

Do you want all your worksheets to confirm to a certain look? Then change the Defaults!!!
1. Press Shift+F11 to create a new worksheet
2. Press Ctrl+A to select (higlight) all cells, Press Ctrl+1, make any formatting changes then click OK.
3. Press F12 (Function 12 key) click in the Save As Type, drop down, then select Template (*.xlt)
4. Click in the Save in drop-down, then find the folder; c:_program files_microsoft office_office_start. (For the underscores shown use backslash)
Name your templete sheet.xlt, then press Enter.
Sheet.xlt is used when you insert a new worksheet (Shift+F11)

Note: These changes are permanent changes on your PC.

View all Excel hints and tips


Server loaded in 0.08 secs.