Skip to playerSkip to main content
  • 2 weeks ago
💁Agenda of the Video▶️ : To Share an interesting Excel Tip & Trick... How To Enable "Camera" Feature as a Tool or Icon in your "Quick Access Toolbar" in Excel.
✅ Real Time Data Update in Excel using Camera Tool - The Excel Camera tool creates a live, linked snapshot of cells, charts, or tables that updates automatically in real-time when the original data changes.
✅ It acts as a dynamic picture, allowing you to move, resize, and display data from one part of a workbook onto another for dashboards.
--------------------------------------------------------------------------

Category

📚
Learning
Transcript
00:04If you want to use live data update functionality in excel to update your dashboard you need
00:18to activate the camera tool in your ribbon or the quick access toolbar so to activate this tool click
00:32on function go to option in this screen click on quick access toolbar you may check all the option
00:44in the popular command or select all command to find the camera option and
00:57if you will not get the option you can use also the command not in ribbon
01:04see now we can check the camera tool option it is available here click on it
01:14via selecting it and click on add once you click on add it will edit here I have already
01:22added so it's showing here in the first time you need to click on this option after selecting
01:30this click on add it will showing here now click on ok and this option will showing here
01:37in your quick access toolbar and you can also add in ribbon area so I am I have added the
01:47option here in the quick access toolbar and for the process how you can use or implement this
02:01option for updating your dashboard live and in the real time you can check the full length video
02:15in my youtube channel thank you for watching
02:17thank you for watching
02:18you
02:18you
02:18you
02:18you
02:18you
02:18you
Comments

Recommended