Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Advantages to Table Feature in Excel 2007?
I have a question that I have never had to deal with as an Office 2000-2007
Trainer at my company. One of our departments needs to know how to use the various Excel 2007 features. One thing on their list is the Excel 2007 Table feature. 1) It seems like an interesting option that automates many of Excel's features. I typically do not use the Table feature and teach how to do the various options without using the Table option. This upcoming training has me thinking. Should I just teach the Table option and not worry about the students understanding many of the underlining automated features like naming the table, calculations using the =subtotal functions, various formatting? What are the advantages and/or disadvantages to the Table feature for a basic Excel user? Does it automate too much? Any thoughts on this would be greatly appreciated! Thanks! Jugglertwo |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Advantages to Table Feature in Excel 2007?
Just my opinion so consider it for what it's 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 wouldn't 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 lean. 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! -- Biff Microsoft Excel MVP "Jugglertwo" wrote in message ... I have a question that I have never had to deal with as an Office 2000-2007 Trainer at my company. One of our departments needs to know how to use the various Excel 2007 features. One thing on their list is the Excel 2007 Table feature. 1) It seems like an interesting option that automates many of Excel's features. I typically do not use the Table feature and teach how to do the various options without using the Table option. This upcoming training has me thinking. Should I just teach the Table option and not worry about the students understanding many of the underlining automated features like naming the table, calculations using the =subtotal functions, various formatting? What are the advantages and/or disadvantages to the Table feature for a basic Excel user? Does it automate too much? Any thoughts on this would be greatly appreciated! Thanks! Jugglertwo |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Table Name Autocorrect Feature Excel 2007 | Excel Worksheet Functions | |||
How do I find the "Show Pages..." Pivot table feature in 2007? | Excel Discussion (Misc queries) | |||
I want to know the Advantages or benefits of MS Access and Excel? | Excel Discussion (Misc queries) | |||
Advantages of Excel over Pencil and Paper | New Users to Excel | |||
What are the advantages of using Access over Excel? | Excel Discussion (Misc queries) |