Lets learn something new, something useful.

How to check if word document has tables using C# and VB

The Office Interop object in .Net has features that can be used to access Ms-Office objects like Excel, Word etc. In this article I am going to show you how to check if an "Ms-Word" document has a table and if yes, then does the table has columns.

What is the formula in Excel to count how many times a particular word occured in a range?

You can use the COUNTIF() function in Excel to count number of occurrences of a particular word in a range.

Let us assume, I have a list of different types of birds in the 2nd column in my Excel worksheet. I want to know how many times a bird of type "Dove" or "Sparrow" is entered in the list. Check the formula.

How to open and read contents of a text file in Python

Python offer two built-in methods that you can use to read contents in a text file. The methods are read() and readline(). Python can handle different types of files like a .txt file, a csv file or Excel worksheets etc. But in this article I am going to show you how to "open" a .txt file in Python and read its content as it is.

Excel formula to remove first four characters

Let us assume, I have some data in my Excel worksheet. From one particular column, I want to extract values after removing the first four characters. I am going to show you three different formulas using three Excel built-in functions to do this.

Excel formula to filter out four letter words

I have shared two simple formulas in this article showing how to "filter out" four letter words in Excel.

You can use a combination of Excel's built-in functions to achive this. Though, the formula is for four letter words, you can extract "n-letters" (any number of letters) word from a cell.

How to create AI images using Bing AI

Have you ever wondered about creating 3D images instantly for your websites? You can find tons of images on the internet today. However, not every image that you come across on the web is "free". Sometimes it takes hours of searching to find what you are looking. Now, you can create your own images in few seconds, by simply typing what's in your mind. Here in this post I am going to show you how to create 3D images for free using Bing AI Image Creator.

How to use RegEx in Excel to filter out email addresses from Cell

Microsoft has recently announced new REGEX functions in Excel. It is still a Beta version and is available only for some Microsoft insiders (Microsoft Community) . The functions will soon be available in Office 365.

However, you can you can create a custom RegEx function using VBA. I'll show you how.

How to use HtmlAgilityPack in Asp.Net?

I am sure you might have come across the term Web Scraping. Ok, web scraping, also known as Screen Scraping is a process of extracting information from a web page. Information such as "title", meta descriptions, "images" etc. In this tutorial I am going to show you how to web scrape or extract data from a website automatically using HtmlAgilityPack library in Asp.Net using C# and Vb. Also I'll explain with examples what is HtmlAgilityPack used for?

Get real-time data (stock quote) from Website in Excel using VBA Macro

Shared a simple VBA macro here that shows how to get or extract live (real-time) data from a website in Excel. This code (macro) will get real-time stock quotes from a website. The macro does not use "Internet Explorer" to web-scrape the website. It shows a different teqnique and a different approach.

How to Convert Excel data into JSON format using JavaScript

Not using an API or a library. Sharing a simple JS code that will convert Excel data into JSON format. It has limitation. However, its useful in some cases. All you have to do is, copy Excel data and paste it in a box and the script will automatically convert the data into JSON format.