Similar Articles

Browse Main Topics:

Business
Computers & Electronics
Education & Reference
Entertainment & Leisure
Family & Home
Finance & Investment
Health
Internet
Pets & Animals
Science & Technology
Society, Politics & Culture
Sports & Recreation

Similar Articles

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 June 1, 2008 Neil J. Rubenking	Easy Date and Time Entry in Excel Cut down data entry time in a flash with handy Excel tricks.
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 January 18, 2005 Neil J. Rubenking	Easier Excel Fractions Regarding the PC Magazine tip about fractions in Microsoft Excel, there's another way to enter fractions directly that will both preserve the actual value of the number and autoformat the cell with a fraction format.
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 February 14, 2007	Numbers With Superscripts in Excel You can format each digit of a number with a different color within an Excel cell, but for the purpose of calculations, the formatting doesn't make any difference.
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 March 2, 2004 Neil J. Rubenking	Transform Forced Text to Numbers in Excel One of my clients sends me Microsoft Excel files in which all the columns are in text format, even when they contain only numbers. What is the easiest way to correct the number formatting?
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 August 30, 2006	Problem Merging Zip Codes That Start with 0 Making Microsoft Office 2003 Small Business allow zip codes that begin with 0.
PC Magazine December 14, 2004 Neil J. Rubenking	Excel's Custom Formats Q: The user wanted to format a cell in Excel so that if its value is positive, it is formatted with the Accounting format and looks like this: "$ 456 "... A: To create your custom format, first format one cell with the Accounting format...
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 April 18, 2007	Pre-1900 Dates in Excel Sorting dates prior to 1900 in Excel.
PC Magazine August 12, 2008 M. David Stone	Those Colors Clash Matching colors between Excel 2007 and Excel 2003.
PC Magazine September 4, 2007 Neil Rubenking	How to Sort by Birthday in Excel How to sort through dates while avoiding leap years.
PC Magazine November 14, 2007 Neil J. Rubenking	Find Unique Rows in Excel Stop searching for new or special entries in Excel by telling the software to how to do the hunting and highlighting for you.
PC Magazine February 8, 2008 David Cardinal	Create Appointments Automatically Do you work on projects whose due dates or events are kept in a spreadsheet? Here are some tips to importing them into your digital planner.
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 Brandon	Get to Know Excel Templates Making sense of data is both the purpose of Microsoft Excel and its challenge.
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 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.
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 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 November 28, 2007 Kyle Monson	Adding Thousands Separators in Word In Microsoft Excel we can format numbers so they display using the thousands separator for accounting or currency.
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 May 18, 2004 Neil J. Rubenking	Another Way to Highlight Formulas Expert advice on highlighting cells containing formulas in Excel.
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.
CFO May 15, 2012 Bill Jelen	Keep It Secret How to make sure hidden rows in spreadsheets stay hidden.
PC Magazine August 1, 2007 Neil Rubenking	Excel Formulas That Read Your Mind Understanding #REF! error markers in Excel formulas.
PC Magazine September 27, 2006	Force Unique Numbers in Excel Keep duplicate numbers from being inserted into a column in Microsoft Excel.
The Motley Fool June 8, 2010 Nathan Alderman	Make Your Checkbook Work for You Hate math? This easy, automated checkbook crunches numbers for you.
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 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 September 4, 2007 Neil Rubenking	Renaming Excel Rows and Columns Excel can optionally number the columns instead of lettering them.
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 September 14, 2005 Ben Z. Gottesman	PivotTable Magic Exploring complex Excel data is easier with a PivotTable. Our tips show you how.
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 February 8, 2008 Neil J. Rubenking	Turn Excel Data and Charts into JPEGs Create figures or a movie from Excel charts.
PC Magazine July 7, 2009 Julie Sartain	Use Excel as an Architectural Design Tool Here's how to you can use the spreadsheet app to design and build simple projects such as decks, porches, dog houses, and even furniture.
PC Magazine September 16, 2003 Helen Bradley	15 Great Excel Tips Microsoft Excel is jam-packed with functions that perform a range of handy calculations and tests. We take a look at 15 Excel functions you may not know about and show you some clever ways to put them to work on your data.
PC Magazine February 3, 2004 Neil J. Rubenking	Highlight Cells Containing Formulas In designing and auditing spreadsheets, I'd like to distinguish visually between cells containing formulas and those containing values.
PC Magazine August 14, 2008 Neil J. Rubenking	Can't Enter Dates in Excel Solutions to Excel date problems
CFO September 1, 2012 Bill Jelen	An Average Solution How to create a prediction of sales in Excel using a moving average and a trend line.
PC Magazine February 3, 2004 Neil J. Rubenking	Mail Merge Formatting Problem I prepare bills using Office XP. An Excel spreadsheet serves as my database, and I use Word's Mail Merge feature to print the bills.
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 November 2, 2005 Neil J. Rubenking	A Better Watermark in Excel How to create the look of a watermark within an Excel worksheet.
PC Magazine February 16, 2005 Neil J. Rubenking	Problem with Excel Time Comparison How to build a formula in Microsoft Excel that produces a different answer based on time.
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 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 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.