O'Reilly Answers

Topics: excel

excel Feed    excel Open Questions Feed    excel Email    Open Questions via Email

Please sign in or register to post.

Please sign in or register to post.

• Microsoft Excel's top 5 tricks

  

  By macslocum : 20 August 2010 - 04:28 AM

  Excel is the go-to choice for number crunching and spreadsheet creation, but those are the run-of-the-mill functions. There's a host of untapped tools and techniques within the program. In the followi...

  Tags:

  • Microsoft Excel
  • Spreadsheet
  • Excel

  1Vote

  1Comment

  ---

• Handling Duplicate Rows in Excel 2010

  

  By chco : 21 July 2010 - 11:19 AM

  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...

  Tags:

  • tables
  • microsoft
  • excel 2010
  • excel

  0Votes

  0Comments

  ---

• Using Information Functions in Excel 2010

  

  By chco : 21 July 2010 - 06:52 AM

  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...

  Tags:

  • excel
  • functions
  • microsoft
  • excel 2010

  1Vote

  0Comments

  ---

• What happened to my Excel toolbox?

  Asked by BJPatt : 21 July 2010 - 06:32 AM

  Tags:

  • excel

  0Answers

  0Comments

  ---

• How can I embed multiple images in Excel using POI?

  Asked by peeps : 15 July 2010 - 03:45 AM

  Tags:

  • excel
  • poi

  0Answers

  0Comments

  ---

• How to Find the Last Day of Any Month in Excel

  

  By sarahkim : 01 July 2010 - 03:58 PM

  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...

  Tags:

  • excel
  • excel 2010
  • date

  0Votes

  0Comments

  ---

• How to Calculate the Difference Between Dates in Excel using DATEDIF()

  

  By sarahkim : 01 July 2010 - 09:01 AM

  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...

  Tags:

  • excel
  • excel 2010
  • date

  0Votes

  0Comments

  ---

• How to insert the current date and time in Excel 2010

  

  By sarahkim : 30 June 2010 - 02:07 PM

  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 ...

  Tags:

  • excel
  • excel 2010
  • date
  • time

  1Vote

  0Comments

  ---

• How Excel stores date and time values

  

  By sarahkim : 30 June 2010 - 10:49 AM

  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...

  Tags:

  • time
  • excel
  • excel 2010
  • date

  0Votes

  0Comments

  ---

• How to Use Conditional Formatting in Excel

  

  By adfm : 29 June 2010 - 08:58 AM

  Have you ever wished that your spreadsheets would automatically format themselves, the way you wanted them to, and not from some generic template? Luckily, Excel provides all the tools you'll need t...

  Tags:

  • Microsoft
  • conditional
  • formatting
  • spreadsheet
  • excel

  0Votes

  0Comments

  ---