excel training onsite - 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 » excel training onsite - Macros

excel training onsite - Macros

resolvedResolved · Low Priority · Version Standard

replyReply Thu 20 Sep 2007, 16:32Delegate Bevan said...

Bevan has attended:
Excel Intermediate course
Excel Advanced course

Macros

Create a Macro

For upcoming training course dates see: Pricing & availability

replyReply Fri 21 Sep 2007, 16:01Delegate Paul said...

RE: Macros

Tools > Macro > Record New Macro

It's literally a recorder that memorises what you do before you stop recording.

such as creating a macro to put borders round cells

 

Excel tip:

Calculate age or service

The DATEDIF() function in Excel calculates the number of days, months, or years between two dates. So, this function makes it easy to calculate a person's age. To try this tip:

In a blank worksheet, type the birth date in cell A1, using slashes to separate day, month, and year.
In cell A2, type =DATEDIF(A1,TODAY(),"y") and press ENTER.

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