Top 20 Microsoft Excel Tips & Tricks скачать в хорошем качестве

Top 20 Microsoft Excel Tips & Tricks

In this step-by-step tutorial, learn the top 20 best Microsoft Excel tips and tricks. 👋 Resources called out in this video: Excel sheet that I used if you want to follow along: https://1drv.ms/x/s!AmxrofZZlZ-whKMxY... In-depth Pivot Table tutorial:    • Pivot Table Excel Tutorial   Learn the fundamentals of Excel in just 2 hours: https://kevinstratvert.thinkific.com ⌚ Timestamps 0:00 Introduction 0:17 Convert image to table in Excel using phone 1:29 Use Excel for free on the web 2:08 Use Ideas to generate insights on your data 3:19 Define names for cells 4:42 Absolute & relative cell references 6:35 Macros 8:35 Data types 9:38 Xlookup function 11:47 Sum function 12:43 Concatenate and flash fill 13:48 Sumif function 14:45 Countif function 15:35 IF function 16:48 Calculate difference between dates & convert function 18:11 Adjust column width & row height automatically 18:56 Freeze panes 19:33 Pivot Tables 21:14 Drop down lists 22:16 Import data from web 23:54 Collaborate with others & comment 24:45 Wrap up 📃 Watch related playlists and videos Excel:    • ❎ How to use Excel   🚩 Connect with me on social: LinkedIn:   / kevinstratvert   Twitter:   / kevstrat   Facebook:   / kevin-stratvert-101912218227818   🔔 Subscribe to my YouTube channel https://www.youtube.com/user/kevlers?... 🎬 Want to watch again? Navigate back to my YouTube channel quickly http://www.kevinstratvert.com