| Similar Articles |
|---|
 |
CFO
June 15, 2012
Bill Jelen |
Blank Check How to get rid of pivot table blanks without affecting calculations.   |
PC Magazine
September 21, 2004 |
A Subtle Bug in Excel Pivot Tables A reader discovers an unusual Excel 2003 flaw, and we have a demonstration. |
PC Magazine
July 2, 2008
Neil J. Rubenking |
Eight Handy Tools in Excel You Probably Don't Know About These simple features in Excel will smarten up your spreadsheets in no time. |
PC Magazine
May 16, 2007
Helen Bradley |
Analyze Data in a Cinch Excel 2007 boasts a host of new feature. Among those is PivotTable a neat and useful new way to look at your data. |
PC Magazine
July 1, 2003
Neil J. Rubenking |
Filtering with Excel's PivotTable Is there a way to count the number of occurrences of each name in an Excel column? |
PC Magazine
March 6, 2007 |
Analyze Multiple Worksheets in Excel Combine long lists of items from about a dozen different workbooks into one Excel worksheet, without duplicating entries. |
PC Magazine
August 3, 2004 |
Counting Unique Names in Excel, Reloaded How to count unique names in excel using pivot tables. |
PC Magazine
June 20, 2007 |
Save Time With Heading Functions in Excel Making custom applications for Excel is easier than you think. Read on to learn how. |
PC Magazine
March 16, 2004
Neil J. Rubenking |
Count Unique Names in Excel I have a list of some 900,000 names in an Excel worksheet. Most of the names have duplicates. How can I count the number of names without counting duplicate entries? |
PC Magazine
October 1, 2003
Neil J. Rubenking |
More PivotTable Power A July 2003 article "Filtering with Excel's PivotTable" states that a pivot table can't tell you who places the high bid, but this is not correct. |
Macworld
March 2001
James Bradbury |
Track Your Progress with Excel Formulas and Graphs Are at Your Fingertips... |
PC Magazine
April 6, 2004
Helen Bradley |
Better Lists in Excel Excel 2003 offers some useful new tools for working with lists. |
PC Magazine
September 14, 2005
Ben Z. Gottesman |
PivotTable Magic Exploring complex Excel data is easier with a PivotTable. Our tips show you how. |
PC World
October 11, 2002
John Walkenbach |
Who Knew Excel Could Do That? Ten Top Tips Make your spreadsheets work harder and give them a polished look with these nifty tricks. |
PC Magazine
April 20, 2005
Helen Bradley |
Outlining Your Data Use Excel's Group and Outline feature to view only as much data as you need. |
PC Magazine
May 31, 2006 |
Pick Lottery Numbers With Excel Using the LARGE() function in Excel. |
PC Magazine
November 18, 2009
Edward Mendelson |
Microsoft Office 2010 Beta There are no big disruptive innovations like the Ribbon in Office 2010, just a bunch of solid new features and enhancements. |
Macworld
August 16, 2007
Rob Griffiths |
Numbers '08 Numbers '08 is a strong entry for Apple in the spreadsheet arena, especially for those who find Excel's feature set overwhelming. |
PC Magazine
August 2, 2006
John Clyman |
Tableau 2 Tableau packages powerful, attractive analytic capabilities into a remarkably smooth user interface. A powerful and compelling step up from Excel's pivot charts. |
