Excel Fu
Public
Unlike* Kung Fu this twine is meant to help people learn about Microsoft Excel tips & trick by sharing with others. Depending on the level of involvement this will be simple tricks (e.g. conditional formatting), medium stuff with equations (and some databse/matrix stuff).
* see wikipedia: "Kung fu can be used in a context without any martial arts whatsoever. Colloquially, kung fu (or gung fu) alludes to any individual accomplishment or cultivated skill obtained by long and hard work
* see wikipedia: "Kung fu can be used in a context without any martial arts whatsoever. Colloquially, kung fu (or gung fu) alludes to any individual accomplishment or cultivated skill obtained by long and hard work
Recent Activity
Items
-
Contextures Blog » AutoFilter By Selection In ExcelAutoFilter By Selection In Excel In Excel 2003, you can add a couple of buttons to the toolbar to make it easy to filter a table. For example, in the table below, the East region is selected. With one click of a button, and no programming, you can add an AutoFilter and filter the table to ...
dekaysion
added
8 months ago
-
-
Sparklines Excel Add-in - TinyGraphsTinyGraphs is an open source add-in for Excel that creates sparklines, mini column graphs, and area graphs from a row of data. It generates beautiful tiny graphics that are as small as a cell and is useful for visualizing large quantities of data, such as stock prices and exchange rates. What ...
dekaysion
added
8 months ago
-
LOESS Smoothing in Excel | PTS BlogIn 1979 William Cleveland published the LOESS (or LOWESS) technique for smoothing data, and in 1988 he and Susan J. Devlin published a refined version of the technique (references are given at the end of this article). For each X value where a Y value is to be calculated, the LOESS technique ...
dekaysion
added
8 months ago
-
Excel Charts and Tutorials Blog by Peltier Technical ServicesPTS Blog - PTS Charts and Things
dekaysion
added
11 months ago
Comments
-
-
Free Debt Reduction Calculator for Excel…and even if you don't need the calculator: check out some really cool excel sheet! All donw without macros!dekaysion added 15 months ago
-
Excel -- Worksheet Functions -- INDEX / MATCHmuch better than the built-in excel documentation, of course.dekaysion added 15 months ago
-
Microsoft Excel TipsYou can subscribe to weekly excel tips & tricks here. Free.dekaysion added 15 months ago
-
Members
Active
-
Started Jul. 25, 2008
-
Rules of this twine
This Twine has open membership.
Comments are allowed.
Members may ,add items ,invite people
Twine is about discovering, collecting and sharing the content that interests you. Learn More
Join Twine
