How to Use Data Bars, Color Scales and Icon Sets using Conditional Formatting in Excel

Filter data Dynamically | How to apply filter function in Excel

Percentof new fucntion in Excel

Excel Drop and Take function in Excel |

Convert Timestamp to time easily

How to Highlight every Saturday (any day ) of the week

How to move rows and columns without inserting and deleting a row or column

Concat Vs Textjoin - Which one to use ?

How to consolidate data from multiple sheets to a single sheet

Learn the new Filter function in excel

How to count dates in a year | Count dates based on the year

Must pass 3 out of 4 subjects | How to find the Eligibility status with multiple criteria

How to find text within a parentheses

How to mask mid of a text in Excel | How to mask mid of a text in Excel using concat

How to pad text in Excel | Do you know how to pad text in excel

How to find missing values | How to find missing values using if and countif function

How to use substitute function in Excel | Case sensitive match use substitute function

How to use replace function in Excel | Learn replace function from basic to advanced

How to fix errors in Excel | #DIV/0! | #NAME? | #NULL! | #VALUE! | #N/A | #### | #NUM! | #REF

Learn these new 6 formulas to become more productive at workplace | New formulas in Excel 2019 & 16

3 ways to highlight column differences | How to highlight column differences

How to copy and paste visible rows and columns

How to count only visible rows in a filtered list | Count only visible rows using a filtered rows

Index and Match : Basic to Advanced | Index and Match with Max,Min and Average function

Get accurate results with Index and Match | How to use Index and Match