c2
Connect on:
  • Home
  • Course Centre
    • Project Management >
      • Professional Project Management
      • Project Management Essentials
      • Managing Project Requirements
      • Scheduling & Cost Control Project Managers
      • Project Leadership, Management & Communication
      • Risk Management for Project Managers
      • Negotiation Skills for Project Managers
      • Managing Remote Project Teams
      • Project Quality Management
      • Project Procurement Management
      • Earned Value Management
      • Professional Project Management - Best Practice
      • Professional Project Management - Exam Preparation
      • PRINCE2® Foundation & Practitioner
      • PRINCE2® Overview
    • Agile Project Management Courses >
      • Agile Project Management
      • Using Scrum in organistations
      • Certified ScrumMaster
    • Java >
      • Core Java Programming
      • Advanced Java Programming
      • Java Programming & XML
      • Java Networking
      • Java Virtual Machine (JVM)
      • Java & Java EE Open Source Testing Tools
    • Java Enterprise Edition (EE) >
      • Enterprise Java with Hibernate and Spring
      • Developing Java Web Applications
      • Java & Java EE Open Source Testing Tools
      • Spring Framework Development
    • C/C++ Programming >
      • C Programming Techniques
      • C++ Programming Fundamentals
      • C++ for C Programmers
      • Advanced C++ Programming
      • C++ & STL Design Patterns
      • Object Oriented C++ for Real-time Applications
    • Unix/Linux >
      • Linux Fundamentals
      • Linux Administration Essentials
    • Windows Server Courses >
      • Installing and Configuring Windows Server 2012
      • Windows Server 2008 - Server Administration
      • Configuring Windows Server 2008 Active Directory
    • .NET Courses >
      • ASP.NET MVC 4.0
    • Perl Programming Courses >
      • Perl Programming
      • Advanced Perl Programming
    • Python Programming Courses >
      • Python Programming
    • Database Courses >
      • MySQL for Developers
    • CompTIA >
      • CompTIA Network+
    • Scripting >
      • JavaScript - Introduction
      • JavaScript - Advanced
    • Data Analysis & Design >
      • Data Analysis & Design - Introduction
      • Data Analysis & Design with UML
    • Microsoft Office Courses >
      • Microsoft Word - Introduction
      • Microsoft Word - Intermediate
      • Microsoft Word - Advanced
      • Microsoft Access - Introduction
      • Microsoft Access - Intermediate
      • Microsoft Access - Advanced
      • Microsoft Excel - Introduction
      • Microsoft Excel - Intermediate
      • Microsoft Excel - Advanced
      • Microsoft Excel - Dashboards
      • Microsoft Excel - Macros
      • Microsoft Excel - Expert
      • Microsoft PowerPoint - Level 1
      • Microsoft PowerPoint - Level 2
      • Microsoft PowerPoint - Advanced
      • Microsoft Outlook - Introduction
      • Microsoft Outlook - To Manage Your Time Efficiently
      • Microsoft Project - Introduction
      • Microsoft Project - Advanced
      • Microsoft Publisher - Introduction
      • Microsoft Visio - Introduction
    • Solaris >
      • Solaris 10 Administration
  • Testimonials
  • About
  • Contact

Microsoft Excel - Macros

Course Description

This is a Microsoft Excel Macros course.  If you perform a task repeatedly in Microsoft Excel, you can automate the task with a macro. A macro is a series of commands and functions and can be run whenever you need to perform the task. The course introduces delegates to the whole area of macros.  The teaching approach contains a mix of lectures, practical and one-to-one work and varies according to the people attending.  For the most part, candidates are able to work at a pace which best suits them, and emphasis is placed upon quality of learning, rather than quantity.

Course Duration

1 day

Course Objectives

On completion candidates should have progressed their skills to produce and edit interactive Microsoft Excel Macros, create and customise the Excel menu and toolbar options, and understand VBA Modules.

Course Content

RECORDING MACROS
Recording a relative macro
Recording an absolute macro
Creating a Quick Access Toolbar button
Stepping through macro created code

EXPLORING THE VISUAL BASIC EDITOR
Turn On/Off the Explorer
Turn On/Off the Properties Window
The Immediate Window

WORKING WITH MODULES 
About Modules
Moving Around the Module

EDITING A MACRO
Editing a Macro
Adding Commands to a Macro
Adding Comments to a Macro
Running a Macro from the Microsoft Visual Basic Editor

FURTHER MACRO EDITING
Removing Lines from a Macro
Using Comments to Remove Lines

USING WORKSHEET DATA IN A MACRO
Introducing Objects, Properties and Methods
Getting Information from the Active Cell
Using ActiveCell in a Macro
Dealing with Errors (Basic Error Handling)
Getting Information from Other Cells
Using Range in a Macro
  
VARIABLES
Introducing Variables and Variable types
Using a Variable

CONTROLLING THE FLOW OF A MACRO
Inserting a New Module
Running Statements When a Condition is Satisfied
Running Statements When a Condition is Not Satisfied
Using ElseIf to Check Several Conditions
Using Multiple Conditions in a Single Statement
Using Multiple If... Then Statements

INTERACTING WITH MACROS

Displaying a Simple Message Box
The MsgBox Function
Customising a Message Box
Using Message Box Buttons
Using Worksheet Data in a Message Box
The InputBox Function
Using an Input Box in a Macro
Getting User Input

RUNNING MACROS AUTOMATICALLY

Running a Macro When You Open a Workbook
Running a Macro When You Close a Workbook

Who should attend?

Aimed at frequent users who have a working knowledge of Microsoft Excel’s Macro creation and execution, this course provides candidates with practical experience of the topics listed in the course outline.         

Pre-requisites

Those attending should have an understanding of Microsoft Excel macro creation and execution, be competent Microsoft Windows users, and be familiar with the basics of file and disk management.
Powered by Create your own unique website with customizable templates.