This preview shows pages 1–7. Sign up to view the full content.
Excel Fundamentals
Lecture  2
This preview has intentionally blurred sections. Sign up to view the full version.
View Full Document Class Objectives
•
Basic Excel Calculations
•
Learning EXCEL built in functions
–
Learning to use CONVERT() function
Assigning name to Variable Values
A variable value can be assigned a name and subsequently used in formulae
Name typed in for
the value in cell E4
Formula for cell E8
changed to Volume/D8,
equivalent to $E$4/D8
This preview has intentionally blurred sections. Sign up to view the full version.
View Full Document Naming Arrays
Entire array
given the name
Volumes
Array name used within
the builtin function SUM
to calculate total volume
produced
To delete a
name select
Insert/Name/
Define
Excel Built in Functions
Σ
In previous example, suppose
we want to calculate average
Volume Produced
Click on cell where you want
to enter average. Type “=”.
Click on arrow next to
in
the standard toolbar. Select the
function Average. Select the
appropriate range.
Average = (B3+B4+B5)/3
Range B3:B5
replaced by
name: Volumes
Range B3:B5
This preview has intentionally blurred sections. Sign up to view the full version.
View Full Document Built in Functions
There are other built in
functions too. Supposing we
want to calculate the Standard
Deviation.
Click on cell where you want
This is the end of the preview. Sign up
to
access the rest of the document.
This note was uploaded on 04/27/2008 for the course PGE 310f taught by Professor Srinivasan during the Spring '08 term at University of Texas at Austin.
 Spring '08
 Srinivasan

Click to edit the document details