Instructor Led Data Training Classes in Canada

Microsoft Excel 2003 Level 2 ...ed to streamline repetitive tasks and display spreadsheet data in more visually effective ways. In this course, you will use Microsoft Excel 2003 to streamline and enhance your spreadsheets with templates, charts, graphics, and formulas. Upon successful completion of this course, students will be able to: * create and apply templates. * create and modify charts. * work  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...

Access 2003 - Level 2 1 Day ... - follow the steps required to properly design a simple database. - create a new database with related tables. - control data entry by modifying the design of a table to streamline data entry and maintain data integrity. - find and retrieve desired data by using filters and joins between tables and within a single table. - create flexible queries to display specified records; allow  more...

Excel Introduction - Level 1 This course provides competency in creating workbooks, modifying worksheets, formatting worksheets and printing worksheets. This course also provides competency in creating and editing formulas, working with basic functions and the Function Wizard, applying text attributes and other formatting characteristics, creating workbooks from templates, using styles, adding worksheet backgrounds, applying  more...

Microsoft Word Training - Intermediate Upon completion you will be comfortable using the Mail Merge function with different data sources; able to apply various Styles, Templates and Forms that ensure document consistency; learn how to generate a Table of Contents and Indexes.  more...

MS Excel Level 1 Training Seminar 1 Day In this course, students will create basic worksheets and charts, enter text and values, work with cells, cell data and copy and move data, use formulas, functions and format worksheets, work with multiple sheets by formatting, repositioning, copying, moving, adding and deleting worksheets, create a chart and set the page display and printing options.  more...

Crystal Reports Introduction (2 Days) Some database programs have limited reporting tools, or the user may not have sufficient programming or SQL knowledge to create some reports. This course is intended to introduce the use of Crystal reports to produce reports from almost any database data (for example, Microsoft Access). This course is classroom style instruction: Instructor-led, hands-on training.  more...

Access 2007 - Level 2 (1 Day) As you begin this course, you should have the basic skills you need to work with a Microsoft Office Access 2003 databases. This includes working with Access tables, relationships, queries, forms, and reports. But thus far you have been focusing on essential database user skills only. In this course you will consider how to design and create a new Access database, how to customize database  more...

Access Intermediate - Level 2 This course provides competency in creating and using forms and sub forms, using advanced form features, creating and using reports, using advanced report features, enhancing forms and reports, using data access pages, managing databases, and importing and exporting data.  more...

Creating Dynamic Presentations with PowerPoint ...tting, working with tables, images, and objects, charting data, and presentation preparation. Learn the tips and tricks that make this easy-to-use package the best in the market: * Learn how to be more efficient when creating presentations. * Find methods to make your presentations more exciting with new ideas to really grab interest. * Add images and drawing objects to  more...

Adobe Flash CS3 - Level 2 As a web developer, you want to create engaging experiences for the visitors to your sites. Thus far, you have probably created straightforward HTML or Flash files with simple animations using prebuilt components. In this course, you will create rich Internet applications with Adobe Flash CS3 using ActionScript . The site you create will pull data from external sources, so it will respond  more...

Microsoft Excel 2003 - level 2 ...a powerful spreadsheet package for working with numerical data. It easily does calculations and allows you to manipulate, track and store the data. This session is designed to give those who are already familiar with the basics of Excel the opportunity to use more advanced techniques in their spreadsheets. In this session, participants will: * apply intermediate formats and styles to  more...

Excel Advanced - Level 3 This course provides competency in validating data, creating and modifying list ranges, sorting database data, using database functions, using the Advanced Filter and Automatic Subtotal features, creating and modifying PivotTables and Pivot Charts, formatting and adjusting PivotTables, auditing worksheets, performing what-if analyses, and working with scenarios.  more...

Project 2003 - Level 2 Upon successful completion of this course, students will be able to: * exchange project plan data with other applications. * update a project plan. * create custom reports. * re-use existing project plan information.  more...

QuickBooks 2007 Level 1 QuickBooks Pro 2007 Level 1 teaches you how to perform daily accounting tasks in the General Ledger, Accounts Receivable, Accounts Payable, and Payroll. This course is geared towards someone who will primarily be doing data entry into QuickBooks.  more...

Access 2003 Introduction 2 Days This course provides the first step in learning how to use this powerful database program. The objective is to provide participants with an understanding of Table design, entering data, and building Queries to manipulate data. Forms and Reports are briefly introduced using the Wizards provided. This course is classroom style instruction: Instructor-led, hands-on training.  more...

Excel 2007 - Level 1 Upon successful completion of this course, students will be able to: * explore the Excel 2007 environment. * work with an Excel worksheet by entering and selecting the data in it. You will also save the data in the worksheet. * modify a worksheet. * perform calculations. * format a worksheet. * develop a workbook. * print workbook contents. * customize the  more...

Excel Intermediate - Level 2 ...ourse provides competency in organizing and consolidating data from multiple worksheets, adjusting the screen display, working with advanced functions, using advanced formatting features, using advanced print options, filtering data, using comments, naming worksheet ranges and formulas, creating and modifying charts, protecting data, importing and exporting data, saving worksheets and workbooks  more...

Crystal Reports Introduction Provides competency in creating reports from a database. Create list report, displaying data , grouping report data, building formulas, formatting reports, enhancing reports, creating and modifying pie charts and distributing data.  more...

Access Introduction - Level 1 This course provides competency in database fundamentals, working with Access objects, creating databases and tables, working with table data and structure, locating information, working with related tables, using select queries and advanced query features, and creating advanced queries.  more...

Microsoft Excel 2007 Level 2 In Microsoft Office Excel 2007: Level 1, you created, edited, formatted, and printed basic spreadsheets. You now have a need to streamline repetitive tasks and display spreadsheet data in more visually effective ways. In this course, you will use Microsoft Office Excel 2007 to streamline and enhance your spreadsheets with templates, charts, graphics, and formulas.  more...

Microsoft Office Visio Professional 2007 - Level 1 Diagrams and charts play a pivotal role in knowledge dissemination, making complex data easy to understand. Microsoft Office Visio Professional 2007 has a host of features that are instrumental in creating pictorial representations of information. In this course, you will learn the essentials of Visio.  more...

Microsoft Office PowerPoint 2003 Level 1 In the past, you have used paper-based overhead systems to give presentations. Now, you want to upgrade those presentations to an electronic format. You can use Microsoft Office PowerPoint 2003 to give electronic presentations. Upon successful completion of this course, students will be able to: - manipulate an existing PowerPoint presentation. - begin creating a presentation. - format  more...

Access 2007 Introduction 2 Days This course provides the first step in learning how to use this powerful database program. The objective is to provide participants with an understanding of Table design, entering data, and building Queries to manipulate data. Forms and Reports are briefly introduced using the Wizards provided. This course is classroom style instruction: Instructor-led, hands-on training.  more...

Excel 2003 - Level 1 You have basic computer skills such as using a mouse, navigating through windows, and surfing the Internet. You have also used paper-based systems to store data that you run calculations on. You now want to migrate that data to an electronic format. In this course, you will use Microsoft Office Excel 2003 to manage, edit, and print data.  more...

Microsoft Access Introduction (2 Days) ...database management system from Microsoft which combines the relational Microsoft Jet Database Engine with a graphical user interface and software development tools. It is a member of the Microsoft Office system. In this 2-day introductory course for Microsoft Access, users will learn: The Basics Table Data Table Design Data Entry Relationships Creating And Using Forms Queries  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 Excel2003 - Level 3 ...ros, 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 worksheets. * Analyze data. * Work with multiple workbooks.  more...

Microsoft Excel 2007 Level 1 Upon successful completion of this course, students will be able to: * explore the Excel 2007 environment. * work with an Excel worksheet by entering and selecting the data in it. You will also save the data in the worksheet. * modify a worksheet. * perform calculations. * format a worksheet. * develop a workbook. * print workbook contents. * customize the  more...

Microsoft Excel - Intermediate Training Upon completion of the course, you will be familiar with the following: Advanced formulas, using range names in formulas, managing worksheets within workbooks, using advance formatting techniques, creating and printing charts as well as sorting data in alphanumeric order. This course is focused on intermediate training. It is recommended that you have basic knowledge of Excel or equivalent  more...

Microsoft Access XP 2003 Level 1 ...Database Objects * Working with Multiple Windows * Adding, Editing, and Deleting Records * Tour of a Form, Query, or a Report * Planning and Creating a Database * Create a Table Using the Table Wizard * Create a Report Using the Report Wizard * Create a Form Using the Form Wizard * Database Object Management * Finding, Filtering, and Formatting Data  more...

System Manager - Report Writer The System Manager is the central module for your Sage Accpac for Windows system. In this course you learn how to define Common Services, and setup up Administrative Services Topics Include: * Creating and activating new company databases * Navigating around the Sage Accpac for Windows program * Using the SmartFinder * Activating other installed modules  more...

Microsoft Excel XP 2003 Level 1 After completing this course, participants who attend this seminar will be able to: * Navigate worksheets, document windows, and the application window * Manage and manipulate Excel files * Edit data * Work with ranges * Create simple formulas * Use built-in Excel functions * Cut, copy, paste data * Format column width, row height, fonts, styles, borders  more...

Microsoft Excel 2007 - Level 2 In Microsoft Office Excel 2007: Level 1, you created, edited, formatted, and printed basic spreadsheets. You now have a need to streamline repetitive tasks and display spreadsheet data in more visually effective ways. In this course, you will use Microsoft Office Excel 2007 to streamline and enhance your spreadsheets with templates, charts, graphics, and formulas  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...

Excel 2007 - Level 3 In this course, you will extend your knowledge into some of the more specialized and advanced capabilities of Excel by automating some common tasks, applying advanced analysis techniques to more complex data sets, collaborating on worksheets with others, and sharing Excel data with other applications.  more...

Excel 2003 - Level 3 ...ros, 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 Computing Core Certification (IC3) exam, and who already have  more...

MS Access 2003 VBA Macros Location: City of Mississauga Date: 2008-05-13 List Price: $650 Offered Price: $520. 00 Seats Available: 2 Participants will be able to accomplish the following: * Understand key concepts that will be used to build custom solutions using Microsoft Access VBA Macros * Become familiar with basic macro techniques for recording, writing, running, and maintaining a macro *  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 Advanced Upon completion of the course, you will be able to work with Outlines, Subtotals, Data Forms and Autofilter. You will also be comfortable using Pivot Tables and Charts as well as importing and exporting data.  more...

WordPerfect Training - Intermediate Level Upon completion of the course, you will be able to work with Outlines, Subtotals, Data Forms and Autofilter. You will also be comfortable using Pivot Tables and Charts as well as importing and exporting data.  more...

Microsoft Excel XP 2003 Level 2 After you complete this course you will be able to do the following: * Name and Reference Cells * Protect Data * Create Links * Use Basic Excel Functions * Create Charts * Create Databases * Work with Data Series ... Participants who complete this course will receive a certificate of completion as well as a course manual ...  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...

Excel 2007 - Level 2 ...the skills necessary to create templates, sort and filter data, import and export data, analyze data, and work with Excel on the web: In Microsoft Office Excel 2007: Level 1, students have created, edited, formatted, and printed basic spreadsheets. They now have a need to streamline repetitive tasks and display spreadsheet data in more visually effective ways. In this course, students who take  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...

MS Access Level 1 Training Seminar This course will provide you with the skills necessary to begin using Access. Topics include designing and creating databases, tables, queries, forms and reports. Day 2 focuses intermediate Access skills, including table relationships, referential integrity, how to integrate data with other applications, modify table design to control data entry, find data, filters, queries, customize forms and  more...

Microsoft Excel - Intermediate Training - French Instructions, English Software Upon completion of the course, you will be familiar with the following: Advanced formulas, using range names in formulas, managing worksheets within workbooks, using advance formatting techniques, creating and printing charts as well as sorting data in alphanumeric order.  more...

Flex 3 and LiveCycles - Integrating with Data and Messaging This two day course instructs developers how to connect with remote data using web services and LiveCycle Data Services' features allowing communication with a Java-based server environment. In addition, skills will be learned how to manipulate and format the returned data.  more...

Excel Datalist Management ...ng: * Add, edit, search for, and delete records in a data list using a form, as well as look up data * Sort records in a data list using a variety of methods * Filter data in a list using a variety of methods, as well as work with filtered data * Create and work with subtotalled lists, as well as use various database functions to summarize data * Create, modify, and work  more...

CATIA V5 Expert Mechanical Designer V5E (5 days) Learn how to: * Create a complex model in CATIA V5 * Create and manage a structured model * Design parts in the context of an assembly * Re-use existing data to complete assemblies * Manage relationships between assembled parts * Analyze and annotate your design  more...

Inventor Advanced (5 Days) This course is intended for new Autodesk Inventor customers, 2D drafters wanting to learn 3D design modeling techniques. It requires that you have the Inventor Essentials prerequisite class. This course is designed to provide attendees with a thorough coverage of 3D Mechanical Computer-aided Design (MCAD) techniques using Autodesk Inventor 7. Attendees explore complex sketching and constraining  more...

Microsoft Access 2003 - Level 2 As you begin this course, you should have the basic skills you need to work with a Microsoft Office Access 2003 databases. This includes working with Access tables, relationships, queries, forms, and reports. But thus far you have been focusing on essential database user skills only. In this course you will consider how to design and create a new Access database, how to customize database  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...

Crystal Reports Introduction-2 Days ...xplore topics such as: Creating a List Report; Displaying Data in a Report; Grouping Report Data; Building Formulas; Formatting Reports; Enhancing Reports; Creating and Modifying Pie Charts; and Distributing Data. This course will run for two days, from 9:00 am to 4:00 pm. Training manuals are included in the pricing, as well as a Certificate of Completion from CBiT. Along with the price, we  more...

Crystal Reports 11 Level 1 - English ...xplore topics such as: Creating a List Report; Displaying Data in a Report; Grouping Report Data; Building Formulas; Formatting Reports; Enhancing Reports; Creating and Modifying Pie Charts; and Distributing Data. This course will run for two days, from 9:00 am to 4:00 pm. Training manuals are included in the pricing, as well as a Certificate of Completion from CBiT. Along with the price, we  more...

Adobe Acrobat 8 Level 1 Adobe Acrobat 8 software enables business professionals to reliably create, combine, and control Adobe PDF documents for easy, more secure distribution, collaboration, and data collection. This course will teach you the fundamentals to this software.  more...

Blackberry End-User Training (1 Day) During this course you will learn how to maximize your efficiency as a BlackBerry end-user. Topics include: time-saving short-cuts for phone, email messages, calendar, and general tips, customizing settings, backing up data, synchronizing with Microsoft Outlook, saving keystrokes with AutoText, using BlackBerry Messenger to PIN other users, using the MemoPad, working with Maps, setting and using  more...

Blackberry End-User Training (1 Day) During this course you will learn how to maximize your efficiency as a BlackBerry end-user. Topics include: time-saving short-cuts for phone, email messages, calendar, and general tips, customizing settings, backing up data, synchronizing with Microsoft Outlook, saving keystrokes with AutoText, using BlackBerry Messenger to PIN other users, using the MemoPad, working with Maps, setting and using  more...

Crystal Reports Level 2 - English Crystal Reports Level 2. This will build on the knowledge gained from Level 1 and create additional topics that will be studied in detail for the next level. In this course, the topics that will be studied will include: Creating Running Totals; Building Cross-tabs in Your Report; Adding Subreports; Improving Report Processing Speed; Building Dictionaries; Charting Data; and Reporting On Excel  more...

Microsoft Excel 2007 Level 1- Introduction 2 Days ...uch as Exploring the Excel Interface; Editing Worksheets; Data Entry; Creating Formulas; Advanced Formatting; Moving Data; Working with Charts; Printing and Viewing the Spreadsheet; and Getting Help. There will also be an opportunity for Lab time, where participants can practice all that they hae learned. There are no prerequisites for this course; this course will run for two full days from  more...

MS Excel 2003 VBA Macros ...nd controls to create a customized dialog box to simplify data entry Understand how to prepare an Excel Workbook containing macros and toolbars, for deployment to other users and machines Learn to customize macros with VBA source code to automate data entry tasks and enable source code protection Learn to enhance source code with variables, constants, and logical operators Learn to handle  more...

Flash Media Server 3 (3 days) This training is being provided online. If you are comfortable with using the Flash CS3 Professional authoring environment and you have knowledge of basic programming concepts as well as basic knowledge in ActionScript3, then you are ready to take this course. Flash Media Server 3: Application Development provides experienced Flash developers with the knowledge and hands-on practice they need to  more...

Microsoft Office PowerPoint 2007: Level 2 Upon successful completion of this course, students will be able to: - manipulate an existing PowerPoint presentation. - begin creating a presentation. - format text slides. - add tables to a presentation. - chart data in a presentation. - modify objects on slides. - add images to a presentation. - prepare to deliver a presentation.  more...

Microsoft Excel 2007 - Level 3 This course was designed for 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  more...

Microsoft Word Training - Intermediate (French Instructions, French Language) Upon completion you will be comfortable using the Mail Merge function with different data sources; able to apply various Styles, Templates and Forms that ensure document consistency; learn how to generate a Table of Contents and Indexes.  more...

PowerPoint Advanced OUTLINE VIEW Creating a slide using the Outline View Importing a Word document Breaking pages WORKING WITH MASTERS Using Design Templates Using Auto Content Wizards Working with Master Slide Headers and Footers TEMPLATES Apply a custom Template Design and Save a Template Deleting a Custom Template INSERTING SOUNDS AND VIDEO Changing Multimedia Settings ADD A MOVIE OR ANIMATED GIF TO A SLIDE  more...

Microsoft Excel 2007 Advanced Upon completion of the course, you will be able to work with Outlines, Subtotals, Data Forms and Autofilter. You will also be comfortable using Pivot Tables and Charts as well as importing and exporting data.  more...

Excel 2003 -- Level 2 In Microsoft Office Excel 2003: Level 1, you created, edited, formatted, and printed basic spreadsheets. You now have a need to streamline repetitive tasks and display spreadsheet data in more visually effective ways. In this course, you will use Microsoft Excel 2003 to streamline and enhance your spreadsheets with templates, charts, graphics, and formulas.  more...

MS 2273 - Managing and Maintaining a Microsoft Windows Server 2003 Environment This course combines five days of instructor-led training with additional e-Learning content to provide students with the knowledge and skills that are required to manage accounts and resources, maintain server resources, monitor server performance, and safeguard data in a Microsoft Windows Server 2003 environment. This is the first course in the Systems Administrator and Systems Engineer tracks  more...

Microsoft Access 2007 - Module 1 Basic 2 Days Objectives * Understand data base architecture and its components * Opening, closing data base and handling objects * Knowledge about table structure * Creating single queries * Creating single form and report  more...

Microsoft Access - Module 2 - Multi Table queries and relations This course is the second of seven modules (levels) that we have to offer for Microsoft Access 2000/2002/2003. Objectives * Fundamental Principles of data base * Creating multi tables queries * Working with formula and functions * Knowledge about relations * Applying referential Integrity  more...

Microsoft Excel - Module 2 Functions and Multiple Worksheets This course is the second of six modules (levels) that we have to offer for Microsoft Excel 2000/2002/2003... Objectives * Use labels and reference names in formulas * Use simple and complex mathematical * functions * Manage workbook worksheets * Perform calculations with references to multiple * worksheets and multiple workbooks * Summarize data with data  more...

Testing Use Case Driven Projects 2 Days ...ts use cases to develop test plans, test cases, and test data to support iterative and incremental development. Students will learn principles and practical tips for developing test plans and test cases iteratively. In each lesson,students are taught how to think like a tester and produce key artifacts or deliverables. During the class students will develop and refine test plans and black box  more...

Visio 2003 Professional Level 1 In this course, you'll learn fundamental skills while creating several types of diagrams using Microsoft Office Visio Professional. You will create a directional map, a block diagram, a basic and a cross-functional flowchart, an organization chart, and an office layout. As you create these drawings, you will learn techniques to drag and manipulate Visio master shapes, create connections between  more...

Microsoft Access - Module 1 Basic 2 Days Objectives * Understand data base architecture and its components * Opening, closing data base and handling objects * Knowledge about table structure * Creating single queries * Creating single form and report  more...

Microsoft Excel 2007 - Module 1 Basic 2 Days * Create and edit a worksheet * Manage Excel workbooks * Enter formulas * Format data * Print and lay out a worksheet * Represent data in a chart  more...

MS 3938 - Updating Exchange Server 2003 to Exchange Server 2007 This three-day instructor-led course teaches students how to implement a Reporting Services solution in an organization. The course discusses how to use the Reporting Services development tools to create reports, and how to use the Reporting Services management and administrative tools to manage a Reporting Services solution. After completing this course, students will be able to: Describe  more...

Dreamweaver Intermediate (2 Days) Location: Toronto Date: 2008-05-29 List Price: $825 Offered Price: $660.00 Seats Available: 2 This course looks at more advanced Dreamweaver topics, as well as creating and managing data-driven Web sites. This course is classroom style instruction: Instructor-led, hands-on training. For more information please call 1-877-313-8881 or copy this link into your browser:  more...

Microsoft Excel Advanced (Option 1) - French Instruction English Software Location: Ottawa Date: 2008-05-16 List Price: $235 Offered Price: $188.00 Seats Available: 2 Upon completion of the course, you will be able to work with Outlines, Subtotals, Data Forms and Autofilter. You will also be comfortable using Pivot Tables and Charts as well as importing and exporting data. For more information please call 1-877-313-8881 or copy this link into your browser:  more...

Crystal Reports Intermediate (2 Days) Location: Toronto Date: 2008-05-26 List Price: $1100 Offered Price: $880.00 Seats Available: 2 This course is designed for people who know how to create basic list and group reports and need to create reports that include subreports, cross-tabs, advanced formulas, and charts based on more than one data series. They may also need to build tools to make it easier for other people to create  more...

Excel Introduction (2 Days) Location: Toronto Date: 2008-05-05 List Price: $460 Offered Price: $368.00 Seats Available: 2 This course is a more extensive overview of basic Excel training than the original one-day intro. In our two-day introduction of Excel, we provide competency in creating workbooks, modifying worksheets, formatting worksheets and printing worksheets. This course also provides competency in creating and  more...

Microsoft Access 2003 - Level 2 Location: Calgary Date: 2008-05-15 List Price: $325 Offered Price: $260.00 Seats Available: 2 Microsoft Office Access 2007: Level 2 is designed for students who would like to learn intermediate-level operations of the Microsoft Office Access program. The Level 2 course is for individuals whose job responsibilities include maintaining data integrity; handling complex queries, forms, and reports;  more...

SQL Advanced ...learn advanced queries and how to add, update, and delete data, tables, views, and indexes. Students enrolling in this course should understand the basics of querying a database with the SQL command language. They should be comfortable issuing SELECT queries against one or more tables and understand query concepts, such as joins. For more information please call 1-877-313-8881 or copy this  more...

SQL Fundamentals of Querying ...se, students will be able to: * Define what a relational database is and identify some uses for the SQL language. * Recognize proper syntax for an SQL statement. * Use aggregate functions, column aliases, and mathematical expressions in a query statement. * Use the WHERE clause to select specific rows of information from a database. * Search for specific character strings or numeric data in a  more...

Microsoft Excel XP 2003 Level 2 (1 Day) Location: Vancouver Date: 2008-05-14 List Price: $199 Offered Price: $159.00 Seats Available: 2 After you complete this course you will be able to do the following: * Name and Reference Cells * Protect Data * Create Links * Use Basic Excel Functions * Create Charts * Create Databases * Work with Data Series For more information please call 1-877-313-8881 or copy  more...

Flash Media Server 3 (3 days) Location: Toronto Date: 2008-04-23 List Price: $1495 Offered Price: $1046.00 Seats Available: 2 Flash Media Server 3: Application Development provides experienced Flash developers with the knowledge and hands-on practice they need to build and deliver Streaming and Social Media applications with Flash Media Server 3. This course focuses on teaching students the Server Side ActionScript,  more...

Microsoft Excel XP 2003 Level 2 (1 Day) Location: Vancouver Date: 2008-05-09 List Price: $199 Offered Price: $159.00 Seats Available: 2 After you complete this course you will be able to do the following: * Name and Reference Cells * Protect Data * Create Links * Use Basic Excel Functions * Create Charts * Create Databases * Work with Data Series For more information please call 1-877-313-8881 or copy  more...

Blackberry End-User Training (1 Day) ...endar, and general tips, customizing settings, backing up data, synchronizing with Microsoft Outlook, saving keystrokes with AutoText, using BlackBerry Messenger to PIN other users, using the MemoPad, working with Maps, setting and using Profiles, and using the Search feature. For more information please call 1-877-313-8881 or copy this link into your browser:  more...

Microsoft Excel Introduction ... * 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 For more information  more...

Microsoft Office Excel 2007 - Level 3 ...ros, 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, format, and print worksheets that include charts and sorted and  more...

Microsoft Excel 2007 Level 2 (1 Day) ...the skills necessary to create templates, sort and filter data, import and export data, analyze data, and work with Excel on the web. In addition, this course helps prepare students who desire to take the Microsoft Office Specialist exam in Excel and who already have knowledge of the basics of Excel, including how to create, edit, format, and print basic worksheets. For more information please  more...

Microsoft Excel - Advanced Level Location: Ottawa Date: 2008-04-15 List Price: $235 Offered Price: $188.00 Seats Available: 2 Upon completion of the course, you will be able to work with Outlines, Subtotals, Data Forms and Autofilter. You will also be comfortable using Pivot Tables and Charts as well as importing and exporting data. For more information please call 1-877-313-8881 or copy this link into your browser:  more...

Microsoft Access Level 1 Training Seminar (2 Days) ...begin using Access. Topics include designing and creating databases, tables, queries, forms and reports. Day 2 focuses intermediate Access skills, including table relationships, referential integrity, how to integrate data with other applications, modify table design to control data entry, find data, filters, queries, customize forms and reports, and create data access pages. For more  more...

Microsoft Excel - Intermediate Training (French Instructions) Location: Ottawa Date: 2008-04-11 List Price: $185 Offered Price: $148.00 Seats Available: 3 Upon completion of the course, you will be familiar with the following: Advanced formulas, using range names in formulas, managing worksheets within workbooks, using advance formatting techniques, creating and printing charts as well as sorting data in alphanumeric order. For more information please call  more...

Microsoft Word - Intermediate Level Location: Toronto Date: 2008-04-10 List Price: $210 Offered Price: $168.00 Seats Available: 2 The second level to our Microsoft Word courses, the Intermediate Level offers in-depth training that is already covered in the introductory courses and then introduce more advanced features of the software. Some of the examples of topics that will be covered includes: Working with sections and columns;  more...

Microsoft Excel 2007 Level 1 ...ork with an Excel worksheet by entering and selecting the data in it. You will also save the data in the worksheet. * modify a worksheet. * perform calculations. * format a worksheet. * develop a workbook. * print workbook contents. * customize the layout of the Excel application window For more information please call 1-877-313-8881 or copy this link into your  more...

Microsoft Excel XP 2003 Level 2 (1 Day) Location: Vancouver Date: 2008-04-07 List Price: $199 Offered Price: $139.00 Seats Available: 2 After you complete this course you will be able to do the following: * Name and Reference Cells * Protect Data * Create Links * Use Basic Excel Functions * Create Charts * Create Databases * Work with Data Series For more information please call 1-877-313-8881 or copy  more...

Microsoft Excel 2007 Level 2 (1 Day) ...ed to streamline repetitive tasks and display spreadsheet data in more visually effective ways. In this course, you will use Microsoft Office Excel 2007 to streamline and enhance your spreadsheets with templates, charts, graphics, and formulas. * enhance the workbook. * automate workbook creation by using templates. * organize data using tables. * create and modify charts.  more...

Microsoft Word - Intermediate Level ...t 2: Formatting tables * Unit 3: Working with Excel data * Unit 4: Working with styles * Unit 5: Headers and footers * Unit 6: Printing labels and envelopes * Unit 7: Working with graphics and objects * Unit 8: Document templates * Unit 9: Managing document revisions * And more... For more information please call 1-877-313-8881 or copy this link into  more...

Microsoft FrontPage 2003 Level 1 (2 days) ...eb sites. It includes the professional design, authoring, data, and publishing tools needed to create dynamic and sophisticated Web sites. The purpose of our course is to teach our participants how to: * Create and publish a Web site using Microsoft FrontPage 2003 * Create and Edit web pages using a graphical interface * Format a Web Page * Working with Images and Hyperlinks  more...

Microsoft Excel XP 2003 Level 2 (1 Day) ...following: * Name and Reference Cells * Protect Data * Create Links * Use Basic Excel Functions * Create Charts * Create Databases * Work with Data Series You will also receive a certificate of completion to indicate that you have completed this course. For more information please call 1-877-313-8881 or copy this link into your browser:  more...

Microsoft Excel Advanced (French Instruction, English Software) ...ourse, you will be able to work with Outlines, Subtotals, Data Forms and Autofilter. You will also be comfortable using Pivot Tables and Charts as well as importing and exporting data. Receive a certificate of completion at the end of this course. For more information please call 1-877-313-8881 or copy this link into your browser:  more...

Microsoft Excel 2007 Level 1 ...Internet. You have also used paper-based systems to store data that you run calculations on. You now want to migrate that data to an electronic format. In this course, you will use Microsoft Office Excel 2007 to manage, edit, and print data. Course Objective: You will create and edit basic Microsoft Office Excel 2007 worksheets and workbooks. For more information please call 1-877-313-8881  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, clipart,  more...

Microsoft Excel 2003 Level 3 ... Top or Bottom Items in a Field Showing Details behind 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  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 Deleting Records  more...

Microsoft Excel Introduction ...ouse and using keyboard Using AutoFill Moving and copying data Drag and Drop Feature Smart Tags BASIC FORMULAS Basic Formulas Auto Sum Editing Formulas Formula Range Finder FORMATTING WORKSHEETS Column Widths Row Heights Number formatting Alignments/Merge and Centre Fonts Borders Patterns INSERTING Inserting a Column Inserting a Row Inserting multiple Rows and Columns Adjusting formulas  more...

Microsoft Excel 2007 Level 1 Location: Vancouver Date: 2008-02-05 List Price: $199 Offered Price: $149.00 Seats Available: 2 Upon successful completion of this course, students will be able to: explore the Excel 2007 environment. work with an Excel worksheet by entering and selecting the data in it. You will also save the data in the worksheet. modify a worksheet. perform calculations. format a worksheet. develop a  more...

Microsoft Access 2003 Level 1 (1 Day) ...0 Seats Available: 2 Objectives Opening and Modifying Database Objects Working with Multiple Windows Adding, Editing, and Deleting Records Tour of a Form, Query, or a Report Planning and Creating a Database Create a Table Using the Table Wizard Create a Report Using the Report Wizard Create a Form Using the Form Wizard Database Object Management Finding, Filtering, and Formatting  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, clipart,  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, clipart,  more...

Microsoft Word 2003 Level 3 - Bilingual ...ng 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: Formatting Long Documents Module 10: Creating A Table Of Contents Module 11: Creating An Index Module 12: Using Bookmarks Module 13: Using Footnotes  more...

Microsoft Excel 2003 Level 4 - Bilingual ...ice: $210.00 Seats Available: 1 Module 0: Working with Data Series Module 1: Using Advanced Functions Module 2: Using Scenarios and Goal Seeking Module 3: Using Data Tables Module 4: Using Auditing Tools Module 5: Consolidating Worksheets Module 6: Solving Problems Module 7: Working With Views Module 8: Using Macros Module 9: Recording Macros Module 10: Editing Macros Module 11: Using Custom  more...

Microsoft Excel 2003 Level 3 ... Top or Bottom Items in a Field Showing Details behind 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  more...

Microsoft Project Training Seminar (2 days) Location: City of Mississauga Date: 2008-01-30 List Price: $650 Offered Price: $454.00 Seats Available: 2 Upon completion of the course, participants will be able to accomplish the following: Understanding the basic operations of the software, working with Windows, menus, commands, and views. Creating a new project file and creating, editing and outlining a task list, as well as  more...

The Cold-Call Fast Start Bootcamp Location: Town of Richmond Hill Date: 2008-02-01 List Price: $7500 Offered Price: $4500.00 Seats Available: 2 Know where your sales are coming from every month Forecast sales based on your knowledge of the lead generation pipeline Systematically creat