Add Observer Currency with airSlate SignNow

Total To Be Charged US$ Euro (please Specify Currency) - Sdbonline Form

hi there hope you all are find there this is MJ today I will show you how to add real-time currency converter in Microsoft Excel so I'm going to explain very easy and I will show you the easy method so don't be confused and be patience and watch this video till the end so let's start first open your browser and open the google and type exits and go through the first link and here you are select your preferred currency like dollar or Euros I will take dollar ok so after this click on rates table ok then it's finished now wait table is a bit now come to Excel open the sheet ok in the sheet click on data and now check from web click on from web ok so as you can see here with one new web open now go to your Chrome or whatever browser using copy the URL don't be confused it's very simple now move to excel and here just where's the URL and click on cope okay we go to the table here as you can see arrow mark is showing so you can import this table to excel so dollar table here so click here and now click on so as you can see here is selected click on import click OK wait for one or two seconds to load data as you can see you so data is loaded now the other main thing is now I want to convert dollar in to euros in real time so this is a dollar and this is the zero and I will take total column okay so be patient I will finish this video very soon so three dollar and the real-time currency type is equal to so here is the zero select a row and hit enter that's it as you can see here the same currency is appear here and now do the multiply our product here like is equal to product sign and select this column or row and hit enter so now is a total but the main thing is the currency change day by day or every second every minute so how to know the exactly currency change when when what the time so for this I have easy solution here you can see the connections click here and then click on refresh I use one of the best way to do this so these are manual click on refresh ok so it's a refresh now okay look at that exchange now as you can see the currency is change and the same thing is applied here because we have linked the formula here when you change the currency it will appear and it will ultimately item delete product your total amount or if you want to set the particular refresh time click the connection and now click on properties here you can type refresh every 1 minute or 60 minutes or 30 minutes okay or if you want reflux data when you opening the file if you want your refresh data after every time you open the file you can take this also or you can do manual either should so okay if a daughter or refers the amount this one take any one as per you are convenient click OK I will text ready set the akhator of 10 minutes 30 more standard whatever ok click OK and close this that's it and now if you want you can hire this look at thus had this okay it's a Marge so after this had a spur on it just is equal to and type is equal to move the cursor and hit enter so formula will apply here and select your column and press control D here and same thing will apply not to the like this and you can type whatever currency or you want you can use any currency like zero yapanese chinese indian rupees whatever so offices do the same thing here like control d and it will automatically calculate you are all currency in real time yeah so when you fresh when you click the connection and refresh it will connect to the net and take the real time currency as you can see your real time currency boom that's it exchange now look at that so this is a way to convert currency in real time in excel sheet so i hope it will help you at time for watching seen next video and please don't forget like comment and subscribe thanks very much