Excel, Power Query, DAX, Power BI
Open in Telegram
1 388
Subscribers
+324 hours
+107 days
+6330 days
Posts Archive
How to filter text which is in *BOLD* or _ITALICS_ in a column
https://youtube.com/shorts/f7CZOh3JVPY?si=vaa72wP1Tu3R0A2S
Quickly gain insights from data by simply selecting it
https://youtube.com/shorts/DLIhMKZOk3s?feature=share
How to calculate months or years between dates using hidden DATEDIF formula
https://youtube.com/shorts/x49Mm-qxvpU?feature=share
Calculate MAXIFS, MINIFS in Excel using SUMIFS syntax
https://youtube.com/shorts/b6PSi7t66gI?feature=share
How to dynamically extract top 10 records
https://youtube.com/shorts/Ps28pL3dXqQ?si=YFDGFu6LHebsbPj9
Moving data in column without adding or deleting the columns
https://youtube.com/shorts/tXk980O6vEw?feature=share
Total calculated changes based on items filtered in dataset
https://youtu.be/HwPg3ruTxlU?si=qYCUuaJd2UGjkGyq
Activate or deactivate conditional formatting in Excel using Checkbox
https://youtube.com/shorts/SKK-hlNDiXM?si=lv8WJssPOO1UOnoX
Glance data inside the Excel file without opening in it
https://youtube.com/shorts/2Z2H8UlXlsc?feature=share
Perform quick data analysis with simple single click - insert data bars, heat map, bar chart, total, running total, % of grand total, etc.
https://youtube.com/shorts/5Eel1vMg4vg?feature=share
You want to use OR logic while applying filters on multiple columns, default auto filter only applies AND logic. Checkout solution here
https://youtube.com/shorts/_ugpsbAboFw?feature=share
Remove duplicates to get a unique list of items with three different approaches in Excel
https://youtube.com/shorts/pSy5vFWmkWY?feature=share
How to get a financial year in Excel
https://youtube.com/shorts/TcOrKni4gZo?feature=share
Heard about WRAPROWS function in Excel? Want to extract ET 500 companies data from a website into Excel in columnar format?
Checkout the video
https://youtube.com/shorts/dwoFu14-Kj4?feature=share
Formula not working in excel when you copy it, change this setting
https://youtube.com/shorts/xAv1pgdSqbc?feature=share
Calculation of month over month change inside the pivot table
https://youtube.com/shorts/bgeVC5X8u4w?feature=share
Default filter does not have option to filter text in bold, italic, etc. check workaround here
https://youtube.com/shorts/f7CZOh3JVPY?feature=share
The default filter does not allow you to select multiple colors while filtering. Checkout workaround for it
https://youtube.com/shorts/ELKPLrp-4yo?feature=share
How to remove blank rows in Excel using Power query with simple click
https://youtube.com/shorts/0h5kp16p5Pc?feature=share
The default group in Pivot Table does not allow months to be grouped as the first half and second half. Check out this how to do it.
https://youtube.com/shorts/7odOY7QuMGU?feature=share
