Hi all, below is my YouTube video for using Excel and Power Query to fetch refreshable web data. This is useful for dashboarding and data
Tag: Excel
Pandas dataframe to Excel, retaining Excel sheet cells formatting
Hi, when we transfer a dataframe to an pre-formatted Excel sheet, there will be a common issue where the cell formatting of the Excel sheet
Clean data headers with Excel and Power Query
Hi, in this post, we are using Excel transpose function and Power Query to clean up our data headers to the format that we want.
Monte Carlo Simulation of 2 dices using Excel
Hi, this post is about using Excel to generate Monte Carlo Simulation of 2 dices. The video below shows the whole process including the generation
Welcome...enjoy coding, Electronics, IOT or data mining? Thank you for visiting my blog. 