How to QUICKLY Use 3D Formulas in Excel

แชร์
ฝัง
  • เผยแพร่เมื่อ 28 ส.ค. 2024
  • Want more Excel videos? Here’s my Excel playlist: • Excel for Beginners: E... In this video tutorial, I will show you how to quickly use 3D formulas in Microsoft Excel. Knowing how to use 3D reference in Excel will help you connect rows, columns, and sheets to make your Excel experience more powerful.
    Other Microsoft Excel Tutorial:
    Microsoft Excel Tutorial - Level 1: • Microsoft Excel Tutori...
    Microsoft Excel Tutorial - Level 2: • Microsoft Excel Tutori...
    Excel for Beginners Tuotiral - Level 3: • Microsoft Excel Tutori...
    Make a drop-down in excel: • How to Create Drop-Dow...
    Pivot Tables in Excel for Beginners - • Excel Pivot Table Tuto...
    VLOOKUP in Excel for Beginners- • Vlookup Function in Ex...
    How to Make a Line Graph: • How to Make a Line Gra...
    10 Best Excel Tips for Beginners: • 10 Best Excel Tips for...
    Want more Excel videos? Here’s my Excel playlist: • Excel for Beginners: E...
    Want more Word videos? Here’s my Microsoft Word playlist: • Microsoft Word

ความคิดเห็น • 45

  • @mannyizquierdo7915
    @mannyizquierdo7915 3 ปีที่แล้ว +9

    Love the way and simplicity you use to explain every detail. Thanks!

  • @willmorales7912
    @willmorales7912 2 ปีที่แล้ว

    I'm watching your videos one at the time because you provide soooo much knowledge. Powerful!!

  • @ahmedlam7215
    @ahmedlam7215 4 ปีที่แล้ว +4

    Thank you for the playlist, sir! Amazing learning experience.

  • @G3nM
    @G3nM 3 ปีที่แล้ว

    Love you so much, this is the video where I learned what is 3D Formulas & how does it work!

  • @rocio2917
    @rocio2917 2 ปีที่แล้ว

    Thanks for the info on the needed details to make it work.

  • @777ISR
    @777ISR 3 ปีที่แล้ว

    I second Manny Izquierdo's comments! Love this and how well you present! Thank you.

  • @willemhart6996
    @willemhart6996 10 หลายเดือนก่อน

    This was SO useful! Thank you very much!

  • @sonyalangeveld5731
    @sonyalangeveld5731 ปีที่แล้ว

    Love this tutorial! Thanks for the way you explain every little detail.

  • @adnanasghar072
    @adnanasghar072 11 หลายเดือนก่อน

    You are doing really well on Excel training. Kindly try to add the Excel file link in the description to follow along.

  • @michellerothwell5126
    @michellerothwell5126 3 ปีที่แล้ว +4

    This is going to save me so much time! For years I have been doing it the slow way where you hit the plus sign between each cell reference on each individual spreadsheet. I should have looked for TH-cam videos years ago. You do your teachings at a very easy-to-follow pace. Would you be able to do one for hyperlinks? I started watching one from another teacher and she goes way too fast. Even with starting and stopping her videos I can't get my hyperlinks to do what she can, especially doing the links within the worksheets that link the worksheets. Very confusing.

  • @bera_owolabi
    @bera_owolabi 4 ปีที่แล้ว

    Thank you so much for your beginner's playlist! All very helpful, simple and straightforward videos. Stay safe.

  • @kathleencrisp1
    @kathleencrisp1 4 ปีที่แล้ว +1

    Thank you Jamie (?Jamey). Much appreciated well done tutorial. Appreciative 69 yr. old Excel beginner. All the best to you and yours. Happy Creating!

    • @TeachersTech
      @TeachersTech  4 ปีที่แล้ว +1

      Thank you! I'm glad it could help you out.

    • @f3ralp1g3on6
      @f3ralp1g3on6 3 ปีที่แล้ว

      beginner? This right here is like a deep web of excel. The depth of Excel where an ordinary human fears to tread. Only mad Excel magicians who crave Excel power and don't hesistate to enter this dark path of 3d sheets watch this video. I assure you that you are not a beginer lol

  • @cigaalgeele
    @cigaalgeele 3 ปีที่แล้ว

    I greet you very much, I really enjoyed your exel lessons thank you teacher

  • @anthonianwiru3769
    @anthonianwiru3769 ปีที่แล้ว

    Thanks 👍😊

  • @fabiolahernandez3456
    @fabiolahernandez3456 3 ปีที่แล้ว

    Thank you so much!

  • @cocoa5117
    @cocoa5117 2 ปีที่แล้ว

    amazing teaching!

  • @vanessachartrand4239
    @vanessachartrand4239 2 ปีที่แล้ว

    Thank you for the help👍

  • @takiyashir8712
    @takiyashir8712 4 ปีที่แล้ว

    Thanks a lot ,Sir .

  • @jmok94747842
    @jmok94747842 4 ปีที่แล้ว +1

    Thanks!

  • @rahibalizada6724
    @rahibalizada6724 3 ปีที่แล้ว

    Thank you very much. It is really cool way explaining excel. In your most videos you have the practice data link so we can download and work on it. But in this one i couldn't find it.

  • @TheMercymerz
    @TheMercymerz 4 ปีที่แล้ว

    Awesome tip!! Thank you

  • @Fernando-cb2gc
    @Fernando-cb2gc 4 ปีที่แล้ว +1

    Amazing!

  • @k-vet2104
    @k-vet2104 3 ปีที่แล้ว

    thank you very much sir for every single simple video tutorial it was very helpful, but the question is how can I create data entry in excel?
    your answer will be very appreciated.

  • @potterylady44
    @potterylady44 6 หลายเดือนก่อน

    Is there a downloadable practice sheet for this? I had to put the same chart and same numbers on each page because I didn't see an info sheet to pull from. My totals aren't the same as yours but hey I did it!

  • @DougPowell01
    @DougPowell01 4 ปีที่แล้ว

    Very nice tip, a real time saver. Now if only we can copy and paste with transpose in the z-axis. Or do a zlookup(). 😉

  • @CalaEnterprise
    @CalaEnterprise 4 ปีที่แล้ว

    Hi Jamie...thank you for making Excel great again. Really great tutorials. Do you have some more? I only found 7 videos about it. I ned to learn, for instance, What If?

    • @TeachersTech
      @TeachersTech  4 ปีที่แล้ว

      You’re welcome and I plan on making that a “what if” soon.

  • @mutebi53
    @mutebi53 3 ปีที่แล้ว

    So beautiful

  • @rondunnett7204
    @rondunnett7204 4 ปีที่แล้ว +1

    Great help. Thanks

  • @andyperry6745
    @andyperry6745 4 ปีที่แล้ว

    HI Jamie, These videos are great and really helpful. I want to learn about having a workbook with multiple sheets where the data links through each sheet. For example if one page has data that I update then a graph on a second worksheet will update too. How do I do that?

  • @prithvi1385
    @prithvi1385 4 ปีที่แล้ว +1

    Will This Formula Works in Excel 2007 Version ?

  • @tmpatklk
    @tmpatklk 4 ปีที่แล้ว +1

    Thanks, Jamie. Interesting. Does this work in Google Sheets too?

    • @TeachersTech
      @TeachersTech  4 ปีที่แล้ว

      You're welcome! Unfortunately it doesn't work on Google Sheets.

  • @lancewilson3424
    @lancewilson3424 4 ปีที่แล้ว

    Thanks Jamie your videos have been very helpful tools. I seen a parts pricelist spreadsheet that had a picture of the part in the next cell? The pictures are taken with a cell phone then added in. I found this very helpful for the employees to ensure the right part is quoted out. I could not figure out how to build a similar one for my company. Could you help me with that?

  • @SteadyChillaxinASMR
    @SteadyChillaxinASMR 4 ปีที่แล้ว

    Hi! You're my Go-To guy and am having g a really hard time in OpenShot. I'm a beginner, having no issues with it. Now, I add 3 video clips,nothing special, but after Exporting, my voice is off with the video?? Please please help me!!!! 💚💚💚

  • @pael82
    @pael82 ปีที่แล้ว

    I need the templet of this excel plz

  • @abdallahtarek3602
    @abdallahtarek3602 4 ปีที่แล้ว

    Make in scape video tutorial but make zoom in video because I have week eyes to follow you

  • @carltonjanet8443
    @carltonjanet8443 4 ปีที่แล้ว

    Hj teacher we neeed full excel
    Please enter your chanel thank u

  • @BLAZINGSTR8DANK420
    @BLAZINGSTR8DANK420 2 ปีที่แล้ว

    This did not help is their a way the name of sheets are messing up the formula? I did everything step by step and don't want to waste hours and need to focus on other classes.

  • @MoniMeka
    @MoniMeka 6 หลายเดือนก่อน +1

    I didn't know that your numbers were different so my grandy totals are different from yours. Ugh!

  • @breonvargas9363
    @breonvargas9363 ปีที่แล้ว

    Get to the point holyyy