Instructor Led Data Validation Training - Training Resources
Data Validation Training Provider? - Tell us about your Training!
Please select the location nearest to you:
Canada
United States
United Kingdom
Australia
South Africa
Croatia
Singapore
From Last Minute Training
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 2003 Level 2 (1 Day)

Location: Vancouver Date: 2008-02-08
List Price: $199 Offered Price: $139.00
Seats Available: 1
Objectives
Displaying and Printing Formulas
Using the Insert Function Feature
Mathematical and Financial Functions
Statistical and Database Functions
Creating a List
Inserting an Excel Worksheet into a Word Document
Opening and Saving Files in Different Formats
Finding and Deleting Records
more...
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 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 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 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 Microcomputing Solutions ltd
Advanced Microsoft Excel
... Custom Number Formats
a Conditional Formatting
a Data Validation & Cell Protection
a Hiding Cell Entries
4 Using Lists
a Advanced Sorting & Data Filtering
a Pivot Tables
a Database Functions
5 More about Worksheets
a Worksheet Auditing
a Using Views
a Scenarios & Report Manager
a Designing Data Entry Forms
6 Advanced Charting
a Understanding a
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 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 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
...
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...
