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

STL - Formerly Best Training Solutions Through Learning
TrustPilot
Excellent
Request Callback We will call you back
0207 987 3777 Call for assistance
Your Basket Basket is empty
microsoft excel courses - macros

Forum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft excel courses - Macros

microsoft excel courses - Macros

ResolvedVersion Standard

Hannah has attended:
Excel Introduction course

Macros

What is a macro?

RE: macros

a macro is a sequence of steps / commands that can be stored and then recalled with a single click or keyboard stroke.

For example, in Excel you may want to create a button that when pressed, will change the margins of a page, add gridlines, and change the Font to bold. By using a Macro you could record this action, and any time you press the button, it would repeat those steps to your active worksheet

I hope that makes sense

Tracy

Excel tip:

Quick Absolute Cell References

When entering cell references in a formula you probably click the cell, or you may type in the cell reference. If you require any of the 4 variations, press the F4 key now before you press Enter to toggle around the relative and absolute entries ($signs).

Note that the F4 key outside of editing a formula is the Repeat key to repeat a previous action.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.