| Similar Articles |
|---|
 |
CFO
May 15, 2012
Bill Jelen |
Keep It Secret How to make sure hidden rows in spreadsheets stay hidden.   |
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. |
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
August 17, 2005
Neil J. Rubenking |
Protect Shared Documents I want to protect Microsoft Word and Excel files from any changes when I send them to other people. Is there some way to lock the format and content when I send them to others? |
Search Engine Watch
October 18, 2006
Chris Sherman |
A Closer Look at Google Docs & Spreadsheets Google has integrated its online spreadsheet and word processor into a single free service that's now available to anyone with a Google account. How does it compare to Microsoft Word & Excel? |
CFO
December 1, 2010
Marie Leone |
Total Trouble The older generation of Excel users remembers how potentially dangerous this Microsoft snag can be. |
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 World
May 3, 2001 |
Top 5 Spreadsheet Add-Ins Avoid the pain and tedium of writing Excel formulas... |
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. |
Macworld
March 2001
James Bradbury |
Track Your Progress with Excel Formulas and Graphs Are at Your Fingertips... |
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
May 4, 2005
Neil J. Rubenking |
Control Rounding in Excel I have an Excel spreadsheet for my small business that I use to figure employee payroll. What formula can I use so that Excel will always round across the columns so they add correctly? |
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
August 17, 2005
Neil J. Rubenking |
Excel Times Two I have a two-monitor system. It should be like Internet Explorer or Microsoft Word, where you can have multiple windows open at the same time. Is this option available in Excel? |
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
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
November 2, 2005
Neil J. Rubenking |
Word Document with Linked Excel Data Linking excel data to word documents while maintaining word formatting. |
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 1, 2007
Neil Rubenking |
Excel Formulas That Read Your Mind Understanding #REF! error markers in Excel formulas. |
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. |
InternetNews
June 22, 2006
Andy Patrizio |
More Problems Found in Microsoft Software For the third time this month, a security flaw has been found relating to Excel, an application not normally associated with viruses and bugs. |
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. |
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 World
April 2004
Edward N. Albro |
Xcelsius Adds Life to Excel App spices up spreadsheets with flashy visuals. |
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
May 18, 2005
Neil J. Rubenking |
Convert Blank Cells to Zeros in Excel In Excel, is there any way to select a range of cells and tell Excel to fill the blank cells with the value zero? |
PC Magazine
August 12, 2008
M. David Stone |
Those Colors Clash Matching colors between Excel 2007 and Excel 2003. |
Science News
December 17, 2005
Ivars Peterson |
The Risky Business of Spreadsheet Errors Faulty spreadsheets and poor spreadsheet practices have been implicated in a wide variety of business and financial problems. |
The Motley Fool
June 7, 2006
Alyce Lomax |
Google Spreads Out The search giant's spreading out into spreadsheets. Do we care? At this juncture the idea of people blowing off Word and Excel and using browser-based products for their important documents is an overblown prospect. |
PC Magazine
October 19, 2004
Neil J. Rubenking |
Excel Converts Fractions to Dates How to enter numeric fractions such as 3/16 or 5/9 in Excel, without having them converted to dates such as March 16 and May 9. |
PC Magazine
April 18, 2007 |
Pre-1900 Dates in Excel Sorting dates prior to 1900 in Excel. |
PC Magazine
May 18, 2004
Neil J. Rubenking |
Another Way to Highlight Formulas Expert advice on highlighting cells containing formulas in Excel. |
PC Magazine
June 22, 2005
Ben Z. Gottesman |
Viewing Excel Attachments in Outlook Lately, when I try to launch Excel attachments from Outlook, Excel starts but the file won't load... The problem--and the solution--is in Excel... |
PC Magazine
February 8, 2008
Neil J. Rubenking |
Turn Excel Data and Charts into JPEGs Create figures or a movie from Excel charts. |
CFO
April 15, 2012
Bill Jelen |
A Global Shift (of Decimals) How to move the decimal point in an array of Excel data. |
PC Magazine
November 30, 2005
Edward Mendelson |
Office Problems, Solved! Some of the most notorious problems and the most useful tricks with Microsoft office. |
PC Magazine
January 18, 2005
Neil J. Rubenking |
Print a Watermark on Excel Worksheet I often create information in Microsoft Excel 2002 that needs to be used before it is complete. I would like to overlay a message such as "INCOMPLETE" in large text across an entire page. |
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
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. |
InternetNews
June 6, 2006
Nicholas Carlson |
Microsoft: Google Spreadsheets is so 10 Years Ago Google wants Excel users to upload their XLS files and share them with Google Spreadsheets. |
PC Magazine
December 1, 2009
Neil J. Rubenking |
Conditional Formatting in Excel Excel's conditional formatting can make spreadsheets a lot easier to interpret - -changing the text color in a cell. |
PC Magazine
February 4, 2011
Edward Mendelson |
Ten Tips for Microsoft Word and Excel Both of these programs drive us crazy sometimes by not doing what we want them to do. Here are 10 tricks to help you get exactly what you want from your documents and spreadsheets. |
PC Magazine
February 3, 2004
Neil J. Rubenking |
Separate Address Elements In Excel I have an extensive Excel spreadsheet with company names and addresses. The city, state, and ZIP code information are combined into one cell. Is there a way this data can be split into three cells? |
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 10, 2007
Gary Berline |
Excel Tip: Cell Navigation Jump easily from one cell to a non-neighboring cell. |
CFO
February 1, 2008
John Goff |
Radical Cells Free spreadsheets? Google, OpenOffice, and others offer intriguing alternatives to Microsoft Excel. |
PC Magazine
October 19, 2004
Neil J. Rubenking |
Excel Fails to Store Credit Card Numbers When entering numeric data over 15 digits long, prefix the data with a single quote ('). This forces Excel to treat the data as text. |
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. |
BusinessWeek
July 10, 2006
Stephen H. Wildstrom |
Look Out, Microsoft Office Web-based programs have their limitations, but the price is right. |
PC Magazine
April 6, 2004
Neil J. Rubenking |
Fix Excel 2003's RAND Function In December, PC Magazine reader and Excel maven Earl Takasaki brought a curious Excel bug to our attention: The RAND function in Excel 2003 may return negative numbers. |
