Top 10 Excel Tricks You Probably Didn't Know

Learn 10 less known excel tricks in 10 minutes.
🚀 Learn Excel here: www.careerprinciples.com/cour...
🆓 DOWNLOAD Free Excel file for this video: view.flodesk.com/pages/634959...
In this video you'll learn 10 less known excel tricks from most common at level 1 all the way to top secret at level 5.
In Level 1 we go over filter by cell value and moving rows and columns by simply holding the shift key and dragging.
In Level 2 we learn to make synchronised changed across sheets and creating new windows to compare sheets.
In Level 3 we learn to import data from the internet and learn the excel data types feature.
In Level 4 we learn sparklines and how to save a pre-designed chart as a template.
In Level 5 we learn to format numbers in thousands or millions as is often the case in accountinng and finance. Lastly, we use trace precedents to see how formulas are being linked.
LEARN:
📈 The Complete Finance & Valuation Course: www.careerprinciples.com/cour...
👉 Excel for Business & Finance Course: www.careerprinciples.com/cour...
🚀 All our courses: www.careerprinciples.com/courses
SOCIALS:
📸 Instagram - careerprinc...
🤳 TikTok - / career_principles
🧑‍💻 LinkedIn - / careerprinciples
GEAR:
📹 My Favorite Books & Gear: kit.co/kenjiexplains
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
Chapters:
0:00​ -​ Leve 1
1:41​ - Level 2
3:13​ - Level 3
5:00 - Level 4
7:30​ - Level 5
Disclaimer: I may receive a small commission on some of the links provided at no extra cost to you.

Пікірлер: 77

  • @KenjiExplains
    @KenjiExplains Жыл бұрын

    🚀 Learn Excel here: www.careerprinciples.com/courses/excel-for-business-finance 📚 See all our courses here: www.careerprinciples.com/courses

  • @simowafula-vu7gm

    @simowafula-vu7gm

    Жыл бұрын

    am need of this

  • @ChasingMyLiberty
    @ChasingMyLiberty Жыл бұрын

    I am in statistics and data analysis classes now. These videos will help a lot. May the Force be with you, Master of Excel.

  • @Nic-xr1og
    @Nic-xr1og Жыл бұрын

    I learned more from watching 3 of your videos than I did from taking an Excel class + Book. Seriously thank you. Subscribed!

  • @nomatusi7514

    @nomatusi7514

    Жыл бұрын

    I went to the library and got excel books. Read for one day and then discovered youtube has very good tutorial. I took back the books to the library.

  • @GeoGuy388
    @GeoGuy388 Жыл бұрын

    Your videos are a treasure trove. Thanks for all of the great info!

  • @D_EASTON
    @D_EASTON Жыл бұрын

    Thank you Kenji. I can start using that chart template trick immediately, and I hope it will save me a lot of time.

  • @hisokaamorou4211
    @hisokaamorou4211 Жыл бұрын

    thanks man! you have put lot of work for this. I love how you teach

  • @09shirish
    @09shirish Жыл бұрын

    Lot of guidance and information from you, thanks for sharing Sir !

  • @anshulhedaoo8332
    @anshulhedaoo8332 Жыл бұрын

    Short, crisp and clean video...liked it

  • @aartikhowal3425
    @aartikhowal3425 Жыл бұрын

    Your teaching skills are better than others, It helps to improve excel skills GREATE WORK👍

  • @andymarci6766
    @andymarci6766 Жыл бұрын

    Nice tricks for everyone, they are a must know! Cheers!

  • @XLLearner_Courses
    @XLLearner_Courses8 ай бұрын

    Always nice to find these kind of videos. Every time I learn something new

  • @johnvodopija1743
    @johnvodopija1743 Жыл бұрын

    Thank you. These tips were very helpful. Cheers 👍😎🇦🇺

  • @andreugiro2807
    @andreugiro2807 Жыл бұрын

    I improved a lot my excel skills! Thanks kenji!!

  • @KenjiExplains

    @KenjiExplains

    Жыл бұрын

    Great to hear!

  • @umairsayyed6849
    @umairsayyed6849 Жыл бұрын

    Thank you Kenji It was very helpful

  • @TutorialsAndTricks
    @TutorialsAndTricks Жыл бұрын

    Thanks for all of the great info 🙏👍

  • @sweitang6305
    @sweitang6305 Жыл бұрын

    Another great vid.....love your channel

  • @mindmywordsbymeghna.5325
    @mindmywordsbymeghna.5325 Жыл бұрын

    You are doing phenomenal job keep posting videos

  • @joyalresh
    @joyalresh Жыл бұрын

    I just learn the best tricks👍🥰 tks dude

  • @Sahnoun23
    @Sahnoun234 ай бұрын

    Very useful, Thank you

  • @kananikaushik3399
    @kananikaushik3399 Жыл бұрын

    These Tricks are just awesome......thank you sooo much this lesson.

  • @KenjiExplains

    @KenjiExplains

    Жыл бұрын

    Thanks for watching!

  • @tristanontheway
    @tristanontheway Жыл бұрын

    wow I didnt know you could do that... thanks kenji for the great video ONCE AGAIN

  • @KenjiExplains

    @KenjiExplains

    Жыл бұрын

    Happy to help!

  • @pjpj6416
    @pjpj6416 Жыл бұрын

    thank you Kenji for this great video.

  • @KenjiExplains

    @KenjiExplains

    Жыл бұрын

    Glad you enjoyed it!

  • @joeyp6111
    @joeyp6111 Жыл бұрын

    thanks for making knowledgeable videos ! i'm planning on taking the cfa level 1 exam in november of 23 any tips ?

  • @camlex6310
    @camlex6310 Жыл бұрын

    Really insightful!!

  • @KenjiExplains

    @KenjiExplains

    Жыл бұрын

    Cheers!

  • @harshavardhanrks9248
    @harshavardhanrks9248 Жыл бұрын

    Helpful tricks

  • @michaelquach7046
    @michaelquach7046 Жыл бұрын

    Definitely saving this video

  • @KenjiExplains

    @KenjiExplains

    Жыл бұрын

    Let's go!

  • @Goddibaba

    @Goddibaba

    Жыл бұрын

    Happy for you, bro.

  • @williamarthur4801
    @williamarthur4801 Жыл бұрын

    Oh no, that data type info is just brilliant, I'm always having to lookup animal classifications, now if only it would tell me the correct order.

  • @dianemetzloff7993
    @dianemetzloff7993 Жыл бұрын

    Love your show

  • @shyaam_sinngh
    @shyaam_sinngh Жыл бұрын

    Great 👍

  • @1986DLee
    @1986DLee Жыл бұрын

    Thanks Kenji. Can you please provide a link to download the excel file? I can only see a link to courses

  • @canrick
    @canrick Жыл бұрын

    Informative thanks

  • @KenjiExplains

    @KenjiExplains

    Жыл бұрын

    Glad it was helpful!

  • @blakemarcus
    @blakemarcus Жыл бұрын

    Thank you!

  • @KenjiExplains

    @KenjiExplains

    Жыл бұрын

    You're welcome!

  • @oscarzhang3964
    @oscarzhang3964 Жыл бұрын

    thank you Kenji 🥰🥰

  • @KenjiExplains

    @KenjiExplains

    Жыл бұрын

    Thanks for watching Oscar!

  • @mahmoudamara6861
    @mahmoudamara6861 Жыл бұрын

    Thank you Kenji

  • @KenjiExplains

    @KenjiExplains

    Жыл бұрын

    You got it!

  • @chebochitalu6543
    @chebochitalu6543 Жыл бұрын

    You never disappoint

  • @KenjiExplains

    @KenjiExplains

    Жыл бұрын

    Thanks for watching Chebo!

  • @Goddibaba
    @Goddibaba Жыл бұрын

    Glad I subscribe.

  • @KenjiExplains

    @KenjiExplains

    Жыл бұрын

    Lets go!

  • @srik7536
    @srik75363 ай бұрын

    Thanks

  • @solomonbhandari-young4154
    @solomonbhandari-young4154 Жыл бұрын

    Top tier

  • @dineshgudla3735
    @dineshgudla3735 Жыл бұрын

    Which version of Office supports moving of columns to the left or right ? I have tried to execute the tip to move the column but instead it is asking do you want replace the selected column content on another column.

  • @mattellwood8090
    @mattellwood8090 Жыл бұрын

    El mago de Excel!

  • @sudhansumishra2895
    @sudhansumishra2895 Жыл бұрын

    Hey can you share some tips to connect to one folder where you have 10 excel file . I want to connect to the folder so that all the data automatically gets connected to the master Excel and in different sheets. Like 10 workbooks in a folder to merge with 1 excel as 10 sheets. I tried to get data from a folder but it does not work

  • @CrazyGuy9990
    @CrazyGuy9990 Жыл бұрын

    Spark lines tip is awesome

  • @KenjiExplains

    @KenjiExplains

    Жыл бұрын

    It really is!

  • @satyammv
    @satyammv Жыл бұрын

    an even more faster way to filter by selected cells value is to - Add Autofilter to your quick access toolbar and you'll be able to filter with just one click :)

  • @ChasingMyLiberty
    @ChasingMyLiberty Жыл бұрын

    question: would you say that it is best to have a pc or macbook in finance. Something that works in a company in person or remote or as an independent contractor.

  • @stan9011

    @stan9011

    10 ай бұрын

    PC

  • @DorothyLi-tu2wj
    @DorothyLi-tu2wjАй бұрын

    good video, but I didn't see the "geography", can you explain?Thanks.

  • @Fiori_oracle
    @Fiori_oracle9 ай бұрын

    Hi to reconcile quickly. How to find out if the reference ID and amount not matching?

  • @willzinner8813
    @willzinner8813 Жыл бұрын

    can you make one on unknown formulas?

  • @KenjiExplains

    @KenjiExplains

    Жыл бұрын

    Noted thank you :)

  • @anubhabchakraborty4926
    @anubhabchakraborty4926 Жыл бұрын

    How to remove the old columns which contain the unformatted data? Deleting them does not work as it shows #REF! in the formatted columns.

  • @danieljonas5799
    @danieljonas57998 ай бұрын

    When trying to put a url in and load the data, I tried it with a 50 states url and excell didn’t load anything is there any specifications I’m missing

  • @chideraonyewuotu5488
    @chideraonyewuotu5488 Жыл бұрын

    @Kenji Explains please can I get a way to reach you personally

  • @chinetugoigboanusi8415
    @chinetugoigboanusi8415 Жыл бұрын

    How do I paste values only from clipboard?

  • @MuhammadTanveer-9797
    @MuhammadTanveer-9797 Жыл бұрын

    How to colum A1, 01 automatic 01 Bottle and 02 Bottles Come written yah condition formatting and format cell In excel please help me

  • @sridevavkb
    @sridevavkb Жыл бұрын

    ok got it

  • @rogermarquez1314
    @rogermarquez1314 Жыл бұрын

    You should have started that you need to make your data into a table

  • @smithrowe8959
    @smithrowe8959 Жыл бұрын

    Wealth and riches are measured by the amount of investments a person has, that's why I invest all the time.

  • @putuindahratnasari7568
    @putuindahratnasari7568Ай бұрын

    MY EXCEL does not have data type , so i can not choose geography option, why is that so?

  • @tears_of_the_kingdom
    @tears_of_the_kingdom Жыл бұрын

    Hi

  • @noahmateo8778
    @noahmateo8778 Жыл бұрын

    The philosophy of the rich and the poor is this:the rich invest their money and spend what is left. The poor spend their money and invest what is left.

  • @lonnpton5239
    @lonnpton5239 Жыл бұрын

    🗿