Excel Macros - How to Create and Use them

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.

Tom Fragale
Instructor:
Tom Fragale
Date:
Thursday, March 21, 2019
Time:
09:00 AM PDT | 12:00 PM EDT
Duration:
60 Minutes

More Trainings by this Expert   Product Id : 502416

Price Details
$150 Live
$290 Corporate Live
$190 Recorded
$390 Corporate Recorded
Combo Offers
Live + Recorded
$289 $340 Live + Recorded
Corporate (Live + Recorded)
$599 $680 Corporate
(Live + Recorded)
Price Detail Options
Overview:

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
  • Visual Basic
  • Quick View
  • Comments and Commands
  • Editing Code
  • Viewing Code as You Record a Macro
  • Using the Step Method to Test a Macro Slowly

Who Will Benefit:
  • 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
  • Administrators
  • Salespeople
  • Trainers
  • Bankers
  • Office workers


Speaker Profile
Tom Fragale is a computer professional with over 30 years of professional experience. He is a Microsoft Certified Trainer, and a Microsoft Certified Expert in Excel. He has trained over 30,000 business people in on-line webinars, public seminars, and on-site training. His clients include many Fortune 500 companies, government agencies, military bases, and companies large and small across many industries, including manufacturing, banking, pharmaceutical, education, retail, etc. He started his career as a database application programmer and has served as a consultant and project manager on many successful projects. His topics of expertise include: Access, Excel, Word, PowerPoint, Outlook, Crystal Reports, SQL Server, Visio, QuickBooks, and SharePoint, among others. His passion is training people and helping people get the most out of their computers, and he is a published author having written a book on Microsoft Access. He graduated in 1988 from LaSalle University in Philadelphia, PA with a BA in Computer Science.




Your Recently Viewed Webinars

Payment Methods

Contact Us

NetZealous LLC,
161 Mission Falls Lane, Suite 216,
Fremont, CA 94539, USA.

Information

  Refund Policy
  +1-800-447-9407
  Fax: 302 288 6884
  support@compliance4All.com