Creating a PivotTable Report

To create a PivotTable report: 1. Select any cell in the source data, and press Ctrl+Shift+* (in Excel 2003, press this or Ctrl+A). 2. Press Ctrl+...

Comparing Lists in Excel 2007

In the screenshot below see two Lists, first list in range A2:A5, second list in range D2:D6. The problem: How to compare lists to find items ap...

Summing Sales Quantities and Amounts of Several Lists, or Presenting the Figures Side-by-Side in Excel 2007

To total the quantities and the amounts of monthly sales Lists: 1. Define Names for two Lists, in screenshot, January2006 (range A1:C6) and Februar...

Summing Stock Lists in Excel 2007

To total stock List quantities: 1. Define Names for two Lists List1 and List2 (see screenshot). 2. Select cell A16 (see screenshot), and select Da...

Coloring and/or Copying Subtotals from Consolidated Lists Containing Links in Excel 2007

To color and/or copy subtotals summary from consolidated Lists: 1. In the Subtotal levels (see screenshot in previous topic), click level1. 2. Sel...

Consolidating Lists in Excel 2007

In this article, we’ll learn about Consolidate option in Microsoft Excel. It is an efficient option to combine the data and summarize data from mul...

Summing Monthly Trial Balance Figures

In this article, we are going to learn how to sum monthly trail balance in Microsoft Excel. Which source is available to do it? In Excel, if we want ...

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

Visit Us On TwitterVisit Us On FacebookVisit Us On Youtube