Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

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

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Practice Auditing

Resolved · Low Priority · Version 2003

Reply Thu 6 Jan 2011, 16:02Delegate Peter said...

Peter has attended:
Excel Intermediate course
Excel Advanced course

Practice Auditing

What is practice auditing?

For upcoming training course dates see: Pricing & availability

Reply Fri 7 Jan 2011, 16:43Trainer Rodney said...

RE: Practice Auditing

Hello Peter,

Hope you enjoyed your Microsoft Excel Intermediate course with Best STL.

Thank you for your question regarding practice auditing. I'm not sure what you are referring to. The only reference to auditing in excel is 'Formula Auditing' which can be found in the Tools menu. This was covered in the intermediate level of your training and perhaps you may have some additional questions concerning this aspect.

If I'm barking up the wrong tree please let me know exactly what it is you are looking for and I will get back to you as soon as I can.

I hope this resolves your question. If it has, please mark this question as resolved.

If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?

Have a great day.
Regards,

Rodney
Microsoft Office Specialist Trainer

Excel articles

· Creating Smarter, Customized Invoices for your Small Business with Microsoft Excel
· Plug Into The Big Grid
· Charting Another Dimension With Excel
· Want To Use Excel To Calculate Your Mortgage Repayments?
· Formulas In Excel: The Very Basics

Please browse our web site to find out more about
excel consulting and other Microsoft training courses.

Excel tip:

Quickly copy a formula across sheets

Suppose you have a formula in cell Sheet1!B2, say =A1*5%, that you wish to copy to cell B2 on Sheet2, Sheet3 and Sheet4. Instead of using copy and paste, try this: (1) Select Sheet1!B2. (2) Group Sheet1 with the worksheets Sheet2, Sheet3 and Sheet4 by holding down Ctrl and clicking on the tabs of the sheets to group them. (3) Press the F2 key, then immediately press Enter to copy the formula in Sheet1!B2 across the grouped sheets.

Remember to ungroup the sheets afterwards! Right-click on any tab and choose Ungroup Sheets to do that.

View all Excel hints and tips