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.

• 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

  ---

• How to Summarize Data Using Sparklines in Excel 2010

  

  By kbnotes : 18 April 2010 - 06:51 AM

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

  Tags:

  • Excel
  • Excel 2010
  • Office
  • Office 2010
  • Sparkline
  • data
  • format
  • formatting
  • worksheet

  0Votes

  0Comments

  ---

• Analyzing Office Files for Appropriate Renaming

  Asked by novicenab : 13 April 2010 - 04:53 PM

  Tags:

  • powerpoint
  • files
  • excel
  • word
  • office

  0Answers

  0Comments

  ---

• Microsoft Office Web Apps: I’m Becoming a Believer

  

  By kbnotes : 11 April 2010 - 09:36 AM

  In a little over a month, Microsoft will release Office 2010 and SharePoint 2010. As a part of Office, Microsoft will offer a suite of Office Web Apps—Excel, PowerPoint, Word, and OneNote--that will...

  Tags:

  • Office Web Apps
  • Office
  • Web
  • Office 2010
  • SharePoint
  • SharePoint 2010
  • Windows
  • Windows Live
  • SkyDrive
  • Word
  • Excel
  • PowerPoint
  • OneNote
  • Groove

  1Vote

  0Comments

  ---

• Begining mySQL for every day work and linking in and out of MS Excel

  Asked by komMWM : 11 March 2010 - 07:40 AM

  

  Answered by KBenson : Mar 17 2010 11:30 AM
  (Skip to the bottom if you are ONLY interesting in the MySQL portion of the question) There's a few basic questions that need to be answered before you can really decide where to start. These ar... full answer >

  Tags:

  • mysql
  • excel
  • web

  1Answer

  0Comments

  ---

• Problem while creating drop-down in excel through jxl if size exceeds 14

  Asked by SURESH_VAVNI : 25 February 2010 - 10:55 PM

  Tags:

  • excel

  0Answers

  0Comments

  ---