Category Archive: Tips and tools

Feb
10

Irregular selections in Excel

Have you ever had a need to filter some tables of data in Excel using masks? If so, this post may be useful to you. The principle is simple: place your data in one sheet (Data), create a mask on another sheet (Mask) consisting of cells filled with ones (where you want to keep the …

Continue reading »

Mar
19

Collaboration on documents

I was advised to use FolderShare application to share documents with my collaborators. But, in fact, we already have subversion for our code development. This automatically raised a question of why would we use FolderShare if we already have subversion installed on our server and in operation. It is not reasonable to compare subversion with …

Continue reading »

Nov
15

iPhone/iPod Touch Disk Mode Solution

If you have had the chance to use an iPhone or iPod Touch, you might have noticed a “small” inconvenience: these devices do not appear as removable storage drives in Windows, like prior versions of iPod (classic, nano, etc). This effectively prevents the iPhone and iPod Touch to be used for data transfer. There is …

Continue reading »

Oct
09

Slideshare

I just ran across Slideshare, a (beta) website that lets you share slides (yes the name is descriptive). I uploaded my first set of (PowerPoint) slides, and now I can embed them in this post – very cool: P54 Presentation at 2007 ITU Fully Networked Car Workshop View SlideShare presentation or Upload your own. (tags: …

Continue reading »

Oct
06

Robert Scoble on getting a job

Looking for a job? Check out this post for excellent suggestions on how to get on top of the resume pile.

Sep
30

Firefox and literature review

Literature review is a big part of a scientific underatkening. Thanks to the Internet, most papers are available on line. This resulted (at least for me) in a big number of papers that I read and stored for feature references… Welcome to the age of data mining. As a researcher I have yet another problem …

Continue reading »

Aug
15

Using Adobe Premiere

As many of you may know, I spent a good part of the summer in front of the video-editing computer transcribing data from videos of experiments. I used Adobe Premiere to organize and view the videos. However, Adobe Premiere was made for movie/cinematic editing, not data transcription, so I had to “invent” a few ways …

Continue reading »

Aug
11

Where did the multiple windows go in Excel 2007?

I have recently realized that when I open multiple documents in Excel they all show up separately on Taskbar but show up in the same window of Excel. This can be very aggravating for anyone who works with multiple documents and multiple monitors. After becoming fed up with Excel I did some research online and …

Continue reading »

Jul
17

Tinyurl.com – a great tool for simplifying web addresses

Check out www.tinyurl.com. It allows you to create tiny URLs out of long and winding ones. This is neat when you want to send a link in an email to someone without having to worry if their email client will interpret the multiple lines of the link correctly. It’s also neat if you want to …

Continue reading »

Jul
15

AutoHotKey – free, open-source utility for Windows

Hello, AutoHotKey is a handy utility that can be used for automation tasks. This program can move the mouse or send key events to different applications. It also can show dialogs. I mostly use it as a macro recorder that works across all the applications. It supports a simple (as in easy to learn), but …

Continue reading »

Older posts «