Instructor Led Macro Training - Training Resources
Macro Training Provider? - Tell us about your Training!
Please select the location nearest to you:
United Kingdom
United Arab Emirates
Canada
South Africa
India
United States
Australia
Singapore
Spain
From Mullan Training
Introduction To MS Access



...Run Reports
- Create Splash Screen
- Use Of The Autoexec Macro & StartUp Command
LOCATIONS
Courses can be delivered at our offices in Belfast city centre (opposite the Europa Hotel) or in your own workplace (where we can provide 8 laptops, projector & flipcharts).
ADDITIONAL INFORMATION
If you would like more information please do not hesitate to contact us.
For a course outline visit
more...
VB Excel


...e program.
COURSE CONTENT
Introduction
What is a Macro
Recording a Macro
Running a Macro
Relative References
Assigning Macros to Buttons and Objects
Assigning a Macro to a Button on a Sheet
Assigning a Macro to a Drawn Object on a Sheet
Assigning a Macro to a Button on a Toolbar
Editing Macros
The Visual Basic Editor
The Project Explorer
The Code Window
more...
From Meirc Training and Consulting
Strategic Finance for Senior Management - Finance and Accounting
...macro finance picture of company goals and objectives.
Enhance their understanding of financial analysis and assess their ability to perform strategic financial analysis.
Learn international finance in this globally structured financial economy.
Become acquainted with Bond, Stock, and Foreign Exchange markets.
Grasp knowledge of investment management as a tool to maximize shareholder
more...
Certified Purchasing Professional - Materials Management




Learn the important organizational role of the purchasing department.
Acquire the proper negotiation techniques with suppliers.
Evaluate the performance of the department at the macro level.
Know when and how to train the purchasing staff.
Decide when to buy or lease based on key purchasing factors.
more...
Certified Purchasing Professional - Dubai




By the end of the program, participants will be able to:
Learn the important organizational role of the purchasing department.
Acquire the proper negotiation techniques with suppliers.
Evaluate the performance of the department at the macro level.
Know when and how to train the purchasing staff.
Decide when to buy or lease based on key purchasing factors.
more...
Certified Purchasing Professional
' This program is designed for Senior buyers, purchasing supervisors, purchasing managers and other material management personnel. This program is worth 25 NASBA CPE?s. Learn the important organizational role of the purchasing department. Acquire the proper negotiation techniques with suppliers. Evaluate the performance of the department at the macro level. Know when and how to train
more...
Certified Purchasing Professional
' This program is designed for Senior buyers, purchasing supervisors, purchasing managers and other material management personnel. This program is worth 25 NASBA CPE?s. Learn the important organizational role of the purchasing department. Acquire the proper negotiation techniques with suppliers. Evaluate the performance of the department at the macro level. Know when and how to train
more...
Certified Purchasing Professional



Objectives:
By the end of the program, participants will be able to:
Learn the important organizational role of the purchasing department.
Conduct accurate supplier analysis.
Evaluate the performance of the department at the macro level.
Know when and how to train the purchasing staff.
Decide when to buy or lease based on key purchasing factors.
Improve the efficiency of buying goods and
more...
From Last Minute Training
Excel 20032007 Macros VBA Level 1 3 Days
Topics include: recording/ running macros, relative mode, macro icons, buttons/ menus, Visual Basic enhancements using objects, properties, methods, events, variables, constants, dialog boxes, "IF" controls, loops & using the editor and Object Browser.
more...
Microsoft Excel 2003 Advanced Available in French and English
Automate repetitive tasks by creating macro-commands. Standardize & accelerate all the page set-up options for your reports. Include complex calculations, your company logo, your signature, or even a professional & attractive format into your worksheets
more...
Microsoft Excel 2007 Level 3 - VBA Macros
Topics included: Building solutions, Macro basics, VBA Programming Basics, VBA User Form Basics, Deployment Basics, Enhancing VBA Code, Handling Errors, Accessing External Data, Excel Automation.
more...
Excel 2003 Macros VBA Level 1 - computer help
...Macros and provides a good introduction to the relationship between macros and Visual Basic.
This course is classroom style instruction: Instructor-led, hands-on training.
Basic Macro Concepts
Macros And Sub Procedures
Limitations Of Recorded Macros
Recording Macros
Relative Referencing
Macro Options
Storing Macros
Editing A Macro
Debugging A Macro
Step Into, Step Over, Step
more...
Microsoft Access 2000 2003 Level 3 Advanced Topics
Upon completion, participants will: Understand macro concepts, create, run, & test Access macros, Create & use switchboard forms, Set Access defaults, apply Startup options, & create & attach command bars and much more.
more...
Excel 2000 - 2003 Advanced Available in French and English synesis
Automate repetitive & mundane tasks by creating macro-commands. Standardize & accelerate all the page set-up options for your reports. Include complex calculations, your company logo, your signature, or even a professional & attractive format.
more...
Microsoft PowerPoint 2007 Level 2- On Track
Objectives:
* Add sounds, ClipArt, and motion clips to a slide
* Edit the properties of a clip
* Select a presentation design template
* Edit a design template
* Create an action button
* Edit the settings of an Action Button
* Create and Edit Hyperlinks
* Integrate PowerPoint with Office 2000
* Create
more...
Excel 2007 Macros VBA Level 1 3 Days
Topics include: recording/ running macros, relative mode, macro icons, buttons/ menus, Visual Basic enhancements using objects, properties, methods, events, variables, constants, dialog boxes, "IF" controls, loops & using the editor and Object Browser.
more...
Microsoft Office Access 2007 Foundation
...-By-Step
Skill Sharpener
Database Tools Ribbon
Macro
Show/ Hide
Analyze
Move Data
Database Tools
Step-By-Step
Skill Sharpener
Case Study
Review Questions
Creating a Database
First Steps
Planning a Database
Creating a Database from a Template
Creating a Blank Database
Using Database Objects
more...
Microsoft PowerPoint XP 2003 Level 2
Objectives
* Add sounds, ClipArt, and motion clips to a slide
* Edit the properties of a clip
* Select a presentation design template
* Edit a design template
* Create an action button
* Edit the settings of an Action Button
* Create and Edit Hyperlinks
* Integrate PowerPoint with Office 2000
* Create
more...
MS Access 2003 VBA Macros
...used to build custom solutions using Microsoft Access VBA Macros
* Become familiar with basic macro techniques for recording, writing, running, and maintaining a macro
* Understand how Visual Basic for Applications is incorporated, used, and modified in Microsoft Access
* Learn how to design and layout a user form and controls to create a customized dialog box to simplify data
more...
MS Excel 2003 VBA Macros

... used to build custom solutions using Microsoft Excel VBA Macros
Become familiar with basic macro techniques for recording, writing, running, and maintaining a macro
Understand how Visual Basic for Applications is incorporated, used, and modified in Microsoft Excel
Learn how to design and layout a user form and controls to create a customized dialog box to simplify data entry
Understand how
more...
Microsoft Access 2003 - Level 3 - English
...s; Form techniques; ActiveX Controls; Indexes; Databases; Macros; Switchboards; Toolbars; Importing to other Office Suite applications such as Excel and Word; and much more. This course will run for one day, from 9:00 am to 4:00 pm, bilingual instructor-led, in which a training manual as well as a certificate of completion will be offered to participants who complete this course.
For more
more...
Excel Macros & VBA Level 3 (3 Days)
Location: Toronto Date: 2008-05-26
List Price: $825 Offered Price: $660.00
Seats Available: 2
This course builds on the topics covered in the second Macros course, and covers further techniques and examples for programming Excel with VBA.
This course is classroom style instruction: Instructor-led, hands-on training.
For more information please call 1-877-313-8881 or copy this link into your
more...
Microsoft PowerPoint 2002/2003 Level 2
Location: Vancouver Date: 2008-05-21
List Price: $199 Offered Price: $159.00
Seats Available: 2
Objectives
* Add sounds, ClipArt, and motion clips to a slide
* Edit the properties of a clip
* Select a presentation design template
* Edit a design template
* Create an action button
* Edit the settings of an Action Button
* Create and
more...
Microsoft Access XP / 2003 Level 3 (1 Day)
Location: Vancouver Date: 2008-04-30
List Price: $279 Offered Price: $223.00
Seats Available: 2
If you have Microsoft Access 2002/2003 Level 2 background information or equivalent experience, and you want to learn more, then you should take this course. In this course, we offer advanced instructions on the applications including on: using autoformat; using the format painter; creating and running
more...
Microsoft Word 2003 Level 3
Location: Vancouver Date: 2008-03-19
List Price: $229 Offered Price: $160.00
Seats Available: 2
In this advanced course of Microsoft Word 2003 participants will learn how to:
* Inserting and Formatting a WordArt Object
* Modifying and Creating a Chart
* Selecting a Chart Type
* Inserting and Excel Worksheet into a Word Document
* Creating a New Form
* Using Text Fields
more...
Microsoft Word 2003 Level 3
Location: Vancouver Date: 2008-02-29
List Price: $229 Offered Price: $160.00
Seats Available: 2
Objectives
* Inserting and Formatting a WordArt Object
* Modifying and Creating a Chart
* Selecting a Chart Type
* Inserting and Excel Worksheet into a Word Document
* Creating a New Form
* Using Text Fields
* Customizing Word s Toolbars
* Recording and Running a
more...
Microsoft Word 2003 Level 3

Location: Vancouver Date: 2008-02-29
List Price: $229 Offered Price: $160.00
Seats Available: 2
Objectives
Inserting and Formatting a WordArt Object
Modifying and Creating a Chart
Selecting a Chart Type
Inserting and Excel Worksheet into a Word Document
Creating a New Form
Using Text Fields
Customizing Word s Toolbars
Recording and Running a Macro
Using Detect and Repair
more...
Microsoft Excel 2003 Level 3

...d a Data Value
Grouping and Ungrouping Data
Section 2 - Macros
Macro Basics
Recording a Macro
Running a Macro
Adding a Macro to a Toolbar
Understanding the Macro Code
Absolute and Relative References
The Personal Macro Workbook
Section 3 - Outlines
Outline Basics
Creating an Outline
Collapsing and Expanding an Outline
Manual Outline
Section 4 - Excel Functions
Function Basics
more...
Microsoft Access 2003 Level 3 (1 Day)

...Formatting Properties
Section 2
Creating and Running a Macro
Editing a Macro
Working with Macro Groups
Assigning a Macro to an Event
Creating Conditional Expressions
Assigning a Macro to a Keystroke Combination
Macro Action Reference
Section 3
Importing Information
Exporting Information
Importing Objects from Another Access Database
Linking Information from an External Source
more...
Microsoft Excel 2003 Level 4 - Bilingual

Location: Ottawa Date: 2008-01-29
List Price: $300 Offered Price: $210.00
Seats Available: 1
Module 0: Working with Data Series
Module 1: Using Advanced Functions
Module 2: Using Scenarios and Goal Seeking
Module 3: Using Data Tables
Module 4: Using Auditing Tools
Module 5: Consolidating Worksheets
Module 6: Solving Problems
Module 7: Working With Views
Module 8: Using Macros
Module 9:
more...
Microsoft Excel 2003 Level 3
... a Data Value
Grouping and Ungrouping Data
Section 2 - Macros
Macro Basics
Recording a Macro
Running a Macro
Adding a Macro to a Toolbar
Understanding the Macro Code
Absolute and Relative References
The Personal Macro Workbook
Section 3 - Outlines
Outline Basics
Creating an Outline
Collapsing and Expanding an Outline
Manual Outline
Section 4 - Excel Functions
Function Basics
more...
From Act Training
Access Level 4
Application Development level one day hands-on instructor led course on Microsoft Access. Topics include: Application Design Concepts, Adding Command Buttons to Guide User Navigation, Automating a Dialog-box Form with a Macro Group, Creating a Switchboard Form, Working with Command Bars Toolbars and Menus, Creating a Splash Screen Form, Using Visual Basic Procedures, Adding Security to an
more...
From Ripple Training
New Roles for HR Practitioners


...edge. Business is operating in an environment affected by macro environmental factors ranging from Technology to Legislation and Globalisation. These factors and many others are causing business to re-evaluate itself, both internally as well as externally. Structures are becoming flatter and decentralisation is taking place as organisations attempt to remain competitive, survive and grow.
more...
From NACE EDUCATION
Linux






...iguration files
* Sendmail configuration with the m4 Macro language
* M4 Macro file
* Debugging Sendmail
Network File System (NFS)
* NFS operation: daemons, portmapper etc.
* Configuring an NFS server
* NFS share options: /etc/ exports
* UID re-mapping
* NFS client operation
* Using the automounter to access NFS mounts
Samba Configuration
more...
From Advanced Concepts
MS FrontPage
... Components and Collaboration, and Microsoft Office 2000: Macro Programming Using Visual Basic for Applications.
Performance-based objectives
Lesson objectives help students become comfortable with the course, and also provide a means to evaluate learning. Upon successful completion of this course, students will be able to:
Apply web site design considerations when creating a web site
more...
MS Access Basic - Advanced
...ing Workgroups, En- & Decrypting Databases and developing Macros
Target Students: Stock Controllers, Database Developers, Human Resource Mangers, Client Liaisons etc.
Prerequisites: MS Access 2000 Basic
Delivery Method: Instructor-led, group-paced, classroom-delivery learning model with structured hands-on activities.
Benefits: Developing a more advanced database with more control
more...
MS Excel Advanced
Course Specification:
Course Length: 1 day/2 evenings
Course Level: Advanced
Software: MS Excel xp/2003/2007 Professional
Course Description:
Excel Advanced concentrates more on the advanced functions available on this application to enhance more efficient and stronger management on calculations and worksheets and workbooks.
Target Students: That already works on Excel and uses Excel on a
more...
From Dunamis Training, LLC
Excel VBA
Have you ever wanted to automate repetitive tasks in Excel? Create a user interface for inputs? Turn your spreadsheet into a powerful application? This course teaches Excel users how to do all these things and more Go to dunamistraining.com and click on the course offerings tab for more information
more...
From Navigator Project Finance
Debt Modelling Masterclass


...
Debt Modelling
* Create a Robust Copy & Paste Macro to solve a circular reference due to Interest on an Average Balance
* Calculating Interest on an Average Balance without a circular reference and without Visual Basic
* Principal Sculpting Algebraic solution of repayment for a constant / target DSCR (without Visual Basic)
* Principal Sculpting - Building a
more...
From Progressive Ventures
One day Seminar on PMBOK Edition Change
M/ S Progressive Ventures is pleased to announce a one day seminar on PMBOK Edition Change. The seminar would have experts talk on the macro level structural changes as well as micro level content changes. This seminar will benefit all Business Managers, Project Managers and certified PMPs.
Course Details:
Course ID : PDC-102
Registrations Fee: 2500 + 12. 36%
No of PDUS: 8pdus
Date: 4th
more...
From NetLearn
Excel 2007 basic - advanced




...: Creating views
D-2: Switching among views
Unit 7: Macros and custom functions
Topic A: Running and recording a macro
A-1: Running a macro
A-2: Recording a macro
A-3: Assigning a macro to a button
Topic B: Working with VBA code
B-1: Observing a VBA code module
B-2: Editing VBA code
Topic C: Creating functions
C-1: Creating a custom function
more...
From Aspect Training
Microsoft Project Advanced
Aspect Traininga s Microsoft Project Advanced course is suitable for those with a sound working knowledge of Project and wish to progress to the most complicated functions and features.
Aspect Traininga s Microsoft Project Advanced course will give you a complete understanding of the higher functions of Project. You will be able to perform the most advanced functions of managing a project and
more...
Microsoft PowerPoint VBA
...youa re not a programmer, you can quickly learn to write macros, automate tasks, and create custom applications for Microsoft PowerPoint with Aspect Training's Microsoft PowerPoint VBA Course.
Youa ll jump right into the basics of recording and running macros with Officea s built-in
Macro Recorder, before quickly moving to the essentials of VBA syntax, using loops and functions, building
more...
From Microcomputing Solutions ltd
Exploring Access 2007
...
a Creating Forms
a Creating Reports
a Queries / Macros / Modules
6 The External Data Tab
a Import / Export
a Collect Data
a SharePoint Lists
7 The Database Tools Tab
a Macro / Visual Basic
a Show/ Hide & Analyse
a Move Data (Split/ Upsize)
a Database Tools
8 Context Tabs
a DataSheet / Table - Design
a Query Tools - Design
a Form Layout Tools a
more...
VBA Programming in Excel Visual Basics
... Microsoft Excel including commands, functions and simple Macros
Duration: 2 days
The topics covered are as follows:
1 Introduction to Macros
a What is a Macro?
a Recording a Macro
a Running a Macro
2 The VBA Editor
a The Visual Basic Editor
a The Project Explorer
a The Code Window
a Procedures
a Comments
3 Variables
a Declaring Variables
a
more...
Microsoft Access Developer Advanced
...g a Menu System
a Designing a Menu Form
a Writing a Macro for the Menu
a Returning to the Menu
a The Startup dialog box
5 Database Utilities
a Compact and Repair
a Database Splitter
a Linked Table Manager
a Converting a Database
6 Security
a What is a Workgroup
a Users and Groups
a Permissions
a Activate the Logon Procedure
7 Queries and Reports
a
more...
Intermediate Microsoft Access
Objectives: This is a second stage course for the spreadsheet program.
Pre Requisites: A basic level understanding of Microsoft Access is recommended.
Duration: 1 day
The topics covered are as follows:
1 Revision
a Topics from the Introduction day
a Revision Exercise
2 More about Datasheets
a Finding Information in a Datasheet
a Replacing Information
a Sorting a
more...
Advanced Microsoft Excel
Objectives: This course will introduce some of the more advanced features of Microsoft Excel.
Pre Requisites: Attendees should have a good working knowledge of Microsoft Excel and be comfortable with arithmetic.
Duration: 2 days
The topics covered are as follows:
1 Data Functions
a Text Functions
a Logical Functions
a HLOOKUP/ VLOOKUP
a Error Functions
2
more...
From Evergreen Team Concepts
ADVANCED MICROSOFT EXCEL For Power Users






...ete understanding of the 4 fundamental building blocks of macro
Learn to smoothly integrate changes from multiple users of a shared workbook
Discover the 9 steps for easily turning a Pivot Table into an HTML file for the Web
See how to set limits and maintain control of data that s input by users without your level of expertise
Who Should Attend
Average Excel users are happy with
more...
Microsoft Excel Tips, Techniques and shortcuts




This one-day workshop, designed for intermediate Excel users who want to enhance their skills, covers all versions of Excel for Windows and Macintosh users.
more...
From Computer Training Source, Inc.
Microsoft Access Advanced
... advanced query techniques; an introduction to functions, macro actions, advanced form techniques including using macros in forms; database security, and advanced report techniques. Our classes are all instructor-led, hands-on learning. Each student has their own computer and is given a student manual with practice files to take home. A free repeat, within six months, is included as well as
more...
From Intellisoft Systems
Advanced Microsoft Excel
...dvanced Excel Lesson 6:
Streamlining Workflow
Create a Macro
Edit a Macro
Apply Conditional Formatting in Excel
Add Data Validation Criteria
Update a Workbook's Properties
Modify Excel's Default Settings
Advanced Excel Lesson 7:
Collaborating with Others
Protect Files
Share a Workbook
Set Revision Tracking
Review Tracked Revisions
Merge Multiple Workbooks
Restrict Document
more...
From 4c-learning Solutions Pvt. Ltd.
Instructional Design Workshop





... Strategies
Broad Types of Instructional Strategies
Macro Instructional Strategies
Micro Instructional Strategies
Additional Instructional Strategies
Content Centric
Learner Centric
Sequencing Strategies
MODULE-7
Standards in e-Learning
Technical
Multimedia
SCORM
AICC
Instructional
SCORM
AICC
Modality
Multimedia
Coherence
Redundancy
more...
From Fisher/unitech
SolidWorks API



...e Windows operating system
Topics:
Lesson 1: Using the Macro Recorder
Lesson 2: The API Object Model
Lesson 3: Setting Systems Options and Document Properties
Lesson 4: Automating Part Design
Lesson 5: Assembly Automation
Lesson 6: Drawing Automation
Lesson 7: Selection and Traversal Techniques
Lesson 8: Adding Custom Properties and Attributes
Lesson 9: The SolidWorks API SDK
Lesson
more...
From Delphi Institute of Management
Masters in Hotel Resort Management

1. Competitive Analysis
2. Macro trends in the hotel industry:
3. Macro hotel industry regulations:
4. Hotel Marketing and Promotion
5. Managing clients and customers
6. Research and Development in Hotel Management
7. Human Resource Management
8. Departmental Management:
9. Budget Control
more...
From Boston University Corporate Education Center
Word 2003 Level II
...s
Lesson 8: Automating Common Tasks
Topic 8A: Run a Macro
Topic 8B: Create a Macro
Topic 8C: Modify a Macro
Topic 8D: Customize Toolbars and Buttons
Topic 8E: Add Menu Items
Lesson 9: Automating Document Creation
Topic 9A: Create a Document Based on a Template
Topic 9B: Create a Document by Using a Wizard
Topic 9C: Create or Modify a Template
Topic 9D: Change the
more...
Access 2003 Level III
...create complex Access databases using forms, reports, and macros.
Who should attend: This course is designed for the student who wishes to learn intermediate and advanced operations of the Microsoft Office Access 2003 database program. The Level 3 course is for the individual whose job responsibilities include working with heavily related tables; creating advanced queries, forms, and
more...
Introduction to Programming
...and shows how scripting can be used on the Web, to create macros, and in Windows. Students will also learn about Hypertext Markup Language (HTML) and its use on the Web.
Lessons
? Using Web Scripting ? Using Macro Scripting ? Using Windows Scripting
Lab 2: Writing Scripts
? Creating ?Hello World? with a Web Script ? Creating ?Hello World? with a Macro ? Creating ?Hello World?
more...
From Creascience
Screening and Optimization Designs


Target Audience
This applied training session in statistics is aimed at all scientific staff collecting data and making decisions based on them.
Aims
It covers the design of efficient experiments requiring few runs for screening and optimization purposes.
Prerequisites
This three-day course deals with the construction of advanced designs for screening and optimization. It assumes
more...
