00:03Hello friends welcome to my channel I am Nazan Madhvi and today we are going to talk about
00:08Excel related trick in which you can use Excel camera to use real-time data update
00:15dashboard to create a real-time dashboard. What do you want to do? Just copy it. Copy
00:20the table data. This is the camera icon. When you click on the camera icon, you can capture this area.
00:35If you want to click on the same screen, you can also see the data here.
00:42If you want to see the other page, you can see the data on the other page.
00:49You can send it to the other page. What can you do? You can send it to the other page.
00:55Just like that, I want to add it to the other page. What do you want to do?
01:00Same thing. Click on camera one time. Click on camera one time.
01:09Click on camera. You can see the data on the other page.
01:19Now we can change it. If we change the original data, if we change the data by the time,
01:25specific copy data on the other page post, we will have a live update.
01:30Whatever it is, we want to change the data.
01:35So if you change the data we want to change the data, we can change the data in our own,
01:41If you change the data, we can actually change the data.
01:43a month. I would like to say, I would like to say, my month, I would like to change some
01:49of the time. It would be 65, and I would like to give the target audience to 80 and I
01:56would
01:56add a budget back to this list. So, I would like to give the budget back to this list.
02:12cares or to add Sum by के लिए देख लिए लेटें ुद्य देख다면
02:22और भी चेंज होगां लाप समें भी चेंज करने हैं यह तो बहु हमिने
02:28डेटा पे चेंज कर दो बहुत है वह चेंज हो, ऑफन लेते हैं कि छिए तरह लै कि
02:37this formula has been updated but if you are in the sheet where you can update your data from the
02:44original sheet
02:46so you will start updating your data from the original sheet
02:4980,000 and I changed my budget and I changed my followers
02:57the same thing we will check in the other sheet
02:59we will change the original thing
03:04if you can update it from the camera
03:09whatever the data will be updated
03:14regularly
03:15you can use the update
03:17copy paste
03:18this will not happen
03:20but the camera
03:23if you click the camera
03:25then you will update the data
03:28as it is
03:29when the original copy changes will be updated
03:34and how do you activate it
03:35you will need to go to the file
03:37option
03:39after the file option
03:41you will need to check
03:42the access tool bar
03:48you will need to check all commands
03:50all commands
03:55all commands
03:57you will see
03:58you will see
04:00commands
04:01you will see
04:03the camera icon
04:05you will see
04:08you will see
04:11you will see
04:13add
04:14add
04:15add
04:16add
04:16add
04:18add
04:25add
04:26add
04:28add
04:28add
04:29add
04:30add
04:30add
04:30like
04:30add
04:30add
04:30add
04:31add
04:31add
04:31add
Comments