microsoft+excel+training - Auditing a worksheet

Resolved · Low Priority · Version Standard

Auditing a worksheet

Seema has attended:
Excel Intermediate course

by - delegate Seema [1 post] (2007 Sep 13 Thu, 16:53) Reply

How do you open the formula auditing toolbar?

Version	Date	Location	Places available	Book	Next place rate:
Excel VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Dec 4 Thu + 5 Fri	Bloomsbury	3	book now	£475	£495
2007	2008 Dec 11 Thu + 12 Fri	Bayswater	4	book now	£499	£530
2007	2009 Jan 8 Thu + 9 Fri	Bloomsbury	8	book now	£345	£425
2003	2009 Jan 22 Thu + 23 Fri	Southwark	5	book now	£450	£485
2003	2009 Jan 29 Thu + 30 Fri	Bayswater	6	book now	£450	£485
2007	2009 Feb 5 Thu + 6 Fri	Bloomsbury	7	book now	£450	£475
Full Schedule: See all 34 Excel VBA course dates. Bookings currently available until 26th November 2009.

RE: Auditing a worksheet

by - trainer Anthony gold contributer [113 posts] (2007 Sep 25 Tue, 16:18) Reply

Hi Seema. Very simply you select Tools - Toolbars and then make sure Formula Auditing is selected.

Hope this helps,

Anthony

· Reporting and Analysis with Excel
· Excel Advanced Courses Ease the Frustration of Learning Complex Tasks
· Microsoft Excel Courses Teach Advanced Macro Techniques
· Advanced level training: Microsoft Excel and the Web
· Excel Macros for the Non-Programmer

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

Rate this page: