Referencing Intermediate steps from other Power query Abhay Gadiya 2026-09-25 | Referencing Intermediate steps from other Power query
AI in Excel to perform quick data analytics & insert pivot tables #shorts #shortvideo #youtubeshorts Abhay Gadiya 2024-09-15 | This video explains how you can use AI in Excel to quickly perform data analytics to gain insights just by simply selecting the data.
FILTER new function in Excel 365 dynamic arrays #youtubeshorts #shortvideo #excel Abhay Gadiya 2024-09-07 | Normal auto filter in excel does not work with OR condition between multiple columns. Using FILTER function in Excel we can now dynamically filter the data using OR criteria between multiple columns
Excel formula to calculate number of months between two dates #excel #shorts #shortvideo #youtube Abhay Gadiya 2024-09-03 | This video explains DATEDIF function / formula in Excel to calculate number of months or years between two dates.
Calculate MAXIFS MINIFS values for selected item #shortvideo #shorts #youtubeshorts #excel #trending Abhay Gadiya 2024-09-02 | This video explains how to calculate maximum or minimum or average values for selected items separately similar to performing SUMIFS inside excel
Dynamically extract Top 10 records by Excel Formula #youtubeshorts #youtube #excel #shorts #trending Abhay Gadiya 2024-09-01 | This video explains steps for extracting top 10 records from dataset using formula dynamically.
Working days between dates with Excel formula #excel #exceltips #exceltutorial #shorts #exceltricks Abhay Gadiya 2024-08-31 | ...
Excel interview move data without column added /deleted #shortvideo #youtubeshorts #youtube #excel Abhay Gadiya 2024-08-30 | ...
Total calculated only for filtered items #shorts #shortvideo #youtubeshorts #excel #trending Abhay Gadiya 2024-08-29 | How to change SUM value based on filter applied on dataset is explained in this video.
Total value changes based on filtered records #shorts #shortvideo #youtubeshorts #excel #trending Abhay Gadiya 2024-08-29 | How to change SUM value based on filter applied on dataset is explained in this video.
Conditional Formatting on or off using checkbox #shorts #excel #youtubeshorts #trending #shortsvideo Abhay Gadiya 2024-08-28 | This video explains how you activate or deactivate conditional formatting on selected cells using Checkbox inside Excel
Look what is inside Excel file without opening #shorts #youtubeshorts #excel #trending #shortvideo Abhay Gadiya 2024-08-26 | This video explains how can you view the contents of Excel file in folder view without opening the file.
Quick data analysis in Excel automatically #youtubeshorts #shortvideo #excel #trending #shorts Abhay Gadiya 2024-08-25 | This video shows how you can insert SUM, AVERAGE, COUNT, DATA BARS, COLUMN CHART, etc. with single click inside quick analysis toolbar
How to not use SUMIFS in Excel #youtubeshorts #shorts #excel #trending #shortsvideo Abhay Gadiya 2024-08-25 | This video shows 3 different solutions when SUMIFS does not work when multiple SUM range of cells are selected.
How to remove duplicates values in Excel 3 methods #youtubeshorts #excel #trending #shorts #youtube Abhay Gadiya 2024-08-23 | ...
How to use slicers in Excel to filter data #youtubeshorts #shorts #excel #shortvideo #trending Abhay Gadiya 2024-08-19 | This shorts explains how to filter the data using slicers in Excel instead of filter drop down.
Top 500 companies in India #youtubeshorts #youtube #shorts #excel #trending #exceltips #shortsvideo Abhay Gadiya 2024-08-15 | This short explains WRAPCOLUMN function in Excel to convert the data of ET 500 companies copied from website into columnar format.
Top 500 companies in India list extracted in Excel Abhay Gadiya 2024-08-13 | This video shows how can you quickly get ET 500 companies list in Excel without lot of formatting and performing complex steps
MS Excel formulas not showing correct result #youtubeshorts #shorts #shortsvideo #excel #trending Abhay Gadiya 2024-08-13 | There are times when you have formula inside Excel sheet but those are not calculating correctly. When you copy the formula, you get the same results. How to rectify this is shown in this short video
How to use pivot tables in excel with conditional formatting #youtubeshorts #shorts #excel #trending Abhay Gadiya 2024-08-12 | ...
Pivot Table - month over month sales variance #youtubeshorts #shorts #excel #trending #youtube Abhay Gadiya 2024-08-11 | This short explains how to get change in sales number from previous month inside Pivot Table in Excel
Filter all the cells where it is colored #excel #shorts #youtubeshorts #trending #exceltips #youtube Abhay Gadiya 2024-08-06 | Filter dropdown in Excel does not allow to filter multiple cells with distinct colors. This short explains workaround to filter such cells.
Grouping month as H1 & H2 in Pivot Table #trending #shorts #excel #youtubeshorts #exceltips #youtube Abhay Gadiya 2024-08-05 | This short explains how you can group Jan to Jun and Jul to Dec as H1 and H2 inside pivot table. This six month grouping inside pivot table.
Conditionally formatting entire row #youtubeshorts #youtube #shortvideo #shorts #trending #Excel Abhay Gadiya 2024-08-04 | This short explains how to highlight entire row using conditional formatting based on item selected in other row where data validation is applied
How to sort data in custom ascending order #youtubeshorts #shorts #shortvideo #trending #excel #tips Abhay Gadiya 2024-08-04 | This short explains how you can use custom list inside Pivot Table to do custom sort the data from April to March as per Indian Financial Year
SUMIFS not working on SUMRANGE column #youtubeshorts #shorts #shortvideo #trending #exceltips Abhay Gadiya 2024-08-01 | This short shows workaround when SUMIFS or SUMIF is not working
SUMIFS not working on multiple sum column range full video #excel #exceltips #sumifs #exceltutorial Abhay Gadiya 2024-08-01 | This video explains workaround when SUMIFS is not working on dataset inside excel.
Pivot Table Field Layouts options #youtubeshorts #shorts #shortvideo #trending #pivottable Abhay Gadiya 2024-07-31 | This shorts shows different layout options for fields inside pivot table.
Conditional / dependent Data validation #trending #youtubeshorts #youtube #shorts #shortvideo #excel Abhay Gadiya 2024-07-30 | This video shows how can you create conditional or dependent data validation list inside excel using Index and match formula.
Navigate to particular cell inside Excel #youtubeshorts #shorts #short #excel #exceltips #trending Abhay Gadiya 2024-07-28 | This short shows how can you name the cell in Excel sheet and then use it inside Go To Toolbar to navigate to it.
Creating multiple sheets from names mentioned in cells #excel #pivottable #shorts #youtubeshorts Abhay Gadiya 2024-07-27 | This short explains how to create multiple sheets in Excel with sheet names mentioned inside cells.
Sort data by calendar month abbreviation custom order #datasorting #excel #exceltips #exceltutorial Abhay Gadiya 2024-07-26 | This short explain how can you sort the data in calendar month order when you have month abbreviation or the order of month you specify.
Conditional or dependent Data Validation inside Excel #exceltips #excel #exceltutorial #exceltricks Abhay Gadiya 2024-07-09 | This video shows how can you can create conditional data validation inside excel.
Convert single column data into multiple columns #exceltips #excel #shorts #youtubeshorts #trending Abhay Gadiya 2024-07-08 | This video shows how to use UNIQUE, TRANSPOSE, FILTER function in excel to convert single column data into multiple columns
Charts with slicers in Excel - Interactive and dynamic without VBA #exceltips #excelchart #excel Abhay Gadiya 2024-07-07 | Do you want to create interactive and dynamic dashboards and charts inside excel then you must watch this video.
Merge Columns in Excel only if it is blank cell new #exceltips #exceltricks #excel #exceltutorial Abhay Gadiya 2024-07-07 | ...
Pivot table in columnar format and repeat labels #exceltips #excel #exceltricks #pivottable Abhay Gadiya 2024-07-07 | This video shows how to fill in row labels inside pivot table instead of showing blank cells.
Restore original sort order of data in excel #exceltips #exceltricks #excel #exceltech #microsoft Abhay Gadiya 2024-07-06 | ...
Quickly Hide and unhide columns using grouping feature in Excel #excel #exceltutorial #exceltips Abhay Gadiya 2024-07-06 | Instead of hide and unhide columns or rows multiple times you can use grouping of columns or rows.
Keyboard shortcuts to be used in excel #exceltips #excel #exceltricks #exceltech #keyboardshortcuts Abhay Gadiya 2024-07-05 | This video gives screenshot of all the keyboard shortcuts that can be used inside Excel.
Getting multiple columns values without VLOOKUP #excel #exceltips #exceltricks #xlookup Abhay Gadiya 2024-07-05 | This video shows alternative to writing complex INDEX and MATCH formula with Advanced filter.
Fill 1 to 1000 serial numbers with 3 different approach in Excel #exceltips #excel #exceltutorial Abhay Gadiya 2024-07-04 | This video shows how can you get 1 to 1000 serial numbers within fraction of second with three different approach inside Excel.
Get multiple column values by using INDEX and MATCH instead of VLOOKUP in Excel #exceltips #excel Abhay Gadiya 2024-07-04 | This video shows how to use dynamic array feature with INDEX and MATCH formula inside Excel instead of using VLOOKUP formula
Keyboard shortcuts to navigate within Excel file #exceltips #excel #keyboardshortcuts #exceltutorial Abhay Gadiya 2024-07-01 | This short shows keyboard shortcuts to navigate within Excel file.
Compare column headers from different sheets in Excel #exceltips #excel #exceltricks Abhay Gadiya 2024-06-30 | This video shows usage of Column Difference in Go To Toolbar to identify difference in column headers from different sheets.
How to bold text cells filtered in Excel #shorts #youtubeshorts #excel #trending #exceltips Abhay Gadiya 2024-06-30 | In Excel you can't filter the data based on font type like - bold, italic, etc. This video explains workaround for it filter such data based on text font.
Power Query one click to remove blank rows in Excel #exceltricks #exceltips #excel Abhay Gadiya 2024-06-30 | This short explains how to remove blank rows with simple one click using Power Query in Excel
Show % to grand total inside pivot table #exceltips #exceltricks#pivottables #excel Abhay Gadiya 2024-06-29 | This short explains how to get individual amount as % of grand totals
Data validation list includes new items automatically #exceltips #excelworld #exceltricks #excel Abhay Gadiya 2024-06-29 | ...
16 digit numbers like credit card to be displayed in Excel cell #exceltips #excel # #exceltricks Abhay Gadiya 2024-06-29 | This video explains steps to display 16 digit numbers inside excel cell
Keyboard shortcut frequently used in Excel #exceltips #exceltricks #excel Abhay Gadiya 2024-06-28 | This short explains different keyboard shortcut keys inside excel
