Instructor Led Data Validation Training
Data Validation Training Provider? - Tell us about your Training!
Please select the location nearest to you:
United Kingdom
Canada
United States
Croatia
Singapore
Australia
South Africa
France
India
From silicon beach training
Microsoft Excel Advanced Training


Microsoft Excel is the world's most popularl spreadsheet application and makes calculating, displaying and sharing data easy.
This advanced excel training course introduces delegates to Excel's more powerful functions, including Absolute Cell Addressing, Conditional Functions, Data Validation, Pivot Tables and much more besides
more...
From Software Training Academy, Inc
Introduction to Ruby on Rails



Learn foundational Ruby and the theory and practice of Rails in this four-day hands-on course. The instructor will coach you in Ruby language constructs and the entire Rails development stack: domain modeling with ActiveRecord, controller and view implementation, testing, database migrations, data validation techniques, AJAX fundamentals, etc. Students will learn how to install, to program in Ruby
more...
Microsoft Excel - Advanced



... 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 analytical features of Excel (such as Goal Seek and Solver), running and recording macros, and sharing Excel data via
more...
From Hands On Technology Transfer, Inc.
PHP Programming


...reports. E-commerce skills including user authentication, data validation, dynamic data updates, and shopping cart implementation are covered in detail. Students also learn how to configure PHP and the Apache Web Server. Comprehensive lab exercises provide facilitated hands on practice crucial to developing competence and confidence with the new skills being learned.
Course Prerequisites:
more...
From Open Source Training
PHP Programming
This hands on PHP Programming course provides the knowledge necessary to design and develop dynamic, database-driven web pages using PHP version 5. PHP is a language written for the web, quick to learn, easy to deploy and provides substantial functionality required for e-commerce. This course introduces the PHP framework and syntax, and covers in depth the most important techniques used to build
more...
From Last Minute Training
Microsoft Excel 2003 Level 2 (1 Day)

Location: Vancouver Date: 2008-02-08
List Price: $199 Offered Price: $139.00
Seats Available: 1
Objectives
Displaying and Printing Formulas
Using the Insert Function Feature
Mathematical and Financial Functions
Statistical and Database Functions
Creating a List
Inserting an Excel Worksheet into a Word Document
Opening and Saving Files in Different Formats
Finding and
more...
Microsoft Excel 2003 Level 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...
From IT's Easy Software Training
Advanced Excel

a Customising a Toolbar
a Using Solver
a IF Statements
a Advanced VlookUp and SUMIF
a IF And
a Logical Tests, Error Trapping
a Using Form Tools
a Data Validation
a Advanced Pivot Tables Formulae
a Recording Basic Macros
a Importing External Data
a Using Named Ranges in a Formula
a Advanced Database Filters and functions
a Advanced Scenarios
a
more...
From American Academy of Computer Training & Technology, Inc.
Microsoft Excel - Part III




Work with advanced formulas, as well as lookup functions such as VLOOKUP, MATCH, and INDEX. Learn about data validation and database functions such as DSUM. Work with PivotTables and PivotCharts, import and export data, and query external databases. Learn about the analytical features of Excel (such as Goal Seek and Solver), running and recording macros, and sharing Excel data via the Web.
more...
From ALP Limited - Artificial Lift Performance
Production Optimization Using Nodal Analysis
...Basic fluid properties (PVT)
Nodal analysis methodology
Data validation and knowing what data to request
Understand and apply multiphase tubing and pipe flow principles
Effect of stimulation and artificial lift on production
Overview of artificial lift methods
Modelling artificial lift using Nodal Analysis techniques
Simple methods to evaluate production benefit and economics
The
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...
From Intellisoft Systems
Advanced Microsoft Excel 2007



...
Edit a Macro
Apply Conditional Formatting in Excel
Add Data Validation Criteria
Update a Workbook's Properties
Modify Excel's Default Settings
Advanced Excel Lesson 7:
Collaborating with Others
Protect Files
Share a Workbook
Set Revision Tracking
Review Tracked Revisions
Merge Multiple Workbooks
Restrict Document Access
Advanced Excel Lesson 8:
Auditing Worksheets
Trace
more...
From Navigator Project Finance
Project Finance Modelling A



...lications of Conditional Formatting
* Application of Data Validation (incl offsheet list selection)
Smart Functions
* Discussion around recommended functions and their applications
* SUMIF/ COUNTIF/ SUMPRODUCT/ DATE FUNCTIONS
* + takeaway file of demonstrations
* Array Functions {Average()}, {Min()},{Transpose()}
Sensitivities /Scenarios
* Using Flex
more...
From Knowledge Source Inc
Microsoft Excel 2007 Level III Advanced
builds on the skills and concepts taught in Excel 2007: Intermediate. Students will work with advanced formulas, as well as lookup functions such as VLOOKUP, MATCH, and INDEX. In addition, students will learn about data validation and database functions such as DSUM. They will learn how to work with PivotTables and PivotCharts, how to import and export data, and how to query external databases.
more...
From Computer Training Source, Inc.
Microsoft Excel Advanced
...cros, learn spreadsheet protection and validation, master data validation, merge and link workbooks, and use advanced data analysis tools. Our classes are all instructor-led, hands-on learning. Each student has their own computer and is given a student manual with practice files to take home. A free repeat, within six months, is included as well as thirty days of technical support. Class is
more...
From Intertech
ASPNET MVC Training with VS 2010 Training
ASP. NET MVC is a fascinating technology that provides an alternative to Web forms for building Web Applications. Instead of building pages using server controls that provide relatively little control over the HTML they produce, MVC gives you complete control. The course starts with an introduction to ASP. NET MVC and the Model-View-Controller pattern on which it is based. You'll learn about
more...
From NetLearn
Excel 2007 basic - advanced




...ent
Topic A: Validating cell entries
A-1: Observing data validation
A-2: Setting up data validation
Topic B: Exploring database functions
Unit 4: PivotTables and PivotCharts
Topic A: Working with PivotTables
A-1: Creating a PivotTable
A-2: Adding fields to a PivotTable
Topic B: Rearranging PivotTables
B-1: Moving fields
B-2: Hiding and showing details
B-3:
more...
From Applied Office
Microsoft Excel 2003 - Locking a Workbook



...ts to be used by other employees and reduce error through data validation, cell locking, and automated assistance. They will learn how to password-protect parts of the spreadsheet, or the entire workbook, to create a solution or template that can be used throughout the organization.
~~~~~~~~~~~~~~~~~~
About the Location
Classes are located at the beautiful University of the Pacific
more...
From GEO-FORM S.A.S.
Complete Outline of Seismic Data Acquisition and Overview of Seismic Processing Analysis
...eismic Interpretation (including data quality control and data validation). It is a detailed exposition of all the processing sequence available in the industry. Emphasis is given from practical aspect and includes a comprehensive set of course documentation and is presented in an informal style to promote maximum participation and discussion.
It is also highly recommended and suitable for
more...
From Dataspark
ExcelVBMS Access training in Bangalore
...k, Solver function, Scenarios, Data tables Data Analysis, Data validation, Formatting and conditional formatting
B) Data Management: - Organizing Data, Sorting and Filtering, Grouping and outlining data, Data subtotaling, Subtotaling, grouping and filtering data, advanced functions in Excel, Lookup functions, Mathematical functions, Text, database functions and Data consolidation, macros
more...
From GITS Academy
MS Excel Advacned training Bangalore
...ver function, Scenarios, Data tables Data Analysis, Data validation, Formatting and conditional formatting
B) Data Management: - Organizing Data, Sorting and Filtering, Grouping and outlining data, Data subtotaling, Subtotaling, grouping and filtering data, advanced functions in Excel, Lookup functions, Mathematical functions, Text, database functions and Data consolidation, macros
more...
