August 2007

Operators in Excel: in casu :

Posted by Theo Heselmans on August 23rd, 2007

You all know that +, -, * and / are operators, and you use them extensively in Excel. There is one operator you also use regularly, but you might not be aware that it's also an operator. I'm talking a

Category:  Microsoft Excel  | TechnoratiTechnorati: ,

Are you Registered for LS 2008: I am :-)

Posted by Theo Heselmans on August 22nd, 2007

I received a 'very' early registration invitation this year. Naturally I enrolled asap. Unfortunately the price has gone up $200 (again !) and is now $1895. Too bad they stopped offering a special pri

Category:  Domino/Notes  | TechnoratiTechnorati: , ,

I’m Game

Posted by Theo Heselmans on August 19th, 2007

I'm hooked again! Ever since I played the original Prince of Persia, a long time ago, I've had it for 'well-designed' games. I got these periods in my live I seem to spend every spare hour to gaming.

Category:  Apple Mac  Personal  | TechnoratiTechnorati: ,

Notes the Calculator

Posted by Theo Heselmans on August 13th, 2007

It's been a while (cfr. 'A Present for you') since I gave the 'end-user' a Notes tip. This is one I discovered some time ago, and I still use it frequently. Whenever you have a editable field in Notes, you can enter calculations in it

Category:  Domino/Notes  | TechnoratiTechnorati: ,

Grouping in Pivot Tables

Posted by Theo Heselmans on August 12th, 2007

One of the coolest features in Excel is Pivot Tables. You probably use them frequently, because of their ease of use, flexibility, and incredible speed. Still a lot of its powers remains hidden. I'm

Category:  Microsoft Excel  | TechnoratiTechnorati: ,

Tracking Field Changes

Posted by Theo Heselmans on August 8th, 2007

Some of my customers want to keep track of changes to particular fields. I while back I built a script library, which can be used in any database and form. Below is a simplified version, to get you started.

Category:  Domino/Notes  | TechnoratiTechnorati: ,

Snapshot-pictures in Excel

Posted by Theo Heselmans on August 6th, 2007

As of version 3 of Excel (we're now at version 12 !), a feature was introduced that's not only unappreciated, but hard to find too. It's called Camera. Customize your toolbar and add the little camer

Category:  Microsoft Excel  | TechnoratiTechnorati: ,

3 weeks to go...

Posted by Theo Heselmans on August 5th, 2007

3 weeks from now, I'll wake up in Mexico. Finally a well-deserved well-needed vacation. We (my wife and I) are having a 1 week tour around the major Mayan cities in Yucatan: Chichén Itzá, Uxmal, Palen

Category:  Personal  | TechnoratiTechnorati:

Cigales-Bierzo-Toro

Posted by Theo Heselmans on August 3rd, 2007

A friend of mine has an interesting site about wines: wijnkennis.be (sorry, only in Dutch). He regularly holds wine-tasting evenings, with wines sent to him from the winemakers themselves, or from loc

Category:  Wine  | TechnoratiTechnorati:

Custom Sorting

Posted by Theo Heselmans on August 1st, 2007

I needed to sort a list, based on a user-defined sorting order. You see this kind of sorting also in Excel (look in 'Options' and 'Custom Lists' to see examples). @Sort has, as of version 6, a grea

Category:  Domino/Notes  | TechnoratiTechnorati: ,