data_viz_week_1
This is an old revision of the document!
Table of Contents
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
Remember to “save” occasionally to not lose work!
Conditional Formatting
NOTEWORTHY
- Information is taken at a glance
- Stop light versus just seeing the words
data_viz_week_1.1600013484.txt.gz · Last modified: 2020/09/13 16:11 by jrseti