Linking Shapes to Data in Excel

Поділитися
Вставка
  • Опубліковано 7 лис 2024

КОМЕНТАРІ • 33

  • @KarmaChophel-o7p
    @KarmaChophel-o7p Місяць тому

    I haven't tried before, even shapes works in the excel without cell by using formula bar....amazing..

  • @user-gx3st2th8q
    @user-gx3st2th8q Рік тому

    very helpful, easy to make a seating chart based on a list with this tutorial

  • @jackiewin4289
    @jackiewin4289 4 роки тому +1

    Thank you for all these excellent lessons that you have sharing with us. I am sure it has been very helpful to most of the viewers especially to myself, thank you! and keep up the great job!

  • @letuslearnmore
    @letuslearnmore 8 місяців тому +1

    Form 2024 year : Amazing explanation with amzaing teacher .

  • @nasrinnasrin4646
    @nasrinnasrin4646 23 дні тому

    Thank you 🙏🙏🙏🙏

  • @orlandobonilla9534
    @orlandobonilla9534 3 роки тому

    Very helpful. Can it be done with transparent circles too in condition to a different cell?

  • @tarvsingh6241
    @tarvsingh6241 Рік тому

    EXCELLENT-CONGRATS & THANKS.

  • @rallymax2
    @rallymax2 2 роки тому

    Can you programmatically control the height and width, and style, color, effect?

  • @MrNiks-li6jn
    @MrNiks-li6jn Рік тому

    It's really helpful 👍👍

  • @punaschaprakash9471
    @punaschaprakash9471 4 роки тому

    Super...simple trick saved my life

  • @coldpond
    @coldpond 2 роки тому

    Very helpful. Could I insert a total directly from a different sheet within the spreadsheet? I've tried, but can't seem to do it just yet. I can bring the cell total to the sheet and then make the cell formula insertion, but not directly from one sheet to another. Just curious.

  • @akashaimachill3434
    @akashaimachill3434 6 років тому +3

    You have helped me so much. Thank you. Will you be able to upload PHP tutorials? please

    • @techteachersandstudents
      @techteachersandstudents  6 років тому +3

      Thanks for your kind comments Dipesh. Unfortunately I don't know PHP. Maybe someday I'll learn it and make a few videos. Thanks for watching.

    • @akashaimachill3434
      @akashaimachill3434 6 років тому

      Can we protect every worksheet with different password so multiple workers can work on same excel online but cannot edit other worker data ?

  • @Exceltrainingvideos
    @Exceltrainingvideos 5 років тому

    That was cool!

  • @frab8061
    @frab8061 Рік тому

    Another solution for changing cell references would be to use the function INDIRECT, which makes it so you can have all your cell references in one place and they point to the cells in which the value really is stored. If you then change the indirect cell reference, the format wouldn't get updated.

  • @geethareddy1148
    @geethareddy1148 6 років тому

    Thanks sir for your resourceful videos. Those are really clear, understandable. Can you tell me how to become knowledgeable in Microsoft office. Where to start?

  • @paulvanobberghen
    @paulvanobberghen 5 років тому +1

    I understand it's possible to add conditional formatting to shapes. If this is true, could you show us how to do that? Thanks.

    • @techteachersandstudents
      @techteachersandstudents  5 років тому

      Thanks for the suggestion! I've added it to my list of videos to record. It will take a few weeks before it's ready.

  • @lavishjain0605
    @lavishjain0605 2 роки тому

    Thank you

  • @pftl69
    @pftl69 6 років тому

    Hello, Thanks a lot for the free lessons on excel. I learned and learning a lot from your lessons. I have a request. Is is possible to upload practice sheet? Or could you provide us a link for that? That’s will be more helpful for us.

    • @cyrilcyril1576
      @cyrilcyril1576 5 років тому +1

      Sir, what I do is, I open my own excel sheet and re-type his very information and then practice with him with the same information by watching different videos. so I often spend alot of time watching one video by immitating each one of his steps. hope this trick is helpful

  • @cyrilcyril1576
    @cyrilcyril1576 5 років тому

    Hi Sir, please am using Excel 2010, I cannot type at in the formular bar after inserting my table. Please for your advice

  • @brianthomas4047
    @brianthomas4047 6 років тому

    Subscribed! Great videos

  • @wesleyk.8376
    @wesleyk.8376 2 роки тому

    Thanks, but what about a CIRCLE? Nobody seems to know this: if I insert a circle that's 24x24" (perfect circle), HOW do I determine how to fit 8,964 cells within that area? It there an auto script to do this? Please help me with details if you can. Thanks

  • @phouksovannphal2709
    @phouksovannphal2709 6 років тому +1

    plz teach us more formulas like SUMIF ...

  • @mite2790
    @mite2790 4 роки тому

    Good work Bro i appreciate it

  • @vijaytaneja8667
    @vijaytaneja8667 6 років тому

    sir please make video on start time and end time. means when we click on start button times start as per clock n when click on end button time end and difference show that how much time is taken for a work by someone.

  • @vijaytaneja8667
    @vijaytaneja8667 6 років тому

    very nice

  • @KCReaper
    @KCReaper 5 років тому

    You just save my ass dude!! Thanks!!

  • @davidstevens7727
    @davidstevens7727 4 роки тому

    I must have the only broken Excel in the world, I just keep getting an error, The formula is missing a range reference or defined name.

  • @ziyacihantaysi2602
    @ziyacihantaysi2602 Рік тому

    The main part of it is at 3:50, remaining stuff is just bull shit....