Excel Learning 20200318

wanmen.org

Peifeng WANG M$ Lecturer

13

Table

data update (accumulation): record list --> table

automated new record adaption

14

Data Safety

data validation (to avoid unintended input)

• between
• from list
• input method mode (any, on, off)

protection

review-->protect table

column lock (unlock for data input)

unlock + fine-grained protection option

15

Email Combine

template, link data, combine doc

combine opt.

• letter, record per page
• content, record continues