Microsoft Office
Timed PopUp message in Ms Access
There are situations in which using certain actions need to display a message, but do not involve our…
Conditional formatting using Mail Merge
The combination of a table/list/database and the Word document seems super useful to me: to be able to…
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:…
Retrieving in a textbox, via VBA, a value calculated by an aggregate function
If it is necessary to display the result of a query that uses certain functions (SUM, AVERAGE, MIN,…
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…