sumrizing data

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Sumrizing Data

Sumrizing Data

resolvedResolved · Medium Priority · Version 2003

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?

Edited on Thu 10 Jul 2008, 09:17

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


 

Excel tip:

Activating the formula bar with the keyboard in Excel 2010

The 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.

View all Excel hints and tips


Server loaded in 0.09 secs.