50 Ultimate Excel Tips and Tricks for 2020




About this tutorial:

Video duration: 00:50:17
The ultimate compilation of Excel tips and tricks to enhance your productivity using Excel. Updated for 2020! I’ve combined long-established tips and tricks with new ones Microsoft added in 2019 and 2020. You’ll find solutions to the most common challenges you face in Excel.

Support me with your Amazon purchases, click here:

Contents 0:00
1. Move Data 0:35
2. XLOOKUP() 1:04
3. Filter List 2:24
4. Ideas 3:04
5. Remove Blanks 3:54
6. Quick Analysis Tool 4:28
7. AutoFit Column Width 5:27
8. Absolute Cell Reference 5:57
9. Paste Special Values 7:19
10. Drop-Down…

Post Author: OfficeTutes.com

Apple lover, ICT and LEAN consultant, MS Office lecturer My other website with video tutorials - Tutorials, guides and news for iPhones and iPads

30 thoughts on “50 Ultimate Excel Tips and Tricks for 2020

    Ernst James

    (October 6, 2020 - 11:47 am)

    Best Excel tutorial by far. Extremely helpful. Second to none.

    Johnny Becerra

    (October 6, 2020 - 11:47 am)

    This is soooo helpful!!! Thank you so much mister😊

    Abdi Dek Muhumed

    (October 6, 2020 - 11:47 am)

    i would like to be your real classroom student to get all the things clearly thank you.

    salim karimi

    (October 6, 2020 - 11:47 am)

    Excellent tips

    editha malones

    (October 6, 2020 - 11:47 am)

    This is so cool! thank you so much!

    peace arnett

    (October 6, 2020 - 11:47 am)

    Thanks for all you do for learners 👍🏽

    DR BAHSHARUDIN MOHD SHARIF

    (October 6, 2020 - 11:47 am)

    Awesome…..really appreciated

    Dakota K

    (October 6, 2020 - 11:47 am)

    On #9 Paste Special Values, you can also just click the Clipboard with the "123", under the bold "Paste Options". 🙂

    edmar quejada

    (October 6, 2020 - 11:47 am)

    How can I get the sum of my IMEI and Mac address using MS Excel? After getting the sum and multiplied by 11, how can I execute "nck" calculation in Ms Excel? IMEI :ime:864436033525271 lan mac address : C4:9F:4C:4E:16:D5

    Frank MD

    (October 6, 2020 - 11:47 am)

    Best among all, hands down!!

    Frank MD

    (October 6, 2020 - 11:47 am)

    Amazing!!!!!
    Thank you so so much

    harish done

    (October 6, 2020 - 11:47 am)

    VERY USEFULL TRICKS EXPLAINED BY WAY IS EXCELENT.

    kantu yudantara

    (October 6, 2020 - 11:47 am)

    Shortcut How back to the cell before

    Jatt Mo

    (October 6, 2020 - 11:47 am)

    Thank you. I found this tremendously helpful.

    Ahmed Moatassim

    (October 6, 2020 - 11:47 am)

    the best tutor ever on youtube. you did a miracle summarizing all these features on one video only. this is helpful for beginners and advanced people.

    Apolinar Rucobo

    (October 6, 2020 - 11:47 am)

    ha that easy thanks

    jodie tran

    (October 6, 2020 - 11:47 am)

    Thank you for sharing … much appreciated!

    Carlos A. Garcia

    (October 6, 2020 - 11:47 am)

    Sir…. Where is the index description for this video….? Thank you….

    Prabhu prabhu

    (October 6, 2020 - 11:47 am)

    Expel
    132
    123
    213
    231
    321
    312
    If I register a three digit number it is automatic
    I need to change how I do this

    Malkal Yzai

    (October 6, 2020 - 11:47 am)

    3:38 regions

    juchito palacios

    (October 6, 2020 - 11:47 am)

    Thank you.

    Sonder

    (October 6, 2020 - 11:47 am)

    Love the People Graphs tip!

    harshil shah

    (October 6, 2020 - 11:47 am)

    How to check Difference between Lists if both Lists are on Different Worksheets. ? can you pls explain.

    Peace

    (October 6, 2020 - 11:47 am)

    Thanks! If you had put your worksheet also that would have given us the chance to do the practice along with you.

    Tony Byfield

    (October 6, 2020 - 11:47 am)

    Some very helpful tips, thank you.

    Mite Dimitrov

    (October 6, 2020 - 11:47 am)

    As soon as I saw those time stamps I was sold! Thank You!

    Ed Leets

    (October 6, 2020 - 11:47 am)

    Those are not tricks! Those are normal steps of basic knowledge. Tricks should be beyon normal!!!

    kalai selvi

    (October 6, 2020 - 11:47 am)

    shall i know how to activate slicers in ma excel

    Saher Bivi

    (October 6, 2020 - 11:47 am)

    Thank you very much

    Amy Howard Miller

    (October 6, 2020 - 11:47 am)

    Thank you

Leave a Reply

Your email address will not be published. Required fields are marked *