For full functionality of this site it is necessary to enable JavaScript. Here are the instructions how to enable JavaScript in your web browser.

Excel Macros and VBA

Tom Fragale is Keynote Speaker at Ijona Skills. He is a computer professional with over 30 years of professional experience. He has extensive experience in consulting and providing custom software solutions. 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........

Read More

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 t........

Why should you attend?

In this training session, you'll learn how to create a stunning, interactive professional-looking dashboard using Excel. This training will provide you with a solid foundation that you can use to build your own dashboards and reports. 

Areas Covered in the Session:

  •  Rationale for Using a Macro ? Why?
  •  Frequent Use of Lengthy Command Sequence
  • Sort/Print/Re-Sort/Print Sequence
  •  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
  •  Using IF Logic in a Macro to Create Different Actions Based on Changing Conditions

Who can Benefit:

  • Business owners 
  • CEO's / CFO's / CTO's
  • Managers of all levels
  • Administrators
  • Sales people
  • Trainers
  • Bankers
  • Anybody who uses Excel on a regular basis, and want to be more efficient and productive

Webinar Id: ISSETF004

Duration: 75 mins

Ratings:

1

2

3

4

5


   

Refund Policy

Webinars of Tom Fragale
Introduction to MS Power BI for Dashboards
Presenter: Tom Fragale

View Anytime
Price: $167
Status: Archived

Excel Dashboard for the Financial Professio...
Presenter: Tom Fragale

View Anytime
Price: $167
Status: Archived

Webinars of Soft Skills
Boost Your Leadership IQ: How to Successful...
Presenter: Mark Hordes

View Anytime
Price: $167
Status: Archived

Zap! You're a manager: getting off on the r...
Presenter: Rebecca Staton-Reinstein

View Anytime
Price: $167
Status: Archived


top
l