BUS 150 Lecture Notes - Lecture 1: Pivot Table, Dialog Box, Hyperlink
Document Summary
Vlookup function: =vlookup(value to be looked up, table in assumption area, column # within table containing result we want to use, true or false: true: approximate match. Vlookup function after column # then it assumes it is true. An approximate match means it will look for largest value less than or equal to what you are looking up. Comparison values need to be in ascending order. Mostly used for text, entries can be in any order. entries. And function: =and(condition 1, condition 2, etc : all conditions must be true, results will be. Or function: =or(condition 1, condition 2, etc : only one condition must be true, result will true or false be true or false. Conditional formatting: finding duplicates through highlight cells rules: home conditional formatting. Pivottables and pivot charts: easy re-arranging of a lot of data: value fields: text fields are counted.