Our Workshops

Description

One Day Workshop

Excel Macros can be used to automate a complicated series of actions or record commonly used commands.

Simple, powerful, and easy to customize, Excel macros can save you time and increase your productivity. Macros called loops are especially useful for working with ranges of data. Whether you've only heard about macros or already used them in Excel, now's the time to find out more about them.

What are Macros? Where are they kept? Why should I care? Very good questions. Macros in Excel are bits of code stored in the workbook that can automate repetitive tasks and quickly get your data in order. They make life easier, and that's why you should care.

Workshop Outline

Introduction to Macros       

• What are Macros?     
• Why do we Use Macros?       
• Macro limitations      

Recording Macros    

• What is recorded?     
• Prepare for the recording     
• Decide where to store the Macro     
• Perform the recording           
• Stop the Recording    
• Save the Workbook    

Deleting and Managing Macros      

• Running Macro          
• Adjust Macro Settings
• Delete a Macro          

 Assigning Macros      

• Assign a Macro to the Quick Access Toolbar
• Create a Macro Button          
• Edit a Macro Button  
• Delete a button          
• Assign a Macro to a Shape    

Introduction to the VB Editor         

• The VBE Interface      
• Open the VBE 

Introduction to Visual Basic for Applications        

• Structure of a Macro 
• Combining Macros    
• Editing Ranges           

Recording Relative References        

• Determine where macros run           
• Macros that make intelligent selections       

Macro Security         

• Why are Macros dangerous?
• Setting Security Options
• Setting a Secure Location      
• Create Digital Signatures      
• Apply Digital Signatures        

Copying Macros        

• Export and Import Modules   
• Export a Module        
• Import a Module

______________________________________________________________________________________________________________________________________________________________

On-Site Workshops

• All workshops are offered in-house at your offices to a minimum of 5 delegates
• You provide the venue and refreshments, Front Foot supply all the workshop material – including laptops for computer-based training sessions

 Remote Workshops

• All workshops are offered remotely to a minimum of 5 delegates
• Front Foot supply all the electronic workshop material

_______________________________________________________________________________________________________________________________________________________________