learning excel - how do you work
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 » learning excel - How do you work out formulas for the work books

learning excel - How do you work out formulas for the work books

resolvedResolved · Low Priority · Version Standard

replyReply Thu 24 May 2007, 16:56Delegate Alison said...

Alison has attended:
Excel Intermediate course

How do you work out formulas for the work books

How do you work out the formulas on a work book?

For upcoming training course dates see: Pricing & availability

replyReply Fri 25 May 2007, 12:18Trainer Tracy said...

RE: How do you work out formulas for the work books

Hi Alison,

Thanks for the question

Which formulas do you mean? Maybe I can help you?

Tracy

 

Excel tip:

Adding date and time

Here are two quick ways to add the date and time to your spreadsheet:

1) Type =NOW(), which displays both date and time in the same cell
or
2) Hold Ctrl and type the colon (:) into one cell for the date and the semi-colon(;)into another for the time.

Note that =NOW() updates to the current date/time whenever the spreadsheet recalculates.

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