ExecuTrain Houston

At ExecuTrain we drive performance and opportunity

Archive for February, 2012

Feb

01

Monthly Tip | Execl 2010 Consolidating Data

Microsoft® Excel 2010 Consolidating Data

You may find that you frequently have related lists of data in multiple sheets or workbooks. Display a summary of the data by consolidating it onto one sheet.

  1. 1. Click the destination cell.
  2. 2. On the Data tab, in the Data Tools group, click the Consolidate button.
  3. 3. In the Consolidate dialog box, in the Function list, select the appropriate function.
  4. 4. In the Reference box, specify the first source area you want to consolidate.
  5. 5. Click the Add button.
  6. 6. Repeat steps 4 and 5 until all source areas are specified then click the OK button.

Tags: , ,
Posted in Monthly Tip | Comments Off

Microsoft, Windows, Access, Aero, Excel, Outlook, PowerPoint, and Visio are registered trademarks or trademarks of Microsoft Corporation in the United States and/or other countries.

Check:
Thank you! One of our advisors will contact you shortly.

Check:

Your information will not be shared or sold. View our Privacy Policy

Your message has been sent successfully!