3 ms·
> Only God Himself can make a pivot table that's usable by a newcomer without "having to read any documentation" Then I guess god himself built the Excel pivot
by jameshart 9y ago
> Only God Himself can make a pivot table that's usable by a newcomer without "having to read any documentation"
Then I guess god himself built the Excel pivot table UI, because I know I never read the documentation on pivot tables before diving in. I just picked up from somewhere that a problem I had might be solved with a pivot table, dug through the UI to find the ‘insert pivot table’ option, and followed the prompts, backtracking with ‘undo’ if things went wrong.
There is real power in interfaces where a user can, knowing that something is possible in the tool, figure out for themselves how to accomplish that goal. Yes, without having to read documentation or attend a training course.
- TeMPOraL 9y agoYou got me here. I wanted to quote something off GP's comment that it obscured what I really wanted to say - that is, using some advanced feature without learning. Learning through reading about it, or learning through experimenting with it. Both are valid ways, but you just can not make a powerful tool that does not require learning.