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.