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
Tag: Excel
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. 