excel

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

TrustPilot

starstarstarstarstar Excellent

  • Home
  • Courses
  • Promotions
  • Schedule
  • Formats
  • Our Clients

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

Excel

resolvedResolved · Low Priority · Version 2003

Shane has attended:
Excel Introduction course

Excel

What is the purpose of macro's, what are the benfits of using them and when is it needed on an excel file.

RE: Excel

Hi Shane, welcome to the forum, thank you for your post; the writing/editing and using of macros is covered comprehensively in our Excel Advanced and Excel VBA courses.
But to answer your question; a macro is a recording of mouse clicks and/or of keyboard entries which are recorded by Excel and played back (like a tape recording) whenever required, a macro is usually recorded to undertake mundane or repetitive tasks, either simple or complex, which saves continuously resolving the function manually.
I hope this has helped, if so please click the Resolved link, best regards Pete.


 

Excel tip:

Shared Conditional Formatting

In a shared workbook, conditional formats applied before the workbook was shared will continue to work; however you cannot modify the existing conditional formats or apply new ones.

View all Excel hints and tips


Server loaded in 0.08 secs.