excel

Question 1

data

Answer 1

remove duplicate
create lists
text to columns
flash fill
to refresh all links and datasets

Question 2

view

Answer 2

freeze column

Question 3

design

Answer 3

to use sub totaling table
trend line chart( in chart category )

Question 4

home

Answer 4

format cell
conditional formatting
text orientation
change sheet style
to change row or column size
create table