Linking Shapes to Data in Excel

Поделиться
HTML-код
  • Опубликовано: 26 дек 2024

Комментарии • 34

  • @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!

  • @KarmaChophel-o7p
    @KarmaChophel-o7p 2 месяца назад

    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

  • @letuslearnmore
    @letuslearnmore 9 месяцев назад +1

    Form 2024 year : Amazing explanation with amzaing teacher .

  • @Daryanavard11
    @Daryanavard11 2 месяца назад

    Thank you 🙏🙏🙏🙏

  • @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.

  • @MrNiks-li6jn
    @MrNiks-li6jn Год назад

    It's really helpful 👍👍

  • @orlandobonilla9534
    @orlandobonilla9534 3 года назад

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

  • @punaschaprakash9471
    @punaschaprakash9471 4 года назад

    Super...simple trick saved my life

  • @rallymax2
    @rallymax2 2 года назад

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

  • @tarvsingh6241
    @tarvsingh6241 Год назад

    EXCELLENT-CONGRATS & THANKS.

  • @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 ?

  • @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

  • @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

  • @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.

  • @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.

  • @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

  • @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?

  • @Exceltrainingvideos
    @Exceltrainingvideos 5 лет назад

    That was cool!

  • @phouksovannphal2709
    @phouksovannphal2709 6 лет назад +1

    plz teach us more formulas like SUMIF ...

  • @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.

  • @brianthomas4047
    @brianthomas4047 6 лет назад

    Subscribed! Great videos

  • @mite2790
    @mite2790 4 года назад

    Good work Bro i appreciate it

  • @lavishjain0605
    @lavishjain0605 3 года назад

    Thank you

  • @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.

  • @vijaytaneja8667
    @vijaytaneja8667 6 лет назад

    very nice

  • @KCReaper
    @KCReaper 5 лет назад

    You just save my ass dude!! Thanks!!

  • @ziyacihantaysi2602
    @ziyacihantaysi2602 Год назад

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