Posts in Tips & Tricks

Gmail Tip: How to delete emails in Gmail in bulk

Gmail is one of the most prominent and widely used email service in the world. This is manifested by several millions of users enjoying Gmail as an email service, both free and paid accounts. One of the factors why people pick Gmail is its huge email storage. Free Gmail accounts come with 15Gig of email storage. Because of this huge storage capacity of Gmail, one is tempted to store several thousands of emails accumulating over time. However, when your email count reaches like 25,000 messages or threads,  you might consider… Read More

Getting Better and Faster: Using Keyboard Shortcuts in Hotmail (Outlook.com)

If you are doing emails every day, like in your work or home office, you might need to be familiar with various ways to use your email better and faster. If you are using Hotmail (Outlook.com) and you send and receive emails using your web browser, you can use keyboard shortcuts. Using keyboard shortcuts, you can save a huge amount of time. You can perform tasks that used to be done with several mouse clicks by just pressing a key combination in your keyboard. Set Your Preferred Shortcut Settings In… Read More

Get Microsoft Windows 10 as a FREE upgrade!

The leading Operating System company – Microsoft – announced Wednesday, that it will offer free upgrades to its newest Windows version, called Windows 10. The upgrade will be first implemented or made available for Windows 8.1 users. The second wave of upgrade will be for the Windows 7 users. According to Terry Myerson, Vice President for Operating Systems of Microsoft Corporation, the company will offer the free upgrade of any devices running Windows 8/8/1 to the latest stable release of Windows 10. This is only available for the first year that… Read More

Free tools to test the speed and response time of your website

Do you have a live website or are you maintaining one? It is indeed exciting to see your website launched live in the internet for all the people to see. It is the product of creativity combined with passion in the things that you want to share with the world. But how do you keep your website fast in serving the pages that your visitors requested? For website designers and developers, keeping the health of your site is a top priority to say the least. One of this website health… Read More

Free Tools to Compress and Optimize PNG files to Reduce Image Size

If you are managing a website, you might need to get acquainted with an image file type “PNG”. Portable Network Graphics (PNG) is a raster graphics file format that supports lossless data compression. PNG was created as an improved, non-patented replacement for Graphics Interchange Format (GIF), and is the most used lossless image compression format on the Web. List of Available Free PNG Optimization Tool for Windows There are several tools that are free that you can use to optimize the size of your PNG images to make a faster-loading… Read More

Free Software to Find What Files and Folders are Taking Up Hard Drive Space

As you are using your computer, it is either writing data or removing data from your hard disk drive. When you are writing more data to your computer hard drive, it is taking up some disk space in it. Depending on the size of files are you are storing up in your computer drive, there will come a time that you will run out of space. And what happens then? If you run out of space: What can you do then? The first best thing to do in this case… Read More

Microsoft Excel: How to apply conditional formatting to a cell based on values of another cells or range?

There are times in our spread sheet that we need to format the cells or cell range based on certain conditions. These conditions however pertain to the contents of the cells that you are to format. This is when Conditional Formatting is very useful. For instance, format the cell range G5:G50 if the values in the individual cells is less than 70%. If you are a teacher calculating the students grade in Excel and you want to automatically color the final grade with dark red if they are faling grades, like below… Read More

Microsoft Excel: The imaginary cell borders are gone. How to show them back?

We are used to seeing cells in MS Excel with a light gray borders. These are called “grid lines”. They are just there as a default behavior of MS Excel to provide visual boundaries among cells. These grid lines are NOT actually being printed by default, they are just visual aide to users to visually see the boundaries between cells. When your Excel settings are messed up and you end up with just a plain white worksheets without those cell boundaries or grid lines, here are the steps to show… Read More

Microsoft Excel: How to Send Excel Workbook as Email Attachment

If you are using MS Excel 2007, 2010 or the newer versions from the date of this writing, now you can send your Excel file as an email attachment using the commands found in Excel menus. This is the “Send As Attachment” command in Excel 2010. What this menu command does is actually simple. When you open your workbook in Excel and this workbook is intended to be sent to someone through email, you can click on the Send As Attachment button and then Excel will invoke or launch your… Read More

Microsoft Excel Power Shortcuts: Converting cell formulas to values

Microsoft Excel 2010, like its older version (2003 or 2007) are packed with huge sets of features and shortcuts waiting to be uncovered. In this article, we will discover how to copy the values of a cell excluding the formulas. Normally, when you copy the cells containing a formula, the formula is copied automatically and the cell references are updated dynamically. This is a very essential feature of Excel. Since the formula is being copied and the cell references in the formula are updated, the cells will then show up… Read More