Monthly List of Due Dates
Subtotal of Selected Cells
Consolidate Data from Different Tables
Calculate Number of Hours Worked by your Staff
Update/Extend Chart Automatically Using Table
Sum of numbers in a range that meet a specific criteria
Represent the Status of a Task
Create Table in Just 3 Steps
Replace Blank Cells with a single command
Get Multiple Columns Using Vlookup Formula
Highlight all the rows from a table for selective parameter
Generate Serial Numbers Automatically While Inserting Data
Extract Day, Month and Year from a Given Date
Compare Two Lists Using Vlookup
Due Date Management
Compare Two lists
Highlight Current Record
Create an Organisational Chart in Excel
30 Print header at top for all pages
Format Painter
Circle Invalid Entries
Dropdown List in Excel Cell
Convert from a Unit to Another
Data Representation using Quick Analysis Tool
Copy Multiple Rows at a Time
Set Text to Proper Upper, Lower Case
Add Page Setup to Quick Access Toolbar
Get Data in Original Sequence
Save Table as an Image
Keep your Confidential Data Invisible
Mark stars for progress as per your score
Get Day, Month or Year in Text Format from date
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.