O'Reilly Answers is a community site for sharing knowledge, asking questions, and providing answers that brings together our customers, authors, editors, conference speakers, and Foo (Friends of O'Reilly). More »
The following is an excerpt from Excel 2010: The Missing Manual. It explains what to do to address the issue of duplicate rows in Excel 2010.Hard-core table types know that every once in a while, desp...
The following is an excerpt from Excel 2010: The Missing Manual. It explains the use of information functions and offers a few tips.Excel features yet another group of functions closely related to the...
This excerpt from Excel 2010: The Missing Manual shows you how to use the EOMONTH() function to calculate the last day of any month.
The EOMONTH() function (short for End of Month) calculates the last...
This excerpt from Excel 2010: The Missing Manual shows you how to use DATEDIF() to calculate the difference between dates in years or months.
If you want to calculate the difference between dates in y...
Excel also provides some invaluable ready-to-use functions to help you do things like identify the current date. This excerpt from Excel 2010: The Missing Manual shows you how to use the TODAY() and ...
This excerpt from Excel 2010: The Missing Manual explains how Excel stores date and time values so you can use Excel's functions to manipulate them.
The reality is that even though many dates look...
Creating charts in Excel 2010 workbooks enables you to summarize your data visually, using legends, labels, and colors to highlight aspects of your data. It is possible to create very small charts to ...