JRSETI Wiki

• Excel zooming
• Excel Worksheet
• Column Headers, Row Indexes
• New Worksheet
• Cmd-right arrow takes you to the last column
• Timestamp Converter! https://www.epochconverter.com/
• Formatting columns type

• Filtering
• Icon changes on column if it is the sorted column
• Freezing: Select cell and select “View” at top to see freezing options.
• Conditional Formatting
• =ROUND(E2/D2*100,0) - remember to enter in cell, then right mouse click lower right cell to apply to entire column
• =IFERROR(ROUND(E2/L2,2),0) avoids div errors
• Breaking a column into 2 columns. Data→Text to Columns.

Remember to “save” occasionally to not lose work!

• Insert→PivotTable

• https://support.microsoft.com/en-us/office/video-vlookup-when-and-how-to-use-it-9a86157a-5542-4148-a536-724823014785 is a good explanation
• Gottcha is that the match column needs to be included

• Median, Mean, Mode
• Data skewed symmetric, left, right

• Information is taken at a glance
• Stop light versus just seeing the words