Uploaded April 2021 | Updated November 2026, 3 days ago
In this video we will learn how to get the gold and silver price in real-time in Excel, there are many traditional ways to get using advanced VBA to extract gold, silver, or precious metal. But by using Excel Stock Data Types things got so easy.
00:00 Intro
00:15 Basic Requirement
01:00 Using Excel Data Type
02:50 Extracting Gold & Silver Price in Excel
04:44 Converting troy ounce to grams in Excel
05:44 Historical Gold & Silver prices
06:28 Handling the Error while extracting the prices
07:10 Validating with prices online
07:32 End
--------------------------------------------------------------
โฌ๏ธ Download Sample File Link
excelexciting.com/get-live-gold-silver-precious-metal-stock-prices-in-excel
--------------------------------------------------------------
๐ Affiliate links :
- Support me with your Amazon purchases: amzn.to/3tR4AUN
- Buy Office365: bit.ly/3nKcbnk
๐ฃ Disclosure: Affiliate links, which means there is no additional cost to you. I will receive a small commission if you make a purchase using the links. By doing so you're helping me keep my blog up and running and you're helping me provide for my family so for that I truly thank you for your support. Please only purchase the products if you believe they will add value to you.
--------------------------------------------------------------
๐ ExcelExciting.com
Connect to our forums feel free to ask queries & answer them
excelexciting.com/forums
--------------------------------------------------------------
Join our Meetup group Saudi Arabia, Microsoft Excel & PowerPlatform Meetup
meetup.com/saudi-arabia-microsoft-excel-power-platform-meetup
--------------------------------------------------------------
๐๐ป Like Facebook Page :
facebook.com/ExcelExciting
๐ฅJoin The Facebook Group -
facebook.com/groups/ExcelExciting
***********************************************************
You can check the following videos as well
Excel with 41Million+ Records & still why UK has Data Loss of COVID-19 Cases?
youtu.be/YVMTgZsRCGQ
Extract Multiple Matching Records
youtu.be/pTVxxaZQx24
Learn how to use Microsoft Flow / Power Automate
youtu.be/HQyxnPYW9Jc
Create Dynamics Flowcharts by connecting EXCEL to VISIO
youtu.be/xfIPFiAxQcQ
***********************************************************
#Excel #FarazShaikh #ExcelExciting #MicrosoftCreators #ExcelTips #ProductivityHack #MadeWithCamtasia #ExcelForMac #ExcelForWindows #ExcelTricks
In this video we will learn how to get the gold and silver price in real-time in Excel, there are many traditional ways to get using advanced VBA to extract gold, silver, or precious metal. But by using Excel Stock Data Types things got so easy.
00:00 Intro
00:15 Basic Requirement
01:00 Using Excel Data Type
02:50 Extracting Gold & Silver Price in Excel
04:44 Converting troy ounce to grams in Excel
05:44 Historical Gold & Silver prices
06:28 Handling the Error while extracting the prices
07:10 Validating with prices online
07:32 End
--------------------------------------------------------------
โฌ๏ธ Download Sample File Link
excelexciting.com/get-live-gold-silver-precious-metal-stock-prices-in-excel
--------------------------------------------------------------
๐ Affiliate links :
- Support me with your Amazon purchases: amzn.to/3tR4AUN
- Buy Office365: bit.ly/3nKcbnk
๐ฃ Disclosure: Affiliate links, which means there is no additional cost to you. I will receive a small commission if you make a purchase using the links. By doing so you're helping me keep my blog up and running and you're helping me provide for my family so for that I truly thank you for your support. Please only purchase the products if you believe they will add value to you.
--------------------------------------------------------------
๐ ExcelExciting.com
Connect to our forums feel free to ask queries & answer them
excelexciting.com/forums
--------------------------------------------------------------
Join our Meetup group Saudi Arabia, Microsoft Excel & PowerPlatform Meetup
meetup.com/saudi-arabia-microsoft-excel-power-platform-meetup
--------------------------------------------------------------
๐๐ป Like Facebook Page :
facebook.com/ExcelExciting
๐ฅJoin The Facebook Group -
facebook.com/groups/ExcelExciting
***********************************************************
You can check the following videos as well
Excel with 41Million+ Records & still why UK has Data Loss of COVID-19 Cases?
youtu.be/YVMTgZsRCGQ
Extract Multiple Matching Records
youtu.be/pTVxxaZQx24
Learn how to use Microsoft Flow / Power Automate
youtu.be/HQyxnPYW9Jc
Create Dynamics Flowcharts by connecting EXCEL to VISIO
youtu.be/xfIPFiAxQcQ
***********************************************************
#Excel #FarazShaikh #ExcelExciting #MicrosoftCreators #ExcelTips #ProductivityHack #MadeWithCamtasia #ExcelForMac #ExcelForWindows #ExcelTricks




![Hindi: VLOOKUP Data from Multiple Worksheets [Excel for mac & windows]
In this video we will learn simple technique how to VLOOKUP the data from the multiple worksheets in Excel for Mac & Windows
๐ Affiliate links :
- Support me with your Amazon purchases: https://amzn.to/3tR4AUN
- Buy Office365: https://bit.ly/3nKcbnk
๐ฃ Disclosure: Affiliate links, which means there is no additional cost to you. I will receive a small commission if you make a purchase using the links. By doing so youre helping me keep my blog up and running and youre helping me provide for my family so for that I truly thank you for your support. Please only purchase the products if you believe they will add value to you.
๐ https://www.ExcelExciting.com
Connect to our forums feel free to ask to queries & answer them
https://excelexciting.com/forums/
๐๐ปFaraz Shaikh - Excel Master
https://www.facebook.com/ExcelExciting/
๐ฅJoin The Facebook Group -
https://www.facebook.com/groups/ExcelExciting/
***********************************************************
DISCLAIMER: The Talking Emoji If any resemblance with any person, living or dead, is purely coincidental. There is absolutely no intention to hurt any person or group of persons or any section of society through this video. This video is created to impart my understanding of a particular subject for viewers in an easy and fun way.
***********************************************************
You can check the following videos as well
Change Multiple Value using Array Method [Excel for Mac & Windows]
https://youtu.be/c8d3xx8KVl8
Un-Stack Data classic way using Excel Online & Excel Mac | Two Solution
https://youtu.be/UvrxmOrr8AQ
Extract Number & Text from a Cell in Excel | Solution 01 by Power Query
https://youtu.be/GHQXgg2PR_k
How Refresh Your Excel Power Query for Office 365 Mac ๐ฅ (Apple) | Phase 1
https://youtu.be/1VRrPPkMGs8
***********************************************************
#Excel #FarazShaikh #ExcelExciting #MicrosoftCreators #ExcelTips #ProductivityHack #MadeWithCamtasia #ExcelForMac #ExcelForWindows #ExcelTricks Hindi: VLOOKUP Data from Multiple Worksheets [Excel for mac & windows]](https://i.ytimg.com/vi/BEskGbTgcis/mqdefault.jpg)


![Create Organizational & Business Flowcharts Linked to Excel (mac & windows)
In this video, we will create Organizational & Business Flowcharts Linked to Excel VISIO charts easily in Excel with the help of the add-in VISIO Data Visualizer and then transfer it VISIO application/web version.
VISIO Price Plan (Affiliate Link): https://microsoft.msafflnk.net/xWP31
๐ Affiliate links :
- Support me with your Amazon purchases: https://amzn.to/3tR4AUN
- Buy Office365: https://bit.ly/3nKcbnk
๐ฃ Disclosure: Affiliate links, which means there is no additional cost to you. I will receive a small commission if you make a purchase using the links. By doing so youre helping me keep my blog up and running and youre helping me provide for my family so for that I truly thank you for your support. Please only purchase the products if you believe they will add value to you.
๐ https://www.ExcelExciting.com
Connect to our forums feel free to ask queries & answer them
https://excelexciting.com/forums/
๐๐ปFaraz Shaikh - Excel Master
https://www.facebook.com/ExcelExciting/
๐ฅJoin The Facebook Group -
https://www.facebook.com/groups/ExcelExciting/
***********************************************************
You can check the following videos as well
NON-VBA Solution Convert Number to Words In Microsoft Word [mac & windows]
https://youtu.be/W1Ghyp6Rla0
Change Multiple Value using Array Method [Excel for Mac & Windows]
https://youtu.be/c8d3xx8KVl8
Extract Number & Text from a Cell in Excel | Solution 01 by Power Query
https://youtu.be/GHQXgg2PR_k
2 Different Formulas - Check Date is Leap Year in Excel (mac & windows)
https://youtu.be/8fjNF2iQel8
***********************************************************
#Visio #Excel #flowcharts #FarazShaikh #ExcelExciting #MicrosoftCreators #ExcelTips #ProductivityHack #MadeWithCamtasia #ExcelForMac #ExcelForWindows #ExcelTricks Create Organizational & Business Flowcharts Linked to Excel (mac & windows)](https://i.ytimg.com/vi/Cor1mixgotY/mqdefault.jpg)
![How to Calculate Hijri Age In Excel (mac & windows)
In this video, we will learn a simple way to calculate the Hijri / Arabic age in excel. This is an age calculator as per the Hijri calendar. The calendar is entirely based on the Moon lunation. Hijri calendar started after the migration of the Prophet Mohammed (PBUH ๏ทบ) from Makkah to Medina. Hijri calendar or Arabic calendar widely used in Islamic countries. It is also known as the Lunar calendar. It contains 12 Islamic months that are depending on the moonโs motion based on the monthly cycles of the Moonโs phases (synodic months or lunations)
โฑ Time Stamp
00:00 Intro
00:24 Basic Understanding Of Hijri Calendar
01:40 Calculate Number of days In Hijri Year
02:14 Calculate Age in the Gregorian / English calendar
02:53 Write Hijri Age Calculator
07:03 Copy Hijri Age Calculator Formula from website
09:10 Copy LAMBDA to calculate Hijri Age
11:04 End
๐ Affiliate links :
- Support me with your Amazon purchases: https://amzn.to/3tR4AUN
- Buy Office365: https://bit.ly/3nKcbnk
- Buy A Me Coffee - https://buymeacoffee.com/ExcelExciting
๐ฃ Disclosure: Affiliate links, which means there is no additional cost to you. I will receive a small commission if you make a purchase using the links. By doing so youre helping me keep my blog up and running and youre helping me provide for my family ๐จโ๐ฉโ๐งโ๐ฆ so for that I truly thank you for your support. Please only purchase the products if you believe they will add value to you.
https://excelexciting.com/how-to-calculate-hijri-age-in-excel/
https://www.timeanddate.com/astronomy/moon/lunar-month.html
๐ https://www.ExcelExciting.com
Connect to our forums feel free to ask queries & answer them
https://excelexciting.com/forums/
Join our Meetup group Saudi Arabia, Microsoft Excel & PowerPlatform Meetup
https://www.meetup.com/saudi-arabia-microsoft-excel-power-platform-meetup/
๐๐ป Like Facebook Page :
https://www.facebook.com/ExcelExciting/
๐ฅJoin The Facebook Group -
https://www.facebook.com/groups/ExcelExciting/
***********************************************************
You can check the following videos as well
Extract Number & Text from a Cell in Excel | Solution 01 by Power Query
https://youtu.be/GHQXgg2PR_k
Excel Tip by the Excel Queen ๐ธ๐ป(Faraz & Leila)
https://youtu.be/6CEYKRIlppE
The easiest way to Unhide All Sheets with one line code [VBA MACRO]
https://youtu.be/cs8T8gYltvI
Easiest Way to Make Dependent Dropdown List Using XLOOKUP
https://youtu.be/OYbusivTbN0
***********************************************************
#Excel #FarazShaikh #ExcelExciting #Hijri #ExcelFormulas #Lambda #MicrosoftCreators #ExcelTips #ProductivityHack #MadeWithCamtasia #ExcelForMac #ExcelForWindows #ExcelTricks How to Calculate Hijri Age In Excel (mac & windows)](https://i.ytimg.com/vi/Cs0MgpppuPA/mqdefault.jpg)

