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

CSOM SharePoint View

Tools> Internet options> Content >Feed settings > Un check Feed reading view     Note: You have to close the browser and start it again

Jan 22

INDEX – MATCH Formula’s Combination

INDEX – MATCH Formula’s Combination VLookup – Searching a value in the left-most column of table array and return value based on column index number.   Combined INDEX MATCH –   formulas work as a right to left lookup, whereas VLOOKUP only works left to right. We can use INDEX MATCH to lookup a value that is …

Continue reading »

Sep 22

VBA – Turn off Auto Filter

Turn off Auto Filter in Active sheet   If ActiveSheet.AutoFilterMode Then ActiveSheet.AutoFilterMode = False     Turn off Auto Filter in Table   If Sheet1.ListObjects(“Table1”).ShowAutoFilter = True Then              Sheet1.ListObjects(“Table1”).ShowAutoFilter = False      End If

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 »