This course includes:

• Recording and Running Macros
• Recording formatting macros
• Recording Relative Macros
• Assigning macros to toolbars and menu bars
• Creating Interactive macros
• Building macros in parts
• Introduction to the Visual Basic Editor
• Creating your own Functions and AddIns
• Using Excel Objects on forms and worksheets
• Using If statements, Select Case Statements and Loops in VBA
• Using named ranges in VBA
• Creating excel templates with macros and objects
• Automating SumIf, CountIf and nested If statements
• Creating a digital signature for macros
• Workshop using your companies Excel spreadsheets

Contact datasort and we will email you a more detailed course outline and answer any queries you may have. All enquiries are welcome without obligation.