Merge table in Power Query using “Between And”
#excelsnadno #joyfulbi #datasmartly #datalovers #powerquery #powerpivot
Merge table in Power Query using “Between And”
#excelsnadno #joyfulbi #datasmartly #datalovers #powerquery #powerpivot
Excel – Concatenate in one cell
BlogPost – Concatenate in one cell
#excelsnadno #joyfulbi #datasmartly #datalovers #powerquery
PowerQuery – Unify the same items
BlogPost – Unify the same items
#excelsnadno #joyfulbi #datasmartly #datalovers #powerquery
Free hot VBA (macros in Excel) workshop.
Free Participation (join here)
#excelsnadno #VBA #workshop #joyfulbi #datasmartly #datalovers
Second video about reporting using PowerTools is released on youtube and “Videos” page. The second video is about PowerQuery.
#excelsnadno #joyfulbi #datasmartly #datalovers
There is a new video about reporting using PowerTools on youtube and “Videos”. It is devided into 2 videos. The first video is about PowerQuery.
#excelsnadno #joyfulbi #datasmartly #datalovers
There is a new video about funtion TextJoin on youtube and “Videos”.
#excelsnadno #joyfulbi #datasmartly #datalovers
There is a new video about PowerQuery’s column from an example on our youtube and “Videos” page.
#excelsnadno #joyfulbi #datasmartly #datalovers
You can look forward to the upcoming workshop “VBA per day”, which was created in collaboration with JoyfulCraftsmen, s.r.o.
#excelsnadno #joyfulbi #datasmartly #datalovers