The Best Microsoft Excel Tips & Tricks in 2021

Показать описание

These Microsoft Excel tips & tricks will save you time and make you a more efficient Excel user. Make sure to learn and apply at least 1 tip from today’s podcast show.

What is your best Excel tip & trick in 2021? You can share it with us at the bottom of this page in the comments area, we would love to hear it!

⌚ Time Stamps:
00:00 - Introduction

02:29 1. Bill Jelen from MrExcel - Left Click to Paste the Status Bar Metrics

03:07 2. Jeff Lenning from Excel-University - CTRL + PAGEUP keyboard shortcut

04:40 3. Avi Singh from LearnPowerBI - How to Excel in a New Career

06:18 4. Oz Du Soleil from OzDuSoleil - Emojis in Excel

07:47 5. Kat Norton from Miss Excel - Flash Fill

08:33 6. Jon Acampora from ExcelCampus - Lamba Function

10:41 7. Chandoo from Chandoo - Icons

11:50 8. Bob Umlas - Dynamic Array Tip

13:51 9. Alan Murray from Computergaga - SUM Function

15:57 10. Bryan Hong from MyExcelOnline - Analyze Data Feature

16:41 11. Chris Newman from TheSpreadsheetGuru - CTRL + SHIFT keyboard shortcut

18:04 12. Anne Walsh from The-Excel-Expert - Recommended Charts

20:04 13. Gašper Kamenšek from ExcelOlympics - Copy multiple items & paste using Windows + V

21:26 14. Wyn Hopkins from AccessAnalytic - Learn to use Power Query

22:33 15. Sumit Bansal from TrumpExcel - Save VBA Codes in Personal Workbook

23:26 16. Cristiano Galvao from Genecsis - Analyze Data Feature

24:32 17. Ivett Szabados from Excelneked - Power Query to Append Worksheets

25:23 18. Georg Lasar from AlbertExcel - Hiding Excel Sheets with the VBA Editor

27:37 19. George Mount from StringfestAnalytics - Consider Learning Python

29:33 20. Mark Proctor from ExcelOffTheGrid - Learn to use Power Query

32:07 21. Yolanda Cuesta from Excelcontabilidadytic - Accessibility for People with Disabilities

32:59 22. John MacDougall from Howtoexcel - LET & Lambda Function

34:25 23. Frédéric Le Guen from Excel-Exercise - Map Charts

36:01 24.Ryan Wells from Wellsr - Python with Pandas

37:02 25. Jordan Goldmeier from AdvancedXL - FORMULATEXT Function

38:00 *BONUS TIP* John Michaloudis from MyExcelOnline - Learn Excel with quick & insightful Instagram Reels

----------------------------

👨‍🏫 MyExcelOnline Academy Online Excel Courses 👇
1,000 video training tutorials & support covering Formulas, Macros, VBA, Pivot Tables, Power Query, Power Pivot, Power BI, Charts, Financial Modeling, Dashboards, Word, PowerPoint, Outlook, Access, OneNote, Teams & MORE...

🔥 OUR BEST EXCEL RESOURCES 🔥

------------

Feel free to comment and ask questions about this Microsoft Excel tutorial below and we will get back to you with the answer ASAP!

If you enjoyed the video, please give a thumbs up, comment, share.

Do not forget to SUBSCRIBE to this channel to get our new Microsoft Excel tutorials delivered straight to you each week! Thank You :)

Cheers,

JOHN MICHALOUDIS
Chief Inspirational Officer & Microsoft MVP

❤️ Let’s connect on social ❤️

#MyExcelOnline