Ask a table a question and get a trustworthy answer back. Built around the things that quietly go wrong in real reports — rows disappearing, totals that do not add up — rather than syntax you could look up.
Asking a table a question
Pick the columns you want and throw away the rows you do not.
Counting things in groups
Turn a long list of orders into one number per group.
Bringing two tables together
Answer questions that live in more than one place at once.
Running totals and rankings
Compare each row against the group it belongs to.