Tips: Excel Tip - Using Pivot Tables
Posted on Monday, October 18, 2004 @ 12:33 PM EDT
|
|
amichalek writes "Businesses large and small routinely amass large amounts of data into Excel spreadsheets. That's fine, but once you've got all that data, how can you better understand it and massage it?
Here's one way: Take advantage of the "PivotTable" functionality built into Microsoft Excel, included in all versions of Microsoft Office.
With PivotTables, you can quickly turn rows of data, such as sales information or inventory figures, into summary reports. Once you have the summary, you can then change the format to create other reports or summaries.
Read the tutorial here.
Small business expert Andrea Michalek is the managing director of Unit of 1.
Andrea built this service to support micro-business owners. The Unit of 1 website is equal parts business networking, community blog, and
member-contributed, expert articles.
Andrea is a Philadelphia-based technology management consultant.
She specializes in building products and services that make complex technology problems as simple as they should be.
Examples include, PDF converter Fast PDF
and News / RSS engine Topular.
Andrea Michalek
1062 Kingscote Drive - Harleysville, PA 19438
Phone: (215) 280-1805
email: andrea at unitof1 dot com
"
|
Technology
|
|
|
|
Permalink | Article submittted by amichalek |
| "Tips: Excel Tip - Using Pivot Tables" | Login/Create an Account | 0 comments |
|
| | The comments are owned by the poster. We aren't responsible for their content. |
|
|
|
You are still an Anonymous user. To comment on this article, please register - it's free. |
|
| |
|
: Unit of 1 Article Archive : Amazon eStore
