ch
Feedback
Excel, Power Query, DAX, Power BI

Excel, Power Query, DAX, Power BI

前往频道在 Telegram
1 388
订阅者
+324 小时
+107
+6330
帖子存档
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

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

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