excel 2010 Questions and Answers

Welcome

Help

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 »

Send us feedback

Topics: excel 2010

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

Self-updating week-based schedule with coloums. Is this possible? Many questions within.

Asked by Inforiel : 03 February 2011 - 03:05 AM
Tags:
0Answers

0Comments
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:
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:
1Vote

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:
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:
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:
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:
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:
0Votes

0Comments