A chart is a visual representative of data in both columns and rows. Charts are usually used to analyse trends and patterns in data sets. Let’s say you have been recording the sales figures in Excel for the past three Continue Reading..
Vlookup (V stands for ‘Vertical’) is an in-built function in excel which allows establishing a relationship between different columns of excel. In other words, it allows you to find (look up) a value from one column of data and returns Continue Reading..
There are many blogs covering this particular topic on internet but there are very few blogs available that actually will help when you are stuck with these 2 errors. I recently had a very tough time fixing these errors, hence Continue Reading..
Microsoft Excel is a very powerful tool, using excel we can connect to all most all known data sources available and create a report easily. In this post, we will learn how to connect to a SQL Server database from Continue Reading..