Instructor Led Macros Training - Training Resources

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...

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 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 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...

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...

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 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...

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...

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...

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 Excel 2007 Level 3 - VBA Macros Topics included: Building solutions, Macro basics, VBA Programming Basics, VBA User Form Basics, Deployment Basics, Enhancing VBA Code, Handling Errors, Accessing External Data, Excel Automation.  more...

Excel 2003 Macros VBA Level 1 - computer help ...Macros and provides a good introduction to the relationship between macros and Visual Basic. This course is classroom style instruction: Instructor-led, hands-on training. Basic Macro Concepts Macros And Sub Procedures Limitations Of Recorded Macros Recording Macros Relative Referencing Macro Options Storing Macros Editing A Macro Debugging A Macro Step Into, Step Over, Step  more...

Microsoft Access 2000 2003 Level 3 Advanced Topics Upon completion, participants will: Understand macro concepts, create, run, & test Access macros, Create & use switchboard forms, Set Access defaults, apply Startup options, & create & attach command bars and much more.  more...

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 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...

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...

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...

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 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...

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...

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 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...

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...

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...

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 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...

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...

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...

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...

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...

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...

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...

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...

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...

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 course,  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...

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 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...

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 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...

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 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...

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...

Excel 2003 Introduction to VBA Course Objective: You will use VBA to create macros for automating repetitive tasks in Excel 2003.  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...

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...

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...

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 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 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...

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 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 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...

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...

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 ... 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...

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...

MS Access 2003 VBA Macros ...used to build custom solutions using Microsoft Access VBA Macros * Become familiar with basic macro techniques for recording, writing, running, and maintaining a macro * Understand how Visual Basic for Applications is incorporated, used, and modified in Microsoft Access * Learn how to design and layout a user form and controls to create a customized dialog box to simplify data  more...

Microsoft 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...

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...

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...

MS Excel 2003 VBA Macros ... used to build custom solutions using Microsoft Excel VBA Macros Become familiar with basic macro techniques for recording, writing, running, and maintaining a macro Understand how Visual Basic for Applications is incorporated, used, and modified in Microsoft Excel Learn how to design and layout a user form and controls to create a customized dialog box to simplify data entry Understand how  more...

Microsoft Access 2003 - Level 3 - English ...s; Form techniques; ActiveX Controls; Indexes; Databases; Macros; Switchboards; Toolbars; Importing to other Office Suite applications such as Excel and Word; and much more. This course will run for one day, from 9:00 am to 4:00 pm, bilingual instructor-led, in which a training manual as well as a certificate of completion will be offered to participants who complete this course. For more  more...

Excel Macros & VBA Level 3 (3 Days) Location: Toronto Date: 2008-05-26 List Price: $825 Offered Price: $660.00 Seats Available: 2 This course builds on the topics covered in the second Macros course, and covers further techniques and examples for programming Excel with VBA. This course is classroom style instruction: Instructor-led, hands-on training. For more information please call 1-877-313-8881 or copy this link into your  more...

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 copy this  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 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 greater  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 information please  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 receive a  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 ...d a Data Value Grouping and Ungrouping Data Section 2 - Macros Macro Basics Recording a Macro Running a Macro Adding a Macro to a Toolbar Understanding the Macro Code Absolute and Relative References The Personal Macro Workbook Section 3 - Outlines Outline Basics Creating an Outline Collapsing and Expanding an Outline Manual Outline Section 4 - Excel Functions Function Basics  more...

Microsoft 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 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 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: Formatting  more...

Microsoft Excel 2003 Level 4 - Bilingual Location: Ottawa Date: 2008-01-29 List Price: $300 Offered Price: $210.00 Seats Available: 1 Module 0: Working with Data Series Module 1: Using Advanced Functions Module 2: Using Scenarios and Goal Seeking Module 3: Using Data Tables Module 4: Using Auditing Tools Module 5: Consolidating Worksheets Module 6: Solving Problems Module 7: Working With Views Module 8: Using Macros Module 9:  more...

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

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...

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 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 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...

Financial Modeling Workshop 3 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...

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...

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...

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...

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...

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...