Instructor Led Macro Training Classes
Refine Your Location:
South Africa
United States
United Kingdom
Canada
United Arab Emirates
Australia
India
Spain
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 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 Last Minute Training
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...
Microsoft PowerPoint 2007 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...
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 Interactive
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 Meirc Training and Consulting
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...
Finance for Executives
... worth 25 NASBA CPE?s. Develop an understanding of the 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 financial institutions such as the Bond, Stock, and Foreign
more...
Finance for Executives



...pants will be able to:
Develop and understanding of the macro finance picture of company goals and objectives.
Enhance your understanding of financial analysis and assess your ability to perform strategic financial analysis.
Learn international finance in this globally structured finance economy.
Become acquainted with financial institutions such as the Bond, Stock and Foreign Exchange
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...
Strategic Purchasing Management



Objectives:
By the end of the program, participants will be able to:
Understand the strategic role of the purchasing department.
Perform accurate supplier evaluation.
Learn the importance of value analysis to purchasing.
Evaluate the performance of the department at the macro level.
Improve the efficiency of the purchasing function.
Know how and when to train the purchasing staff.
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 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...
From Navigator Project Finance
VBA for Financiers


... syntax
* Generating your own code versus recording a macro
* Programming standards
* Application: Navigating a model using VBA
How to test and debug VBA applications
* Break Points
* Immediate Window
* Watch Window
* Stack
* Application : Debug a client s Project Finance VBA code
Coding VBA Building blocks
* Difference between sub/function/macro
more...
Debt Modelling Masterclass


...ngs.
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 Graphical
more...
Financial Modelling Fundamentals



... * Shift to select
* Ctrl+Shift to select section
Macros
* Record simple macro
* Link to button/object
* Run Macros
Review spreadsheets
* Tracing Dependents
* Tracing Precedents
Day Two
Print settings
* How to set up page breaks to
* print on one or several pages
* Adjusting zoom level
* Headers/Footers
Automated fill
* Generate list 1
more...
From Evergreen Team Concepts
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 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 NACE EDUCATION
Linux






...figuration 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
* The Samba
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...
