JRSETI Wiki

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.
=====Excel Week 1=====

====Recommended Class====



====Required Class====

=====Module Lesson=====

  * 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! 

===Conditional Formatting===

===Pivoting====

  * Insert->PivotTable

====VLOOKUP====

  * 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

====Stats====

  * Median, Mean, Mode
  * Data skewed symmetric, left, right
====NOTEWORTHY====

  * Information is taken at a glance
  * Stop light versus just seeing the words
  * Difference between Data Science and Data Analytics: https://www.sisense.com/blog/data-science-vs-data-analytics/#:~:text=While%20many%20people%20use%20the,major%20difference%20being%20the%20scope.&text=Data%20science%20produces%20broader%20insights,answers%20to%20questions%20being%20asked.