How to create a Google Account without Gmail

By following these steps, you will be able to open a free Google Account without the need to create a Gmail account. You will be able to choose your own non-Google email address. Once you have created your account, other people who use the Google environment can share Google Drive documents, Google Docs, Google Sheets […]

Read More

How to merge Excel sheets into one combined with VBA code

The following VBA code can help you to get data from all worksheets of active workbook together into a new single worksheet. At the same time, all of the worksheets must have the same field structure, same column headings and same column order. Please do as follows: 1. Hold down the ALT + F11 keys, […]

Read More

Conditional Formatting in Google Sheets

Conditional Formatting allows you to do things like painting a row in Google Sheets based on the input of one of the cells on that row. I use it a lot to color track when tasks are done for example. For example: To use it just select the whole working area and choose “Conditional Formatting”, […]

Read More

How to split the date from the time in Google Sheets

Split the date Let’s start from the following document which traces the data recording every second. We want to split the date and time in order to put the date in column B and time in column C.       To accomplish this separation, we must keep in mind that the value of 1 […]

Read More

How to forward and delete emails on CPanel

Some mail servers give you the possibility to configure to forward all the emails you receive on an email account to another account and delete them afterwards, they offer this directly with one click. CPanel unfortunately doesn’t have this option as easy. You can create a forwarder or you can create a full email account. […]

Read More

How to see your iPhone or iPad screen on your Mac for free

Sometimes we wish we could visualize the screen of our iPhone or iPad on our Mac without using a third party tool like Reflector from Squirrels for example. You could want this because you need to build up a tutorial or explain something by showing the actual actions on the device and maybe post it on […]

Read More

Zebra style on Google Sheets with conditional formating

Microsoft Excel and other programs in Microsoft Office provide a handy feature called “Quick Styles” to help you quickly format a selected range as a striped table. The table can have zebra lines meaning alternating rows are formatted with different colors. Google Sheets do not support zebra stripes (yet) but you can use conditional formatting […]

Read More

How to fix Snagit to correctly paste images in Google Mail

Sometimes you want to paste a captured image with Snagit into a Gmail new mail and you just see an empty box instead of the image. The problem is the depth of the image captured by Snagit, and here is how to fix it. For existing images you already captured you can do the following […]

Read More