| Similar Articles |
|---|
 |
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 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 World
August 23, 2006
Dennis O'Reilly |
Web Spreadsheets Nearly Ready for Prime Time Internet services offer simpler, easier-to-use worksheets. |
CFO
May 15, 2012
Bill Jelen |
Keep It Secret How to make sure hidden rows in spreadsheets stay hidden. |
Macworld
March 2001
James Bradbury |
Track Your Progress with Excel Formulas and Graphs Are at Your Fingertips... |
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
December 9, 2003
Brickley & Cutting |
Automate Long Fills In Excel It's easy to create a macro that takes the hassle out of filling large ranges in Excel. |
PC Magazine
August 1, 2007
Neil Rubenking |
Excel Formulas That Read Your Mind Understanding #REF! error markers in Excel formulas. |
Macworld
December 2001
Joseph Schorr |
Mesa 3 Mesa 3, a full-blown spreadsheet program for OS X, lets you build a budget, map out complex statistical data, and produce presentation-quality reports. But how does Mesa measure up to Microsoft Excel when it comes to slicing and dicing your numeric data? Not very well, unfortunately... |
PC Magazine
September 2, 2003
Neil J. Rubenking |
Sort Thousands of Rows Individually You can run a sort operation on each row of an Excel worksheet using a handy function. |
PC Magazine
August 2, 2006
John Brandon |
Get to Know Excel Templates Making sense of data is both the purpose of Microsoft Excel and its challenge. |
CFO
December 1, 2010
Marie Leone |
Total Trouble The older generation of Excel users remembers how potentially dangerous this Microsoft snag can be. |
PC World
December 17, 2001
John Fontana |
Exposing Excel's Dirty Little Secret Spreadsheet could potentially reveal confidential data, but Microsoft says the problem is only one of perception... |
PC Magazine
October 14, 2003
Neil J. Rubenking |
Absolute and Relative References in Excel Avoid error messages in your formulas by using the $ character to indicate cell references that should never change. |
PC Magazine
January 31, 2007
Helen Bradley |
Introducing Excel 2007 Along with its new interface, Microsoft Excel 2007 offers several subtle improvements to those spreadsheet tools you use every day. |
PC Magazine
May 18, 2004
Neil J. Rubenking |
Another Way to Highlight Formulas Expert advice on highlighting cells containing formulas in Excel. |
PC Magazine
August 12, 2008
Neil J. Rubenking |
Checksum for a Spreadsheet Create a cell in Excel that does the equivalent of a "hash" or sum of the entire active workbook. |
PC Magazine
June 1, 2005 |
Beyond Excel: Spreadsheet Add-Ons and Alternatives Here's a look at four programs that help you map, chart, model, and display complex calculations in ways Microsoft Excel can only dream of: Advantage for Analysts 4.0... Quantrix Modeler 1.2 Professional Edition... Tableau... Xcelsius Enterprise Suite... etc. |
PC Magazine
November 16, 2004
Neil J. Rubenking |
Copy Only Values in Excel A simple technique lets you grab just the data from a spreadsheet. |
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
October 10, 2007
Gary Berline |
Excel Tip: Cell Navigation Jump easily from one cell to a non-neighboring cell. |
PC Magazine
April 4, 2008
Sarah Pike |
Copying Multiple Paragraphs into One Cell There's an easy way to avoid having paragraph breaks split text among cells in Excel. |
PC Magazine
November 11, 2003
Neil J. Rubenking |
Fixing an Excel Formula I have created several Excel 2000 worksheets that use the VLOOKUP formula to get information from one central worksheet. Now I need to add columns to the root worksheet. |
PC Magazine
April 6, 2004
Helen Bradley |
Better Lists in Excel Excel 2003 offers some useful new tools for working with lists. |
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? |
Wall Street & Technology
March 19, 2007
Ivy Schmerken |
Capital Markets Firms Can Run Spreadsheets on a Server With Microsoft's New Excel Services Responding to Wall Street firms' compliance concerns over spreadsheets in Excel 2007, Microsoft is now offering firms the ability to run Excel Services on a server. |
CFO
April 15, 2012
Bill Jelen |
A Global Shift (of Decimals) How to move the decimal point in an array of Excel data. |
PC World
April 2004
Edward N. Albro |
Xcelsius Adds Life to Excel App spices up spreadsheets with flashy visuals. |
PC Magazine
January 12, 2005
Neil J. Rubenking |
Mysterious Four-Year Error in Excel I have an Excel 2002 workbook with records from the past ten years. |
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. |
PC Magazine
August 17, 2004 |
Use a Formula as a Named Range in Excel Regarding the article "The Ultimate Sum Formula in Excel"... |
PC Magazine
November 16, 2005
Neil J. Rubenking |
Import Over 256 Columns in Excel How to a list of more than 256 items into excel. |
Macworld
March 2004
Jeffery Battersby |
Mariner Write 3.5 and Mariner Calc 5.2 Strong Applications Undermined by Inconsistent Compatibility with Microsoft Office. |
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
October 1, 2003 |
Excel's Array Formulas Array formulas are a powerful addition to your Excel toolbox. We show you how to start using them. |
PC Magazine
November 14, 2007
Helen Bradley |
Fast Data Entry in Excel Anytime you can enter data without having to type it yourself, you improve accuracy and save yourself effort. There are plenty of opportunities in Excel to enter data in a faster and smarter way than via the keyboard. |
InternetNews
May 28, 2009
David Needle |
Google Begins Testing New Scripting for Apps Apps Script designed to bring scripts and automation to Google Spreadsheet and eventually other applications in the Google suite. |
PC Magazine
March 16, 2005
Helen Bradley |
Conditional Formatting in Excel Make the information in your spreadsheets more accessible with formatting based on certain conditions. |
PC Magazine
January 10, 2007 |
Copy Only Subtotals in Excel A way to copy just the results of a subtotal display to other cells in an Excel spreadsheet. |
PC Magazine
August 23, 2005
Ben Z. Gottesman |
Finding Hidden Columns in Excel I somehow lost several of the leftmost columns in a Microsoft Excel spreadsheet and have been unable to make them visible again. How can I get these lost columns back? |
InternetNews
July 2, 2007
Stuart J. Johnston |
Are Spreadsheets 'Out of Control'? Study finds that spreadsheets are under-appreciated as critical enterprise assets, but recommends the use of audit and compliance tools. |
PC Magazine
May 11, 2010
Edward Mendelson |
Microsoft Office 2010 Microsoft delivers serious power and polish with Office 2010, but unless you need its new high-end features (like 64-bit code, for big Excel spreadsheets), it's an early-adopter, power-user product.... OpenOffice... Zoho... |
PC Magazine
September 4, 2007
Neil Rubenking |
Renaming Excel Rows and Columns Excel can optionally number the columns instead of lettering them. |
PC Magazine
December 22, 2004
M. David Stone |
Exploring Document Properties Take advantage of a little-known Word feature to make dealing with files much easier. |
PC Magazine
September 14, 2005
Neil J. Rubenking |
Excel's Calendar Control Object How to add Calendar Control 11.0 to your spreadsheet. |
PC Magazine
November 14, 2007
Sarah Pike |
Excel Tip: Rearrange Data Data is much easier to manipulate when Excel can help with the sorting. |
PC Magazine
February 2, 2009
Kathy Yakal |
Bill.com Bill.com is a great way to stay on top of your business's accounts payable, whether you're a small business running QuickBooks or a bigger one on Intacct... FreshBooks... |
PC Magazine
July 19, 2010
Edward Mendelson |
10 Excellent Tips for Microsoft Excel 2010 Excel is, without a doubt, one of the most powerful, complex, and tricky desktop apps ever designed. Mastering Office 2010's spreadsheet app can take years; fortunately, we've got 10 very cool shortcuts to Excel mastery. |
PC Magazine
May 17, 2006 |
Excel Filter Problem Resolved Making the count of matching items in Excel using it's Auto-Filter feature appear in the status bar at bottom left. |
PC Magazine
April 18, 2007 |
Pre-1900 Dates in Excel Sorting dates prior to 1900 in Excel. |
