excels
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 » Excels

Excels

resolvedResolved · Low Priority · Version 2003

replyReply Mon 2 Jun 2008, 15:59Delegate Sarah said...

Sarah has attended:
Excel Introduction course

Excels

What are marcos?

For upcoming training course dates see: Pricing & availability

replyReply Tue 3 Jun 2008, 17:11Trainer Simon said...

RE: Excels

Hi Sarah,

Thank you for your question.

If you perform a task repeatedly in Microsoft Excel, you can automate the task with a macro. A macro is a series of commands and functions that are stored in a Microsoft Visual Basic module and can be run at anytime.

So you could record a macro that stored the commands to autofit all the columns on every workbook you open or use.

I hope this give you an insight to macros.

Regards

Simon

 

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

Excel tip:

Copying Formulae Quickly

There is a quicker way of copying a formula down a column.

Just point and double click on the black autofill handle in the right hand corner of a cell.

This will work providing you have some data in the column to the left of the column.

Sandy

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