98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Sumrizing Data
Sumrizing Data
Resolved · Medium Priority · Version 2003
Fri 27 Jun 2008, 16:45Delegate Asayehegn said...
Asayehegn has attended:
Word Intermediate course
Excel Intermediate course
Outlook Advanced course
Sumrizing Data
How can i easily sumrise huge number of data other than using pivot table?
Thu 10 Jul 2008, 09:17
Edited on Thu 10 Jul 2008, 09:17Trainer Pete said...
RE: Sumrizing Data
Hi Asayehegn, Thank you for your question.
There are three main methods of summarising data not using Pivot Tables, and these are;
Subtotaling
Outlining
Consolidation
These options are covered in our Excel Courses Intermediate and Advanced, and are all quite in depth, perhaps if you wish to look at these methods then you could come back and we can give a much more focused attention to your needs.
regards Pete
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Activating the formula bar with the keyboard in Excel 2010The formula bar in Excel 2010 contains a number of different formulas. However, it is time consuming to open the formula bar every time and insert the formula using the mouse. Instead, you can activate the formula bar with the keyboard. Simply press the F2 button on the keyboard then the information in the cell will expand allowing you to edit the information in the cell. |
