Just my opinion so consider it for what it is worth!
There are 3 types of spreadsheet "consumers".
Number crunchers (like me!)
Paper shufflers (people who put together reports)
Managers, executives (they read the reports of the numbers I crunch)
What kind of info you want to include in your training materials depends on
who your audience is.
From my perspective, a spreadsheet starts with a good solid understanding of
how to crunch numbers. So, I'd want more training on formulas. If I was a
paper shuffler I'd want more training on things like tables, pivot tables,
charts. If I was a manager/executive I probably would not be too concerned
with any of that. I'd just want a "pretty" report!
You might want to include a little bit of everything but if your audience
leans one way or the other include more info depending on which way they
Personally, I rarely use tables, pivot tables. In my line of work they seem
very limited in scope (not much good for anything beyond very basic stats).
But on the other hand, some people use tables/pivot tables for everything!
Microsoft Excel MVP