Excel Functions & Data Analysis Tools

Short Description
In Excel, all formulas begin with an equal sign (=) and are … formula contains operators with the same order of precedence, Excel …

Website: www.techdocs.ku.edu | Filesize: 431kb

Content
Functions & Data Analysis Tools
Academic Computing Services
A Division of Information Services
www.ku.edu/acs
Abstract:
This workshop focuses on the functions and data analysis tools of Microsoft Excel. Topics included are the function wizard, function definitions, and the data analysis tool pack.
Contents
Introduction……………………………………………………………………………………………………….3
Objectives…………………………………………………………………………………………………………3
Prerequisites……………………………………………………………………………………………………..3
Related Training Available from ACS……………………………………………………………………..3
Definitions…………………………………………………………………………………………………………4
Function Wizards………………………………………………………………………………………………..5
Sample Functions in the Function Wizard……………………………………………………………7
Add-in Commands and Functions………………………………………………………………………….9
Loading an add-in……………………………………………………………………………………………9
Unloading an add-in……………………………………………………………………………………….10
Data Analysis Tools…………………………………………………………………………………………..10
Histogram……………………………………………………………………………………………………..10
Conditional Sum…………………………………………………………………………………………….13
Analyzing Data with the Pivot Table………………………………………………………………….14
Array Formulas………………………………………………………………………………………………16 . 2003 University of Kansas. All rights reservedACS Computer Training
Functions & Data Analysis Tools
Getting Additional Help………………………………………………………………………………………18 Academic Computing Services - 2 - . 2003 The University of Kansas
A Division of Information Services…