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 » Offset function

	98.1 % recommend us
	More live stats...

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

Training information:

Offset function

Resolved · Medium Priority · Version 2007

Reply Fri 1 Oct 2010, 16:48Delegate Emeraba said...

Emeraba has attended:
Excel Intermediate course
Excel Advanced course

Offset function

Could you give me examples of how to use the offset function

For upcoming training course dates see: Pricing & availability

Reply Tue 5 Oct 2010, 23:07Trainer Newson said...

RE: Offset function

Hi Eme

Here is an article from Microsoft describing the use of the Offset function

http://support.microsoft.com/kb/324991

I hope that helps. Any further queries please do not hesitate to contact me.

Thanks

Newson

Reply Tue 5 Oct 2010, 23:07Trainer Newson said...

Will be marked as resolved in 5 days

Notice: This is an automated message. Due to inactivity, this forum post will be marked as 'resolved' if there are no further responses in the next 5 days.

Tue 12 Oct 2010: Automatically marked as resolved.

Excel articles

· Finding Your Way Around Excel 2007
· Microsoft Excel Training Course
· So Why Are There So Many File Types In Excel 2007?
· How To Create Formulas In Excel
· Tips for Transitioning to Excel 2007

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

Excel tip:

Make macros work in newer versions of Excel

If you have created macros in Excel 97 or 2000 that you want to be able to use in 2002/XP or 2003, you may need to alter the macro security settings in the newer version of Excel you are using.

To do this, go to Tools - Options - Security.

Select Macro Security and change the security setting to Low.

Tick the boxes next to 'Trust Add-ins' and 'Trust Visual Basic' and click OK.

After you have restarted Windows, you should then be able to use your macros created in earlier versions of Excel.

View all Excel hints and tips