MS Excel

Posted in MS Excel Projects VBA

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…

Continuare...
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:…

Continuare...
Posted in Microsoft Office MS Excel

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…

Continuare...