Import specific range of Excel in Python
Hello friends! Today we’ll be learning how to import specific range of excel data in Python. Easy to follow code.
Read moreFilter till end of the month VBA
Hello friends! Today we’ll be learning how to filter for end of the month in VBA. Easy to follow steps. I have attached Excel file to used in this blog post.
Read moreDynamic Measure and Dimension in Power BI
Hello friends! Today we’ll be learning how to create dynamic measures and dimension using slicer. We’ll have a drop down select the drop down for dimension and measure. Easy to follow steps. I have attached Power BI file to used in this blog.
Read moreExtract URL from hyperlink using VBA
Hello friends!! We’ll be learning to extract the URL from hyperlink using VBA function.
Read moreRanking by groups using Power query in Power BI
Hello Friends, Today we’ll be learning how to create ranking by groups using Power query in Power BI. Easy and quick tutorial to follow. Power BI is attached used in the tutorial.
Read moreGet paid to write Technical Articles
Hello Friends, this blogpost will be different from other blog posts and there will be no tutorials but I’ll share the sources from which you can make money as technical writer. Some of the sites pay up to $1000 per article depending on the quality and views.
Read moreCreate prefilled form in Airtable
Hello friends!! Today we’ll be learning about the prefilled form in Airtable. Airtable is a spreadsheet-database hybrid, with the features of a database but applied to a spreadsheet. One of the important features is form view.
Read moreQuery function in Google Sheets
Hello friends!! Today we’ll be learning about the “Query” function in Google sheets. Query is one of powerful function in Google sheets. Combining with other functions makes it super helpful for the analysis.
Read more