20 tricks and tricks for advanced MS Excel

Selected Excel 2013/2016/2019 tricks and tricks for advanced users: conditional formatting in Excel, PivotTables, Power Query Excel, charts, custom formats, and more.

More tricks, Excel tutorials and an example file can be downloaded here https://statanaliz.info/tryuki-ms-excel/

► Corporate training "Advanced level MS Excel":
https: //statanaliz.info/trening-prodv ...

► Online course "Advanced level MS Excel":
https: //statanaliz.info/kurs-prodvinu ...

**************************

💳 Support the channel with money
https://statanaliz.info/donate/

*** Contents ***
0:00 - 1. Hide zero values ​​in cells
1:11 - 2. Secrets of effective search
6:00 - 3. Select constants, formulas, empty cells
8:04 - 4. Text by column
9:28 - 5. Custom format
14:25 - 6. Conditional formatting
21:55 - 7. Restriction of data entry
23:46 - 8. Dropdown list
24:41 - 9. Copy of subtotals
26:11 - 10. Image in note
27:58 - 11. Control value window
30:02 - 12. Copy the chart format
32:05 - 13. Chart template
33:32 - 14. Sparklines
35:03 - 15. Calculated PivotTable Fields
36:56 - 16. Undo auto-fit column width in pivot table
37:51 - 17. Link to pivot table
39:26 - 18. Data Model
46:11 - 19. Power Query: Undo Column Collapse (unpivot)
49:30 - 20. Power Query: merging queries

*** 20 MS Excel Tricks and Tricks for Beginners ***
https://youtu.be/PcjezxSZVOo

*** 20+ Excel keyboard shortcuts to work like a pro. ***
https://youtu.be/TARLP-YfPXo


*** My site is about Excel and statistics ***
https://statanaliz.info/

*** Pages and accounts in social networks ***
Facebook: https: //www.facebook.com/statanaliz.i ...
Vkontakte: https://vk.com/id_statanaliz_info
Twitter: https://twitter.com/statanaliz_info
Telegram: https://t.me/statanaliz

#msexcel