Useful Gyaan
http://usefulgyaan.wordpress.com/
Sharing Stuff to Make Life @Work Easier Mostly, but not limited to, MS Office is what we talk about.
This is the fb page of the blog "Useful Gyaan" that is meant to share useful tips and tricks (and tutorials) on applications that are used at work.
05/07/2015
Reverse Geocoding: Get Location Address from GPS coordinates(Latitude & Longitude) Reverse geocoding is the process of taking a set of GPS coordinates and turning it into the nearest available address. Browsing through the net, I found VBA code on many websites to get GPS coordin...
09/01/2015
Dynamically Highlight Data point on Your Chart Without VBA It’s no secret that I’m a big fan of beautiful data visualizations. What may not be so obvious is that I’m huge on the KISS (keep it simple stupid) principle when it comes to getting work done. I b...
12/11/2014
http://usefulgyaan.wordpress.com/2014/09/30/store-and-fetch-files-sql-server-tables/
Trick of the Week :: Store (and then fetch) files from SQL Server tables Problem Statement: I have a database of employees where I store information about each person. I wish to have a picture of the employee in my database that I want to retrieve when I select an emplo...
12/11/2014
http://usefulgyaan.wordpress.com/2014/11/11/hide-rows-with-no-data/
Did You Know :: How to Hide Rows With No Data We have earlier discussed how to hide errors in a worksheet in this post. Today I'm going address another similar problem that is very commonly faced. There are various ways to tackle it and there ...