Dependent dropdown list in Excel
Hello friends! Today we’ll be learning create dependent drop down list in Excel. Excel sheet used in this tutorial is attached to this blogpost to download.
Read moreCategory: Excel
Optimize VBA codes
Hello friends! Today we’ll be learning ways to optimize VBA codes. VBA is a powerful tool for automating tasks in Excel, but poorly written code can be slow and inefficient. In this blog post, we’ll explore some tips and techniques for optimizing VBA code to improve performance and make your workflows more efficient.
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 moreExtract URL from hyperlink using VBA
Hello friends!! We’ll be learning to extract the URL from hyperlink using VBA function.
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 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 moreList of YouTube resources for Data Science learning path
Hello friends!! I have curated the list of YouTube tutorials(4-10 hours long) for data science learning path. The videos will surely help you to get started. I’ll suggest you to go through the videos of topics you want to learn. First time watch at 2x speed just movie to get the idea of the topics.
Read moreData science Learning Path
Hello friends!! I have created the learning path for data science tools. It covers almost all the topics to start with the tool and become comfortable in it. Check the data science learning path below.
Read more