Spreadsheet Tricks

From TeleCafeWiki
Revision as of 14:38, 18 February 2014 by Dave (talk | contribs) (Pivot Tables)
Jump to navigation Jump to search

Excel Add-Ins

The Timeslider is a historical data engine for Microsoft Excel. The add-in allows you to store and retrieve historical data directly from the cells of your spreadsheet.

Pivot Tables

This course includes one self-paced lesson and one practice session for hands-on experience.

Miscellaneous

Notes & Comments

Use Excel's data validation feature to share meaningful information about specific cells with users.
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("Tutorial found here: http://lifehacker.com/add-comments-to-a-formula-in-excel-for-your-future-refe-510113024")

Mixing Text & Numbers

Describes the formula syntax and usage of the TEXT function in Microsoft Office Excel. Excel's TEXT function returns a value converted to text with a specified format.
One of many video lessons from Contextures Inc..

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]

Other Edit Pads (Non-Spreadsheet)

References

  1. ↑ EditGrid service is ending May 1, 2014
Retrieved from "https://www.telecafe.org/smw/index.php?title=Spreadsheet_Tricks&oldid=451"