Author: Ovidiu.S
E-TERN-ization and COALE-scence
We’ve already discussed the ternary operator in another article. However, we haven’t yet covered the null coalescing operator…
Eliminating diacritics
There are some situations when we need to use, in MS Office applications (eg Excel), certain words without…
The lowest and highest value simultaneously formatted
If we have several intervals where we want to highlight, through conditional formatting, the lowest and the highest…
Remove own styles at once
Sometimes, if we have to format various retrieved documents, we may realize that the phrase “better to redo…
Alternative to inline chart
If the values are less than 100, it is possible to create a graph in the cell, by…
Format Cells Tricks
Hide cell text with Format Cells Select the cells containing the text to be hidden In the Format…
Simple trigger examples
Triggers have the role of launching a certain action, in a given context (INSERT, UPDATE or DELETE), before or after these actions.
Letter spacing button
To be able to use it in all Word files, you can work directly in the normal.dotm template….
Worksheet dynamization
I appreciate some features that I have used in specific applications where, for example, the width of a…
Decimal Truncation
In MS Access, there may be situations, more rarely, when you don’t want to round some numerical values…