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 August 17, 2004	Use a Formula as a Named Range in Excel Regarding the article "The Ultimate Sum Formula 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 April 15, 2012 Bill Jelen	A Global Shift (of Decimals) How to move the decimal point in an array of Excel data.
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 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 December 30, 2003 Neil J. Rubenking	The Ultimate Sum Formula in Excel Here's how to set up a formula that will automatically adapt and sum all the cells above it, wherever it is placed.
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?
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 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 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 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 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.
Macworld March 2001 James Bradbury	Track Your Progress with Excel Formulas and Graphs Are at Your Fingertips...
PC Magazine June 22, 2004 Neil J. Rubenking	Get the Last Nonblank Cell in An Excel Range Creating an array formula for this task.
PC Magazine April 26, 2005 Neil J. Rubenking	Another Way to Get Last Nonblank Cell Tips for getting the most out of Microsoft Excel.
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 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 World May 3, 2001	Top 5 Spreadsheet Add-Ins Avoid the pain and tedium of writing Excel formulas...
PC Magazine August 14, 2008 Neil J. Rubenking	Can't Enter Dates in Excel Solutions to Excel date problems
PC Magazine May 18, 2004 Neil J. Rubenking	Another Way to Highlight Formulas Expert advice on highlighting cells containing formulas in Excel.
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?
PC Magazine January 1, 2008 Neil J. Rubenking	The Incredible Shrinking Excel Text Excel fonts getting a bit tiny? Here's how to keep them readable.
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 12, 2005 Neil J. Rubenking	Mysterious Four-Year Error in Excel I have an Excel 2002 workbook with records from the past ten years.
CFO May 15, 2012 Bill Jelen	Keep It Secret How to make sure hidden rows in spreadsheets stay hidden.
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 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.
PC World August 23, 2006 Dennis O'Reilly	Web Spreadsheets Nearly Ready for Prime Time Internet services offer simpler, easier-to-use worksheets.
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 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 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.
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 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 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 May 4, 2004 Neil J. Rubenking	Sorting Text in Excel Reordering words is more complicated than numbers. Here's a procedure that works.
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 30, 2003 Neil J. Rubenking	Finding the First Thursday Excel's WEEKDAY and MOD functions help you determine which days fall on which dates each month.
PC Magazine June 1, 2005 M. David Stone	Listening to Office You may know you can speak text and commands to Office. But did you know Office can talk back?
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 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 November 14, 2007 Sarah Pike	Excel Tip: Rearrange Data Data is much easier to manipulate when Excel can help with the sorting.
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.
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 September 14, 2005 Ben Z. Gottesman	PivotTable Magic Exploring complex Excel data is easier with a PivotTable. Our tips show you how.
PC Magazine December 14, 2004 Neil J. Rubenking	Advanced Ranking in Excel Q: I have columns of students, band instruments, and tryout scores... A: This seemingly knotty problem can be solved with a single formula...
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 August 2, 2006 John Brandon	Get to Know Excel Templates Making sense of data is both the purpose of Microsoft Excel and its challenge.
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 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?