Visit Every Wednesday for Excel Tips, Tricks, Formulas and Functions

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.