Don't be afraid of macros - learn how to create and use them. When you find yourself repeating actions in Excel - whether it's a five-step sequence you use when formatting a certain cell type or the 30 steps you use when you sort, filter, and print multiple worksheets once a week, the possibility exists that you can automate these actions in the form of a macro. Thereafter, you can perform these sets of actions with a simple keystroke combination, a button in a worksheet, or by using a button in the Quick Access toolbar.
This topic shows you how to create these macro shortcuts, alerts you to situations ideal for creating macros, and explores the actual code (in the language called Visual Basic) created when you record command sequences. This is not a course in Visual Basic, but you will get a quick look at it and understand its role in creating and using macros.
Creating a macro may ultimately involve programming techniques but most macros are developed by recording the way you use standard Excel commands. This topic will show you how to create macros and give you examples of various macros that handle large amounts of information and interact with multiple files. You will also see how to activate a macro with commands, buttons, keystrokes, or pictures.
Why should you Attend: More and more, your company is asking you to do some things with Excel spreadsheets that has you challenged or even overwhelmed.
Maybe someone else worked on a spreadsheet, and then they moved on, and now you are in charge of that spreadsheet.
That is called inheriting a spreadsheet. That is what it is actually called. But inheriting a spreadsheet is not as fun as inheriting a million dollars.
Maybe there is some macros in the spreadsheet that you need to run, and you don't know how to get to the macros. Maybe you want to make your own macros, but you don't know how. Many times there is nobody else to ask about macros at work. Or maybe your company is asking you to do certain tasks, and you know there must be a way to get those tasks done, but you don't know how to actually do it.
Do you seem to perform the same steps in Excel over and over and again? Does that take a lot of time? Do you sometimes make a mistake with any of the steps? Then this webinar is for you. When you learn how to record a macro, you can automate those repetitious tasks, makes them run faster, and run them with no mistakes every time. This webinar will help you save time, avoid mistakes and make you more productive in Excel by teaching you how to record and use macros.
Areas Covered in the Session:
Length Data Manipulation Need Steps Used to Record a Short Macro
Naming the Macro
Assigning a Keystroke Shortcut
Storing the Macro
Avoiding Pitfalls While Recording
How to Run (Play Back, Execute) a Macro
Keystroke Shortcut; Command
Button in the Quick Access Toolbar
Worksheet Picture or Clipart
Comments and Commands
Viewing Code as You Record a Macro
Using the Step Method to Test a Macro Slowly
- Business Owners
- CEO's / CFO's / CTO's
- Managers of all levels
- Anybody who uses Excel on a Regular Basis, and want to be more Efficient and Productive
- Office Workers
• Business Owners
• CEO's / CFO's / CTO's
• Managers of all levels
• Anybody who uses Excel on a Regular Basis, and want to be more Efficient and Productive
• Office Workers