If (if/then) Logical_test: enter statement that you wish to evaluate referring to specific cell Formulas—Function Library: Insert Function icon A logic statement in excel that can be Value_if_true: enter the value OR Logical icon IF dialog box used to check a certain criteria. If the you want to appear if the criteria is found to be TRUE, then it NOTE: statement from the logical test returns a predefined value; however, depict cells without values as is true “” if it is false it returns a different Can embed IF statements within IF Value_if_false: enter the value value. Functionally, it can be used to statements you want to appear if the create categories or identify values statement from the logical test that are or are not in a specified is false range. Lookup_value: is the linking Vlookup Tool that allows you to search one Insert new column/select the cell where you variable in your current dataset row or column or multiple rows and want the Vlookup formula to be calculated (or the cells in which you will columns; almost like a phone book Formulas—Function Library: Insert Function enter the value whose data where you start with a piece of icon VLOOKUP dialog box you’re looking for) Select the function components as indicated Table_array: is the dataset you information you know. Functionally, are looking in that has the allows you to merge data sets via a linking variable in the first linking variable (such as patient column (or the data you want medical record number). Also helpful NOTE: vlookup to use for its search) Index/linking variable (e.g. MRN) must be in Col_index_number: specify when you need to find information in the 1st column of the named range which column within the a very large spreadsheet. table_array you would like to look in (number of columns over from the index) Range_lookup: specify FALSE for exact match and TRUE for approximate match Statistical Many basic statistical tests are Two options to locate different tests: tests available in excel. These can be Formulas function library more functions – helpful to do quick statistical statistical view available functions calculations, but probably would not Data Analysis Data analysis view and select – be your primary data analysis tool. desired test
If (if/then) A logic statement in excel that can be used to check a certain criteria. If the criteria is found to be TRUE, then it returns a predefined value; however, if it is false it returns a different value. Functionally, it can be used to create categories or identify values that are or are not in a specified range. Formulas—Function Library: Insert Function icon OR Logical icon IF dialog box NOTE: depict cells without values as “” Can embed IF statements within IF statements Logical_test: enter statement that you wish to evaluate referring to specific cell Value_if_true: enter the value you want to appear if the statement from the logical test is true Value_if_false: enter the value you want to appear if the statement from the logical test is false Vlookup Tool that allows you to search one row or column or multiple rows and columns; almost like a phone book where you start with a piece of information you know. Functionally, allows you to merge data sets via a linking variable (such as patient medical record number). Also helpful when you need to find information in a very large spreadsheet. Insert new column/select the cell where you want the Vlookup formula to be calculated Formulas—Function Library: Insert Function icon VLOOKUP dialog box Select the function components as indicated NOTE: Index/linking variable (e.g. MRN) must be in the 1st column of the named range Lookup_value: is the linking variable in your current dataset (or the cells in which you will enter the value whose data you’re looking for) Table_array: is the dataset you are looking in that has the linking variable in the first column (or the data you want vlookup to use for its search) Col_index_number: specify which column within the table_array you would like to look in (number of columns over from the index) Range_lookup: specify FALSE for exact match and TRUE for approximate match Statistical tests Many basic statistical tests are available in excel. These can be helpful to do quick statistical calculations, but probably would not be your primary data analysis tool. Two options to locate different tests: Formulas – function library more functions statistical view available functions Data – Analysis Data analysis view and select desired test
aspire_excel_2013_pc_and_mac_2016_guide_final.docx