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
Category: 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.
Welcome...enjoy coding, Electronics, IOT or data mining? Thank you for visiting my blog. 