will introduce you to the exciting new pivot table features in Excel 2007. Create quick summaries and pivot charts, add impact with traffic light icons, design calculated fields, group dates and numbers.
Go To Special Sections of an Excel Worksheet
Posted on November 12th, 2008 by Debra Dalgleish
Excel reports often have blank rows that separate the sections. In this example, I needed a new formula to calculate the average price per order. After entering the formula in cell E2, I copied it down to the last row in the report. That was quicker than pasting the formula into each little section in [...]
Filed under: Data Entry, Excel, Keyboard Shortcuts | 2 Comments »
