Change deadline date colour in a cell

Center the text without using Merge and Center option

Automatically fill a series of data in your worksheet, like dates or numbers.

Use Sumif with Criteria

Chart for Percentage with Conditional Formatting

Auto Number After Row Delete

Auto total of data in a Table

Create a Chart from entered data in a single Cell similar to a Progress Bar

Remove Middle Name from Complete Name in a Single Cell

Set time to the nearest minutes depending on the selected variable

Set grade for your Data. This can be used for Product, Sales Etc

Automatically Add Borders to Table Data

Mask a few digits of a number E.g. 8 Digits of an Aaadhaar Card to maintain Privacy

Copying or Moving a table is as simple as selection and darg and drop. Just follow the instructions in the video and you shall see that it is so easy.

Consolidate worksheets to generate an effective way to view amalgamated report or data.

Calculate the Age of a person from the given date of birth.