Data Subtotals

[ LiB ]

If your database contains numerical data, Excel can look at your database and create subtotals and grand totals, which can help you manage and analyze your data. Before creating subtotals, you must first sort the database by the field you want to subtotal . You can then calculate subtotals for any column that contains numbers .


graphic/13fig23.gif



graphic/13fig24.gif



graphic/13fig25.gif



graphic/13fig26.gif



graphic/13fig27.gif



graphic/13fig28.gif



graphic/13fig29.gif


[ LiB ]


Microsoft Office Excel 2003 Fast & Easy
Windows XP Registry: A Complete Guide to Customizing and Optimizing Windows XP (Information Technologies Master Series)
ISBN: N/A
EAN: 2147483647
Year: 2002
Pages: 157
Authors: Olga Kokoreva

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net