IST 195 Lecture Notes - Lecture 1: Sparkline

• School: Syracuse University
• Department: Information Studies
• Course: IST 195
• Professor: Jeffrubin

Document Summary

Allow you to create instructions using mathematical expressions and commands. Allows you to set rules for cell formatting. A tiny chart in a worksheet cell that provides a visual representation of data. Retrieves information from an excel database based on supplied instance of a unique identifier. 4 pieces of information: lookup value, table array, col_index_num, true/false (based on sorted or not) Separating the values in each row with specific character. Most spreadsheet or database applications are able to import or export (read/save) data in a delimited format. Enables someone to quickly and easily summarize and analyze large amounts of data.