Instructor Led Macros Training
Macros Training Provider? - Tell us about your Training!
Please select the location nearest to you:
United Kingdom
United States
United Arab Emirates
Canada
India
Singapore
South Africa
Phillipines
Australia
Malaysia
From Wise Owl Business Solutions Ltd
Excel VBA Macros



Not only our best-selling course, but also one of our favourites. This two-day course takes you through Visual Basic for Applications in Excel from recording macros through to advanced form design. On the way you will learn how to write object-oriented programs and how to create loops and implement error-handling. Microsoft Excel macros are fun - let us show you why!
For a full list of
more...
Excel VBA Macros
Advanced VBA for Applications
If you already know how to program in Access, Excel or Word VBA, maybe it is time to learn about some of the more advanced features of the language. Ever wondered what a class module is? Curious about FileSystemObjects? Now is the time to find out what these things mean!
For a full list of course topics, see our website
more...
Microsoft Excel 2003 Advanced



If you've been using Microsoft Excel for a while now, maybe it's time to move on a bit. This two-day course shows how you can use Excel to manage a database, create advanced charts, use some of the advanced functions in Excel and much more besides! Invest two days of your time to make yourself permanently more efficient in Excel, by finding out just what it can do.
more...
Basic Querying in Access 2007




Does your computer system generate large amounts of data, which you find is just too cumbersome to analyse? This course assumes no knowledge of Access, and shows how to use Access queries to manipulate data (whether this is held in Access, Excel or some other format). Database design, tables, forms and reports are also normally briefly covered.
For a full list of course topics, see our
more...
Access VBA Macros



If you have mastered tables, queries, forms and reports in Access, it is maybe time to learn Access programming. This two-day course shows you how to use Access VBA to automate your databases, making your database development easier - and more fun!
For a full list of course topics, see our website
more...
Advanced PowerPoint 2007




You have probably been using the basics of PowerPoint for some time now to create simple presentations and slide shows, but wonder what more it has to offer. This one-day course takes you further into PowerPoint, showing (for example) how to create your own templates, link presentations and even how to record macros.
For a full list of course topics, see our website
more...
Basic Querying in Access 2003
Does your computer system generate large amounts of data, which you find is just too cumbersome to analyse? This course assumes no knowledge of Access, and shows how to use Access queries to manipulate data (whether this is held in Access, Excel or some other format). Database design, tables, forms and reports are also normally briefly covered.
For a full list of course topics, see our
more...
Access 2007 Introduction for Developers
Have you been given the task of designing and developing a database in Microsoft Access? Finding it difficult to know where to start? This three-day course assumes no prior knowledge of Access, and covers all the basics of Access, including how to design your database, creating tables, creating Access queries, and using Access forms, reports and macros. In fact the only thing this course does
more...
Excel 2007 Business Modelling
This course is aimed fairly and squarely at people who work in Finance and business modelling. Developed in-house by an expert in business modelling, this course shows you how to create robust business models which are easy to build and (above all) easy to test. The course makes extensive use of Excel range names.
For a full list of course topics, see our website
more...
Access 2003 Introduction for Developers
Have you been given the task of designing and developing a database in Microsoft Access? Finding it difficult to know where to start? This three-day course assumes no prior knowledge of Access, and covers all the basics of Access, including how to design your database, creating tables, creating Access queries, and using Access forms, reports and macros. In fact the only thing this course does
more...
Advanced Visual Basic for Applications
If you already know how to program in Access, Excel or Word VBA, maybe it is time to learn about some of the more advanced features of the language. Ever wondered what a class module is? Curious about FileSystemObjects? Now is the time to find out what these things mean!
For a full list of course topics, see our website
more...
Advanced Visual Basic 2005
If you have the basics of Visual Basic 2005, now is the time to do some serious development! Learn how to create your own classes, build a 3-tier application and much more.
For a full list of course topics, see our website
more...
Introduction to Excel 2003
If you have not used Microsoft Excel spreadsheets before, this one-day introductory course is the perfect point to start. Assuming no knowledge of Excel, the course shows you how to enter data and formulae, format your work to look attractive, print your work and create Excel charts.
For a full list of course topics, see our website
more...
Excel 2003 Business Modelling
This course is aimed fairly and squarely at people who work in Finance and business modelling. Developed in-house by an expert in business modelling, this course shows you how to create robust business models which are easy to build and (above all) easy to test. The course makes extensive use of Excel range names.
For a full list of course topics, see our website
more...
Advanced PowerPoint 2003
You have probably been using the basics of PowerPoint for some time now to create simple presentations and slide shows, but wonder what more it has to offer. This one-day course takes you further into PowerPoint, showing (for example) how to create your own templates, link presentations and even how to record macros.
For a full list of course topics, see our website
more...
Visual Basic 2005 Windows Forms
Been dabbling with VBA in Access, writing macros in Excel or building systems using Visual Basic 6? This is the ideal course for you! Learn how to create forms and code in Visual Basic 2005, using Visual Studio 2005 as the development environment.
For a full list of course topics, see our website
more...
Introduction to Excel 2007
If you have not used Microsoft Excel spreadsheets before, this one-day introductory course is the perfect point to start. Assuming no knowledge of Excel, the course shows you how to enter data and formulae, format your work to look attractive, print your work and create Excel charts.
For a full list of course topics, see our website
more...
From The Career Center
Microsoft Word 2007 Level 2
In the first course in this series, Microsoft Word 2007: Level 1, you gained all the basic skills that you need to create a wide range of standardized business documents. If you use Microsoft Word 2007 on a regular basis, then once you have mastered the basic skills, the next step is to improve your proficiency. To do so, you can customize and automate the way Microsoft Word 2007 works for you.
more...
Microsoft Word 2007 Level 2
Microsoft Excel Introduction To VBA
In the previous Excel courses, you used Excel to simplify business tasks, including the creation of spreadsheets, graphs, charts, and formulas that were difficult to create and nearly impossible to maintain using pencil and paper. You now want to simplify your work in the Excel environment by automating many of the repetitive tasks that are part of the spreadsheet development. In this course, you
more...
Microsoft Access 2007 Level
...ing existing data, writing advanced queries, working with macros, enhancing forms and reports, and maintaining a database. The Level 3 course is for the individual whose job responsibilities include working with related tables;creating advanced queries, forms, and reports;writing macros to automate common tasks;and performing general database maintenance. It is also designed as one in a series
more...
Microsoft Access Level 3 2010
...ing existing data, writing advanced queries, working with macros, and performing database maintenance. Upon successful completion of this course, students will be able to: restructure data into appropriate tables to ensure data dependency and minimize redundancy write advanced queries to analyze and summarize data create and revise Microsoft Office Access 2010 macros customize reports by
more...
Microsoft Word Level 2 2010
This course is designed for persons who are able to create and modify standard business documents in Microsoft Word 2010, but need to know how to create or modify complex business documents and customized Word efficiency tools. It also aims to assist persons preparing for the Microsoft Office Specialist exams for Microsoft Word 2010. Course Objective: You will create complex documents and build
more...
Microsoft Excel Level 3 2010
... students desiring to gain the skills necessary to create macros, collaborate with others, audit and analyze worksheet data, incorporate multiple data sources, and import and export data. Course Objective: You will automate some common Excel tasks, apply advanced analysis techniques to more complex data sets, troubleshoot errors, collaborate on worksheets, and share Excel data with other
more...
MS Word PowerUser Level
...lay and work with those forms and long documents by using macros and
collaborating. You will create, modify, and distribute forms, long documents, and Web pages.
Upon successful completion of this course, students will be able to:
automate tasks by writing and revising macros.
create references to information in a document.
prepare a document for publication.
revise documents based
more...
Access PowerUser Level
...ructured data, perform summary operations on data, create macros to
automate tasks, enhance forms and reports, and use Access data in other Office
applications. This course targets persons who have job responsibilities that
include structuring existing data into properly designed tables, analyzing data,
automating work in Access, implementing advanced form and report capabilities,
and using
more...
From Lorman Education Services
Microsoft Excel
Benefits strong Need an Excel productivity boost? /strong
You can now learn simple tricks and understand new features that will make you instantly more proficient using Excel ! Most Excel users are underutilizing this software. Start using the full power of Excel , and learn cool Excel tips that will make you the 'go-to' person in your office! Register today and get the information to make you a
more...
Microsoft Excel
Benefits strong Need an Excel productivity boost? /strong
You can now learn simple tricks and understand new features that will make you instantly more proficient using Excel ! Most Excel users are underutilizing this software. Start using the full power of Excel , and learn cool Excel tips that will make you the 'go-to' person in your office! Register today and get the information to make you a
more...
From Wintrac Inc.
Basic Assembler Language
... in tables
Build program linkage
Code data management macros
Use dumps to debug Assembler language program S0C7 abends
Developing larger programs using multiple base registers
Creating and using DSECTs.
Students will code, assemble and execute a series of programs using fixed point and decimal instructions and file access
You can get a complete list of other Mainframe classes at
more...
Word 2002 XP- Level 3
You know how to use Microsoft Word to create and format documents and newsletters. In this course, you'll learn how to use Word to create forms and long documents as well as how to make it easier to display and work with those forms and long documents by using macros and colloborating.
You can get a complete list of other Desktop Application Software classes at
more...
IMS Transaction Monitor with Message Format Services MFS
The course is a series of lectures, discussions, written exercises, and programming exercises dealing with the concepts, capabilities, and coding for IMS Transaction Monitor programs.
Students will design terminal screens and code Message Format Services (MFS) macros to implement those screen designs.
You can get a complete list of other Mainframe classes at
more...
Microsoft Office 2000 - Macro Programming Using Visual Basic For Applications
Students will learn to create and edit macros, and gain an understanding of VBA code.
You can get a complete list of other Desktop Application Software classes at http://www.wintrac.com/courses/coursesdesktop.asp
more...
Microsoft Office 2000 - Macro Programming Using Visual Basic For Applications
Students will learn to create and edit macros, and gain an understanding of VBA code.
You can get a complete list of other Desktop Application Software classes at http://www.wintrac.com/courses/coursesdesktop.asp
more...
Access 2003 -Advanced (Model 2001)
Students will learn how to use a variety of complex query techniques, create more efficient forms and reports, and create and use macros to automate their forms. In addition, students will gain experience with Internet-related features, including hyperlinks and the Web toolbar.
You can get a complete list of other Desktop Application Software classes at
more...
Microsoft Office Access 2007- Level 3 (Second Edition)
Your training in and use of Microsoft ® Office Access? 2007 has provided you with a solid foundation in the basic and intermediate skills for working in Microsoft ® Office Access? 2007. You have worked with the various Access objects, such as tables, queries, forms, and reports. In this course, you will extend your knowledge into some of the more specialized and advanced capabilities of
more...
z-OS Assembler Language - Advanced Topics
This class is oriented to the advanced Assembler language programmer that includes updated information relating to features with HLASM and the changes introduced with z/ OS. Specific topics will focus on 64-bit virtual storage addressing and the programming changes required to exploit new z/ OS features. New macros and data structures inherent in the z/ OS architecture will be explored. In
more...
Assembler Language - Data Management Topics
...amic allocation, data in virtual, and the data management macros for various files. In addition, the discussion will include topics that deal with sequential files, VSAM, linear data sets, PDSE, and VSAM data striping. This course is a workshop environment where classroom projects will involve writing programs to process records in the various file formats.
You can get a complete list of
more...
From Meirc Training and Consulting
Advanced Business and Financial Modeling Using Excel - Finance and Accounting




Improve their modeling skills using excel 2007.
Boost productivity by practicing hands-on advanced Excel tools.
Become skilled at VBA and MACROS to automate and manage tasks efficiently.
Develop dynamic and interactive business models.
Enhance business reporting and charting skills.
more...
Advanced Business and Financial Modeling Using Excel - Finance and Accounting
By the end of the program, participants will be able to: Advance their modeling skills using Excel 2007. Boost productivity by practicing hands-on advanced Excel tools and model building techniques. Build Financial Models and calculate Net Present Value - NPV, Internal Rate of Return - IRR, Corporate Valuations, Free Cash Flows - FCF, and Weighted Average Cost of Capital - WACC. Perform MACROS to
more...
Mastering Business and Financial Reporting Unleashing the Power of Excel 2007


Boost Excel reporting expertise in business, finance, and accounting. Automate the report preparation and analysis to assist in enhancing the decision making process. Demonstrate proficiency in pivot tables and pivot charts. Slice and dice large accounting and business data in no time. Apply data reporting techniques to real-life business situations. Use Macros to perform repetitive tasks and
more...
From Magna Training
SAS Training
... Macro Statements
Macro Functions
Autocall Macros
* SAS Macros
o Introduction to SAS Macro Language Elements
o Introduction to Macro Variables
o Automatic Macro Variables
o User define Macro Variables
o How Macro processing will undergo inside the SAS system
o Macro Statements
o Macro Functions
more...
From Mullan Training
Advanced MS Access


...ill be presented at the outset this will make use of:
- macros
- interrogating data using custom dialogue boxes
- action queries
- use of Expression Builder
- a range of advanced functions
PREREQUISITES
A working knowledge of Access or our Introduction to MS Access course will allow sufficient knowledge to attend our Advanced MS Access course.
BENEFITS
At the end of this course you will
more...
Advanced MS Excel (1 & 2 Days)


Our 1 or 2 day Microsoft Excel Intermediate / Advanced course is suitable for those with a sound working knowledge of Excel who wish to progress to the most complicated functions and features.
PREREQUISITES
A working knowledge of Excel or our Introduction to MS Excel course.
BENEFITS
At the end of this course you will have a complete understanding of the higher functions of Excel.
You
more...
Advanced MS Word - 1 Day

Our 1 day Microsoft Word Advanced course is suitable for those with a sound working knowledge of Word who wish to progress to the most complicated functions and features.
Prerequisites
A good working knowledge of Word is required, or our Introduction to MS Word course.
Benefits
At the end of this course, you will have a complete understanding of the higher functions of Word.
You will be able
more...
Advanced MS Project



...oft Project Environment
- Creating menu items
- Creating macros
- Format task layout
- Create new task/ resource fields (create lookups to facilitate data entry)
- Working with global settings
- Making changes using the Options dialog box
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
more...
VB Access



...nt
When to use Visual Basic for Applications instead of Macros
Visual Basic for Applications Development Environment
Programming in the VBA Language Code Compilation
Finding Bugs
Error Handling in VBA
Ignoring Errors
Trapping Errors
Writing Useful Error Handlers
Class Modules and Form-Event Procedures
Using Form Events
Code Behind Forms
Changing Form Properties
Creating
more...
VB Excel


...cro
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
Procedures
Inserting Comments
Printing a Visual Basic Module
The
more...
Introduction To MS Frontpage



...Button, Marquee, Etc)
- Create And Use Templates
- Use of Macros
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 our website
more...
From silicon beach training
Microsoft Access Training


This intensive Microsoft Access training course introduces attendees to relational databases concepts, and how to create and maintain a database using MS Access. MS Access is a powerful database application which will save you time takes the pain out of creating relational databases. This beginners Access provides the skills needed to build basic databases, and provides a platform from which to
more...
Microsoft Access Advanced Training


This Advanced Microsoft Access training course builds on the skills covered in our Beginners Access Course. Learn how to analyse data by creating advanced Access queries, reports and forms that are efficient and make repetitive tasks quick to complete.
more...
VBA For Excel Training


This VBA for Excel training course will provide delegates with knowledge of Visual Basic for Applications within the contect of Excel.
This 2 day VBA for Excel training course will teach participants how to create and edit macros, and gain understanding of the VBA code.
more...
From Statistics & Analytics Consultants Group
Data Manipulation Techniques
Using a popular statistical software package you will learn basic data manipulation tasks such as: Bringing in different types of files (SPSS, SAS, txt, dat., excel, use the ODBC, etc); Clean data and address such issues as missing data, duplicate entries, outliers; Reshaping, aggregating, merging data; Performing such tasks as looping, vectors, beginning automations with macros specific to data
more...
From Maverick Enterprises
Get on Track with MS Access Advanced




Learn advanced techniques such as: querying with SQL; using crosstab, parameter, and action queries; creating and running macros; importing, exporting, and linking database objects; optimizing, replicating, and synchronizing databases; and basic database security.
more...
From WWP Training Ltd
Microsoft Access 2003 VBA Programming
Aims
This course will help students to become proficient database application developers by using the features of Microsoft Access and Visual Basic for Applications.
Prerequisites
Students wishing to attend this course should have completed foundation and advanced courses in Access or have equivalent practical experience. Specifically, students should be familiar with creating queries,
more...
From Software Training Academy, Inc
Microsoft Excel - Advanced



...cel (such as Goal Seek and Solver), running and recording macros, and sharing Excel data via the Web.
Learning Objectives:
Designated as Approved Courseware for the Microsoft Certified Application Specialist program, this course will help students prepare for the Excel 2007 exam (77-602). For comprehensive certification training, students should complete Excel 2007: Basic, Intermediate,
more...
From Technical Training Solutions
Excel - Forms Macros VBA





... is and how to create them. From there, students will use macros to automate routine Excel tasks. Students will learn to customize the Excel environment by altering the toolbars, menus and keyboard shortcuts to suit their needs. Students will get a thorough introduction to the VBA development environment that is based on Visual Basic. The class covers the most essential code topics including:
more...
From Javelin Technologies
SolidWorks API Programming (3 Days)




This API course teaches you how to use the SolidWorks API (Application Programming Interface) to automate and customize SolidWorks.
Prerequisites:
- Experience with the Windows operating system.
- Attended the SolidWorks Visual Basic course.
- Used the software for a few months.
To receive information on special pricing please click on the "Request Information" button below for:
-
more...
From Evans Analytics
Data Manipulation Techniques

Using a popular statistical software package you will learn basic data manipulation tasks such as: Bringing in different types of files (SPSS, SAS, txt, dat., excel, use the ODBC, etc); Clean data and address such issues as missing data, duplicate entries, outliers; Reshaping, aggregating, merging data; Performing such tasks as looping, vectors, beginning automations with macros specific to data
more...
From RAMCO Software Training
VBA Programming for Microsoft Office Applications






This course is intended for the person who has a strong familiarity with Microsoft Word, Excel, and Access and who would like to begin learning how to automate these programs. It introduces the audience to the programming concepts involved in the Visual Basic language while applying those concepts to the Microsoft Office programs.
The course uses a combination of lecture, hands-on practice,
more...
From ibruk Consulting Pvt Ltd
Mastering Microsoft Excel
Microsoft Excel is a powerful spreadsheet application with features that enable computation, graphical representation and analysis of data. It has many features that can make life easier for people who deal in numbers on an everyday basis.
Also, with Microsoft Office 2007, there is a new way of working in Microsoft Office. ibruk consulting's Mastering Microsoft Excel training program helps your
more...
Mastering Microsoft Word
While many work with Microsoft Word on a daily basis, few exploit its potential completely. Also many have devised their own ways of doing things (which are often a result of trial and error) instead of using simpler ways that Microsoft word offers.
With Microsoft Office 2007, there is a new way of working in Microsoft Office. ibruk consulting's Mastering Microsoft Word training program helps
more...
From Open Source Training
C Programming
This hands on C programming course provides a comprehensive introduction to the ANSI C language, emphasizing portability and structured design. Students are introduced to all major language elements including fundamental data types, flow control, and standard function libraries. Thorough treatment is given to the topics of string and character manipulation, dynamic memory allocation, standard I/
more...
From London Financial Studies
Index Linked Bonds and Inflation Derivatives




The market for index-linked bonds and inflation derivatives is growing rapidly. The program covers the mechanics of the instruments, their valuation and how they can be used to take or hedge inflation exposure alone or embedded in other structures.
Traders, risk managers, fund managers, project finance and structured finance practitioners, accountants, auditors, consultants and anyone interested
more...
Convertible Bonds and Securities


... pricing models are implemented using Excel functions and macros and participants will be able to take away all worked examples.
Who The Course is For
* Traders
* Credit and equity risk managers
* IT
* Middle office
* Quantitative researchers
* Hedge funds
* Portfolio managers
* Structured products desk
Prior Knowledge
* Numerate background (basic)
* Basic knowledge
more...
Interest Rate Derivatives 2 Second Generation Techniques


...ario spreadsheets containing relevant Excel functions and macros for participants to take away.
Who The Course is For
This course is designed for anyone who wishes to be able to price, use and manage second-generation interest rate derivatives:
* Quantitative Analysts
* Risk Managers
* Financial Engineers
* Traders and Structurers
* Researchers and others who manage interest
more...
Using Inflation Derivatives in Today s Market


Course Outline
The market for inflation derivatives and other index-linked products is growing rapidly. The programme covers the mechanics of the instruments, their valuation and how they can be used to take or hedge inflation exposure alone or embedded in other structures.
Traders, risk managers, fund managers, project finance and structured finance practitioners, accountants, auditors,
more...
Counterparty Risk, Credit Exposure and CVA


...xercises and models implemented using Excel functions and macros.
All delegates will receive a copy of Jon Gregory's recent published book "Counterparty Credit Risk: The New Challenge for Global Financial Markets" (Wiley).
Who The Course is For
* Credit traders and credit officers
* Risk managers and credit risk practitioners
* Structurers and salespeople
* IT
* Middle office
more...
From NobleProg - IT training courses
Excel VBA Advanced Training Course





This course has been created for VBA developers who want to learn advanced topics and use VBA macros in the most efficient way. The course deals with object oriented programming, advanced VBA functionality and integration with external libraries and data sources.
more...
From Single Sourcing Solutions, Inc
Configuring the Arbortext Application
...liases, and use ActiveX controls. You will create and run macros and learn how to create dynamic dialog boxes using the XUI Editor. You will learn how to merge data from external sources. You will configure and assign profiles. You will also learn how to customize Web output and configure PDF files. After successfully completing this course, you will be prepared to create, configure, install,
more...
From Last Minute Training
Word 20072010 Advanced 1 Day
Topics include: fields, bookmarks, styles, autoformat, combining documents, tracking changes, inserting objects, linking, document map, splitting a document, advanced outline numbering, table of contents, forms, templates, customizing word, and macros.
more...
MS Project 20032007 Level 2
Student will be able to track projects using progress lines, use earned value analysis & pert charts, create & share resource pools, work with multiple reports, import & export data & communicate within workgroups using rollup taskbars as well as macros
more...
Microsoft Excel 2007 2010 Level 3 Advanced
This course will teach you how to create outlines and subtotals, Pivot tables, create and use Macros and forms.
more...
Word 2003 Level 3 Advanced - French Instruction English Software
Upon completion, you'll be able to insert comments, bookmarks, footnotes & endnotes; learn how to cross reference documents, track changes, use tables to calculate data, record & run macros to automate your work & enhance your documents using graphics..
more...
Excel 2003 Level 3 Advanced 2
Designed for users familiar with Excel & want to expand their knowledge. Upon completion of the course, you'll be able to protect & unprotect worksheets & workbooks, use goal seek, auditing toolbar, data tables, scenarios as well as create & edit macros
more...
Microsoft Excel 2007 Level 4 Expert
This course will teach you to create macros and form controls as well as work with SharePoint.
more...
Microsoft Word 2000 XP 2003 Level 4 Expert
The focus of this course is to allow you to create forms, web pages, use macros, and manipulate long documents using features such as references, outline, and tables of contents.
more...
CATIA V5 - Week K - Intro to VBA VB Automation 5 days
At the end of this course, participants will have a good understanding of the different ways to automate tasks related to CATIA V5: CATIA Macros and Visual Basic Programming
more...
Lotus 123 Level 3 Advanced FRENCH
Students will learn to modify and personalize their Lotus 123 environment and create macros. Students will also learn to analyze and audit data.
more...
MS Project 2007 Level 2
Student will be able to track projects using progress lines, use earned value analysis & pert charts, create & share resource pools, work with multiple reports, import & export data & communicate within workgroups using rollup taskbars as well as macros
more...
Word 2007 level 3 Advanced
Upon completion, you'll be able to insert comments, bookmarks, footnotes & endnotes. Learn how to cross reference documents, track changes, use tables to calculate data, record & run macros to automate your work and enhance documents using graphics....
more...
Word 2003 Level 3 Advanced
Upon completion, you'll be able to insert comments, bookmarks, footnotes & endnotes; learn how to cross reference documents, track changes, use tables to calculate data, record & run macros to automate your work & enhance your documents using graphics..
more...
Microsoft Word 2007 Level 4 Expert
Student will learn how to create advanced forms and macros, Manage changes to their document and work with referencing tools.
more...
Excel Macros VBA Level 3 3 Days
This course builds on the Level 2 course. Topics include: advanced user forms & dialog boxes, creating wizards, developing text utilities, VBA & charts, using Excel events, working with other applications, and customizing toolbars & menus with VBA.
more...
Excel 2007 VBA Macros 2 Days- Presido Learning Center
Location: Winnipeg Date: 2009-03-23
List Price: $550 Offered Price: $440. 00
Seats Available: 2
This course is intended for participants who are familiar with Excel 2000, 2002 or 2003.
For information please call 1 877 313 8881 or visit http://www. lastminutetraining. ca/ courses. php/ course/ 6890/ Excel-2007-VBA-Macros-%282-Days%29
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...
Excel Macros & VBA Level 1-3 Days

Location: Town of Newmarket Date: 2007-04-23
List Price: $825 Offered Price: $575.00
Seats Available: 5
This course explores creating, editing, and using Excel Macros and provides a good introduction to the relationship between macros and Visual Basic.
more...
MS Access - Level 2

April 12, 2007
In this course topics include, advanced query techniques, creating efficient forms and reports, macros and Internet related features. At this level, instructors may vary the course content to some extent to accommodate the needs of attendees, exploring or reviewing other functions in greater depth.
more...
MS Excel 2003 Level 3 Training Seminar

Location: City of Mississauga Date: 2007-04-19
List Price: $245 Offered Price: $171.00
Seats Available: 2
This course is designed for students desiring to gain the skills necessary to create macros, collaborate with others, audit and analyze worksheet data, create PivotTables and PivotCharts, incorporate multiple data sources and import and export 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
more...
MS Excel 2003 Level 3 Training Seminar

Location: City of Mississauga Date: 2007-06-21
List Price: $245 Offered Price: $171.00
Seats Available: 2
This course is designed for students desiring to gain the skills necessary to create macros, collaborate with others, audit and analyze worksheet data, create PivotTables and PivotCharts, incorporate multiple data sources and import and export data.
more...
Microsoft Excel 2003 Level 3
...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
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
more...
Microsoft Word 2003 Level 3 - Bilingual

Location: Ottawa Date: 2008-01-30
List Price: $300 Offered Price: $210.00
Seats Available: 2
Module 0: Using Mail Merge
Module 1: Merging Mailing Labels And Directories
Module 2: Sorting Table Data
Module 3: Using Formulas In Tables
Module 4: Importing Excel Worksheets
Module 5: Working with Lists
Module 6: Using Macros
Module 7: Using Forms
Module 8: Tracking Revisions
Module 9:
more...
Microsoft Word Advanced Training

Location: Ottawa Date: 2008-01-30
List Price: $235 Offered Price: $164.00
Seats Available: 2
Upon completion of the course you will be able to insert comments, bookmarks, footnotes and endnotes. You will learn how to cross reference documents, track changes, use tables to calculate data, record and run macros to automate your work and enhance your documents by using graphics, charts,
more...
Microsoft Word Advanced Training (French Instruction, English Software)

Location: Ottawa Date: 2008-01-31
List Price: $235 Offered Price: $164.00
Seats Available: 2
Upon completion of the course you will be able to insert comments, bookmarks, footnotes and endnotes. You will learn how to cross reference documents, track changes, use tables to calculate data, record and run macros to automate your work and enhance your documents by using graphics, charts,
more...
Microsoft Excel 2003 Level 2 (1 Day)

Location: Vancouver Date: 2008-02-08
List Price: $199 Offered Price: $139.00
Seats Available: 1
Objectives
Displaying and Printing Formulas
Using the Insert Function Feature
Mathematical and Financial Functions
Statistical and Database Functions
Creating a List
Inserting an Excel Worksheet into a Word Document
Opening and Saving Files in Different Formats
Finding and
more...
Microsoft Excel 2003 - level 3

This courseware is a continuation of the Microsoft Excel level 2, in which students gained more knowledge as a proficient user of Excel. You will begin with a review of these intermediate subject areas and then move to more advanced topics with Excel. In this session you will:
* Create data maps
* Create and use a database
* Create and use Pivot Tables
* Create and run
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
more...
Microsoft Word Advanced Training

Location: Ottawa Date: 2008-02-25
List Price: $235 Offered Price: $188.00
Seats Available: 2
Upon completion of the course you will be able to insert comments, bookmarks, footnotes and endnotes. You will learn how to cross reference documents, track changes, use tables to calculate data, record and run macros to automate your work and enhance your documents by using graphics, charts,
more...
Microsoft Word Advanced Training
Upon completion of the course you will be able to insert comments, bookmarks, footnotes and endnotes. You will learn how to cross reference documents, track changes, use tables to calculate data, record and run macros to automate your work and enhance your documents by using graphics, charts, clipart, themes and watermark features as well to control a big document using master and subdocuments and
more...
Microsoft Excel XP 2003 Level 3
Location: Vancouver Date: 2008-03-18
List Price: $229 Offered Price: $160.00
Seats Available: 2
After you complete this course you will be able to do the following:
* Create and modify Pivot Tables
* Create and modify macros
* Create and modify outlines
* Use advanced functions
* Trace Dependents and Precedents
* Create and modify scenarios
You will also
more...
Microsoft Word XP 2003 Level 2
Objectives
* Creating Envelopes and Labels
* Merge data with form letters and labels
* Create tables
* Format tables, including calculations
* Sort lists and tables
* Create and work with multiple columns
* Create macros
* Customize toolbars
* Edit and delete macros
* Create keyboard shortcuts
more...
Access 2007 - Level 3 - presidio
The Level 3 course is for the individual whose job responsibilities include working with related tables; creating advanced queries, forms, and reports; writing macros to automate common tasks; and performing general database maintenance. It is also designed as one in a series of courses for students pursuing the Microsoft Office Specialist Certification for Microsoft Office Access 2007, and it is
more...
Microsoft Excel XP 2003 Level 3
Location: Vancouver Date: 2008-04-28
List Price: $229 Offered Price: $160.00
Seats Available: 2
After you complete this course you will be able to do the following:
* Create and modify Pivot Tables
* Create and modify macros
* Create and modify outlines
* Use advanced functions
* Trace Dependents and Precedents
* Create and modify scenarios
For more
more...
MS Access Training - Level 2
Location: City of Mississauga Date: 2008-04-23
List Price: $245 Offered Price: $195.00
Seats Available: 2
In this course topics include, advanced query techniques, creating efficient forms and reports, macros and Internet related features. At this level, instructors may vary the course content to some extent to accommodate the needs of attendees, exploring or reviewing other functions in
more...
Microsoft® Office Excel® 2007 - Level 3
... students desiring to gain the skills necessary to create macros, collaborate with others, audit and analyze worksheet data, incorporate multiple data sources, and import and export data. In addition, the course is also for students desiring to prepare for the Microsoft Office Specialist exam in Excel 2007, and who already have knowledge of the basics of Excel, including how to create, edit,
more...
MS Excel 2003 Level 3 Training Seminar
This course is designed for students desiring to gain the skills necessary to create macros, collaborate with others, audit and analyze worksheet data, create PivotTables and PivotCharts, incorporate multiple data sources and import and export data.
more...
Microsoft Excel Introduction
Location: Vancouver Date: 2008-05-08
List Price: $199 Offered Price: $159.00
Seats Available: 2
Objectives
* Creating Envelopes and Labels
* Merge data with form letters and labels
* Create tables
* Format tables, including calculations
* Sort lists and tables
* Create and work with multiple columns
* Create macros
*
more...
Excel Macros & VBA Level 1 (3 Days)
Location: City of Mississauga Date: 2008-05-12
List Price: $825 Offered Price: $660.00
Seats Available: 2
This course explores creating, editing, and using Excel 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.
For more information please call 1-877-313-8881 or
more...
Microsoft Excel 2007 - Level 3
... students desiring to gain the skills necessary to create macros, collaborate with others, audit and analyze worksheet data, incorporate multiple data sources, and import and export data. In addition, the course is also for students desiring to prepare for the Microsoft Certified Application Specialist exam in Microsoft Office Excel 2007, and who already have knowledge of the basics of
more...
Microsoft Excel XP 2003 Level 3
After you complete this course you will be able to do the following:
* Create and modify Pivot Tables
* Create and modify macros
* Create and modify outlines
* Use advanced functions
* Trace Dependents and Precedents
* Create and modify scenarios
more...
Excel Macros & VBA Level 1 (3 Days)
This course explores creating, editing, and using Excel 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.
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
more...
Access Advanced - Level 3
This course provides competency in designing applications, using advanced tools and controls, creating dialog boxes, using macros, controlling data entry, using dialog boxes to filter records in reports, creating custom switchboards, enhancing applications, using database utilities, and tailoring applications for multiple users.
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...
Access 2003 - Level 3 (1 Day)
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 reports; writing macros to automate common tasks; and performing general database maintenance.
more...
Excel 2003 - Level 3
... students desiring to gain the skills necessary to create macros, collaborate with others, audit and analyze worksheet data, create PivotTables and PivotCharts, incorporate multiple data sources, and import and export data. In addition, the course is also for students desiring to prepare for the Microsoft Office Specialist exam in Excel 2003 or Module 2-Key Applications of the Internet and
more...
Excel 2003 Advanced (1 Day) - cldouglas
The third level in the series, Excel 2003 Advanced builds on the topics learnt from Introduction and Intermediate and expands upon them. In addition to the expanded topics, there will also be new topics inside this class. The topics in this class will include: Streamlining with macros, Advanced formula creation, Customizing the work area, and much much more.
Included will all courses are
more...
VBA for Excel - Level 1
This course is targeted to students who are looking to gain the skills necessary to apply VBA to develop macros, format worksheets, create user-interactive macros, work with multiple worksheets, and perform calculations. In addition, students who already have knowledge of the basics of Excel, including how to create, edit, format, and print worksheets that include charts and sorted and filtered
more...
Microsoft Access 2003 XP Level I II
This course covers table creation, relationships, extracting information using queries, designing forms and creating reports. Advanced queries including action queries, advanced forms and reports including sub forms and sub reports, import/ export, and macros will also be covered.
more...
PowerPoint 2003 Advanced 1 Day - cldouglas
During this course, we look at advanced animations, advanced slide shows, action buttons and settings, macros, design and planning your presentation, the content, multimedia, use of colours and fonts, creating handouts, rehearsing & packaging your presentation, and use of technology when presenting.
more...
Microsoft Word XP 2003 Level 3
Objectives
* Create AutoText Entries
* Create text boxes
* Use Graphics And Watermarks
* Use the Drawing Tools
* Create Outlines
* Generating Indexes And Tables Of Contents
* Use Styles And Templates
* Create Online Forms
* Create Macros
more...
Microsoft Office Word 2007 Level 2
- manage lists.
- customize tables and charts.
- customize formatting with styles and themes.
- modify pictures in a document.
- create customized graphic elements.
- insert content using Quick Parts.
- control text flow.
- use templates to automate document creation.
- perform mail merges.
- use macros to automate common tasks.
more...
Microsoft Word 2007 Level 3 - on track
Objectives
* Create AutoText Entries
* Create text boxes
* Use Graphics And Watermarks
* Use the Drawing Tools
* Create Outlines
* Generating Indexes And Tables Of Contents
* Use Styles And Templates
* Create Online Forms
* Create Macros
more...
Word Customization Long Documents and Macros
This course provides competency in customizing the Word environment; using Excel worksheets and XML documents; navigating long documents; summarizing document content; using endnotes, footnotes, tables of figures, tables of authorities, indexes and tables of contents; using master documents; and working with macros.
more...
Microsoft Access XP 2003 Level 3
Objectives:
* Explain 3 steps to normalize a database
* Explain 3 types of database relationships
* Use the Table Analyzer Wizard
* Explain query join properties
* Create command buttons on a form and attach macros
* Create action queries
* And much, much more...
more...
PowerPoint 2007 Advanced 1 Day
During this course, we look at advanced animations, advanced slide shows, action buttons and settings, macros, design and planning your presentation, the content, multimedia, use of colours and fonts, creating handouts, rehearsing & packaging your presentation, and use of technology when presenting.
more...
Microsoft Excel2003 - Level 3
... students desiring to gain the skills necessary to create macros, collaborate with others, audit and analyze worksheet data, create PivotTables and PivotCharts, incorporate multiple data sources, and import and export data.
Upon successful completion of this course, students will be able to:
* Customize workbooks.
* Collaborate with others using workbooks.
* Audit
more...
Access 2007 Upgrade 1 Day
Access version 2007 has significant changes in the design aspect. This course is essential if you want to get back to developing where you left off. Topics include: new, improved user interface, templates, enhanced sorting and filtering, layout view, stacked and tabular layouts, automatic calendar, rich text in memo fields, enhanced quick create, improved datasheet view, total row in datasheets,
more...
Microsoft Word 2007 - Level 2
In the first course in this series, Microsoft ® Office Word 2007: Level 1, you gained all the basic skills that you need to create a wide range of standardized business documents. If you use Microsoft Word 2007 on a regular basis, then once you have mastered the basic skills, the next step is to improve your proficiency. This course will help you do that. Upon successful completion of this
more...
Access 2003 Advanced - cldouglas
This course is the most advanced course in the series. It is therefore recommended that you have taken the Intermediate course in order to proceed. The course topics will include: using the Switchboard, macros, relationships, database utilities, and more. Following the end of the course, participants will receive telephone support, a courseware and certificate of completion.
more...
Microsoft Excel 2007 Level 3 - On Track
* Create and modify Pivot Tables
* Create and modify macros
* Create and modify outlines
* Use advanced functions
* Trace Dependents and Precedents
* Create and modify scenarios
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...
Excel 2003 Automating Tasks with Macros
Do you frequently perform the same tasks in Excel? Learn various ways to save time and steps by recording macros.
more...
Word 2007 Advanced - computer help
Topics include: fields, bookmarks, styles, autoformat, combining documents, tracking changes, inserting objects, linking, document map, splitting a document, advanced outline numbering, table of contents, forms, templates, customizing word, and macros.
more...
Word 2007 Automating Tasks with Macros
Are there certain procedures and tasks you use often when creating Word documents? Do you often insert the same block of text in your documents? Would you like to automate these common tasks to complete them more quickly?
more...
Excel 2003 Introduction to VBA
Course Objective: You will use VBA to create macros for automating repetitive tasks in Excel 2003.
more...
Excel 2007 Automating Tasks with Macros
Do you frequently perform the same tasks in Excel? Learn various ways to save time and steps by recording macros. Learn to write macros to automate various Excel tasks.
more...
Microsoft Access 2007 Advanced
In this course, you will extend your knowledge into some of the more specialized and advanced
capabilities of Access by structuring existing data, writing advanced queries, working with
macros, enhancing forms and reports, and maintaining a database.
more...
Microsoft Project 2007 Level 2 - nexient
Who should attend
This course is intended for participants who are familiar with Microsoft Office Project 2007.
Performance Objectives
Upon completion of the course, participants will be able to accomplish the following:
Understand the concepts of word processing, and how to create, save, and open documents for easy document management
Use sample templates, create custom templates, and
more...
Microsoft Word 2000 2003 Level 3 - nexient
Who should attend?
This course is intended for participants who are familiar with Word 2000/ 2002/ 2003.
Performance Objectives
Upon completion of the course, participants will be able to accomplish the following:
Assign themes and insert graphics to add visual appeal to documents and use WordArt and text boxes to enhance document layout
Add columns, headers, and footers to enhance page
more...
MS Excel 2003 - Level 3 Training Seminar - HBI
This course is designed for students desiring to gain the skills necessary to create macros, collaborate with others, audit and analyze worksheet data, create PivotTables and PivotCharts, incorporate multiple data sources and import and export data.
more...
Microsoft Excel 2003 Level 2 1 Day - On Track
Objectives
Displaying and Printing Formulas
Using the Insert Function Feature
Mathematical and Financial Functions
Statistical and Database Functions
Creating a List
Inserting an Excel Worksheet into a Word Document
Opening and Saving Files in Different Formats
Finding and Deleting Records
Using Data Validation
Automating Tasks with Macros
more...
Microsoft Word 20022003 Level 2 - On Track
Topics included in this 1 day course are : envelopes and labels, mail merge, tables, sorting, columns, customizing toolbars, macros & autotext.
more...
Word 2003 Automating Tasks with Macros
Are there certain procedures and tasks you use often when creating Word documents? Do you often insert the same block of text in your documents? Would you like to automate these common tasks to complete them more quickly?
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 Word 2002 - 2003 Level 3 - on track
Topics included in this 1 day course are : Styles and templates, online forms, bullets and numbering, outline, indexes and table of contents, macros, text boxes, graphics, drawing in word and more.
more...
Microsoft Excel 20022003 Level 3
This 1 day course topics are : pivot tables, macros, outlines, Excel functions, auditing, what-if analysis and more.
more...
Microsoft Excel 2000-2003 Level 3 VBA Macros
This course is intended for participants who are familiar with Excel 2000/ 2002/ 2003 and who wish to learn to use macros to automate functions and to develop applications using Excel as the platform.
more...
Access 2003 Advanced- Last Minute Training
Location: Toronto Date: 2009-03-23
List Price: $825 Offered Price: $660. 00
Seats Available: 2
This course takes an in-depth look at macros, securing a shared database and using functions.
For information call 1 877 313 8881 or visit http://www. lastminutetraining. ca/ courses. php/ course/ 7059/ Access-2003-Advanced-%283-Days%29
more...
Microsoft Word 2002-2003 Advanced Training- Compuease
Upon completion of the course you will be able to insert comments, bookmarks, footnotes and endnotes. You will learn how to cross reference documents, track changes, use tables to calculate data, record and run macros to automate your work and enhance your documents by using graphics, charts, clipart, themes and watermark features as well to control a big document using master and subdocuments and
more...
MS Excel Advanced - OPTION 2- Compuease
Upon completion of the course, you will be able to protect and unprotect worksheets and workbooks, use goal seek, auditing toolbar, data tables, scenarios as well as create and edit macros.
more...
PowerPoint 2007 Advanced 1 Day- Last Minute Training
During this course, we look at advanced animations, advanced slide shows, action buttons and settings, macros, design and planning your presentation, the content, multimedia, use of colours and fonts, creating handouts, rehearsing & packaging your presentation, and use of technology when presenting.
more...
Excel Macros VBA Level 2 3 Days - computerhelp
This course builds on the topics covered in the first Macros course, and covers further techniques and examples for programming Excel with VBA.
more...
Microsoft Excel 2000-2003 Level 3 VBA Macros- Nexient
This course is intended for participants who are familiar with Excel 2000/ 2002/ 2003 and who wish to learn to use macros to automate functions and to develop applications using Excel as the platform.
more...
Microsoft Word 2000 2003 Level 3 -Nexient
Upon completion participants will be able to enhance publications with graphics, build page layout, use outline view to organize documents, insert revisions & comments, record/ edit macros to automate repetitive actions & create custom menus & toolbars.
more...
Microsoft Access Advanced- Compuease
In this course, you will extend your knowledge into some of the more specialized and advanced capabilities of Access by structuring existing data, writing advanced queries, working with macros, enhancing forms and reports, and maintaining a database.
more...
Microsoft Access Advanced-Compuease
In this course, you will extend your knowledge into some of the more specialized and advanced capabilities of Access by structuring existing data, writing advanced queries, working with macros, enhancing forms and reports, and maintaining a database.
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...
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...
MS Access 2003 Level 2 - new era
Designed for those who want to learn intermediate & advanced operations of the MS Access 2003 database program & whose job responsibilities include working with heavily related tables; creating advanced queries, forms, & reports; writing macros...
more...
MS Excel 2007 Level 3 Training Seminar
This course is designed for students desiring to gain the skills necessary to create macros, collaborate with others, audit and analyze worksheet data, create PivotTables and PivotCharts, incorporate multiple data sources and import and export data.
more...
Microsoft Word 20022003 Level 3 - on track
Topics included in this 1 day course are : Styles and templates, online forms, bullets and numbering, outline, indexes and table of contents, macros, text boxes, graphics, drawing in word and more.
more...
MS Access 2007 Level 2 - newera
In this course, you will extend your knowledge into some of the more specialized and advanced capabilities of Access by structuring existing data, writing advanced queries, working with macros, enhancing forms and reports, and maintaining a database.
more...
Excel Macros VBA Level 3 - ch
This course builds on the Level 2 course. Topics include: advanced user forms & dialog boxes, creating wizards, developing text utilities, VBA & charts, using Excel events, working with other applications, and customizing toolbars & menus with VBA.
more...
Microsoft Excel 2003 Advanced - tplanit
Level 3. This course provides competency in Outlining and Grouping Data, Pivot Tables, Excel Workbooks as Web Pages, Creating and Using Workbooks, Visual Basic and Macros, Advanced File Management and Security.
more...
Microsoft Access Level 3 Advanced - ctc
This course will consist of the following lessons:
Customizing Menus and Toolbars
Setting Access Option
Creating Macros
Organizing Report Data
Formatting Reports
Common Report Tasks
Basic Queries
Management Action Queries
and more!
more...
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...
Word 2007 Advanced 1 Day
Topics include: fields, bookmarks, styles, autoformat, combining documents, tracking changes, inserting objects, linking, document map, splitting a document, advanced outline numbering, table of contents, forms, templates, customizing word, and macros.
more...
Access 2003 Level 3 - teksource
Topics included: Structuring Existing Data; Writing Advanced Queries; Simplifying Tasks with Macros; Adding Interaction and Automation with Macros; Making Forms More Effective; Making Reports More Effective; Maintaining an Access Database.
more...
Microsoft Excel 2007 Advanced Available in French and English
In this 2-day instructor-led course you will learn: Creating macros using the macro recorder & Visual Basic programming. Creating forms using the Microsoft Excel Forms toolbar. Creating user forms or more precisely, user interfaces.
more...
Microsoft Excel 2007 Level 3 Advanced
Students will learn to modify and personalize their Excel environment and create macros. Students will also learn to create and use Excel forms.
more...
VBA Excel
Students will learn concepts used to build custom solutions with Microsoft Excel VBA Macros. The participant will become familiar with macro techniques for recording, writing, running, and maintaining a macro.
more...
Access 2007 Advanced French
In this course, you will extend your knowledge into some of the more specialized and advanced capabilities of Access by structuring existing data, writing advanced queries, working with macros, enhancing forms and reports, and maintaining a database.
more...
Microsoft Access 2000 XP 2003 Level 3 Advanced
This course will consist of: Customizing Menus and Toolbars, Setting Access Options, Creating Macros, Organizing Report Data, Formatting Reports, Basic Queries, Multiple Table Queries, Table Relationships
more...
Microsoft Excel 2000 XP 2003 Level 2 Med
This course will consist of: Formulas In Exce, Functions, Names & Ranges, Array Formulas, Lists & filters, Records & Fields, Macros, Excel as a Database, Form Controls
more...
Microsoft Excel 2000 XP 2003 Level 3 Advanced
This course will consist of: Outlining And Grouping Your Data, Pivottables, Excel And Hyperlinks, Workbooks As Web Pages, Creating And Using Shared Workbooks, Visual Basic And Macros, Excel Security.
more...
MS Project 2003 Level 2
Student will be able to track projects using progress lines, use earned value analysis & pert charts, create & share resource pools, work with multiple reports, import & export data & communicate within workgroups using rollup taskbars as well as macros
more...
Excel Macros & VBA Level 2-3 Days

Location: Toronto Date: 2007-09-05
List Price: $825 Offered Price: $575.00
Seats Available: 2
This course builds on the topics covered in the first Macros course, and covers further techniques and examples for programming Excel with VBA.
This course is classroom style instruction: Instructor-led, hands-on training.
more...
Excel Macros & VBA Level 2-3 Days

Location: City of Mississauga Date: 2007-09-10
List Price: $825 Offered Price: $575.00
Seats Available: 2
This course builds on the topics covered in the first Macros course, and covers further techniques and examples for programming Excel with VBA.
This course is classroom style instruction: Instructor-led, hands-on training.
more...
From Linking Savannah, GA
Data Manipulation Techniques
Using a popular statistical software package you will learn basic data manipulation tasks such as: Bringing in different types of files (SPSS, SAS, txt, dat., excel, use the ODBC, etc); Clean data and address such issues as missing data, duplicate entries, outliers; Reshaping, aggregating, merging data; Performing such tasks as looping, vectors, beginning automations with macros specific to data
more...
From Amplios Academy
Financial Modeling Workshop 2 Day



...many employees are able to build simple models and to use macros, much potential benefit and management productivity improvement is left unrealized as the simple steps to the next level of improvement of the solutions developed are unknown.
In this course, participants learn the principles behind accounting, finance and statistics and how to use functions and macros to represent them in Excel.
more...
From NR Computer Learning Center
MS Excel 2010 Advance 1 Day







Microsoft ® Office Excel 2010 a Advanced teaches students how to use some more complex features to use with different types of reports. Students will look at productivity tools to increase data entry, features to enable collaboration with others, and use various commands to analyze large numerical reports. Target Audience
This course is for the individual whose job responsibilities
more...
Microsoft Access 2010 Intermediate









Your training has provided you a solid foundation of basic and intermediate skills in Microsoft ® Office Accessa 2010. You have worked with the various Access objects, such as tables, queries, forms, and reports. In this course, you will extend your knowledge into some of the more specialized and advanced capabilities of Access by structuring existing data, writing advanced queries, working
more...
From Act Training
Excel Level 3
Advanced level one day hands-on instructor led course on Microsoft Excel. Topics include: Customizing the Work Area; Advanced Formula Construction; Using Pivot Tables; Working with Multiple Worksheets; Consolidating and Analysing Data; Using Protection and Display Options; Introduction to Macros; Working with Interactive Excel Web Documents.
The prerequisite for this course is Excel Level 1 &
more...
Word Level 2
Intermediate level one day instructor led course on Microsoft Word. Topics include: Working with Sections, Managing Tables and Table Data, Using Mail Merge, Styles and AutoText, Introduction to Templates, Introduction to Macros, The Internet and the Web.
The prerequisite for this course is Word Level 1 or equivalent knowledge.
The next course in the series is Word Level 3.
more...
Access Level 3
Advanced level one day hands-on instructor led course on Microsoft Access. Topics include: Parameter and Action Queries, Query Joins and Crosstab Queries, Using Advanced Form Techniques, Creating Basic Macros to Automate Forms, Using Macros to Provide User Interaction and Automate Tasks, Using Advanced Report Techniques, Web Capabilities and Data Integration.
The prerequisite for this course is
more...
From FOSVA Training
Microsoft Access 2010 Level 3
...e a PivotTable and a PivotChart
Simplifying Tasks with Macros
a Create a Macro
a Attach a Macro
a Restrict Records Using a Condition
a Validate Data Using a Macro
a Automate Data Entry Using a Macro
Creating Effective Reports
a Include a Chart in a Report
a Print Data in Columns
a Cancel Printing of a Blank Report
a Publish Reports as PDF
Maintaining
more...
Microsoft Word 2010 Level 2
...ate document creation
Use the mail merge function
Use macros to automate common tasks
Target Audience
This course is designed for students who are able to create and modify standard business documents in Microsoft Word 2010 but need to know how to create or modify complex business documents and customised Word efficiency tools.
Pre Requisites
Students should be able to use
more...
Microsoft Word 2003 Level 3
...ments, how to create charts, links to other applications, macros, advanced table and formatting techniques and how to protect documents.
Target Audience
Anyone wishing to improve their knowledge of Microsoft Word or those who are working with large documents and wish to learn the more advanced features of this package.
Pre Requisites
Delegates who have or are using Microsoft
more...
Microsoft Excel 2010 Level 3
Course Benefits
Upon successful completion of this course students will be able to:
Enhance productivity and efficiency by streamlining the workflow
Collaborate with other workbook users
Audit worksheets
Analyse data
Work with multiple workbooks
Import and export data
Integrate Excel data with the web
Structure workbooks with XML
Target Audience
This course is designed
more...
Microsoft Excel 2007 Level 3
... students desiring to gain the skills necessary to create macros, collaborate with others, audit and analyse worksheet data, incorporate multiple data sources, and import and export data. This course is also for students who already have knowledge of the basics of Excel, including how to create, edit, format and print worksheets that include charts and sorted and filtered data.
Pre
more...
Microsoft Excel 2003 Level 3
... advanced level. It includes working with database lists, macros and creating and using User-Defined Functions, Using a What Ifa , scenarios, data maps and pivot tables. Also teaches about importing and exporting data, linking and embedding and protecting data.
Target Audience
Those wanting to learn how to use Excel to a high level and in much more depth a suitable for accountancy
more...
Microsoft Excel 2003 Level 2
Course Benefits
Teaches you how to use multiple worksheets, workbooks and workspaces and create financial functions and use advanced formatting techniques including auditing, charts, macros and template creation.
Target Audience
Those wanting to learn how to use financial formulae to a higher level in Excel.
Pre Requisites
Microsoft Excel 2003 Level 1 or a good understanding of
more...
From Professional Automation Support Services Ltd
Concept Level 2

Objectives a By the end of the course students will be able to:
- Configure a PLC
- Use security features
- Programme in all 5IEC languages
- Create and use DFBs
- Create and use macros
- Create and use DDTs
- Create documentation
- Export /Import programmes
Content
a Quantum hardware modules and configuration
a IEC 1131-3overview
a Programming languages FBD, SFC, LD,
more...
From IT's Easy Software Training
Advanced Excel

a Customising a Toolbar
a Using Solver
a IF Statements
a Advanced VlookUp and SUMIF
a IF And
a Logical Tests, Error Trapping
a Using Form Tools
a Data Validation
a Advanced Pivot Tables Formulae
a Recording Basic Macros
a Importing External Data
a Using Named Ranges in a Formula
a Advanced Database Filters and functions
a Advanced Scenarios
a
more...
From Acend Corporate Learning
Customized Microsoft Excel Training in Toronto






...* Analyze data
* Work with Excel on the Web.
* Create macros
* Collaborate with others
* Audit and analyze worksheet data
* Create PivotTables and PivotCharts
* Incorporate multiple data sources
* Import and export data.
Upon enrolment in our Customized Excel Training, you will receive free skills assessments that will identify which of the following areas are needed and you
more...
From Aspect Training
Microsoft Access Advanced
Aspect Traininga s Microsoft Access Advanced Training course is designed for those users who wish to step their current knowledge of Access to take advantage of the more complex features. On completion delegates will understand relational databases and be able to work with related tables. They will learn how to generate much more complicated queries and create more advanced forms and reports
more...
Microsoft Word VBA
Get ready to take your Word Documents to the next level by harnessing the power of the VBA language. Aspecta s Word VBA course will help you gain more control over your documents by using VBA while also showing you how to develop more dynamic Word forms for other users. From introductory concepts to advanced developer topics, it guides you through every aspect of Word VBA.
Aspecta s Word VBA
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...
Excel Advanced
... students desiring to gain the skills necessary to create macros, collaborate with others, audit and analyze worksheet data, incorporate multiple data sources, and import and export data. After Aspecta s Advanced Excel training you're likely to walk away with countless ideas for streamlining your daily activities and enhancing the usefulness of your data. On this course , you'll scratch the
more...
Microsoft Excel VBA
Get ready to take your Excel applications to the next level by harnessing the power of the VBA language. Aspecta s Excel VBA course will help you gain more control over your spreadsheets by using VBA while also showing you how to develop more dynamic Excel applications for other users. From introductory concepts to advanced developer topics, it guides you through every aspect of Excel VBA.
more...
Microsoft Word Advanced
Microsoft Word is the world's number one word processing application. Word documents are so ubiquitous that they are almost an IT standard in themselves. But Microsoft Word is a whole lot more than a simple word processor. It is a communication tool that allows you to share information in attractive and presentable formats. You know how to use Microsoft Office Word to create and format typical
more...
From New York Interactive Media
Advanced Excel 2003 for Business
...* Save time with recording and replaying straight forward macros
* Quickly organize and analyze large amounts of raw data with Pivot Tables and Charts
* Increase your Excel knowledge with efficiency techniques, advanced formulas and collaborating techniques.
Examples of people who will benefit greatly from this class:
* Those working with databases
* Those who have been
more...
From Mohd Arsalan
2 Day VBA-Excel Live Training-Hyderabad
...Macros in Hyderabad. An insructor led training with 1: 1 man-pc ratio in a world class training infrastructure at Madhapur which will make you comfortable writing your own VBA code and automating reports and processes at your work.
Now a days more and more companies are looking for candidates who have knowledge of automation. Just knowing excel is not enough. More emphasis is being given for
more...
Advance Excel and VBA Macros -2 Day Workshop(22nd & 23rdJan)-Hyderabad
An insructor led training with 1: 1 man-pc ratio in a world class training infrastructure at Ameerpet. This workshop provides a road map to the world of VBA for Ms-Excel. Many excel users fancy the terms "macro" or "writing a vba code". This workshop aims to give them a perfect platform to learn vba coding from Scratch. Before jumping to VBA I will explain the advance features of excel-2007 with
more...
From Learn Excel Class
Excel VBA
...raining teaches the strengths and weaknesses of recording macros, how to use and pass variables, if/ then statements and loops like for/ next and do/ while. You will also learn how to call functions, how to write your own functions, how to create forms, how to use workbook events to add buttons to toolbars, and how to connect to a database. No other school offers students access to a video
more...
Advanced Excel Class
...e features (validations, extract unique values), advanced macros (with light VBA programming) and collaboration techniques.
Advanced Excel Training Objectives:
* Advanced Excel Formulas:
Named Ranges, Vlookup, Index, Match, If, SumIf, IsError, Text Functions, Formula Auditing and more
* Advanced Data Analysis: What-If Analysis with Pivot Tables
* Database Features:
more...
From Mohd Arsalan
VBA Training workshop-Hyderabad 19th of June
...Macros workshop is intended for professionals who currently have experience on Excel and wish to write VBA code to automate their tasks. The workshop aims at educating you on how to write a vba code from scratch and developing fully functional application with user-form controls. With 1: 1 man machine ratio, the attendees will be provided ample time to follow and try the examples practically.
more...
VBA for Excel Macros
This program intends to impart the knowledge of creating macros in excel using Visual Basic application. An individual after completion will be able to automate the routine manual excel activities by writing a macro code. The program starts from basic of programming for dummies to creating user forms, command buttons, event programming.....This is delivered as an online webcast or as a live
more...
From Zilogic Systems
Zilogic ARM Embedded systems Training
...reprocessor
* Preprocessor Constants
* Preprocessor Macros
* Macro Pitfalls
* Conditional Compilation
* Stringization Operator
Embedded System Programming
Hardware Fundamentals
Embedded Systems
* What Is an Embedded System?
* Define the components of an embedded systems
Digital Electronics
* Logic Gates
* Flip flops
* Clocks
* Counters and Shift Registers
*
more...
From American Academy of Computer Training & Technology, Inc.
Microsoft Excel - Part III




Work with advanced formulas, as well as lookup functions such as VLOOKUP, MATCH, and INDEX. Learn about data validation and database functions such as DSUM. Work with PivotTables and PivotCharts, import and export data, and query external databases. Learn about the analytical features of Excel (such as Goal Seek and Solver), running and recording macros, and sharing Excel data via the Web.
more...
Microsoft PowerPoint - Part II




Learn to customize PowerPoint by modifying the Quick Access Toolbar and creating macros. Apply themes and templates, and work with SmartArt graphics and tables. Add multimedia content and interactive elements to slides, and learn about presentation distribution options including PDF and HTML. Integrate PowerPoint with Word and Excel. Prerequisite: PowerPoint Part I or equivalent.
more...
From Advanced Concepts
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 Word Advanced
Course Specification:
Course Length: 1 day/2 evenings
Course Level: Advanced
Software: MS Word xp/2003/2007 Professional
Course Description:
MS Word Advanced course will enable students to perform on Word more professionally. Delegates will be able to perform most of the functions Word have.
Target Students: Students with knowledge on MS Word xp/2003/2007.
Prerequisites: Windows
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 Miracle Infocom
Corporate Training Programs












...
Office Automation
MS Office XP
Advanced Excel and Macros
MS Access
Open Office
Ms Project 2002
Ms Project Central 2000
Programming with MS Project Central 2000
MS Project Server 2002
Crystal Reports
Internet
HTML
XML
Others
Programming Logic
We at Miracle Infocom have conference and training rooms made available to companies for holding
more...
From Tekguru Career Development Company
Desktop Applications Courses

...ity. From "How to Build and Use Word Tables" to "Building Macros for Excel," TEKGURU can customize and deliver interactive training to assist students with their specific problems or questions.
Improve your productivity and enhance your effectiveness at TEKGURU.
Courses under this program are:
- Microsoft Word Level 1
- Microsoft Word Level 2
- Microsoft Excel Level
more...
From Navigator Project Finance
VBA for cashflow models


... can cause more problems than it solves.
Do you need VBA macros in your financial models?
This course gives you the skills and confidence to write your own code and expand your analytical skill set beyond the standard Excel functionality. It is targeted at analysts who need to build complex but efficient financial models or who want to improve their ability to work with models developed by
more...
From Knowledge Source Inc
Microsoft Access 2010 Level III Advanced
Length: 1 day
Prerequisites: Microsoft Access 2010 Level I and Level II or equivalent knowledge
Course Level: Advanced
This course includes a Blended Learning Bonus Pack. In addition to the instructor-led course and book, participants will also receive the following bonus on-line materials for 12 months at no additional charge:
Microsoft Office Access 2010 Level III Knowledge Assessment
more...
Microsoft Excel 2007 Level III Advanced
builds on the skills and concepts taught in Excel 2007: Intermediate. Students will work with advanced formulas, as well as lookup functions such as VLOOKUP, MATCH, and INDEX. In addition, students will learn about data validation and database functions such as DSUM. They will learn how to work with PivotTables and PivotCharts, how to import and export data, and how to query external databases.
more...
Excel Macro Programming Level I
...cipants will be able to:
Use the VB Recorder to create macros
Learn and practice six different ways to run macros
Learn how to open the Visual Basic Editor (VBE)
Understand the VBE interface
Use 4 simple rules for learning the Visual Basic for Application language (VBA)
Practice simple edits in VBA using messaging tools, simple branching statements and a looping construct
more...
Microsoft Access 2007 Level III Advanced
The Level III course is for the individual whose job responsibilities include working with related tables; creating advanced queries, forms, and reports; writing macros to automate common tasks; and performing general database maintenance.
more...
Microsoft Project 2007 Crash Course Learn Project in Two Days
...t Guide
Status Indicators
Lesson 11: Using Macros
Recording / Editing / Deleting Macros
Copying Macros from Other Project Files
Visual Basic and Macros
Visual Basic for MS Project 2007
Lesson 12: Analyzing Your Project
Analyzing Your Project
PERT Analysis
Scenarios
Earned Value Analysis
Lesson 13: Expert Topics
Working with Forms
more...
Microsoft Excel 2007 Macros Crash Course Learn VBA Programming in Two Days
Overview
Save time and increase productivity by automating mundane and repetitive tasks with Macros and VBA procedures. Develop a strong understanding of the Excel 2007 object model used in VBA. Learn advanced Variable concepts. Exploit VBA tools and functions.
more...
From Training-2-Go
Excel 2007 - Advanced
Advanced functions
Lookups and data tables
Advanced list management
PivotTables and PivotCharts
Exporting and importing
Analytical options
Macros and custom functions
Conditional formatting and SmartArt
more...
From Computer Training Source, Inc.
Microsoft Excel Advanced
...at numbers, use the solver, sort and filter lists, create macros, learn spreadsheet protection and validation, master data validation, merge and link workbooks, and use advanced data analysis tools. 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
more...
Microsoft Access Advanced
..., 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 thirty days of technical support. Class is usually one day
more...
From D. H. D"Urso & Associates
AIA101 Accelerated Introduction to Microsoft Access

Accelerated Introduction to Microsoft Access course for experienced Microsoft Office users. Corresponds roughly to material required for MOUS proficient level plus some additional material. Covers tables, external data, queries, forms, reports and macros. Students will create a working database application during this intensive, hands-on course. This database can be tailored to the needs of custom
more...
From General Computers
MS Excel Macro L2
The participant should be able to record and modify recorded macros in Excel, to understand the basic VBA codes, to write macro with VBA code manually, to control and loop blocks of instructions and to create custom dialog box to run macros.
more...
MS Excel Macro Level 1
Participants will be able to record macros, to edit and to run macros, to enhance macros with the use variables in the macro VBA codes
more...
From Moviola Digital Education Center
Introduction to Ableton Live

What is Live?
Ableton Live is a loop-based music sequencer and DAW that is designed as an instrument for live performance as well as a tool for DJ's. Live utilizes "Elastic Audio" which allows users to stretch, and automatically beat match songs making it a quick favorite among DJ's and remix artists.
This class covers:
Composing with Live
DJ'ing with Live
Beat matching & Creating
more...
From Silverbrook Financial Learning center
Financial Modeling with Excel
History of spreadsheets, Excel functions, Modeling techniques, capital structure analysis, cost of capital modeling, Discounted cash flow, Macros, corporate finance transactions, Validation and control, Evaluation of newly built-in model
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 2e2
Microsoft Access Specialised
...erstand hyperlinked and data access pages, create and use macros, design advanced data queries and implement Access security features.
Prerequisites: This course is designed for students who have completed the Access Database Fundamentals course or have equivalent knowledge. It is not suitable as an introduction for people who have little or no experience with this software.
Target Audience:
more...
Microsoft Word Advanced
Objectives: By the end of this course you will be able to create and manage data lists for merging purposes, use the referencing tools to add navigation and add additional information to documentation, create macros to eliminate repetitiveness and design forms with added intelligence, using the provided manual if required.
Prerequisites: This course is designed for students who have completed
more...
Microsoft Excel Advanced
...d pivot tables to manage large worksheets. Run and record macros to automate complex or repetitive tasks. Publish a worksheet as an interactive Web page. Apply financial formulas and array formulas in Data Tables to determine outcomes.
Prerequisites: This course is designed for students who have completed the Excel Intermediate or have equivalent knowledge. It is not suitable as an
more...
From Dataspark
ExcelVBMS Access training in Bangalore
...nctions, Text, database functions and Data consolidation, macros writing in Excel/ VBA. Duration: 20hrsa .
2. VBA/ macros programming in Excel.
Introduction to VBA, VBA Procedures, User Forms, Creating Multiple Pivot Table, Modifying Pivot Table, Excela s Events, Interacting with Other Applications, Controlling Program Flow and Making Decisions IF, If Else, Else if, Select...While
more...
From Peopleclick Technosolutions Pvt. Ltd
sap abap training in bangalore with realtime scenarios
...ues.
o Includes.
o Subroutines.
o Function modules.
o Macros
a Variants.
a Conversion exits.
a For all entries and joins (inner and left outer).
a Message class creation & message types and handling messages.
a Events for classical reports.
a Events for interactive reports.
a Hide and hotspot.
a Creating and handling buttons.
a Menu painter.
ABAP OOPS
a
more...
From SMART SHEETS
Excel Macro and VBA Training Program from Smart Sheets in bangalore
Getting bugged with too much work in office?
Do you Work a lot on MS Excel? Want to Automate the manual or every day tasks you perform in MS Excel?
Looking to gain productivity in your organization by performing process automations?
Here is an opportunity to learn and become an Excel VBA Expert and be a automation expert in your office.
We, at Smart Sheets announce Excel VBA Training Program
more...
From GITS Academy
MS Excel Advacned training Bangalore
...nctions, Text, database functions and Data consolidation, macros writing in Excel/ VBA. Duration: 22hrsa .
2. VBA/ macros programming in Excel.
Introduction to VBA, VBA Procedures, User Forms, Creating Multiple Pivot Table, Modifying Pivot Table, Excela s Events, Interacting with Other Applications, Controlling Program Flow and Making Decisions IF, If Else, Else if, Select...While
more...
From MasterSkills Learning Solutions
Financial Modeling using Microsoft Excel
Course Highlights :
a Microsoft Excel Introduction a Standard Toolbar a Formatting, Drawing & Status Toolbar a Excel Options a Sorting, Filtering a Pivot Tables a Functions - Basic, Logical, Text, Date, Time a Lookup & Reference a Conditional Formatting a Cell, Row, Column & Sheet a Data Validations a Linking Worksheets a Hyperlinks a Referencing a
more...
From GITS Academy
business analysis Training in Bangalore
...ent software. Our training includes Base/ SAS, SAS/ Stat, Macros, Graphs SQL, ODS Access.
We also provide in-depth Training in advance SAS Products like Advance Statistical Procedures, Macros, SQL, Eminer and Eguide etc.
Analytics with SPSS
--------------------------
SPSS is among the most widely used programs for statistical analysis in social science. It is used by market researchers,
more...
SAS Training in Bangalore
...AS BASE
o SAS STAT
o SAS GRAPH
o SAS MACROS
o SAS SQL
o SAS ODS
o SAS ACCESS
We also provide indepth Training in advance SAS Products like Advance Statstical Procedures, Macros, SQL, Eminer and Eguide etc.
Our Specialties:
o Special Guidance for Base/ SAS and Advance/ SAS Certification.
o Real Time Exposure with Project work
more...
From Corporate Education Group
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...
Excel 2003 Level III
... students desiring to gain the skills necessary to create macros, collaborate with others, audit and analyze worksheet data, create PivotTables and PivotCharts, incorporate multiple data sources, and import and export data. In addition, the course is also for students desiring to prepare for the Microsoft Office Specialist exam in Excel 2003 or Module 2-Key Applications of the Internet 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 Applied Computer Training & Technology
Advanced Word



Students enrolling in these courses will learn creating and revising business documents using Word. It is also intended for persons desiring to prepare to be a certified Microsoft Office Specialist (MOS) in Word.
Students will create and distribute a form, automate tasks by writing and revising macros, create references to information in a document, prepare a document for publication, revise
more...
