Instructor Led Formulas Training
Formulas Training Provider? - Tell us about your Training!
Please select the location nearest to you:
United States
India
United Kingdom
United Arab Emirates
Canada
South Africa
Malaysia
Croatia
Singapore
Phillipines
From The Career Center
Microsoft Excel 2007 Level 2
...e your spreadsheets with templates, charts, graphics, and formulas. Course Objectives You will apply visual elements and advanced formulas to a worksheet to display data in various formats. Upon completion of the class the student will be able to: enhance the workbook automate workbook creation by using templates organize data using tables create and modify charts analyze data using
more...
Microsoft Excel 2007 Level 2
Microsoft Excel Introduction To VBA
...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 the spreadsheet development. In this course, you will apply the Visual Basic for Applications (VBA) programming language
more...
Microsoft Excel Level 2 2010
...l sets necessary for calculating data using functions and formulas, sorting and filtering data, using PivotTables and PivotCharts for analyzing data, and customizing workbooks. Course Objective: You will use advanced formulas and work with various tools to analyze data in spreadsheets. You will also organize table data, present data as charts, and enhance the look and appeal of workbooks by
more...
Excel Expert Level
... sorting and filtering; importing and
exporting; advanced formulas; analysis tools; and collaboration. You will create templates,
sort and filter data, and import and export data, analyze data, and collaborate on the Web in
Excel.
Upon successful completion of this course, students will be able to:
use a variety of techniques to sort and filter data.
re-use and share data by importing
more...
Excel Level 1
This course, Excel 2002 Level 1, is the first course in a series. This course
will give you the skills to create, edit, format, and print basic worksheets and
charts in Excel. You will create basic worksheets and charts.
Upon successful completion of this course, students will be able to:
work with cells and cell data by using a variety of moving and copying techniques.
perform calculations
more...
From iWare Logic
Oracle BI Presentation Services 10g Create ReportsDashboards
...vot tables
a Setting aggregation rules and building formulas
Creating Interactive Dashboards
a Introduction to Dashboards and pages
a Dashboard Editor UI elements
a Composing Dashboard elements
Configuring Interactive Dashboards
a Types of Dashboard content
a Embedding content in Dashboards
Customizing the Oracle Business Intelligence User
more...
Oracle BI Presentation Services 10g Create ReportsDashboards
...vot tables
a Setting aggregation rules and building formulas
Creating Interactive Dashboards
a Introduction to Dashboards and pages
a Dashboard Editor UI elements
a Composing Dashboard elements
Configuring Interactive Dashboards
a Types of Dashboard content
a Embedding content in Dashboards
Customizing the Oracle Business Intelligence User
more...
From Wintrac Inc.
Excel 2000 - Advanced
Students will probably get the most out of this course if they want to learn the skills and concepts necessary to work with advanced features of Excel 2000. Students should have a basic knowledge of the concepts involved in using Excel 2000. For example, they should be familiar with data types (text and values), copying data, basic formulas and functions, and opening and saving files.
You can
more...
Excel 2002 (XP) - Level 2
This course is the second in a three-course series that satisfies the requirements for the Microsoft Office User Specialist (MOUS) certification. This course will expand upon the skills you learned in the Excel 2002Level 1 course and give you an opportunity to work with some more advanced features of Excel, including templates; sorting and filtering; importing and exporting; advanced formulas;
more...
Server Agents for Lotus Domino Designer R5
During this course you will create agents that run in memory of the Domino Server. These agents run on a scheduled or event-driven basis, and are written using Simple Actions, Formulas, or LotusScript.
Emphasis is placed on understanding the security requirements and server resources required to safely and effectively run agents.
You can get a complete list of other Lotus Notes/Domino
more...
Microsoft Office 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.
You can get a complete
more...
Microsoft Office Excel 2003 - Introduction to VBA
...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...
Excel 2003 Charting and Organizing Data (Model 2001)
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.
You can get a complete
more...
Microsoft Excel 2004 for Macintosh - Level 2
In Microsoft ® Excel ® 2004 for Macintosh: 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 2004 for Macintosh to streamline and enhance your spreadsheets with templates, charts, graphics, and formulas.
more...
Microsoft Office Excel 2007- Level 2 (Second Edition)
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.
You can get a
more...
Microsoft Office Excel 2007- VBA
...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 the spreadsheet development. In this course, you will apply the Visual Basic for Applications (VBA) programming language
more...
Microsoft Office Excel 2008 -Level 2 (Macintosh)
In Microsoft ® Office Excel ® 2008: Level 1 (Macintosh), 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 ® 2008 to streamline and enhance your spreadsheets with templates, charts, graphics, and
more...
Crystal Reports 8.0 Quick Start Workshop
This 2-day workshop is designed for beginning users with little or no exposure to Crystal Reports. The intent of the course is to familiarize the students with the Crystal Reports environment, and get them up and reporting quickly. The workshop provides the basic steps for creating, modifying, saving and viewing reports to more flexible tasks such as basic formulas and the powerful automated
more...
Crystal Reports 8.5 Quick Start Workshop
This 2-day workshop is designed for beginning users with little or no exposure to Crystal Reports. The intent of the course is to familiarize the students with the Crystal Reports environment and get them up and reporting quickly. The workshop provides the basic steps for creating, modifying, saving and viewing reports to more flexible tasks such as basic formulas and the powerful automated
more...
Crystal Reports 9.0 Quick Start Workshop
This 2-day workshop is designed for beginning users with little or no exposure to Crystal Reports. The intent of the course is to familiarize the students with the Crystal Reports environment and get them up and reporting quickly. The workshop provides the basic steps for creating, modifying, saving and viewing reports to more flexible tasks such as basic formulas and the powerful automated
more...
CorelDRAW X3- Level 2
In CorelDRAW ® X3: Level 1, you created, edited, formatted, and printed basic drawings. You now have a need to create a complicated brochure for a client. In CorelDRAW ® X3: Level 2, you will use CorelDRAW X3 to create the brochure and enhance its appearance with advanced colors, charts, graphics, and formulas.
You can get a complete list of other Corel classes at
more...
Crystal Reports 100 Quick Start Workshop
This 2-day workshop is designed for beginning users with little or no exposure to Crystal Reports. The intent of the course is to familiarize the students with the Crystal Reports environment and get them up and reporting quickly. The workshop provides the basic steps for creating, modifying, saving and viewing reports to more flexible tasks such as basic formulas and the powerful automated
more...
Crystal Reports XI Designer 3 Workshop
2This two-day workshop is designed to expand your working knowledge of Crystal Reports and move you into creating more complex reports. Time will be spent walking you through the tips and tricks of advanced report writing, along with a lot of hands-on practice. In addition, you will cover custom function, advanced formulas, and report efficiencies techniques. This course incorporates a number of
more...
Crystal Reports 2008 Designer 2 Workshop
This two-day workshop is designed to enhance your basic report writing skills and move you into creating more complex reports. Time will be spent walking you through the tips and tricks of advanced report writing along with a good amount of hands on practice. In addition, you will cover professional design, techniques, sub-reporting and advanced formulas. This course incorporates a number of hands
more...
Crystal Reports 2008 Designer 3 Workshop
This two-day workshop is designed to expand your working knowledge of Crystal Reports and move you into creating more complex reports. Time will be spent walking you through the tips and tricks of advanced report writing along with a good amount of hands on practice. In addition, you will cover custom functions, advanced formulas and report efficiencies techniques. This course incorporates a
more...
From L'Obel IT-Palaestra
L'Obel Certified Oracle DBA Training in Bangalore





...fying a Runtime Parameter Form
a Creating Reports
a Formulas and Summaries
a Changing Fonts and Modifying Field Properties
a Page Layout adjusting Page Size
a Report Headers and Footers
a Anchors
a Creating Forms
a Creating Forms Letters
a Creating Mailing Labels
a Creating Matrix Reports
a Combination Reports
a Creating Parameter Forms
a Adding Buttons,
more...
L'Obel Certified Oracle Training in Bangalore





...fying a Runtime Parameter Form
a Creating Reports
a Formulas and Summaries
a Changing Fonts and Modifying Field Properties
a Page Layout adjusting Page Size
a Report Headers and Footers
a Anchors
a Creating Forms
a Creating Forms Letters
a Creating Mailing Labels
a Creating Matrix Reports
a Combination Reports
a Creating Parameter Forms
a Adding Buttons,
more...
From Pitman Training Centre London
Lotus Course Fundamentals Of Domino 8 Application Development
...ments in them.
Create formatted views.
Create formulas and learn about programming languages that can be used in conjunction with Domino.
Use formulas in conjunction with forms.
Select and manipulate data for use and display in views.
Work with layers, subforms, instant messaging, and autosave features.
Work with hierarchical views, response data, shared
more...
From Meirc Training and Consulting
Masterclass Microsoft Office Professional 2007 Developing Smart Work Skills


...footnotes, indexes, and table of contents. Excel: create formulas, calculate values, analyze data, present information visually with graphics and charts, analyze data, work with databases, share spreadsheets for review and manage changes. PowerPoint: learn how to create memorable presentations, create great-looking slides, charts, and diagrams, bring ideas to life with animation and special
more...
From Mullan Training
Introduction To Crystal Reports



...Using the visual linking expert
Formula Basics
- Using formulas
- Using the Formula Editor
- Using basic calculations
- Using string manipulation
- Applying basic date calculations
- Applying If Then Else formulas
- Applying Boolean formulas
Basic Cross-Tabs
- What is a Cross-Tab?
- Using the Cross-Tab Expert
- Editing a Cross-Tab layout
- Additional Cross-Tab layout features
more...
Advanced Crystal Reports



...zing
- Selecting records
- Summary Drill Down
- Linking
- Formulas
- CrossTabs
Advanced Formulas
- Creating multiple statement formulas
- Using variables
- Understanding two-pass reporting
- Using evaluation time functions
- Creating running totals
- Adding User Functions Libraries (UFLs)
Conditional Formatting
- Types of formatting
- Absolute formatting
- Conditional on/off formatting
-
more...
From silicon beach training
Microsoft Excel Training


Microsoft Excel is the world's most popularl spreadsheet application and makes calculating, displaying and sharing data easy.
This beginners Excel training course provides a solid introduction to Excel's core functionality, including Rows and Columns, Formatting Data, Creating Charts & Graphs, Using Formulas, Print Layouts and much more.
more...
From Business Industrial Network
Practical Process Control Training Workshop - PID Control

After great success in St. Louis, this PID Troubleshooting 2 day course
"Practical Process Control" is now being offered as one of our
Atlanta industrial manufacturing seminars. Your process control manager should
send at least two engineers to the Atlanta training, as this PID training is
second to none in the process control industry.
SEMINAR/WORKSHOP DATE: Jul. 19-20, 2007
This Atlanta
more...
From Maverick Enterprises
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
more...
Dive Into Microsoft Excel Worksheet Intermediate




...icks 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
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...
From WWP Training Ltd
Microsoft Excel 2003 Level 1
Aims
This course is aimed at people who want to learn how to use Microsoft Excel to carry out basic spreadsheet tasks including the creation of simple formulas and functions. The course is suitable for either beginners or people with limited experience of the product.
Prerequisites
Students who wish to attend this course need to be familiar with the use of a PC keyboard and mouse.
more...
Microsoft Excel 2003 Level 2
Aims
This course is aimed at people who want to expand their basic knowledge of Microsoft Excel to work with larger spreadsheets and workbooks, create charts and manage tables of data.
Prerequisites
Students who wish to attend this course must have a basic knowledge of Excel and feel comfortable with creating, saving, editing and formatting spreadsheets and creating basic formulas and
more...
Microsoft Excel 2003 Level 3
Aims
This course is aimed at people who want to expand their knowledge into some of the more advanced calculation and analytical capability of Microsoft Excel.
Prerequisites
Students who wish to attend this course must have a good knowledge of Excel and be competent at working with basic formulas and functions, multiple sheets and multiple files.
more...
Microsoft Excel 2007 Level 1
Aims
This course is aimed at people who want to learn how to use Microsoft Excel to carry out basic spreadsheet tasks including the creation of simple formulas and functions. The course is suitable for either beginners or people with limited experience of the product.
Prerequisites
Students who wish to attend this course need to be familiar with the use of a PC keyboard and mouse.
more...
Microsoft Excel 2007 Level 2
Aims
This course is aimed at people who want expand their basic knowledge of Microsoft Excel to work with larger spreadsheets and workbooks, create charts and manage tables of data.
Prerequisites
Students who wish to attend this course must have a basic knowledge of Excel and feel comfortable with creating, saving, editing and formatting spreadsheets and creating simple formulas and
more...
Microsoft Excel 2007 Level 3
Aims
This course is aimed at people who want expand their knowledge into some of the more advanced calculation and analytical capability of Microsoft Excel.
Prerequisites
Students who wish to attend this course must have a good knowledge of Excel and be competent at working with basic formulas and functions, multiple sheets and multiple files.
more...
iWork Numbers 09 Introduction
Aims
This course is designed for new users of iWork Numbers. The course will cover all topics required create spreadsheets from setup, creating formulas, charting and also formatting and printing.
Prerequisites
Basic Mac Navigation is required.
more...
From JCS Computer
Peachtree Advanced
...ash accounts. They will learn to set-up Payroll deduction formulas, customize Financial Statements, set-up User security rights & other advanced features of the system.
Fee: 1 day session $349. 00
This class is taught by an experienced certified trainer. There will be a maximum of 4 students per class and is hands on 1 person per PC. All classes are CPE accredited. Students will receive
more...
From Software Training Academy, Inc
Microsoft Excel - Advanced



...xcel 2007: Intermediate. Students will work with advanced formulas, as well as lookup functions such as VLOOKUP, MATCH, and INDEX. In addition, students will learn about data validation and database functions such as DSUM. They will learn how to work with PivotTables and PivotCharts, how to import and export data, and how to query external databases. Finally, students will learn about the
more...
Microsoft Excel 2007 - Basic



...nd workbooks. Then they will enter and edit text, values, formulas, and pictures, and they will save workbooks in various formats. Students will also move and copy data, learn about absolute and relative references, and work with ranges, rows, and columns. This course also covers simple functions, basic formatting techniques, and printing. Finally, students will create and modify charts, and
more...
From Technical Training Solutions
Excel - Forms Macros VBA





Course Summary:
Students will become familiar with what a macro is and how to create them. From there, students will use macros to automate routine Excel tasks. Students will learn to customize the Excel environment by altering the toolbars, menus and keyboard shortcuts to suit their needs. Students will get a thorough introduction to the VBA development environment that is based on Visual Basic.
more...
From Pitman Training Centre Notting Hill
Lotus Course Fundamentals of Domino 8 Application Development
...ments in them.
Create formatted views.
Create formulas and learn about programming languages that can be used in conjunction with Domino.
Use formulas in conjunction with forms.
Select and manipulate data for use and display in views.
Work with layers, subforms, instant messaging, and autosave features.
Work with hierarchical views, response data, shared
more...
From Kogent
BOC320 - Crystal Reports - Report Design II - Business Reporting Solutions
BOC320: Crystal Reports - Report Design II - Business Reporting Solutions
Crystal Reports 2008 is a powerful, dynamic, actionable reporting solution that helps you design, explore, visualize, and deliver reports via the web or embedded in enterprise applications. This two-day instructor-led course is designed to give you comprehensive skills and in-depth knowledge to plan and create reports
more...
BOC330 - Crystal Reports - Report Design III - Report Processing Strategies
BOC330: Crystal Reports - Report Design III - Report Processing Strategies
Crystal Reports 2008 is a powerful, dynamic, actionable reporting solution that helps you design, explore, visualize, and deliver reports via the web or embedded in enterprise applications. This one-day instructor-led course is designed to give you comprehensive skills and in-depth knowledge required to plan and create
more...
From RAMCO Software Training
Microsoft Excel 2007 Level 1






The course uses a combination of lecture, hands-on practice, and independent exercises to familiarize students with Excel. Students learn the structure of workbooks and worksheets. They create their own workbook, enter and edit data, and build formulas. They use Copy and Fill commands to minimize data entry. They enhance the appearance of worksheets by adjusting columns and rows, adding colors
more...
Microsoft Excel 2007 Level 2





The course uses a combination of lecture and hands-on exercises to familiarize students with higher level skills in the Excel program. Students learn to differentiate between absolute and relative cell references, create and use complex formulas, manipulate large worksheets, name ranges, and link worksheets.
Students should be ready to work with large spreadsheets commonly used in budget
more...
From Optivation
Excel Basic Formulas
...formulas with this online class! The introduction of Microsoft Office 2007 (Word, Excel, Power Point, etc) marks the first major change to the user interface since Bill Gates, personally, developed the drop down menu interface over 10 years ago. The drop down menu interface is gone, replaced by the ribbon. The ribbon has many similar characteristics but many, many differences. The course
more...
From Global Innovative Campus
Piled Foundations Design
...pile settlement, negative skin friction), dynamic driving formulas, wave equation analysis, dynamic testing), static methods of pile load testing. Application and interpretation of the wave equation and dynamic and static pile-load-testing methods are highlighted with an emphasis on the practical issues related to pile monitoring and acceptance on typical construction projects. Construction
more...
From mindXCEL Consultancy
NLP Business Master Practitioner Training licensed by Richard Bandler

...ed successful therapists and began to create mathematical formulas of what he had noticed them doing. With some of his then students, he then took these techniques and strategies and began to build models of excellence with them.
Richard proved amazing in using his mathematical skills to ensure that these models of excellence were not only very effective, but also learnable in a very short
more...
From NobleProg - IT training courses
Oracle eBusiness Suite - HRMS Modules - Payroll Fast Formulas





This course explains how to write Fast Formulas for Oracle Payroll processing. Topics include Fast Formula usages, syntaxes, and formula result rules. Real-life formulas will be used as case models.
more...
From mindXCEL Consultancy
NLP Practitioner Training certified by Dr Richard Bandler
...ed successful therapists and began to create mathematical formulas of what he had noticed them doing. With some of his then students, he then took these techniques and strategies and began to build models of excellence with them.
NLP (Neuro-linguistic Programming) involves the study of patterns, which are created by the interaction of the brain, language and the physical body.
In simple
more...
From Global Innovative Campus
PMP CAPM Exam Preparation 4th Edition - Evening Class 385 PDUs
... 9 knowledge areas, the 5 processes, a review of all math formulas and actual tips on writing the exam.
The workshops focus on PMI terminology and processes (American), comparing them with Canadian industry terminology. Although the course is intended to help participants write and pass the exam, participants will get a large dose of practical experience as well as some principles and theories
more...
PMP Exam Preparation 4th Edition - Daytime Class 42 PDUs
... 9 knowledge areas, the 5 processes, a review of all math formulas and actual tips on writing the exam.
The workshops focus on PMI terminology and processes (American), comparing them with Canadian industry terminology. Although the course is intended to help participants write and pass the exam, participants will get a large dose of practical experience as well as some principles and theories
more...
From NobleProg - IT training courses
Statistics Level 2 Training Course





This statistics course covers advanced statistics. It explains most of the tools commonly used in research, analysis, forecasting. It provides very short explanation of theory behind the formulas.
This course does not related to any specific field of knowledge, but can be tailored if all the delegates have the same background and goals.
Some basic computers tools are used during this course
more...
From mindXCEL Consultancy
Licensed NLP Practitioner Training Licensed by Richard Bandler - Abu Dhabi

...ed successful therapists and began to create mathematical formulas of what he had noticed them doing. With some of his then students, he then took these techniques and strategies and began to build models of excellence with them.
Richard proved amazing in using his mathematical skills to ensure that these models of excellence were not only very effective, but also learnable in a very short
more...
Licensed NLP Practitioner Training Licensed by Richard Bandler - Egypt
...ed successful therapists and began to create mathematical formulas of what he had noticed them doing. With some of his then students, he then took these techniques and strategies and began to build models of excellence with them.
Richard proved amazing in using his mathematical skills to ensure that these models of excellence were not only very effective, but also learnable in a very short
more...
NLP Master Practitioner Training licensed by Richard Bandler
...ed successful therapists and began to create mathematical formulas of what he had noticed them doing. With some of his then students, he then took these techniques and strategies and began to build models of excellence with them.
Richard proved amazing in using his mathematical skills to ensure that these models of excellence were not only very effective, but also learnable in a very short
more...
From Last Minute Training
CATIA V5 - Week C - Knowledgeware 3D FTA 5 days
This course will consist of Creating parameters, Formulas and Lists, Adaptive Behaviors, Design Tables and Part Families, Knowledge Advisor Tools, Powercopies, Knowledge Expert, Rule Base, and Solution Analysis.
more...
Excel 20072010 Formulas
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 20072010 Introduction 1 Day
Topics include: entering data, creating formulas, copy and move, column width and row height, inserting and deleting columns and rows, numeric formats, alignment, fonts, lines and shading, spell check, saving and opening files, and printing.
more...
Crystal Reports 2008 Level 1
This course will cover Exploring the Crystal Reports 2008 Interface, Working with Reports, Using Formulas in Reports, Building Parameterized Reports, Grouping Report Data, Enhancing a Report and Distributing Data
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...
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 - 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...
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
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...
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...
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
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
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 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...
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...
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...
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 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
more...
Microsoft Word 2003 Level 3 - Bilingual

...irectories
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
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...
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,
more...
Microsoft Excel Introduction

... 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
more...
Microsoft Excel 2003 Level 2 (1 Day)

Location: Vancouver Date: 2008-02-08
List Price: $199 Offered Price: $139.00
Seats Available: 1
Objectives
Displaying and Printing Formulas
Using the Insert Function Feature
Mathematical and Financial Functions
Statistical and Database Functions
Creating a List
Inserting an Excel Worksheet into a Word Document
Opening and Saving Files in Different Formats
Finding and
more...
Microsoft Excel 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
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 - 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...
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...
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...
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 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...
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...
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...
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)
...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...
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...
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 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...
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 - 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 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 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...
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...
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...
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...
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...
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...
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...
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...
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 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...
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...
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 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 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...
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...
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...
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 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 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...
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...
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 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...
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 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...
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...
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...
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...
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...
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...
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...
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 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 - 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...
Microsoft Excel 2003 Level 2 1 Day - On Track
Objectives
Displaying and Printing Formulas
Using the Insert Function Feature
Mathematical and Financial Functions
Statistical and Database Functions
Creating a List
Inserting an Excel Worksheet into a Word Document
Opening and Saving Files in Different Formats
Finding and Deleting Records
Using Data Validation
Automating Tasks with Macros
more...
Microsoft 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 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...
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...
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...
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- 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...
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...
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...
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...
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 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 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 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 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 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...
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...
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...
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...
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...
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...
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 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 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 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...
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...
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...
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...
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...
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...
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...
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...
Microsoft Excel 2007 Pivot Table Workshop Level 3 Advanced
This course will consist of:
Creating a Pivot Table
Using the Report Filter
Formatting the Pivot Table
Using Formulas Functions
Working with Multiple Data Ranges
Creating PivotCharts
more...
Excel 2003 Level 1 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...
Microsoft Excel 2007 Level 2 Med
This course will consist of the following lessons:
Using Formulas In Excel
Exploring Excel Functions
Using Functions In Excel
Working With Names And Ranges
Working With Array Formulas
Working With Records And Fields
and more!
more...
MS Excel 2003 Level 2 - 1 Day - tcet
In this course, you will use Microsoft Office Excel 2003 to streamline and enhance your spreadsheets with templates, charts, graphics, and formulas.
more...
Microsoft Excel 2003 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...
Microsoft Office Excel 2007 Level 2
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 Level 2 Med
This course will consist of the following lessons:
Using Formulas In Excel
Exploring Excel Functions
Using Functions In Excel
Working With Names And Ranges
Working With Array Formulas
Working With Lists
more...
Crystal Reports 2008 Report Design III - Report Processing Strategies
As a business benefit, you will find that your increased understanding of report processing, formulas, custom functions and subreports will help you make more effective report design decisions and create more efficient reports.
more...
Microsoft Excel 2000 XP 2003 Level 2 Med
This course will consist of: Formulas In Exce, Functions, Names & Ranges, Array Formulas, Lists & filters, Records & Fields, Macros, Excel as a Database, Form Controls
more...
Microsoft Excel 2003 Level 1

Location: Vancouver Date: 2007-09-04
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
more...
Excel Introduction-1 Day

Location: Toronto Date: 2007-09-04
List Price: $275 Offered Price: $190.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 comfortable
more...
Excel Introduction-1 Day

... 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.
This course is classroom style instruction: Instructor-led, hands-on training.
For more information please visit:
more...
From Saryx
Microsoft Excel Level 2
In level 1 of the Microsoft Office Excel certification course 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 to streamline and enhance your spreadsheets with templates, charts, graphics, and formulas.
more...
Microsoft Excel 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 transfer that data to an electronic format. In this course, you will use Microsoft Office Excel to manage, edit, and print data
more...
From The Office Training Company
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...
From Computer Tutoring Ltd
Microsoft Excel 2010 Introduction






...face, how to enter information, manage files, learn about formulas and formatting as well as how to print your work.
This would be run as a private course. We can run private courses at your offices, and supply the laptops and projector.
Training materials and 3 months post training support are included the price.
Our rates are per day and not per person, and for a Microsoft course are
more...
Microsoft Excel 2007 Intermediate





...ith templates, charts and graphics. You will use advanced formulas to display data in various formats, giving your documents a more professional look.
This would be run as a private course. We can run private courses at your offices, and supply the laptops and projector.
Training materials and 3 months post training support are included the price.
Our rates are per day and not per
more...
From FOSVA Training
Microsoft Excel 2010 Level 2
...of this course students will be able to:
Use advanced formulas
Organise worksheet and table data using various techniques
Create and modify charts
Analyse data using PivotTables, Slicers and PivotCharts
Insert and modify graphic objects in a worksheet
Customise and enhance workbooks and the Microsoft Office Excel environment
Target Audience
This course is for students
more...
Microsoft Excel 2007 Level 2
...rse students will be able to:
Calculate with advanced formulas
Organise worksheet and table data using various techniques
Create and modify charts
Analyse data using PivotTables and PivotCharts
Insert graphic objects
Customise and enhance workbooks and the Excel environment
Target Audience
The target students for this course are students who desire to gain the skills
more...
From KCOM Management Sdn. Bhd.
Database Management using Microsoft Excel
This in-depth two-day course introduces Microsoft Excel users to the database features of the software application. Participants will learn how to sort and manage data in lists; filter and query data; use outlines on worksheets, lookup and database functions. Participants will also learn how to create and work with PivotTables, use data tables to make projections, audit formulas and data, protect
more...
From OST Global Solutions, Inc
Advanced Capture Management
...analysis; create advantageous teaming arrangements; apply formulas to solution development; and much more. The course also focuses on measuring and improving cost-efficiency and effectiveness of the capture team.
This course takes capture management to the next level a what does it take to maximize win probability; mastermind the most effective win strategy using cutting edge techniques.
more...
From Sonic Training
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...
From Maximum Impact Solutions
Bespoke Crystal Reports 2011
The bespoke Crystal Reports 2011 Course, is where we work with you to design the course you need for your organisation, to enable you to design the reports you want.
The course will be an interactive instructor led course, where the demos and exercises can be designed, to incorporate your data and your reporting scenarios.
Select from a number of topics and build your own course, to meet
more...
Advanced Crystal Reports 2011
The course is designed to provide delegates with extensive and in-depth knowledge of Crystal Reports 2011.
Allowing report designers to create reports that will analyse and interpret business information.
On completion of the course, delegates will be able to:
* Create Advanced Formulas,
* Create Specialised Reports,
* Create Parameterized Reports,
* Create Crosstabs, and
* Create Sub
more...
Introduction Crystal Reports 2011
On completion of this interactive instructor led course, delegates will be able to create the following reports, using Crystal Reports 2011:
Setting Up Crystal Reports 2011
Creating a Basic List Report,
Displaying Specific Report Data,
Creating Grouped and Summary Report, and
Creating Formulas within Reports
Adding Charts to Reports
more...
Advanced Crystal Reports XI




The course is designed to provide delegates with extensive and in-depth knowledge of Crystal Reports XI.
Allowing report designers to create reports that will analyse and interpret business information.
On completion of the course, delegates will be able to:
* Create Advanced Formulas,
* Create Specialised Reports,
* Create Parameterized Reports,
* Create Crosstabs, and
* Create Sub
more...
Advanced Crystal Reports 2008

The course is designed to provide delegates with extensive and in-depth knowledge of Crystal Reports 2008.
Allowing report designers to create reports that will analyse and interpret business information.
On completion of the course, delegates will be able to:
* Create Advanced Formulas,
* Create Specialised Reports,
* Create Parameterized Reports,
* Create Crosstabs, and
* Create Sub
more...
Bespoke Crystal Reports 2008
The bespoke Crystal Reports 2008 Course, is where we work with you to design the course you need for your organisation, to enable you to design the reports you want.
The course will be an interactive instructor led course, where the demos and exercises can be designed, to incorporate your data and your reporting scenarios.
Select from a number of topics and build your own course, to meet
more...
Introduction Crystal Reports 2008

On completion of this interactive instructor led course, delegates will be able to create the following reports, using Crystal Reports 2008:
Overview of crystal Reports 2008
Setting Up Crystal Reports 2008
Creating a Basic List Report,
Displaying Specific Report Data,
Creating Grouped and Summary Report, and
Creating Formulas within Reports
Adding Charts to Reports
more...
Introduction Crystal Reports XI




On completion of this interactive instructor led course, delegates will be able to create the following reports, using Crystal Reports XI:
Overview of crystal Reports XI
Setting Up Crystal Reports XI
Creating a Basic List Report,
Displaying Specific Report Data,
Creating Grouped and Summary Report, and
Creating Formulas within Reports
Adding Charts to Reports
more...
Bespoke Crystal Reports XI




The bespoke Crystal Reports Course, is where we work with you to design the course you need for your organisation, to enable you to design the reports you want.
The course will be an interactive instructor led course, where the demos and exercises can be designed, to incorporate your data and your reporting scenarios.
Select from a number of topics and build your own course, to meet your
more...
From Courage Speaks, LLC
Down and Dirty Grammar Tricks
...formulas, memory tricks, and tips!
Course Description:
Master grammar by using simple, easy-to-remember memory tricks, formulas, and tips. Save time. End frustration and embarrassement by communicating with perfect grammar every time.
Content Includes:
Why grammar can be so confusing, and why memory tricks work
Learn five formulas to perfect punctuation every time
Know when to use "I"
more...
How to Write and Manage E-mail Effectively
...otional obstacles and misinterpretations
a Time-saving formulas to save time and communicate clearly
a Simple strategies to organized and manage e-mail
a Apply amazing tips and save time by when you schedule e-mail
a How subject lines can determine if and when yours gets read
a Proper e-mail etiquette that can make all the difference
a When to avoid using e-mail as a method of
more...
Secrets to Great Grammar




...formulas and memory tricks.
Save time and embarrassment. Speak and write with confidence.
Who Should Attend:
This program is anyone who must project
a professional image in emails, documents, presentations, or while on the phone.
Since excellent grammar and writing skills are crucial in todaya s workplace, this program is essential to everyone!
If you have never a gotten ita
more...
Writing for Todays Business World How to Write Better and Faster
The business world has changed, and so has writing. You have to do more of it, faster, and to a reader who ignores most of it.
Through this highly interactive seminar, learn the secrets to capturing your reader's attention immediately! And reduce your writing to one-third the time it normally takes. As an added bonus, master punctuation and grammar with fast, easy memory tricks and formulas. We
more...
From Acend Corporate Learning
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...
From INT Information Systems, Inc.
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...
From Aspect Training
Crystal Reports Advanced
On Aspect Traininga s Crystal Reports Advance training course, delegates will create complex reports and data sources using Crystal Reports tools. They will create more sophisticated reports including sub reports and cross-tabs, and also increase the speed and efficiency of reports by using SQL queries.
Aspect Traininga s Crystal Reports Advance training course is designed for people who know
more...
From New York Interactive Media
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...
From Learn Excel Class
Introduction to Excel Class Training
...g techniques to navigate, create new models, create basic formulas (Sum, Average, Count), format and print your data, make charts and use Excela s database features (sort, filter, subtotal). The introduction to Excel training includes a printed 40-page user guide. Students also receive online access to our video library of an Excel class for you to review at your own pace.
Introduction
more...
Advanced Excel Class
...formulas and functions (Vlookup, If/ Then, Index/ Match, DSum, arrays, formula auditing techniques), what-if data-analysis techniques (pivot tables, scenarios, forecasting), database features (validations, extract unique values), advanced macros (with light VBA programming) and collaboration techniques.
Advanced Excel Training Objectives:
* Advanced Excel Formulas:
Named Ranges,
more...
Introduction To Excel
Learn Excel basics in our introduction to Excel course. Learn time saving techniques to navigate, create new models, create basic formulas (Sum, Average, Count), format and print your data, make charts and use Excela s database features. No other school offers students access to a video library for you to review the class at your leisure!
more...
From Mohd Arsalan
ADVANCED EXCEL
This program intends to impart the advance excel benefits to an individual. After the successful completion of the program, an individual will be able to use advanced filters, advanced pivots, array formulas, multi-dimensional lookup, more advanced formulas combining sumif, if, index, date functions and text functions. The program is offered online as well as as a live workshop.
more...
From Corpex Solutions
Crystal Reports training on 14th 15th Feb 2009
...Report
6. Applying Section Formatting
7. Creating Basic Formulas
8. Applying Conditional Reporting
9. Representing Data Visually
10. Distributing a Report
Date: Saturday 21st and Sunday 22nd February' 2009
Time: 9: 30am to 5: 30pm
Venue Details:
Corpex Solutions,
1001 E, 1st Floor, 14th Cross,
Off CMH Road-Opposite Road of Gokul Kuteera Restaurant
more...
From Xanterra South Rim LLC
Introduction to Spreadsheets

Training Module #3 is the introduction to spreadsheets. The training class will focus on the following: a What is a spreadsheet
a Why on a computer?
a Basics of a spreadsheet
a Types of Data
a Specific Formulas (or FUNCTIONS)
a copying formulas
a Formatting
a inserting a column
a inserting a row
a charts and
more...
From American Academy of Computer Training & Technology, Inc.
Microsoft Excel - Part I





Learn the basic functions and features of Excel. Use the Help system and navigate worksheets and workbooks. Enter and edit text, values, formulas, and pictures, and save workbooks in various formats. Move and copy data, learn about absolute and relative references, and work with ranges, rows, and columns. This course also covers simple functions, basic formatting techniques, and printing. Create
more...
Microsoft Excel - Part III




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

Training overvew
In this instructor-led live training session you will learn advanced functions and techniques in using Microsoft Excel. If you use this great tool for data operations on everyday basis this course is a must see!
Training agenda:
- Using Excel As a Database
- Filtering Excel data list
- Advanced formulas and functions
- Searching and extracting data
- Conditional
more...
MS Excel Intermediate

Training overview:
In this instructor-led live training session you will learn most important and useful functions of Microsoft Excel. This knowledge covers everyday practise in usage of this great tool.
Training agenda:
- Filling data series
- Advanced cells and tables formatting
- Working with formulas
- Basic Excel functions
- Understanding relative and absolute cell references
-
more...
MS Excel Basics

Training overview:
In this instructor-led online live training session you will learn basic Microsoft Excel functions and best practise in using them in your work.
Training agenda:
- Introducing MS Excel Environment
- Working with Workbooks
- Working with Worksheets
- Entering and editing text
- Working with text, numbers and dates
- Basic cells and tables formatting
- Basic
more...
From EJA International
Licensed NLP Business Practitioner
...ed successful therapists and began to create mathematical formulas of what he had noticed them doing. With some of his then students, he then took these techniques and strategies and began to build models of excellence with them.
NLP (Neuro-linguistic Programming) involves the study of patterns, which are created by the interaction of the brain, language and the physical body.
In simple
more...
From Advanced Concepts
MS Excel Intermediate
...on:
Excel Intermediate will concentrate on more advanced formulas and on formatting methods
Target Students: That needs to know more about calculation formulas and databases
Prerequisites: Windows xp/2003/2007/ MS Word xp/2003/2007 Basic, Ms Excel xp/2003/2007 Basic
Delivery Method: Instructor-led, group-paced, classroom-delivery learning model with structured hands-on activities.
more...
MS Excel
...arget Students: That needs to know more about calculation formulas, charts and databases
Prerequisites: Windows xp/2003/2007/ MS Word xp/2003/2007 Basic
Delivery Method: Instructor-led, group-paced, classroom-delivery learning model with structured hands-on activities.
Benefits: Performing Calculations and Charts
What s Next: MS Excel xp/2003/2007 Intermediate.
Course content:
X Working
more...
From GetOpenOffice.org
OpenOffice.org and StarOffice Comprehensive Calc


...more course covering advanced Calc topics such as charts, formulas, pivot tables, calculations, equations, scenarios, and other advanced topics. Available at your site.
For information on training and prices, see www.getopenoffice.org/training.html
The Comprehensive Calc workbook is used for this course; see the table of contents at www.getopenoffice.org/workbooks.html To order the
more...
From Systats Consulting Sdn. Bhd.
How to Optimally Adjust Processes to Maintain a Target Value
Traditional SPC concentrates on separation of common from special cause but is not meant to be a process adjustment scheme. However, in many manufacturing applications, control to a target is of primary concern. This course gives engineers the knowledge to know when adjustment is necessary, what kind of adjustment to make, and to design optimal adjustment schemes in terms of deviation from target
more...
From Intellisoft Systems
Advanced Microsoft Excel 2007



... improve productivity, enhance spreadsheets with charts & formulas and streamline your work.
Learn how you can automate common tasks, apply advanced analysis techniques to more complex data sets, collaborate on worksheets with others, and leverage on Excela s advanced functionality to simplify your day-to-day work.
Course Outline for Advanced Excel Tips & Techniques:
Day 1
Advanced
more...
From triVariant LLC
Earned Value Management Concepts
WHAT YOUa LL LEARN Earned Value Management (EVM) is a set of good business practices for managing, controlling, and predicting program performance, and if you're running a government defense, biotech, or IT program (or applying for one), you likely need to use it.
In this informative introduction, our instructor guides you through each stage of running an effective EVM system, from
more...
From Technology Training, Inc.
Engineering Statistics


This short course covers all the usual topics in reliability and statistics and explains how the theory is applied in engineering. The actual evaluation of statistical formulas is done using programmable calculators, which simplify the process and save hours of tedious work
more...
From Tekguru Career Development Company
Advance Excel 50 Percent Discount
Advance Excel. Schedule available weekdays. Contact us at 384-8890/ 544-6655 or mobile 0908-2856695
more...
From CAL Business Solutions
Microsoft Excel for Dynamics GP
Join CAL as we show you how to get the most out of GPa s integrations with Microsoft Excel. Items covered will be: the GL Reconcile Tool, exporting options with SmartList and Navigation List, several key formulas for analyzing data (including basic Pivot Tables); Live Excel Data connections; creating a Live Excel a dashboarda . Session will also include a demo of Infiniaa s
more...
From Sunshine Career Institute
IV Therapy





..., blood, plasma, albumin and TPN therapy. Medication math formulas and dosage calculations are also discussed. This program is stress-free and we look forward to seeing you in this excellent program utilizing the latest is Audio-Visual technology. Legal issues as well as scope of practice for RNs and LPNs will be discussed.
Course Fees $180 for 30 Hours of continuing education, course
more...
From IT Updates Inc
Business Objects Enterprise XI and Crystal Report Development
...ing Records, Sorting, Grouping record
3. Creating Basic Formulas (Defining formulas, Creating formulas and
Applying them
Crystal Reports XI Design: -Business Reporting Solutions
1. Report Creation Review, Managing Reports, Publishing reports to BO
Enterprise, Using Variables and Arrays, Building Parameterized Reports,
Using Report Templates, Using Report Sections
2.
more...
From Knowledge Source Inc
Microsoft Excel 2010 Level II Intermediate
Course Objectives:
use advanced formulas.
organize worksheet and table data using various techniques.
create and modify charts.
analyze data using PivotTables, Slicers, and PivotCharts.
insert and modify graphic objects in a worksheet.
customize and enhance workbooks and the Microsoft Office Excel environment.
more...
Excel Crash Course




Course Description: The first day of this course, you will create and edit basic Microsoft Office Excel 2010 worksheets and workbooks. On the second day, you will use advanced formulas and work with various tools to analyze data in spreadsheets. You will also organize table data, present data as charts, and enhance the look and appeal of workbooks by adding graphical objects.
more...
Microsoft Excel 2007 Level III Advanced
...xcel 2007: Intermediate. Students will work with advanced formulas, as well as lookup functions such as VLOOKUP, MATCH, and INDEX. In addition, students will learn about data validation and database functions such as DSUM. They will learn how to work with PivotTables and PivotCharts, how to import and export data, and how to query external databases. Finally, students will learn about the
more...
