Ragavan Rajan

Author's details

Name: Ragavan Rajan
Date registered: October 25, 2013
URL: http://www.snatchExcel.com

Biography

I'm Ragavan Rajan - Lead Business Improvement, Innovation & Development, having professional experience in SharePoint 2010 / SharePoint 2013, Windows 7, Windows 8, One note, VB Script, Excel and VBA.

Latest posts

  1. Google Pixel Phones — October 5, 2016
  2. Google Allo-Competitor for Whatsapp? — September 26, 2016
  3. SharePoint CSOM- Turn off the formatted XML View — August 30, 2016
  4. Excel 2013 very slow — March 26, 2015
  5. “Cannot insert object” error in an ActiveX -Security Patch Issue — March 23, 2015

Most commented posts

  1. Excel 2013 very slow — 5 comments
  2. Formulas Not working when dragging down — 2 comments
  3. Real Life Fact!! — 1 comment
  4. OneNote Tips and Tricks#9: — 1 comment

Author's posts listings

Oct 05

Google Pixel Phones

The first phone made by Google – PIXEL.   This time, Google has manufactured his own hardware and released two phones namely PIXEL and PIXEL XL . The interesting thing is it comes with VR headset ( Virtual Reality). Differentiated primarily by the size and resolution of their screens — 5-inch 1080p display on the …

Continue reading »




Sep 26

Google Allo-Competitor for Whatsapp?

Google launched a new one this week called Allo. Google actually unveiled Allo (a messaging app) and Duo (a video calling app) at Google I/O in May, but just hours ago, Allo finally made its way to the App Store on iOS and Google Play on Android. “What’s the big deal?” you might ask. Google …

Continue reading »




Aug 30

SharePoint CSOM- Turn off the formatted XML View






Mar 26

Excel 2013 very slow

Affected users: Global Problem:  Excel 2013 is very slow When I copy and paste some data Excel is crashing and taking long time Excel performance is really slow if I filter any data on the cell Solution:- Task 1: Increase your virtual memory Open the control panel > on the right hand top corner >Select …

Continue reading »




Mar 23

“Cannot insert object” error in an ActiveX -Security Patch Issue

Affected Users: Global Problem:    You will get one of the Error in Excel   Object library invalid or contains references to object definitions that could not be found. Cannot insert object. Solution:-1   Please check your system whether you have Admin rights.  if not through following steps   Step1: Click the bottom of the right …

Continue reading »




Dec 09

Sharon Fruit

I had the best fruit in my life. I still remember the taste of Sharon Fruit. It was delicious.. Yummy !!! Please check out my Facebook Sharon Fruit page if you are also interested !!    Click here to view my FB page. Feel free to hit the like button 




Mar 11

Formulas Not working when dragging down

Excel Issues/ Problem #1: Issue: Formulas Not working when I drag it down: when I drag a formula from the cell on downwards, the numbers remain the same in all the pasted cells. When I double click on the individual formulas, it updates. Solution: Go to Formulas Menu -> calculation- change it to Automatic   …

Continue reading »




Mar 05

OneNote Tips and Tricks#9:

OneNote Tips and Tricks#9:  Take notes easily- using linked notes: OneNote allows you to take notes instantly while you are in live meeting or reading specific contents in the internet or using any of your office products. Solution:  1. Open OneNote > Review > Linked notes  > Start taking notes 2. The software icon will …

Continue reading »




Feb 26

#2:Compare two lists instantly

Excel Intermediate:  #2:Compare two lists instantly Solution:  1. Select  range in both lists  2. Go to Conditional Formatting > Highlight Cells Rules > Duplicate Values > OK  Play this trick immediately to do your quick comparison instantly  Benefits: No need to spend time in writing formulas /code Instant way Alternatively you can watch my below video …

Continue reading »




Feb 20

#1:Connect to Internet Explorer(IE) via VBA

VBA Intermediate:  #1:Connect to Internet Explorer(IE) via VBA Solution:  1. Using Late binding methodology create object of IE and make the visible property as true.  2. Then Navigate to your URL  Benefits:  Automate your day to day work Save your time Increase your productivity Alternatively you can watch my below video for better clarity  If …

Continue reading »




Older posts «