PLS 21 Lecture Notes - Lecture 3: Power Pivot, Hyperlink, Business Intelligence

• School: UC-Davis
• Department: Plant Science
• Course: PLS 21
• Professor: D.Frank

Document Summary

Excel handles data and numbers, and logical operations. 256 (2^8) columns for a total of. 16,777,216 (2^16 x 2^8 = 16,777,216 2^24) cells. Ask not if excel can do it, but how you can do it with excel. History of spreadsheets: visicalc was the first spreadsheet program available for personal computers. It was the application that turned the computer from a hobby for computer enthusiasts into a serious business tool: clones of visicalc were soon released: Key elements of spreadsheets: cells: contain the data, cells: contain the data, rows: horizontally aligned cells, columns: vertically aligned cells. Sheet or worksheet: a single page: workbook: a file with multiple sheets. Function: used to perform mathematical or logical operations: range: data location across multiple cells. Integers (55), decimals (3. 197), exponents (5. 9e+2), special symbols. Alphanumeric (june, 7#84, 231 oaks: dates. August 19, 2002; 1/18/17; 19-aug-02: times.