How To Easily Copy Excel Sheet Table With Rows And Column Headings In Word Document?

Here is a short video tutorial on how to easily copy Excel sheet table with rows and columns in word document.

If you have any further query or any other problem related to word and excel spreadsheet please feel free to drop your question in comment section.

Get Microsoft Office 365 For Free

Yes, you can download Microsoft Office 365 absolutely for free. But catch is, only if you are a student or lecturer and have email ID which ends with EDU, say [email protected] or [email protected]

But wait, even if you don’t have student email address then you can get one for free from here>>

Once you get the student email ID follow following steps to get free Microsoft Office 365.

Step 1:  Check your eligibility

Get Microsoft Office 365 For Free 1

– Visit https://products.office.com/student

– Click Find out if you’re eligible

– Enter your school email address to check your eligibility.

Step 2:  Sign Up

– You’ll get an email with a link to sign up.

– Complete the simple signup process.

Step 3:  Download & Install

Get Microsoft Office 365 For Free 2

– Sign in with your new account at portal.office.com.

– Click install at bottom.

– In new page, Scroll down and again click on install button.

– A Setup Installer file will be downloaded.

– Click the setup file and follow simple process to install the Office 365.

Enjoy 🙂

 

Watch Youtube Videos without Buffering – Youtube Offline

Now you can watch as much video as you want on Youtube and that too without buffering. Doesn’t seem true? Yeah it is. Youtube very recently came up with Youtube offline feature where you can load the video when you have good internet connection (wifi) and watch it later. The video will remain there for few days and will be discarded from the offline list automatically you have don’t connect to internet. Only one stuff to remember, this one works only on Mobile for the time being.

Watch out this demo video by Youtube India

 

So the process is like this

  1. Get a wifi connection first
  2. Go to the Youtube video which you want to watch
  3. Now click on the download image and your video will be added offline

Youtube-offline

 

 

 

 

 

 

 

 

That’s all. Now you can go to your Youtube app later and watch the Video offline even if you don’t have an internet connection. To find this video open Youtube app, go to menu on the left bar and go to offline.

This is amazing, right?

How to Silent Whatsapp Group

Now a days Whatsapp has become the hub for all sorts of chatting, be it among school chatting, business chatting or whatever. So people keep adding their friends, colleagues, relatives randomly. Sometimes it becomes annoying when whatsapp keeps singing for every single update on the group and if the group is really big, it can be a terrible pain. But there’s an option to silent whatsapp group, read below

  1. Go to the group
  2. Touch the three vertical dots
  3. Touch Mute
  4. You can mute it starting from 8 hours to as long as 1 year
  5. You can also opt out from getting notification and once you visit the group, then only you will be able to see all new updates
  6. If the group is open already, it will still make the notification sound, don’t get confused, it won’t once you close the group.

Its pretty easy, right?

 

Image source: www.itprobs.com

Private Auto Sharing Problem on Google+

We have a very active and big Google+ page where we engage our users. Earlier we used to post there manually but recently we have started auto sharing because of less bandwidth and suddenly we noticed a huge decline in engagement. We were wondering what could be the probable reason when I suddenly found out all these posts are shared privately.

The problem is when you connect a Google+ page to our website for auto posting, Google+ automatically sets the circle as private and you keep wondering why on the earth every time you publish on your blog it gets shared privately.

Basically you can not do anything about this on the website, you might end up checking every feature on WordPress, all settings of your plug in but the problem actually lies in your Google+ page. So this is how you solve the problem

  1. Go to your Google+ page
  2. Go to settings
  3. Scroll down and click on Manage Apps & Activities
  4.  Click on Google Tab
  5. Click where Private is written and change that to Public
  6. Save

That’s all. Now whatever you publish on your blog, it will straight go to your G+ users, publicly 🙂

 

Image courtesy: www.wpsquare.com

How to insert a Word Doc within a Word Doc

Many a times we need to add a word doc within another word doc for reference. This is how it is done.

Click on Insert:

Untitled

On your right side display, click for a dropdown in “Object”, select “Object…”

Untitled

Now take care of the following in the next pop up:

*There will be two tabs, “Create New” and “Create from File”, select “Create From File”
*Browse and upload the doc you want to add for reference
*Tick on “Display as Icon”

Untitled

And you have your doc within a doc

Untitled

How To Share Photos With Selected People In Instagram?

If you love to capture the world through the lens of your camera, then you definitely be an avid Instagram user. With its amazing user interface, the app is just a delight to use. Not forgetting to mention, the filters it has which allows you to transform your image, giving it an artsy look. While you do love to share your travel, food, and other life adventures in instagram, it’s accessible for everyone to view. However, there can be moments when you want to share your pics with a selected few, Instagram just has the solution for you.

How To Share Photos With Selected People In Instagram?

1] Capture your image and run your artistic magic wand. 2] To share it with a selected few, click on ‘Direct’. 3] Now select the users from your friends list or include any username, with whom you want to share the image. Sharing photos with selected instagram users That’s it and you’re game. Now share your private-life moments with the selected few and don’t worry about it being accessible to the whole world. If you’ve been using Instagram for a while, had you ever noticed the ‘Direct’ feature? Follow me @ankurmans

How To Convert CR2 Image File To JPEG?

I was recently going through the pictures of my photoshoot and wanted to email a few of them as attachment.

While a 25 MB CR2 (Canon Raw) image attachment was out of the question, my brain immediately told me to convert it into a JPEG and then attach the compressed version.

The only problem???

Neither, Windows Photo Manager nor Adobe Photoshop 7 (Yes, I’m old school) would open it.

I found a lot of online converters but I ain’t no Creative Commons material.

A wise man said,

  Do What You Can With What You Have!

By default, I was left with Windows Live Photo Gallery to browse my CR2 file images.

Thus, I decided to find a way to convert the CR2 image file to JPEG using what I had.

A little digging around the Microsoft forums and I found the codec pack that would do the job.

How To Convert CR2 Image File To JPEG?

1] Download and install this Microsoft Camera Codec Pack (6.3.9721.0).

Psst…. The above link is tried and tested by us!

2] Open your CR2 image file using Windows Live Photo Gallery and click on Edit, Organize or Share.

3] Double Click and open your image file once again inside the editing tool.

4] Click on ‘Make a Copy’ and when it asks you to save the file, save it as .JPG format.

This is the simplest way to convert your CR2 image file to jpg or other low sized versions.

I’m pretty sure, this wouldn’t be a big issue for photographers but for a layman with minimal specs desktop or laptop setup, you can’t go wrong with the above steps.

Let us know if this was helpful to you in the comments section.

Cheers!

(Image source: t3.com

How To Share Map With Your Friend?

It might be the most common problem we have come across. Often we find it difficult to make our friends understand our locations or the location of meeting and we end up sharing some stupid map images, scanned images or depend completely upon landmarks and localities. Enough is enough, this can’t be the way.

Ever wondered how would that be if you can share map, location with your friend online, that too you can direct on the map, update the map online and your friend is updated at the same time, will not that be amazing?

Thanks to Google, now we have a solution to share map.

How To Share Map With Your Friend?

  1. Go to drive.google.com.
  2. Click on New>>More>>Google My Maps.
  3. Add a marker where you want to meet.
  4. You can add direction to this mark.
  5. You can add multiple layers if you have multiple purpose.
  6. You can also measure online the actual distance.
  7. You can also draw line manually to highlight the road if direction isn’t working for you.
  8. Once you are done, you can share the map with your friend, all you need to do is to share the map with your friend’s email id, you can share this with as many friends as you want, perfect for a hangout.
  9. You can edit the map online, so change of plan? No problem, just edit this.

Hope this saves some time of yours 🙂

Image Source: deviantart

Claim Your 100GB Of Free Cloud Storage In OneDrive Right Now

The cloud storage war seems to have heated up between Microsoft and Dropbox this time. The Seattle based company is giving away 100GB of free cloud storage in OneDrive for all Dropbox users.

Yes, if you have a Dropbox account, then you are eligible for 100GB of free cloud storage in OneDrive.

I’ve made this simple for you. Just follow these steps and get rewarded with 100GB of free cloud storage. Instantly!!!

Steps To Claim Your 100GB Of Free Cloud Storage In OneDrive:

1] Go to this Microsoft link

Microsoft OneDrive Free 100 GB storage invitation

 

2] Click ‘Verify and get my storage’. You will be asked to login to your Windows Live account. Login with your correct live credentials and then give permission to the OneDrive app to access your account.

Login to your live account

3] Save the file to your Dropbox account. After you allow the OneDrive app to access your account, it’ll prompt you to login to your Dropbox account. And then, it’ll requests you to save a file to your dropbox account.

100 GB free OneDrive storage success

 

4] Pat yourself on the back. If you didn’t skip any of the steps above, you now have 100GB of free cloud storage in OneDrive.

Free 100 gb storage in Dropbox

You can login to your onedrive account and confirm your extra free storage. The 100 GB of free storage is available for one year, listed as “Enthusiast bonus”.

100 GB Free storage in OneDrive for dropbox users

 

Enjoy the extra 100GB of cloud storage. Make the best of it; take backups, save your high-def photographs.

Isn’t this cool? So why won’t you share this with your friends.

Psst… What do you use your cloud storage for? Comment below.

How To ‘EASILY and QUICKLY’ Take Screenshots With Samsung Galaxy S4 Or Any Other Similar Android Phone

how-to-take-screenshot-in-samsung-android-phone-galaxy-s4Hey there, this is a quick post on how to take screenshots with Samsung Galaxy S4 or any other similar kind of Android phone like S3 and S5.

In post title, I have put ‘EASILY and QUICKLY’ in uppercase, and there is a good reason for that. I recently shifted from iPhone to Android phone and it took me a while to figure out “How to easily and quickly take screenshots’.

In iPhone, it is damn simple, with just one gentle press of power button (or hold button) and home button we can take screenshots. But in Samsung, I tried pressing standby button (or power button) and home button together, but every time either home button gets pressed earlier or standby button.

Also, with thick protective cover on phone, taking screenshot become even more difficult. Then with lots of trial, I learnt the trick.

How To ‘EASILY and QUICKLY’ Take Screenshots With Samsung Galaxy S4 Or Any Other Similar Android Phone?

To take screenshot easily and quickly all you have to do is following steps –

  1. Open the screen that you want to capture.
  2. Press standby button and home button together.
  3. Then keep HOLDING both the buttons till you get your screenshot.

HOLDING for a while is the trick, which no one told me.

Probably, you already knew this trick but as a iPhone user, it took me a while to learn it, so I thought I should share with you just-in-case if you struggle.

There are other ways like swiping with gesture but I prefer this method over that.

Image Credits: Samsung/Galaxy S4

How to open a CSV file if you don’t have MS Excel installed?

When I joined my new company, I was given a Mac and was asked to do all my works with that. That Mac didn’t have MS office and it was not allowed to install as well. So I was finding it very difficult since I had to deal with MS excel and CSV files.

Ultimately I found the solution of my problem, I am sure its a common problem for many people and therefore I would like to share it.

How to open a CSV file if you don’t have MS Excel installed?

It involves two easy steps:

  1. Upload on Google drive
  2. Once uploaded, open it with Google spreadsheet

Upload on Google drive

– Go to drive.google.com and click on New, then select upload files option and choose your CSV file to upload.

– Open it with Google spreadsheet

– Once the upload is complete, just click on the file and it will open in a Google spreadsheet and Yay… you are all set to go.

Important: Just remember one thing, once you have uploaded the file, try to rename it, else later you might not be able to find it. So either rename it to something which you can remember, or add the link to any other spreadsheet, or add it to any folder which you remember.

Still confused? Watch this video.