May 4. 2007 by Del.

Ok - computer application books are a dime a dozen and even though they look good in the bookstore - by the time you crack the cover, the reality is the first few chapters cover the basics, the middle of the book covers some good info … but not in enough detail to get you past the first roadblock (back to Google for answers!), and the final “advanced topics” chapters aren’t (advanced … of course they are “final”).

Apress caught my eye in the bookstore today with a couple of uniquely titled Excel books (pivot tables and database functions). The books cut right to the chase and into the meat of the topic. No generic how to find the power button Chapter 1! Their website has the tagline “books for professionals by professionals”. The website also contains sample chapters, table of contents, and source code files. Great way to check out the details.

Books that caught my eye:
A Complete Guide to PivotTables: A Visual Approach
Excel 2007: Beyond the Manual
and Beginning Python: From Novice to Professional which has potential application for writing data analysis detectlets in Picalo.

Posted in book, Python, DataAnalysis, spreadsheet | Print | No Comments »

June 25. 2004 by Del.

CFOdirect Network - Financial reporting service on FASB standards, US GAAP rules, International Accounting Standards, FAS 142, financial risk management, internal audit department, treasury systems: “Spreadsheet Hell

CFOs are interested in the many new technologies being pitched to them, but are they really trapped in spreadsheet hell?

Don Durfee
CFO IT Magazine”

Posted in spreadsheet | Print | No Comments »

May 12. 2004 by Del.

Site has numerous well written and illustrated tips for Excel and Access. Excellent reference site for students learning to use either application. ddv

Index of Help for Excel functions, graphs and testing

Posted in spreadsheet | Print | No Comments »