MS Excel
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…
Worksheet dynamization
I appreciate some features that I have used in specific applications where, for example, the width of a…
Automatic rounding for a range of cells
If it is desired that, in a sheet, numerical values be formatted and displayed by rounding with a…
Posted in MS Excel
Calculation of work experience, using the DATEDIF function
If an employee record is required, Excel can be used for automatic calculation using the DATEDIF function. Obs:…
Conditional Formatting Depending on the Condition of a Column
Conditional formatting adds in the analysis of data from a spreadsheet. To apply a conditional formatting rule on…