Custom Search
Provided by: Last Minute Training

Analysing Statistical Data with Excel

Last Minute Training
Training Provided by Last Minute Training This class is an overview of calculations using selected advanced functions drawn from the statistical, database, & mathematic functions in Excel's core collections & add-in libraries. Participants will be introduced to creating user-defined functions.
This is primarily ilt training
Contact Last Minute Training for more information
Course Level:basic
Duration:1 days
Training Presented in:English
Analysing Statistical Data with Excel CORE TOPICS
Review of Excel Formulas Calculating with Common Functions
Create Basic Formulas
Order of Precedence Rules
Calculate with Simple Functions
Copying Formulas and Functions
Creating Absolute & Relative References
Multisheet and Multi-workbook Formulas
Activating the Tool Pack Add-in
Create and Apply a Name for a Range of Cells
Calculate with Basic Date/ Time Functions
Calculate with Basic Financial Functions
Calculate with Basic Statistical Functions
Calculate with Basic Lookup/ Reference Functions
Calculate with Basic Logical Functions
Calculate with Basic Database Functions

Auditing Worksheets Date/ Time Library
Trace Cell Precedents
Trace Cell Dependents
Locate Errors in Formulas
Set Data Validation Properties
Locate Invalid Data and Formulas
Watch and Evaluate Formulas
Explore Selected Advanced Date & Time Functions from the Standard and Analysis Tool Pack Add-in Libraries

Mathematics Library Statistical Library
Explore Selected Advanced Math Functions from the Standard and Analysis Tool Pack Add-in Libraries
Explore Selected Advanced Statistical and Analytic Functions from the Standard and Analysis Tool Pack Add-in Libraries

Database Library Building Custom User Defined Functions with Visual Basic
Explore Selected Advanced Database Functions from the Standard and Analysis Tool Pack Add-in Libraries
Introducing Fundamental Concepts of Visual Basic Programming
Identify and Declare Variables and Constants
Controlling Program Logic
Distinguish Between Functions and Procedures
Creating Simple Custom Functions
Using Custom Functions Within a Worksheet Formula
About The Training Provider: Last Minute Training
Last Minute Training - Last Minute Training Corp. works similar to last minute discounted travel. We sell training seminars at deep discounts on a last minute basis. If you want to save 30 - 60 off high quality training seminars and have the flexibility to attend with only a few days notice check out our website and see if the training you are looking for is on sale. While your there set up and free account...
Do you teach analysing ?
tcw11-gfc-v396M-11/20/09-23:26:06-()[A]-[A]-[A] -12:49:25