Recently I was watching an Excel product review and noticed the author copied the derived values from a formula into another column. This was fine, but then he deleted the column with the formula. Sound familiar? In this tutorial, Ill show you two faster and easier ways to overwrite formulas with their values. (Includes video demo and sample spreadsheet.)
Cell phones are a fantastic convenience, but they come with unexpected surprises like unwanted phone calls. Maybe your cell phone number was recycled and belonged to someone else. Or, your number mistakenly appeared in some directory for a business. Regardless of the cause, solutions are popping up ranging from downloadable apps and 3rd party services that can help manage the experience.
Are you or your customers using devices other than your PC to get things done online? The advantage is that you can use many services from any internet connected device. The downside is when you need help. Sometimes trying to figure out what your cell phone or tablet is running can be a challenge. Fortunately, there is an online tool from Imulus that can help find important support details and share them.
After I left the corporate world, one hard thing for me was being efficient with my time. Like many professionals, I needed an appointment scheduling tool that allowed access to me, whether it was a 15 minute phone call or a 2 hour meeting with various parties. I needed some way that could replace the enterprise meeting planner, but without the cost.
Are you finding yourself in front of the PC too many hours at night or when it’s dark? Maybe you’re doing work or just catching up with friends. The problem is the bright light from the display may be impacting your sleep and causing eye strain. Fortunately, there is a free utility that minimizes this problem. The program is called f.lux and is from the same folks who brought you Google’s Picasa.
As the web has evolved, it seems like there are more reading distractions. Some websites are so aggressive at displaying ads; it’s hard to follow the article. In other cases, sites present articles in multiple pages to increase page views. And some sites use styles which are harder to read such as white text on dark backgrounds. Fortunately, there is a free browser add-on for Google Chrome and Firefox that solves these issues and more.
Ever feel you’re at an audio buffet table and you’ve loaded up on too much content? This recently happened to me with some audio courses and podcasts. I didn’t have enough time to hear all the lectures and conference calls. I needed to find a way to shorten the listening process. The solution was easier than I thought using the free sound editor and recorder called Audacity. (Includes ScreenSteps)
My bank started offering a useful email alert feature. The problem was Google's email filter kept flagging the alerts as spam. Typically, I find the spam filter in Gmail accurate, but in this case, it repeatedly failed. I thought clicking the Not Spam button or adding my bank to my contact list would add an entry to some whitelist. In these cases, the solution involved creating a simple email filter.
Have you noticed how much online video is on the web or available for download? At first, it was mainly online tutorials that I saw, but now we've got everything from full college courses to "how to" channels on YouTube. While there’s been an explosion of content, I’m still constrained by my time. I needed find a way to speed things up so I could watch more content in the same time. Below are several free and commercial tools that allow you to speed up your videos.