wanmen.org
excel course by WANG Peifeng (M$ MVP Lecturer)
5.
Order
user defined order for specific requirement
duplicated title via extra column of numbers (wage list example)
6.
Filter
auto filter, ~* to mean the charactor *
advanced filter, (complex conditions)
- and, for the same row,
- or, for different rows.
7.
Type Summary
different level of summary
looped summary
search and position, for floating object delete
levels may be the result of Group Construction
8
Basic Functions
sum, ave, max, min, count, counta
drag = select then control + enter, could be facilitated via 'select and position'
single variable solving, data->analysis simulation->single varialbe solution