Linking Shapes to Data in Excel
ฝัง
- เผยแพร่เมื่อ 9 ก.ย. 2018
- Learn how to add shapes to your Excel spreadsheets and then to link those shapes to data so that the information on the shape changes when the spreadsheet data changes. This is more than just an Excel trick, because it can really enhance the look of your spreadsheet and can visually "pull out" the data that you want people to focus on. #excel #exceltutorial ***Consider supporting Technology for Teachers and Students on Patreon***: / technologyforteachersa...
- แนวปฏิบัติและการใช้ชีวิต
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!
Super...simple trick saved my life
Very helpful. Can it be done with transparent circles too in condition to a different cell?
very helpful, easy to make a seating chart based on a list with this tutorial
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.
Can you programmatically control the height and width, and style, color, effect?
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?
Hi Sir, please am using Excel 2010, I cannot type at in the formular bar after inserting my table. Please for your advice
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.
EXCELLENT-CONGRATS & THANKS.
Subscribed! Great videos
Good work Bro i appreciate it
That was cool!
It's really helpful 👍👍
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
very nice
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.
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
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.
You have helped me so much. Thank you. Will you be able to upload PHP tutorials? please
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.
Can we protect every worksheet with different password so multiple workers can work on same excel online but cannot edit other worker data ?
Thank you
plz teach us more formulas like SUMIF ...
I understand it's possible to add conditional formatting to shapes. If this is true, could you show us how to do that? Thanks.
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.
Form 2024 year : Amazing explanation with amzaing teacher .
You just save my ass dude!! Thanks!!
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.
The main part of it is at 3:50, remaining stuff is just bull shit....