Excel Fu
-
Bookmark
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
9 months ago
-
YOU TUBE
-
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
9 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
9 months ago
-
Excel Charts and Tutorials Blog by Peltier Technical ServicesPTS Blog - PTS Charts and Things
dekaysion
added
12 months ago
-
An Excel 2003 Tutorial: How to Summarize Excel Data For Reporting and Analysis, An Excel 2003 TutorialIn Excel, you normally enter a formula by typing it into the formula bar and then pressing the Enter key. You array enter a formula by typing it into your formula bar, holding down the Ctrl and Shift keys, and then pressing Enter. After you array-enter a formula, the formula bar shows that it ...
dekaysion
added
12 months ago
-
Excel for Business - ExcelUserExcelUser is the online resource for business users of Microsoft Excel. The site provides articles, spreadsheets, and tips for all business users of Microsoft Excel.
dekaysion
added
12 months ago
-
Statistical Computing with R | TwineThis twine collects all links and resources related to the "R Project", an open source tool package for statistical computing -- available on most …
dekaysion
added
14 months ago
-
The Spreadsheet Page - Excel TipsExcel has a long history, and it continues to evolve and change. Consequently, the tips provided here do not necessarily apply to all versions of Excel. In particular, the user interface of the most recent version, Excel 2007, is vastly different from its predecessors. Therefore, the menu ...
dekaysion
added
15 months ago
-
High-Level Interface Between R and ExcelR and Microsoft Excel have a very different user interface concept. R is a program- ming language, whereas Excel mostly works with a direct manipulation interface. In R one works with data objects (data frames, matrices, single values) by naming them and referring to them by names in the ...
dekaysion
added
15 months ago