► Learn the 21 Best Excel Tips and Tricks for Beginners and Intermediates! A real free Excel course in just a few minutes. Check it out now! ???? OUR NEW EXCEL CHANNEL - / @meplanilhas ???? [COURSE] Complete Excel - from Basic to Advanced: https://bit.ly/3gokL64 ???? Increase Your PRODUCTIVITY - https://bit.ly/3d6c1ju ???? Increase Your FOCUS - https://bit.ly/3xCCOxn ???? Digital Book Reader I Recommend - https://amzn.to/3UqjFeY __________________ ???? FREE DOWNLOAD ???? 5 Essential Excel Functions Everyone Needs to Know - http://www.meensinatv.com /ebook-5-fun... __________ ???? BOOK ???? The Best and Most Complete Excel Book in Portuguese (from Basic to Advanced) - https://amzn.to/3fiHXkf _____________ ???? SUMMARY // In this Excel class you will learn: 1. Move around the table with the keyboard - 01:22 2. Column Autofit in Excel - 02:07 3. Quick Analysis in Excel - 03:30 4. Filter in Excel - 04:24 5. Freeze Row, Column and Panel in Excel - 05:21 6. Autocomplete in Excel - 07:08 7. Relative and Absolute Reference - 08:56 8. Transpose (Column to Row and Row to Column) - 11:43 9. Separating Text into Columns - 12:41 10. Screenshot - 14:15 11. Display all formulas in Excel - 15:26 12. Dropdown List in Excel (Waterfall Menu) - 16:35 13. Remove Duplicates in Excel - 17: 27 14. Reach Goal in Excel - 18:14 15. VLOOKUP function - 19:18 16. Paste Special Values ​​- 22:01 17. Insert image into graph - 23:00 18. IF function in Excel - 23:54 19. Conditional Formatting in Excel - 25:06 20. SUMIF function in Excel - 27:27 21. IFERRO function in Excel – 28:55 You will learn how to create a spreadsheet in Excel in a much more professional way! = = = = = = = = = = = = = = = = = = = = Microsoft Excel is one of the most used tools within companies, in several areas. But he also scares a lot of people. Therefore, many people keep asking themselves how to learn Excel, but don't take the step forward. In this video we decided to show the 21 best Excel tips for beginners and intermediates. So, there's no mistake, you will learn how to create a spreadsheet in Excel in a more professional way. Even if it's just to manage your household budget and plan your vacations and parties. Let's talk about basic Excel formulas and work with the VLOOKUP, IF and SUMIF functions. We also talk about conditional formatting in Excel, which is very useful in everyday life. We show how to freeze row, column and panel; how to achieve a goal in Excel; how to transpose content, making columns become lines and lines become columns; Excel autofill… and much, much more! This is a real free Excel course! You will learn a lot in a single video, believe me. You will truly learn how to create a spreadsheet in Excel without fear. The class was made in Microsoft Excel 2016. But it is also suitable for Excel 2019, 2013 and 2010. So, check out our 21 best Excel tips and tricks now! = = = = = = = = = = = = = = = = = = = = Watch more Excel classes! In the playlist below you will find a real free Excel course. Check it out! ???? Microsoft Excel – Free Classes • How to Calculate AVERAGE in Excel Easily... = = = = = = = = = = = = = = = = = = = = Canal Me Teach TV aims to share FREE content about more varied technologies in our daily lives to make life easier for many people. We believe that through digital inclusion we can contribute to reducing social inequality a little. Help us in our mission: SHARE with your friends and family! A hug! = = = = = = = = = = = = = = = = = = = = ???? SUBSCRIBE TO THE CHANNEL: https://goo.gl/7MWDjQ ​​= = = = = = = = = = = = = = = = = = = = = ???? SOCIAL MEDIA: → Facebook: https://goo.gl/cZvfy8 → Twitter: https://goo.gl/2Ns8DP → Google Plus: https://goo.gl/n94Tbn → Telegram Channel: http://bit.ly/2OoIrel = = = = = = = = = = = = = = = = = = = = ???? PARTNERSHIPS: [email protected] = = = = = = = = = = = = = = = = = = = = #excel #tips #spreadsheet #teach #tutorial = = = = = = = = = = = = = = = = = = = = =