microsoft excel training day courses near kent - macros
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 » microsoft excel training day courses near kent - Macros

microsoft excel training day courses near kent - Macros

resolvedResolved · Low Priority · Version Standard

replyReply Wed 14 Nov 2007, 15:56Delegate Katie said...

Katie has attended:
Excel Advanced course

Macros

I would appreciate some suggestions of uses for Macros in sales spreadsheets.

For upcoming training course dates see: Pricing & availability

replyReply Mon 19 Nov 2007, 10:34Trainer Pete said...

RE: Macros

Hi Katie, thank you for your post. In answer to your question, a macro is a recording of keystrokes and mouse clicks, any task that you wish to duplicate can be recorded as a macro. This means any repetitive task that you undertake on your spreadsheet will be recorded and replayed when you run the macro. Perhaps a calculaltion that involves the same cells and the same formula is one example, or if you wish to undertake a formatting task which is a common repetitive task, record your macro and run it whenever you need. If you record a macro and save it in the Personal Macro Workbook it will be available in every worksheet that you open. I hope that helps, regards Pete.



 

Excel tip:

The Easiest Way to See a Sum or Average in Excel 2010

Did you know the quickest and most simple way of working out the average or sum of a set of numbers?

Highlight numbers in cells or type some numbers in cells and then look at the status bar at the bottom of the window. Here you will see a display of the average of the numbers, as well as a count of the cells and the sum of these cells.

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