Tỷ giá ngoại tệ

Google Sheets – Tutorial 05 – Automatic Currency Conversion



Often you need to convert currencies, for instance to keep track of income or expenses, and it’s always a nuisance to update the latest exchange rates to keep your calculations up-to-date.

With Google Drive, you no longer need to change all your formulas.

In any cell of your Google Docs spreadsheet you can use the GoogleFinance function to pull in an exchange rate from real time data, so calculations are always up to date without having to look up the exchange rate.

Find all the Currency Codes here:

———–

As always if you found this helpful, subscribe today and find us on one of the following websites:

Flipped Classroom Tutorials Blog:
Flipped Classroom Tutorials Facebook Page:

Support the creation of these Tutorials on Patreon:

GEG West Bangkok Blog:
GEG West Bangkok Community:

Looking to create your own videos like this to ‘flip’ you class?
I use Techsmith Camtasia and Snagit and love it!
Get it Here with Educational pricing for Students and Educators(Affiliate Link):

Nguồn: https://mywifi.com.vn/doi-song

Xem thêm: https://mywifi.com.vn/doi-song/ty-gia-ngoai-te/

21 Bình luận

  1. Crypto Swen

    Thank you! You have saved me a lot of money and most important, TIME!

  2. Siddarth Bhat

    Thanks for the tip! Grateful

  3. Kiaracam

    Very helpful thanks for making it easy!

  4. Usman Saeed

    Thank you so much. It solved my problem

  5. Hussain Saifuddin Botad

    Great Explanation, Many Thanks

  6. Capa Publisher

    THANK YOU very much

  7. Tamara Ross

    Explanation is concise and easy to follow. However, I'm received the Error Message "When evaluating GOOGLEFINANCE, the query for the symbol: 'MXNUSD' returned no data." Is this a Google change in the formula that I'm missing?

  8. Yoanna Francisca

    Other people would explain it in a very complicated way. Yours is so simple and easy to understand. Thanks!!!!!

  9. Jia Ren

    Thanks, how about one column have various currency and I would like to formatting them the same currency in another column.

  10. Robin Mohan

    Very helpful! Thanks a lot!

  11. ailina63

    THANK YOU! 🙂

  12. Ladzio Banter

    =F3*GoogleFinance("CURRENCY:USDGBP") is giving me a "Circular Dependency Detected" error

  13. AlecWoldt

    thank you bro

  14. Srigovic

    very professional

  15. Markus M. Pollak

    Perfekt Thanks

  16. Jie Zhou

    Thank you!! Problem solved!

  17. N1n741

    Thank you, very useful

  18. The Aussie Bloke

    Legend. Thanks!
    And so easily explained !

  19. Nattaphan Wannasiri

    Thank you so much you just saved my life

  20. Jake Brumby

    Cut to the chase:

    =GOOGLEFINANCE("Currency:USDGBP")

Trả lời

Email của bạn sẽ không được hiển thị công khai. Các trường bắt buộc được đánh dấu *