98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » excel training - Macros
excel training - Macros
Resolved · Low Priority · Version Standard
RE: Macros
Dear Andrew
Thank you for attending Excel Advanced training.
Macros are created when you see yourself repeating similar task day in and day out.
These could be group of actions that you have to carry out for most, if not all of your work books. Or it could be lengthy text that you have to enter in all your workbooks e.g. Company name, Address, etc..
There are few things you have to be aware before you start recording a macro.
Macro records all your actions i.e Mouse clicks and the key strokes. So it is very important that you do not start making mistakes while you are recording a macros!!
It is advisable to get your self familiar with the actions that you intend to record as macros or you could write the actions step by step on a piece of paper.
Remember you can assign a short cut key to the macro or can even attach it to a button on the tool bar.
If you need further help in creating and/or editing Macros please do not hesitate to ask in the forum post!!
it is advisable to cjheck what other delegates have asked in terms of Macros in Excel.
If you believe that macros will help you enormously because you repeat lots of tasks and want to master them along with knowing other great things that you can do with them then please look at our website for the VBA Course which will help you with your job related tasks!!
Hope this helps!
Kindest Regards
Rajeev Rawat
MOS Master Instructor 2000 and 2003
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Quickly hide and unhide rows and columnsUse the keyboard shortcut Ctrl+9 to hide selected rows and Ctrl+0 to hide selected columns. The good thing about this shortcut is that you do not need to select entire rows or columns. For example, select B3:D3 then press Ctrl+0 to hide columns B to D. |