Welcome / Bienvenue / Benvinguts / Bienvenidos
For information about my translation services, please visit the main site.
Pour des informations sur mes services, merci de regarder le site principal.
Para información sobre mis servicios de traducción, visite el web principal.

AutoHotkey script to move the focus away from the Concordance window

Sometimes you want to keep the MemoQ Concordance window open on your second screen while you work on your document. But there’s no built-in method to achieve this with the keyboard. You can only do so by clicking with the mouse.

This short script moves the focus away from the Concordance window and to the main MemoQ window, allowing you to work on the document while keeping the Concordance window open. Just press ctrl+k to activate the script.

#IfWinActive, Concordance
^k:: ; MemoQ: Move focus away from Concordance window
WinActivate memoQ

The following script closes the Concordance window. Continue reading


Useful links related to PerfectIt

PerfectIt checks: A brief explanation of each check performed by PerfectIt, with links to a full explanation.

PerfectIt style sheets: Information on working with style sheets and customising them.

PerfectIt settings tab: What the options in the Settings tab do and how to configure them.

Introduction to MS Word wildcards: An exercise providing a basic introduction to using wildcards in Microsoft Word. Includes links to other, more comprehensive resources on Word wildcards.

Users’ Facebook group: A Facebook group for PerfectIt users. Users ask how to configure certain settings. Particularly useful if you can’t get a wildcard search working.

Associations offering discounts: a list of associations whose members are entitled to a discount on PerfectIt.

Interested in a workshop?

I organise PerfectIt workshops for translators’ and editors’ associations in which I provide an overview of the program, then delve into its advanced features. I usually end with an interactive section in which participants can ask me how to enforce certain style rules using PerfectIt. For more information, write to the e-mail address found on my main website.

If you have already attended one of my workshops and have not received How-to…with-PerfectIt4.pdf, send me an e-mail and I’ll send you a copy.

IntelligentEditing’s playlist on building stylesheets


La facturation en monnaie étrangère : un formulaire pour convertir les prix en euros selon la loi française

La loi française permet la facturation en monnaie étrangère, et le portail de l’Économie, des Finances, de l’Action et des Comptes publics explique comment le faire.

Pour le calcul du montant en euros de vos factures, j’ai créé un formulaire Excel. Il suffit d’introduire la date de facture, le montant et la devise pour que le formulaire vous calcule le montant en euros selon les deux méthodes permis par la loi française. Les taux de changes utilisés pour les conversions sont les taux officiaux de la Banque centrale européenne, qui publie les taux de référence utilisés par les autorités françaises.

ConversionFacturesDevises par anglopremier.com.


How to remove an initial cap from glossary entries

Many online glossaries start every term with a capital letter, such as in this example:

  • Comptes d’accumulation
  • Accumulation accounts

Since these terms would only be capped at the start of a sentence, translators ought to import them without the initial caps.

Use the following formula in Excel to remove leading caps. The formula below assumes the first term is in cell E1, but to change it to wherever your first term is, then paste it down all the rows containing terms.


Please note that if you don’t use Excel in English, you will need to translate the formula words. Also, if you have your system set to use decimal commas, replace the commas in the formula with semi-colons.

The reason the formula is so long is because it initially checks to see whether the second character is capped. If the second character is also capped, it assumes the term is an acronym, and therefore does not change the first character to lower case.


Use old-style Excel and Word menus in new versions of Office

A common complaint people make when they install Word 2007 (or Excel 2007) or later is that they don’t like the ribbon and prefer the menus used in Word 2003 (or Excel 2003) and earlier. Microsoft insist that things are easier to find in the new version, but many of us beg to differ. For me, my main qualm with the new version is that it takes me longer to browse through all the options than it did with the old system.

Also, certain options are in illogical places. For example, if you want to insert a row or column in Excel you’ll probably look in the “Insert” tab. But you won’t find it. It’s in the “Home” tab. Why on earth is an “insert” option not in the “Insert” tab?

The Swiss company UBit has produced an add-on that creates a ribbon tab called “Menu”, which contains old-style menus. The add-on can be downloaded from here.

Unfortunately it doesn’t allow you to open the menus with the keyboard. And that’s where I come in! I’ve produced a script to be used with UBitMenu that allows you to open up the menus using the keyboard (i.e. alt+f opens the file menu, etc.) and browse through with the cursor keys. Click here to download the script.

Once you have installed UBitMenu and my script, you can browse through the menus almost as easily as in the old version of Word and Excel.

Please note it currently only works with the English menu shortcuts, and it may not work with certain screen resolutions, as it relies on clicks on the correct part of the screen.

If you test it, please report back whether it works for you.

If you would like a version for your own language, please tell me the shortcut letters for the different menus (File, Edit, View, Format, Tools, Table and Window) in your language.


Bookmarklet tweaks

I’ve corrected some of the bookmarklets I made available on my main website. All the bookmarklets now lead to the correct site, and the Oxford English Dictionary one now works with all words. There is also a link to a site explaining how to disable speed dial in Firefox, since the bookmarklets don’t work if you are on the speed dial page.


Invertext glossaries

Edit on 29 March 2012

I have looked at this glossary more closely and having seen entries like this I can only conclude that it is not a reliable source.

End of edit

For professional translations, visit www.timtranslates.com.

Today I stumbled across this little beauty of a webpage. It contains a bilingual Spanish<>English glossary with 6,000 definitions in the fields of banking, stock markets, accounting, money and currencies, corporate banking, retail banking and money laundering. I’ve not really tested it yet, but it looks promising.

The glossary is produced by Ediciones Verba, who have produced what looks like a very interesting set of technical dictionaries. I’d be very interested in hearing from anyone who has bought the dictionaries.

I’m a little hesitant about buying them because I wonder whether at some point they’ll put everything online. Also, the dictionaries are not cheap (though given the number of entries, that’s not surprising). I do hope that at some point they will produce digital versions, because that’s what most translators prefer searching in. I’d rather select the terminology I’m looking for and activate a search on my computer or online than get a bulky paper dictionary and look for it manually. In fact, I’d be willing to pay more for an electronic dictionary than for a paper version.



Linguee is an online tool that searches for online translations of terms. It was originally only available for English<>German, but French, Spanish and Portuguese have now been added. You have to look carefully at the sources use and check the results for reliability, but provided you do that it’s a very useful tool.

Linguee website

Spanish<>English toolbar button (drag to the toolbar if using Firefox)
French<>English toolbar button (drag to the toolbar if using Firefox)