Difference between revisions of "Spreadsheet Tricks"
Jump to navigation
Jump to search
(→Miscellaneous: Notes & Comments) |
(→Notes & Comments: Return Cell Value as Number with Excel N Function) |
||
| Line 5: | Line 5: | ||
* [http://lifehacker.com/add-comments-to-a-formula-in-excel-for-your-future-refe-510113024 Add Comments to a Formula in Excel for Your Future Reference] | * [http://lifehacker.com/add-comments-to-a-formula-in-excel-for-your-future-refe-510113024 Add Comments to a Formula in Excel for Your Future Reference] | ||
: The N() function comes in handy if you want comments embedded within the formula for your own notes, reference, etc.<br />Example: <code>=SUM(E82:E83)+N("No hourly rates found.")</code> | : The N() function comes in handy if you want comments embedded within the formula for your own notes, reference, etc.<br />Example: <code>=SUM(E82:E83)+N("No hourly rates found.")</code> | ||
| + | |||
| + | * [http://www.youtube.com/watch?v=JUB0E5r_ERw Return Cell Value as Number with Excel N Function] (Video) | ||
| + | : One of many video lessons from [http://www.youtube.com/user/contextures?feature=watch Contextures Inc.]. | ||
* [http://www.techrepublic.com/blog/microsoft-office/an-alternative-to-excel-comments/ An alternative to Excel comments] | * [http://www.techrepublic.com/blog/microsoft-office/an-alternative-to-excel-comments/ An alternative to Excel comments] | ||
Revision as of 17:03, 6 February 2014
Miscellaneous
Notes & Comments
- The N() function comes in handy if you want comments embedded within the formula for your own notes, reference, etc.
Example:=SUM(E82:E83)+N("No hourly rates found.")
- One of many video lessons from Contextures Inc..
- Use Excel's data validation feature to share meaningful information about specific cells with users.
Array Formula In Google Spreadsheet
<html><iframe width='950' height='300' frameborder='0' src='https://docs.google.com/spreadsheet/pub?key=0Ap9dh6jmi4yndEp1Q1M4cXk0QTFOTmpRWW5mb25kNkE&output=html&widget=true'></iframe></html>
Embedding Spreadsheets & Parts of Spreadsheets
Embed SkyDrive Spreadsheet
<html><iframe width="650" height="450" frameborder="0" scrolling="no" src="https://skydrive.live.com/embed?cid=0D58D956AB4BC9E0&resid=D58D956AB4BC9E0%21117&authkey=AH7Glp3oB3WJ4Ag&em=2&AllowTyping=True&wdDownloadButton=True"></iframe></html>
iFrame code for the spreadsheet on SkyDrive
Embed Google Spreadsheet
<html><iframe width='500' height='350' frameborder='0' src='https://docs.google.com/spreadsheet/ccc?key=0Aumujjc9cTZhdE92TExvcjU5NVZBbFk2Ul82dFI1ZUE&single=true&gid=0&range=J2%3AQ12&output=html&widget=true'></iframe></html>
- Sources
- See Also
Quick Edit Sheets
- Ethersheet is an open source tool to make collaborating on spreadsheets fast, easy and secure. You can also download the code on GitHub.
- Unfortunately, EditGrid's service is ending May 1, 2014.[1]