Hello guys, Welcome to Africa's Largest Video Search Engine, and you are watching Top 20 Microsoft Excel Tips & Tricks. and this video is uploaded by Kevin Stratvert at 2020-10-23T02:00:02-07:00. We are just promoting this video only for entertainment and educational purpose only. I hop you like our Video Search Engine. [AOPa7ORJj4Y]
| Name | Top 20 Microsoft Excel Tips & Tricks |
| Video Uploader | Video From Kevin Stratvert |
| Upload Date | This Video Uploaded At 23-10-2020 09:00:02 |
| Video Discription | 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-whKMxYi3HuSk1aLx-PA?e=BIFDPp - In-depth Pivot Table tutorial: https://youtu.be/m0wI61ahfLc - 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: https://www.youtube.com/playlist?list=PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY 🚩 Connect with me on social: - LinkedIn: https://www.linkedin.com/in/kevinstratvert/ - Twitter: https://twitter.com/kevstrat - Facebook: https://www.facebook.com/Kevin-Stratvert-101912218227818 🔔 Subscribe to my YouTube channel https://www.youtube.com/user/kevlers?sub_confirmation=1 🎬 Want to watch again? Navigate back to my YouTube channel quickly http://www.kevinstratvert.com [AOPa7ORJj4Y] |
| Category | Science & Technology |
| Tags | kevin stratvert | excel | excel tips and tricks | excel functions | excel formulas and functions | formulas and functions | formulas | functions | function | formula | excel tutorial | excel tutorial formulas | how to use excel formulas | how to use excelo | microsoft excel tutorial | formulas in excel | excels basics | beginners | tutorial | how to | formula excel | learning excel | microsoft | microsoft excel | excel tutorials |
