Uploaded June 2020 | Updated November 2026, 2 days ago
StockHistory is a newly released function that will grab the historical stock information & currencies.
--------------------------------------------------------------
⬇️Download Sample File
https://1drv.ms/x/s!AhCxCSOesgK6hB05lhy8g4zZP0dT?e=FgcfyL
excelexciting.com/excel-stockhistory-function
--------------------------------------------------------------
🗳Vote STOCKHISTORY Function properties fields to accept the string values
excel.uservoice.com/forums/304921-excel-for-windows-desktop-application/suggestions/40652983-stockhistory-function-properties-fields-to-accept
--------------------------------------------------------------
🛒 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
--------------------------------------------------------------
👍🏻Faraz Shaikh - Excel Master
facebook.com/ExcelExciting
👥Join The Facebook Group -
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
Un-Stack Data classic way using Excel Online & Excel Mac | Two Solution
youtu.be/UvrxmOrr8AQ
--------------------------------------------------------------
Extract Number & Text from a Cell in Excel | Solution 02 by Power Query
youtu.be/iei5rMstlJ0
--------------------------------------------------------------
Two Best Excel Tricks by Excel Experts
youtu.be/ihVtnUDTCBM
--------------------------------------------------------------
XLOOKUP Get the lowest value Column Name in Excel
youtu.be/Cbu2ZlvVfXs
***********************************************************
#Excel #BUSY #BLOCKED #FarazShaikh #ExcelExciting #MicrosoftCreators #ExcelTips #ProductivityHack #MadeWithCamtasia #ExcelForMac #ExcelForWindows #ExcelTricks
StockHistory is a newly released function that will grab the historical stock information & currencies.
--------------------------------------------------------------
⬇️Download Sample File
https://1drv.ms/x/s!AhCxCSOesgK6hB05lhy8g4zZP0dT?e=FgcfyL
excelexciting.com/excel-stockhistory-function
--------------------------------------------------------------
🗳Vote STOCKHISTORY Function properties fields to accept the string values
excel.uservoice.com/forums/304921-excel-for-windows-desktop-application/suggestions/40652983-stockhistory-function-properties-fields-to-accept
--------------------------------------------------------------
🛒 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
--------------------------------------------------------------
👍🏻Faraz Shaikh - Excel Master
facebook.com/ExcelExciting
👥Join The Facebook Group -
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
Un-Stack Data classic way using Excel Online & Excel Mac | Two Solution
youtu.be/UvrxmOrr8AQ
--------------------------------------------------------------
Extract Number & Text from a Cell in Excel | Solution 02 by Power Query
youtu.be/iei5rMstlJ0
--------------------------------------------------------------
Two Best Excel Tricks by Excel Experts
youtu.be/ihVtnUDTCBM
--------------------------------------------------------------
XLOOKUP Get the lowest value Column Name in Excel
youtu.be/Cbu2ZlvVfXs
***********************************************************
#Excel #BUSY #BLOCKED #FarazShaikh #ExcelExciting #MicrosoftCreators #ExcelTips #ProductivityHack #MadeWithCamtasia #ExcelForMac #ExcelForWindows #ExcelTricks

![Trick to Create A Data Entry Table In Power Query for Excel
A simple technique to create a data entry table inside a power query for excel.
Copy Code: https://excelexciting.com/simple-trick-to-create-a-data-entry-table-in-excel-power-query/
Resources: https://excelexciting.com/resources/
🛒 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/
***********************************************************
DISCLAIMER: 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 to Refresh Your Excel Power Query for Office 365 Mac 🖥 (Apple) | Phase 1
https://youtu.be/1VRrPPkMGs8
***********************************************************
#Excel #FarazShaikh #ExcelExciting #MicrosoftCreators #PowerQuery #PowerBI #ExcelTips #ProductivityHack #MadeWithCamtasia #ExcelForMac #ExcelForWindows #ExcelTricks Trick to Create A Data Entry Table In Power Query for Excel](https://i.ytimg.com/vi/bHPrRbcw6f0/mqdefault.jpg)
![Lookup last matching value in the column (Excel - Mac & Windows)
In this video, we will learn how to VLOOKUP the last record or lookup the last matching value in a column. In order to achieve the last record value, we will build a complex formula that will return our desired result.
⏱ Time Stamp
00:00 Intro
00:16 Understanding Dataset
00:40 Building the solution
03:40 Wrapping the solution in one cell
05:29 End
🛒 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/
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
VLOOKUP Data From Multiple Worksheets [Excel for mac & windows]
https://youtu.be/ROym3e-S4OQ
Trick to Create A Data Entry Table In Power Query for Excel
https://youtu.be/bHPrRbcw6f0
Change Multiple Value using Array Method [Excel for Mac & Windows]
https://youtu.be/c8d3xx8KVl8
Extract Number & Text from a Cell in Excel | Solution 02 by Power Query
https://youtu.be/iei5rMstlJ0
***********************************************************
#Excel #FarazShaikh #ExcelExciting #MicrosoftCreators #ExcelTips #ProductivityHack #MadeWithCamtasia #ExcelForMac #ExcelForWindows #ExcelTricks Lookup last matching value in the column (Excel - Mac & Windows)](https://i.ytimg.com/vi/bh9ELJflc_Y/mqdefault.jpg)


![Excel Trick# 6 - Convert Numbers to Percentage [Part 02] - #Shorts #exceltricks #exceltips #excel
In this video, we will learn how to convert numbers to percentage values in Microsoft Excel
🛒 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/
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/
***********************************************************
#Excel #FarazShaikh #ExcelExciting #MicrosoftCreators #ExcelTips #ProductivityHack #MadeWithCamtasia #ExcelForMac #ExcelForWindows #ExcelTricks Excel Trick# 6 - Convert Numbers to Percentage [Part 02] - #Shorts #exceltricks #exceltips #excel](https://i.ytimg.com/vi/c1qa3yeyRts/mqdefault.jpg)
![Change Multiple Value using Array Method [Excel for Mac & Windows]
This was an interesting question asked by one of our subscribers, How to change the scores in our data set without changing the data.
🛒 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/
***********************************************************
DISCLAIMER: 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 on particular subject for viewers in easy and fun way.
***********************************************************
You can check the following videos as well
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 02 by Power Query
https://youtu.be/iei5rMstlJ0
2 Different Formulas - Check Date is Leap Year in Excel (mac & windows)
https://youtu.be/8fjNF2iQel8
Two Best Excel Tricks by Excel Experts | https://youtu.be/ihVtnUDTCBM
***********************************************************
#FarazShaikh #ExcelExciting #MicrosoftCreators #ExcelTips #ProductivityHack #MadeWithCamtasia #ExcelForMac #ExcelForWindows #ExcelTricks Change Multiple Value using Array Method [Excel for Mac & Windows]](https://i.ytimg.com/vi/c8d3xx8KVl8/mqdefault.jpg)


![Easiest way to Unhide All Sheets with one line code [VBA MACRO]
In this video we will learn how to write simple code to unhide the sheet from the current workbook.
👍🏻 Like us on Facebook
https://www.facebook.com/ExcelExciting/
👥Join The Facebook Group -
https://www.facebook.com/groups/ExcelExciting/
***********************************************************
DISCLAIMER : 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 on particular subject for viewers in easy and fun way.
***********************************************************
You can check the following videos as well
🥇🥈🥉Top N Values | Easy Solution with NEW Dynamic Arrays (macOS & Windows)
https://youtu.be/DexVJUA-j8A
🔎Get The Missing Number from the list | Dynamic Arrays (macOS & Windows)
https://youtu.be/xtpHeszAC5M
🛠Convert All Sheets Data To Excel tables - macOS & Windows | VBA
https://youtu.be/T7KNkGSwZL4
***********************************************************
#UnhideAllSheets #FarazExcelMaster #ExcelTrick #MicrosoftCreators #ExcelTips #ProductivityHack #Camtasia #FarazShaikh Easiest way to Unhide All Sheets with one line code [VBA MACRO]](https://i.ytimg.com/vi/cs8T8gYltvI/mqdefault.jpg)
