Instructor Led Formulas Training - Training Resources

Microsoft Access 2007 Database Design Learn to identify the components of a database, open a table & find information stored in it, create & customize table designs, enter data & validate using input validation formulas, create relationships between tables to ensure data accuracy...  more...

Use of Neural Networks in Reservoir Characterisation Neural networks find their archetype in nature and are a simplified imitation of the human brain. They are widely used for analysis and prediction purposes, particularly for financial services, the security industry and automotive industry. Within the oil and gas industry their utilization is not common practice yet. Wherever statistics, best practice formulas and the meanwhile vast amount of data  more...

Real World Crystal Reports - Level 2 - Advanced this course will consist of: Advanced Database Connectivity & Linking Advanced Sectional Management concepts Cross Tabs Advanced Formulas Learn how to Sum SubReports Custom Functions Building a Report using Crystal's 'Commands'  more...

Crystal Reports 2008 Report Design II - Business Reporting Solutions - nexient As a business benefit, you'll be able to increase your understanding of formulas, variables, arrays, templates, parameters, summaries, & sections. This course will also help you make more effective report design decisions & create more efficient reports  more...

Crystal Reports Introduction XI2008 2 Days Topics include: 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.  more...

Microsoft Excel 2007 Level 1 - uofa Upon completion participants will be able to accomplish the following: Understand the concepts of word processing, create, save, and open documents; organize columns and rows; calculate values; create formulas; format worksheets; use views and more.  more...

Microsoft Excel Introduction FRENCH - compuease This Course is designed to cover important features of an Excel spreadsheet to new users. Upon completion of the course you will be able to create and save a simple spreadsheet, use simple formulas and functions. Format and print your spreadsheets.  more...

MS Excel 2007 Level 2 - HBI In this course, you will use Microsoft Office Excel 2007 to streamline and enhance your spreadsheets with templates, charts, graphics, and formulas.  more...

Excel 2003 Intermediate - CIT This course provides competency in creating absolute formulas, formulas & range names, combining and splitting formulas, text formulas, date and time formulas, referencing cells on other sheets, or other files, auditing, goal seeking and array formulas.  more...

Microsoft Excel 2007 Level 2 - nexient Participants will learn to: organize, protect, and display data; create linking formulas; use the IF function; set up multiple worksheets; create & modify charts ; use styles to format worksheets; use conditional formatting, comments, & text boxes  more...

Microsoft Excel 2003 Foundation 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..more  more...

Microsoft Excel 2003 Intermediate Available in French and English Master Excel's analytical & database management tools. Quickly perform data consolidation or other functions, & create charts & 3- dimensional formulas to highlight various areas of your business.  more...

Microsoft Excel - Intermediate FRENCH Upon completion, students will be familiar with: 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...

Microsoft Excel 2007 Intermediate Training - compuease In this 1 day course you'll learn : 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...

Excel 2007 Level 2 - teksource In this course, you will use Microsoft Office Excel 2007 to streamline and enhance your spreadsheets with templates, charts, graphics, and formulas.  more...

MS Excel 2003 Level 2 - 1 Day HBI Description: Upon successful completion of this course, students will be able to: calculate with advanced formulas. organize worksheet and table data using various techniques. create and modify charts. analyze data using PivotTables and PivotCharts. insert graphic objects. customize and enhance workbooks and the Microsoft Office Excel environment.  more...

Microsoft Excel 20022003 Level 1 - ontrack Topics included in this 1 day course are : getting started, spreadsheet basics, file management, working with formulas, formulating your spreadsheet, printing your spreadsheet and more.  more...

MS Excel 2007 Level 1 - newera This course is designed to teach the fundamentals of using an Excel spreadsheet, including the basics of entering data into a sheet, to building formulas to formatting.  more...

Excel 2007 Introduction 1 Day - computerhelp This course introduces participants to the Microsoft Excel program. The objective is to make the student comfortable with spreadsheet concepts like columns, rows, cells, sheets, and creating formulas. At the end of the course, students can begin creating their own spreadsheets and be comfortable enough to pursue the more sophisticated topics covered in the Intermediate and Advanced courses.  more...

MS Excel 2003 Level 1 Training Seminar - HBI 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...

Excel 2003 Level 2 - Acend In this course, you will use Microsoft Excel 2003 to streamline and enhance your spreadsheets with templates, charts, graphics, and formulas.  more...

Microsoft Excel 2003 XP Level I Start with the basics, including elements of Excel screen, simple formulas (Sales-Expenses=Profit), operators: + - = / * ^, cut, copy, paste using toolbar, menu bar, mouse and keyboard, working with workbooks, worksheets, tabs, moving/ copying worksheets, formatting labels and values, AutoFormat; basic functions (SUM, AVG, MIN, MAX, NOW), printing, calculating percentages, relative/ absolute cell  more...

Microsoft Excel 2000 - 2003 Level 1- Nexient This 1 day training course is intended for new users of Excel 2000/ 2002/ 2003. Course Outline includes : Getting started with Microsoft Excel, modifying the worksheet, using formulas & functions, formatting worksheets & setting print options.  more...

Excel 2007 More Functions and Formulas Do you need to do more advanced calculations? Do you want to use more of the 300+ built-in Excel functions? This class covers four groups of common functions: logical functions, text functions, lookup and reference functions, and conditional functions.  more...

Excel 2003 More Functions Formulas Do you need to do more advanced calculations? Want to learn to use more of the 300+ built-in Excel functions? This class covers four groups of common functions: logical functions, text functions, lookup and reference functions, date and time functions.  more...

Microsoft Excel 2003 Level 2-GT Upon completion, students will be able to perform worksheet organization, use advanced formulas such as the IF function, setup and work with multiple workbooks and worksheets, modify links, and create and work with different styles.  more...

Microsoft Excel 2003 Level 1-GT Upon completion of this course, participants will be able to accomplish the following: - navigate through an excel spreadsheet -organize information and edit contents -use basic formulas and functions -format worksheets -review and print workbooks  more...

Microsoft Excel 2003 Level 1- GT Upon completion of this course, participants will be able to accomplish the following: - navigate through an excel spreadsheet -organize information and edit contents -use basic formulas and functions -format worksheets -review and print workbooks  more...

Microsoft Excel 2007 Level 2-Nexient Participants will learn to: organize, protect, and display data; create linking formulas; use the IF function; set up multiple worksheets; create & modify charts ; use styles to format worksheets; use conditional formatting, comments, & text boxes.  more...

Microsoft Excel 2007 Level 2- Nexient Participants will learn to: organize, protect, and display data; create linking formulas; use the IF function; set up multiple worksheets; create & modify charts ; use styles to format worksheets; use conditional formatting, comments, & text boxes.  more...

Microsoft Excel 2007 Level 1- Nexient Upon completion participants will be able to accomplish the following: Understand the concepts of word processing, create, save, and open documents; organize columns and rows; calculate values; create formulas; format worksheets; use views and more.  more...

Microsoft Excel 2000 - 2003 Level 2- Nexient Upon completion, participants will: Organize, protect, and display data, create linking formulas and use the IF function, set up multiple worksheets, create and modify charts to present data effectively, create and apply styles to format worksheets.  more...

Microsoft Excel 2000 - 2003 Level 1 - nexient Who should attend? This 1 day training course is intended for new users of Excel 2000/ 2002/ 2003. Performance Objectives Upon completion of the course, participants will be able to accomplish the following: Open and move around in an Excel workbook to learn navigation skills necessary for creating and using Excel spreadsheets Organize columns and rows to accommodate information and edit  more...

Microsoft Excel 2007 - Level 2- newera 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 2002-2003 Level 1 On Track Topics included in this 1 day course are : getting started, spreadsheet basics, file management, working with formulas, formulating your spreadsheet, printing your spreadsheet and more.  more...

Excel 2007 - Level 2 presidio The target students for this course are students who desire to gain 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...

Excel 2003 Formulas 1 Day- Last Minute Training This course is designed for Excel users who would like to learn more about creating formulas, as well as brushing up on math skills  more...

Microsoft Excel 2000 - 2003 Level 2 nexient ...t, and display data, using various tools Create linking formulas and use the IF function Set up multiple worksheets, use information from other sources through consolidation, and copy and paste links to combine information into one worksheet Create and modify charts to present data effectively, customize charts to enhance their appearance Create and apply styles to format worksheets  more...

Excel 2003 Formulas- Last Minute Training Topics include: review of basic formulas, absolute formulas, formulas & range names, manipulating formulas, combining & splitting formulas, text formulas, date & time formulas, referencing cells on other sheets/ files, auditing, goal seek, array formulas.  more...

Microsoft Excel 2007 Level 1- GTI Upon completion of this course, participants will be able to accomplish the following: - navigate through an excel spreadsheet -organize information and edit contents -use basic formulas and functions -format worksheets -review and print workbooks  more...

Microsoft Excel 2007 Level 1 - GTI Upon completion of this course, participants will be able to accomplish the following: - navigate through an excel spreadsheet -organize information and edit contents -use basic formulas and functions -format worksheets -review and print workbooks  more...

Microsoft Excel 2007 Level 2- GTI Upon completion, students will be able to perform worksheet organization, use advanced formulas such as the IF function, setup and work with multiple workbooks and worksheets, modify links, and create and work with different styles.  more...

Excel 2007 Working with Workbooks Are you currently saving every Excel spreadsheet in a separate file? Did you know you can have multiple pages in a one Excel file called a "workbook?" Did you know you could create formulas that span multiple worksheets? Did you know you could share workbooks with other users?  more...

Microsoft Excel 2007 Level 2 - nexient ...t, and display data, using various tools Create linking formulas and use the IF function Set up multiple worksheets, using information from other sources through consolidation, and copy and paste links to combine information into one worksheet Create and modify charts to present data effectively; customize charts to enhance their appearance Create and apply styles to format worksheets  more...

Excel 2007 Level 2 - Acend In this course, you will use Microsoft Office Excel 2007 to streamline and enhance your spreadsheets with templates, charts, graphics, and formulas.  more...

Excel 2003 Introduction 1 Day- Last Minute Training This course introduces participants to the Microsoft Excel program. The objective is to make the student comfortable with spreadsheet concepts like columns, rows, cells, sheets, and creating formulas. At the end of the course, students can begin creating their own spreadsheets and be comfortable enough to pursue the more sophisticated topics covered in the Intermediate and Advanced courses.  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...

Excel 2000 - 2003 Intermediate Available in French and English Master Microsoft Office Excel's analytical and database management tools. Quickly perform data consolidation or other functions, and create charts and three dimensional formulas to highlight various areas of your business.  more...

Excel 2003 Introduction 1 Day This course introduces participants to the Microsoft Excel program. The objective is to make the student comfortable with spreadsheet concepts like columns, rows, cells, sheets, and creating formulas. At the end of the course, students can begin creating their own spreadsheets and be comfortable enough to pursue the more sophisticated topics covered in the Intermediate and Advanced courses.  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...

MS Excel 2007 Level 1 Training SeminaR - HBI 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...

Excel 2007 Formulas 1 Day This course is designed for Excel users who would like to learn more about creating formulas, as well as brushing up on math skills. This course is classroom style instruction: Instructor-led, hands-on training.  more...

Microsoft Excel 2003 - Level 2 - newera 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...

Microsoft Excel 2007 - Fast Track ... Access Toolbar The Ribbons: Home, Insert, Page Layout, Formulas, Data and Review The Formulas Bar The Name Box The Worksheet The Excel Pointers The Status Bar | Module 3: Editing Worksheets | Working with Columns and Rows Using the Name Box To Navigate Creating Name Ranges Working with Sheet Tabs | Module 4: Data Entry | Entering Alpha-numeric Values  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...

Crystal Reports XI R1R2 Report Design II Business Reporting Solutions - nexient Who should attend? The target audience for this course is report designers who are responsible for creating and distributing reports and have completed Crystal Reports RD110R2: Fundamentals of Report Design. Performance Objectives Upon completion of the course, participants will be able to accomplish the following: To plan and create reports that will help you analyze and interpret  more...

Microsoft Access 2000 - 2003 Level 1 Database Design - nexient ...re its accuracy by using input masks and input validation formulas Create relationships between tables to ensure data accuracy and to deploy referential integrity Create forms for entering data into tables, and change the design elements that have been placed on those forms Create several query types, edit and run queries, and use action and calculation queries Create several report  more...

Microsoft Access 2000 - 2003 Level 1 Database Design nexient ...re its accuracy by using input masks and input validation formulas Create relationships between tables to ensure data accuracy and to deploy referential integrity Create forms for entering data into tables, and change the design elements that have been placed on those forms Create several query types, edit and run queries, and use action and calculation queries Create several report  more...

Excel 2003 Functions and Formulas Do you want to perform calculations in your Excel spreadsheets? Do you want to use any of the 300+ built-in Excel functions? Do you want to learn how to efficiently create worksheets that update automatically?  more...

Excel 2003 Working with Workbooks Did you know you can have multiple pages in a one Excel file called a "workbook?" Did you know you could create formulas that span multiple worksheets? Did you know you could share workbooks with other users?  more...

Excel 2007 Functions and Formulas Do you want to perform calculations in your Excel spreadsheets? Do you want to use any of the 300+ built-in Excel functions? Do you want to learn how to efficiently create worksheets that update automatically?  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...

MS Excel Level 2 Training Seminar In this course, students will streamline and enhance worksheets with templates, charts, graphics and formulas. They will receive the course materials that will be used for the course, as well as a certificate of completion at the end of the course. The course is designed so as it is more hands-on, classroom-like style.  more...

Crystal Reports Intermediate 2 Days 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 reports. This course is classroom style instruction: Instructor-led, hands-on training.  more...

Microsoft Excel Introduction This Course is designed to cover important features of an Excel spreadsheet to new users. Upon completion of the course you will be able to create and save a simple spreadsheet, use simple formulas and functions. Format and print your spreadsheets.  more...

Word and Excel 2003 XP Essentials In Microsoft Word learn the basics of entering text, the File, Save As command, opening and editing a document, scrolling in a document, searching in a document, AutoCorrect, selecting text, moving and copying text, basic character and paragraph formatting. Particular attention is paid to three essential skills - using tabs, tables and mail merging. In Microsoft Excel, start with the basics,  more...

Microsoft Excel 2003 XP Level II Start with the basics, including elements of Excel screen, simple formulas (Sales-Expenses=Profit), operators: + - = / * ^, cut, copy, paste using toolbar, menu bar, mouse and keyboard, working with workbooks, worksheets, tabs, moving/ copying worksheets, formatting labels and values, AutoFormat; basic functions (SUM, AVG, MIN, MAX, NOW), printing, calculating percentages, relative/ absolute cell  more...

Excel - Functions This course looks at a variety of functions within Excel. Focus on the IF and Vlookup functions. Other functions covered are: text, statistical, mathematical, logical, financial and information. You should have an understanding of of Excel Intermediate topics with solid understanding of formulas before taking this course.  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 - Introduction This Course is designed to cover important features of an Excel spreadsheet to new users. In this course, you will use Microsoft Office Excel 2007, upon completion of the course you will be able to create and save a simple spreadsheet, use simple formulas and functions. Format and print your spreadsheets.  more...

Microsoft Excel 2003 Level 2 ...e 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 with graphic objects. * calculate with advanced formulas. * sort and filter data. * use Excel with the Web. To ensure your success, we recommend that you  more...

Excel 2003 Formulas (1 Day) This course is designed for Excel users who would like to learn more about creating formulas, as well as brushing up on math skills. This course is classroom style instruction: Instructor-led, hands-on training.  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...

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

Excel 2007 Introduction (1 Day) This course introduces participants to the Microsoft Excel program. The objective is to make the student comfortable with spreadsheet concepts like columns, rows, cells, sheets, and creating formulas. At the end of the course, students can begin creating their own spreadsheets and be comfortable enough to pursue the more sophisticated topics covered in the Intermediate and Advanced courses.  more...

Excel Intermediate - Level 2 This course 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  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...

Microsoft Excel - private, one on one training - INTERMEDIATE level Duration Details 3 hour block of time What can be learned at this seminar: NOTE: This is PC based training - Versions Offered: 97, 2000, 2002, 2003. VIEWING WORKSHEETS Customizing View Options Displaying and Customizing Toolbars Hiding Workbooks and Worksheets Freezing Panes Grouping and Ungrouping Worksheets MORE FORMATTING TECHNIQUES Styles, Guidelines and the  more...

Excel - Formulas Provides competency in creating absolute formulas, formulas and range names, manipulating formulas, combining and splitting formulas, referencing cells on other sheets or files, auditing, goal seeking and array formulas.  more...

VBA for Excel 2003 ...cluding 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 spreadsheet development. In Excel 2003: Introduction to VBA you apply the Visual Basic for Applications (VBA) programming  more...

Crystal Reports Introduction-2 Days Crystal Reports 11. In this course, we will explore 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  more...

Crystal Reports 11 Level 1 - English Crystal Reports 11. In this course, we will explore 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  more...

Microsoft Excel 2007 Level 2 Functions and Analysis - English ...ourse, and then proceed to teach topics such as Reviewing Formulas; Understanding Functions; Financial Functions; Logical Functions; Lookup Functions; Date Functions; Statistical Functions; What-if Analysis; and Auditing Formulas. Also, an opportunity will be provided to all participants to use the lab to practicie the topics learned through this course. Participants who complete this course  more...

Microsoft Excel 2007 Level 1- Introduction 2 Days ...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 9:00 am until 4:00 pm  more...

Microsoft Excel 2003 Level 1 This one day Microsoft Excel Training course covers the fundamentals of what you will need to know to effectively use Microsoft 2003. Objectives Understanding the Excel Program Screen Using Menus, Toolbars and Creating a New Workbook Opening, Saving, and Manging a Workbook Moving the Cell Pointer Worksheets Entering Formulas Editing and Formatting a Worksheet Cutting, Copying, and  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...

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

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

Crystal Reports - Intermediate Level (2 Days) Location: Montreal Date: 2008-05-21 List Price: $490 Offered Price: $392.00 Seats Available: 2 Objectives * Defining complex formulas * Adding sub reports * Using parameters * Using cross-tab reports For more information please call 1-877-313-8881 or copy this link into your browser:  more...

Crystal Reports Intermediate (2 Days) ...ate 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 reports. 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...

Excel Introduction (2 Days) ...s 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 AutoFormats, and finding and replacing data. For more information please call 1-877-313-8881 or copy this link into your  more...

Microsoft Excel - Intermediate Training (French Instructions) ...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 1-877-313-8881 or copy this link into your browser:  more...

Microsoft Excel 2007 Level 2 (1 Day) ...e 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. * analyze data using PivotTables and PivotCharts. * work with graphic objects. * calculate with advanced formulas. * sort and filter data For more information  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 ... 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 VARIOUS VIEWS View Preferences Freezing Panes  more...

Microsoft Word 2003 Level 3 - Bilingual ... 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 And Endnotes Module  more...

Microsoft Excel 2003 Level 1 Location: Vancouver Date: 2008-01-28 List Price: $199 Offered Price: $139.00 Seats Available: 2 This one day Microsoft Excel Training course covers the fundamentals of what you will need to know to effectively use Microsoft 2003. Objectives Understanding the Excel Program Screen Using Menus, Toolbars and Creating a New Workbook Opening, Saving, and Manging a Workbook Moving the Cell  more...

Microsoft Excel Introduction (French Instruction, French Software) Location: Ottawa Date: 2008-01-24 List Price: $185 Offered Price: $129.00 Seats Available: 2 COURSE OUTLINE - Getting started - Excel basics - Basic editing - Basic formulas - Formatting worksheets - Inserting - Various views - Printing  more...

Excel Introduction-1 Day Location: Town of Newmarket Date: 2007-07-06 List Price: $275 Offered Price: $175.00 Seats Available: 2 This course introduces participants to the Microsoft Excel program. The objective is to make the student comfortable with spreadsheet concepts like columns, rows, cells, sheets, and creating formulas. At the end of the course, students can begin creating their own spreadsheets and be  more...

MS Excel 2003 Formulas for Finance Location: City of Mississauga Date: 2007-07-05 List Price: $245 Offered Price: $171.00 Seats Available: 2 This course features an overview of the financial, math, and database calculations supplied in Excel's core function collection and add-in libraries. Participants will also be introduced to creating their own user-defined functions with Visual Basic in order to extend Excel's supplied  more...

Crystal Reports Intermediate-2 Days Location: Toronto Date: 2007-04-26 List Price: $1100 Offered Price: $770.00 Seats Available: 4 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 Formulas-1 Day Location: Town of Newmarket Date: 2007-04-18 List Price: $275 Offered Price: $175.00 Seats Available: 5 This course is designed for Excel users who would like to learn more about creating formulas, as well as brushing up on math skills.  more...

Excel Formulas-1 Day Location: Toronto Date: 2007-04-17 List Price: $275 Offered Price: $175.00 Seats Available: 5 This course is designed for Excel users who would like to learn more about creating formulas, as well as brushing up on math skills.  more...

MS Excel Level 2 Training Seminar Location: City of Mississauga Date: 2007-04-26 List Price: $205 Offered Price: $143.00 Seats Available: 2 In this course, students will streamline and enhance worksheets with templates, charts, graphics and formulas.  more...

MS Excel Level 1 Training Seminar Location: City of Mississauga Date: 2007-04-23 List Price: $205 Offered Price: $143.00 Seats Available: 1 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,  more...

Excel Formulas-1 Day Location: City of Mississauga Date: 2007-04-13 List Price: $275 Offered Price: $190.00 Seats Available: 5 This course is designed for Excel users who would like to learn more about creating formulas, as well as brushing up on math skills.  more...

MS Excel 2003 Formulas for Statistical Analysis Location: City of Mississauga Date: 2007-04-13 List Price: $245 Offered Price: $171.00 Seats Available: 2 This class is an overview of calculations using selected advanced functions drawn from the statistical, database, and mathematic functions in Excel's core collections and add-in libraries. Participants will also be introduced to creating user-defined functions with Visual Basic in order to  more...

Microsoft Excel 2002 (XP) Level I Location: Toronto Date: 2007-04-10 List Price: $80 Offered Price: $56.00 Seats Available: 2 Start with the basics, including elements of Excel screen, simple formulas, working with workbooks, worksheets, tabs, moving/copying worksheets, formatting labels and values, AutoFormat; basic functions (SUM, AVG, MIN, MAX, NOW, IF), printing, calculating percentages, relative/absolute cell references,  more...

Excel Functions-1 Day March 26, 2007 9:00am to 4:00pm This course is designed for Excel users who would like to learn more using the various functions available in Excel. This course is classroom style instruction: Instructor-led, hands-on training. Course Prerequisite: Required: Solid understanding of Excel Introduction and Formulas topics. Recommended: Knowledge of Excel Intermediate Level I topics.  more...

Excel Formulas-1 Day March 20, 2007 9:00am - 4:00pm This course is designed for Excel users who would like to learn more about creating formulas, as well as brushing up on math skills. This course is classroom style instruction: Instructor-led, hands-on training.  more...

Word and Excel 2002 (XP) Essentials ...t with basics, including elements of Excel screen, simple formulas ( Sales - Expenses Profit) , operators: - = / * , cut, copy, paste using tool bar, menu bar, mouse and keyboard, working with textbooks, worksheets, tabs, moving/copying worksheets, formatting labels and values, AutoFormat; basic functions ( SUM, AVG, MIn, MAX, NOW) printing, calculating, percentages, and basic charts.  more...

Excel Introduction-1 Day April 3, 2007 9:00am-4:00pm This course introduces participants to the Microsoft Excel program. The objective is to make the student comfortable with spreadsheet concepts like columns, rows, cells, sheets, and creating formulas. At the end of the course, students can begin creating their own spreadsheets and be comfortable enough to pursue the more sophisticated topics covered in the  more...

MS Excel Level 1 Training Seminar April 2, 2007 9:00am - 4:00pm 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...

MS Excel Level 2 Training Seminar April 10, 2007 9:00am - 4:00pm In this course, students will streamline and enhance worksheets with templates, charts, graphics and formulas.  more...

Microsoft Excel 2003 - Introduction Identify basic worksheet and workbook concepts and terms Enter & edit data Modify the worksheet Use functions to calculate and return values Format cells to enhance the appearance of your worksheet Use drawing features and other enhancements Change the page set-up to define how the printed worksheet appears This course is suitable for absolute beginners and  more...

Microsoft Excel 2003 - Introduction / Beginning ...rts. work with graphic objects. calculate with advanced formulas. sort and filter data. use Excel with the Web. SEE DAY TWO BELOW FOR ADDITIONAL TOPICS Welcome to Sonic Training!. (http://www.sonictraining.com 877-760-0078) Macromedia (Dreamweaver, Flash, Fireworks), Adobe (Photoshop, InDesign, Illustrator), Database (SQL, Access, Filemaker Pro, Goldmine), Programming (HTML, CSS, XML,  more...

Customized Microsoft Excel Training in Toronto ...orking with Graphic Objects * Calculating with Advanced Formulas * Sorting and Filtering Data * Using Excel with the Web * Streamlining Workflow * Collaborating with Others * Auditing Worksheets * Analyzing Data * Working with Multiple Workbooks * Importing and Exporting Data * Structuring XML Workbooks Reasons to choose Acend for your Customized Excel Training *  more...

Crystal Reports 10 Level 1 (Nonconsecutive days) In this course, students will build basic list and group reports that work with almost any database. Who Should Attend: 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  more...

Crystal Reports 10 Level 2 (Nonconsecutive days) In this course, students will learn how to create more sophisticated reports like subreports and cross-tabs. Also, they learn how to increase the speed and efficiency of their reports by using SQL queries and dictionaries. Who Should Attend: This course is designed for people who know how to create basic list and group reports and need to create reports that include  more...

Crystal Reports XI Level 1 (Nonconsecutive days) In this course, students will build basic list and group reports that work with almost any database. Who Should Attend: 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  more...

Crystal Reports XI Level 2 In this course, students learn how to create more sophisticated reports including subreports and cross-tabs, and how to increase the speed and efficiency of your reports by using SQL queries. Who Should Attend: 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  more...

Excel training courses (1 day) Introduction in Bristol, Bracknell or Solihull ...et Format a spreadsheet Edit data on a spreadsheet Use formulas and functions Print a spreadsheet Pre-requisites Experience of Windows 2000 or later. Basic keyboard skills. This course is recommended as a starting point for most Excel users as it covers most of the basics self-taught users will struggle with. Course Contents Introduction to Microsoft Excel What is Excel? Excel file  more...

Advanced Excel 2003 for Business Class Type: * Can retake the class, for free, up to 3 months. * Free forum support for 1 year after class * Hands on, goal based * Small Classes of 4 to 9 people * Fast computers * Comfortable chairs, convenient location * Patient, Fun, Experienced Trainer When you are finished with this class you will be able to: * Extract data from large databases  more...

Dive Into Microsoft Excel Spreadsheets and Workbooks Keeping track of sales figures, statistics or mortgage payments has never been easier, or more difficult. Microsoft Excel gives you the power to develop formulas using built-in functions, Use charts and graphs to predict trends and understand relationships, Consolidate data from several worksheets into one, Find and organize information by filtering, sorting, and grouping, Summarize and analyze  more...

Dive Into Microsoft Excel Worksheet Basics Fundamentals of a Spreadsheet; Cells; Rows and Formulas Create and Edit a Spreadsheet Selecting and Entering Data into a Cell Learn Tips, Tricks and Shortcuts Enter and format your data, and write formulas Develop Formulas using Built-in Functions Use charts and graphs to predict trends and understand relationships Create a template to speed up your work Using the AutoFill and Custom Fill  more...

Dive Into Microsoft Excel Worksheet Intermediate ...ricks and Shortcuts Enter and format your data, and write formulas Develop Formulas using Built-in Functions Use charts and graphs to predict trends and understand relationships Create a template to speed up your work Using the AutoFill and Custom Fill Create and Edit Forms Consolidate data from several worksheets into one Find and organize information by filtering, sorting, and grouping  more...

Introduction to Microsoft Excel ... apply formatting to change the data's appearance and use formulas to their advantage. The class is taught as a hands-on "laboratory" lead by an experienced instructor. During class, students use a workstation to work with actual files and real-world examples. In addition to the classroom instruction and hands-on exercises, each participant recieves a booklet and class CD, detailing the topics  more...

Intermediate Microsoft Excel ...rmediate Excel emphasizes the data organization tools and formulas available to Excel users. At the end of class, students will be able to better understand their data by using tools like sorting and filtering, and use more advanced formulas to perform more advanced analytical tasks. The class is taught as a hands-on "laboratory" lead by an experienced instructor. During class, students use a  more...

Advanced Microsoft Excel ...ost of its attention to the construction of more powerful formulas. At the end of class, students will understand how formulas can be nested inside one another to create calculations that would be impossible using single formulas. The class is taught as a hands-on "laboratory" lead by an experienced instructor. During class, students use a workstation to work with actual files and real-world  more...