In this video, I will show you the camera tool in Excel, which you can use to create dynamically linked images that update when you change the original data.
You can read more about it here: https://ift.tt/2s4spII
Camera tool is not available by default in Excel, so you need to add it first in the Quick Access Toolbar. Once you have added it, you can create a linked image with a single click.
All you need to do is select the range of cells for which you want to create the image and then click on the camera tool icon in the QAT.
You can place the image on the same sheet or in any other sheet of the workbook.
In case you need to take a snapshot of a chart and create a linked picture, you need to select all the cells around it (in such a way that the chart is within the range of cells.
Once done, simply click on the camera tool icon and it will create a linked picture of the chart.
This tool can be really useful when you want to create a dashboard. You can use these images to quickly take a snapshot and create the dashboard.
This video is a part of my ‘Excel is two-minute’ series, where I share simple and quick tips to help you speed up your work and be more efficient
Subscribe to this YouTube channel to get updates on Excel Tips and Excel Tutorials videos – https://www.youtube.com/c/trumpexcel
This YouTube channel is managed by Sumit Bansal (who also runs the TrumpExcel website). This channel is meant for people who want to learn Excel.
It covers a lot of Excel basics and advanced Excel topics such as Excel Formulas, Functions, Pivot Table, Shortcuts, Excel VBA, Macros, Excel Dashboards, Excel Charts, Conditional Formatting, Power Query, etc. Please subscribe to this channel to be the first to know when new Excel tutorials come out.
You can find a lot of useful Excel resources on the following site: https://trumpexcel.com/
#Excel #ExcelTips #Excelin2Minutes