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 […]
All posts by admin
How to know when a computer running Windows was last restarted and last installed
The following command will allow you to know how long has it been since the computer where you run this command has been restarted for the last time. Just open Start > Run and paste the following command: cmd /k systeminfo | find /i “Boot Time” If want you can also look at the up time […]
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, […]
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”, […]
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 […]
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. […]
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 […]
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 […]
Avoid “The Following functions are ON and cannot be used in the current environment application”
The following is a prompt you might receive probably with Minolta multifunction printers, here are simple steps to avoid having this prompt every time you want to print: 1) Start > Control Panel > Devices & Printers 2) Double click on the printer you are having the prompt with. 3) Go to “Printer” > “Properties”. 4) On the popup […]
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 […]