Sandeep Jadhav

Power Pivot | How to use KPIs in Power Pivot | combining data using power pivot

Amazing usage of countif function | Mastering the COUNTIF Function in Excel: A Comprehensive Guide

Textjoin function in Excel | How to use textjoin | Difference between Concatenate, Concat & Textjoin

A short but useful tip on Freeze Panes | How to freez both rows and columns together

Combine two files into one using power query | How to append two tables in power query

Power Query in Excel | Learn with suitable examples | A Powerful tool for data transformation

Filter formula in Excel | Filter function | Filter function with multiple conditions

Mastering Pivot Tables: Calculated Fields for Advanced Data Analysis in Excel

How to combine two tables into one pivot table Step-by-Step Tutorial| Power pivot | Use power pivot

Amazing use of IF function | Nested IF function | How to Use the IF Function in Excel

How to create drop down in excel | Data validation in excel

10 Excel short cuts you should know | Excel shortcuts | Excel command shortcut keys

Transpose using power query | How to convert horizontal data vertically | pasting data vertically

Relative and Mixed cell reference | How to lock cells in formula | cell reference in excel

Flash Fill in excel | Mahical formula flash fill | how to separate data in excel improve efficiency

Pivot Table in Excel | How to create summary of data | Create summary of data using pivot table

Dynamic vlookup Function Vlookup Match function

How to consolidate data | Data consolidation in excel | How to consolidate data in one sheet

Isnumber and istext funtion in excel | isnumber wil vlookup function

Paste special option | How to use paste special in excel | paste special values

How to paste data in filtered cells

How to create candle stick charts? | How to interpret candle stick charts | High low close charts.

Rank function in excel | Rank.avg function in excel | How to use Rank function

How to create checklist in Excel | Checklist in excel | Dynamic checklist in excel

How to use Index Match in Excel | Index match Vs vlookup | Index match formula in excel

Offset function in Excel | How to use offset formula | How to get last cell value from dynamic list