-
What is this?
From advanced Bash tricks to Python gotchas to MySQL tutorials, this blog covers various topics in programming and systems administration. Find out how to get more done and have fun! Keep up with the latest by subscribing to the RSS feed!About the Author
This is the tech blog of Samuel Huckins. You can check out my homepage and other websites below, or send me a message here.-
-
Recent Posts
Post categories
Tags
Apache Apple Bash bookmarks CLI command database Desktop disk editor efficiency Excel filesystem firefox graph graphing hardware HTML information keyboard Launchy Linux logging migration Mobile monitoring MySQL PDF Programming putty Python Ruby scripting Security ssh subversion svn sysadmin Trac Ubuntu vim Vista web web applications WindowsBlogroll
Handy Links
My Sites
My del.icio.us
-
- Posts 194
- Words in Posts 70,576
- Comments 559
-
Tag Archives: Excel
Handy Excel Tip: Open workbook in new instance
I’ve written before about using Excel for some remote data collection and analysis tasks. One thing that often annoyed me in such situations was the inability to utilize multiple monitors. Whenever I wanted to break out a sheet, or especially … Continue reading
Excel web query URLs with dynamic parameters
Last year I wrote about the ease and utility of pulling data into Excel via web queries. This mechanism has served me well in the interim and has proven to be an effective tool in collecting data for certain kinds … Continue reading
Pulling data into Excel from web queries
Excel 2007 is an amazing tool. I normally find Microsoft’s software unintuitive, annoying, and slow. But for quick numeric analysis tasks or advanced reporting, Excel can do amazing things. Before utilizing all this reporting and analytical firepower, you have to … Continue reading