Differences

This shows you the differences between two versions of the page.

--- data_viz_week_1 [2020/09/12 21:06] – [Module Lesson] jrseti
+++ data_viz_week_1 [2020/09/13 20:29] (current) – [NOTEWORTHY] jrseti
@@ Line 15: / Line 15: @@
   * 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.