TABLES IN EXCEL Excel tables to the web
TABLES IN EXCEL
Excel tables to the web
Getting Tables to the Web Tableizer No classes Not formatted We have had Mac problems HTML Formatter
Getting Tables to the Web Mr. Data Converter Sets up (too many) classes Formatted Caveat: it requires that there be a value in the upper left cell
What Is in the Excel Tables?
Two Possibilities Just type in the table Quick and easy OR Use the power of Excel We start the journey today
Spreadsheets
Why Use Spreadsheets? Repetitive calculations Frequency Complexity Different views Analysis of data Explorative Manipulation
Basic Structure Spreadsheet (Worksheet) Column (letters) Row (numbers) cell (letter-number) workbook = collection of worksheets
Cells
What Can Be In a Cell Label – identification for people Constant – any format Text, number, picture, hyperlink, … Value for computer Format for people Formula Always – uses cells & constants begins with = “takes the value of”
Formulas
Simplest Formula =cell Why do you use it? Fundamental Principle: Never have to change anything in two places Variant of DRY (Don’t Repeat Yourself) Copy-paste Fine if you really want a snapshot Does not work if data will change
Formulas Referencing Cells Once you define the formula Can change the values as often as you like Automatically re-computes Treats cells as variables Defined by location, not value Each cell constant or another formula Example Pay = hourly rate * hours worked Values can change Formula remains the same
Copying formulas Want the same information for different data Example: Can min, max, avg grades for each assignment use copy or fill Copying a formula moves it relatively
Dragging (Fill) Bottom One right corner cell copies Value exact Formula Multiple changes cells extrapolate
What if Want SAME Place Absolute Can positioning lock the cell, column or row Cell: $A$1 Column: Row: To $A 1 A$1 change a reference to absolute Insert PC: $ Use F 4 Mac: Cmd-T
Finding functions
- Slides: 18