Posts

VLOOKUP - Excel Function Everyone Should Know

Image
I usually post on this blog about different technologies, most of them web-based. It occurred to me however, that perhaps people would like to learn some cool functions they can use with Microsoft Excel. VLOOKUP is one of those Excel functions that can be sometimes overlooked but perhaps everyone should know about because it can save you a lot of time and can be very powerful when dealing with large data sets. What exactly is VLOOKUP? Basically, VLOOKUP lets you  search for specific information  in your spreadsheet. For example, if you have a list of players for a particular sports team and some basic information about them, you could search for the name of someone based on their number. To go along and work on the examples, please download the spreadsheet . In this first example, we are going to use VLOOKUP to find the name for number  88 . You can probably see that it is Jessica Chandler, but that's because this is a simple example. Once you learn how to use VLOOKUP, y

Square Cash (cash.me) - send cash to a person or a business in seconds

Image
Cash.me overview: Ever wondered how to easily transfer money from one account to another or how to transfer money to your friend or pay your child without having to go to the bank? What if I told you not only that you can transfer money using your cellphone but also that it is FREE and easy?! Yes, all of our dreams of being able to transfer money from one account to another seamlessly using our smartphones just became reality. Square Cash (cash.me) brought to us by Square offers the solution we have all been waiting for. It offers a solution for personal use (sending money between friends) and also for business purposes (getting paid for your consulting service). You may ask, how does it work? To learn more read below or visit cash.me or download the android or iPhone apps. Square Cash ( cash.me ) main page What is a $Cashtag? On the main website, you can learn more about square cash and most importantly, you can claim your $CASHTAG, which as you will learn in a moment is the

The Amazon Empire - Take advantage of these services for great content

Image
The FREE Kindle App (always free for life) There are several different ways to consume content amazon offers to its customers and one of the best options is using the  FREE Kindle app . This app can be used on your PC, a smartphone (various operating systems), a tablet and creates an opportunity for you to read eBooks on any device without having to own an  eReader such as Amazon Kindle  itself.  Download FREE Kindle app What does the FREE Kindle app offer? The ability to read Kindle books with no Kindle device so that you can take advantage of the often much cheeper kindle versions of books (some are even free) compared to the print versions and also so that you can read them from any of your devices. Access to any and all of your kindle books in the library at any time so that you can stop reading and start reading any time you are free. The kindle app using Whispersync technology is actually capable of syncing the furthest page read, your notes and bookmarks across

Acorns - Turn small investments into big gains

Image
Overview: Acorns is an app that allows you to invest your "spare change" automatically and is revolutionizing the way you could be saving for your retirement or any other purpose. I have personally started saving with this app about a year ago and find it very helpful because I have been able to save money little at a time that I would not have saved otherwise and would have spent it on non-essential purchases. Here is a snapshot of acorns and the way it looks on various devices. I have used the app on my iPhone and love it and I have logged in on my desktop computer, however I have not personally interacted with it using the iWatch. Acorns  overview Types of investments: I have set up several of my accounts for the round-ups and essentially it works the way you would think, every time I use the card associated with the linked account, it invests the spare change by rounding it up to the nearest dollar, however you have to reach at least 5 dollars for this to happen.

True Key – Never forget a password again

Image
True Key – Never forget a password again True Key is revolutionizing password protection by allowing anyone to use biometric data (fingerprints, facial scans) to log in without the need to remember every password. True Key was developed by Intel Security and comes in two different options: A free option that allows you to manage up to 15 passwords or a paid subscription of $19.99/year, that allows you to manage an unlimited number of passwords (actually up to 2,000). Both pricing options come with the full set of features and are compatible with Windows, OS and Android operating systems and Internet Explorer, Google Chrome and Mozilla Firefox when it comes to the browsers (however some of the features differ between operating systems and browsers). While face recognition and finger print scan are two of the options for using True Key , if you are not comfortable with using your biometric information, you can choose to use Email verification or Master Password verification

Ebates - Best Cash Back and Coupons for Online Purchases

Image
Ebates.com - The Best Cash Back and Coupons Site Who doesn't like to save money when shopping? What if I told you that Ebates.com literally pays you to shop online? Sounds too good to be true? Keep on reading, I promise you there is no catch to this one and you do not need to be afraid of getting into some rewards program that has strings attached.  Ebates.com  is one of several websites that allow you to shop online and receive cash back for your purchases. It also provides you with coupon codes when applicable for additional discounts. It is free and incredibly easy to save on everyday or special purchases. Ebates.com  home page. The screen shot above, shows the home page of  Ebates.com . You will notice that you can shop by department, search for a particular store or even just browse different categories that might be offering exceptionally high cash back offers for a limited time. I usually use  Ebates.com  when I am going to purchase something anyway and then

JPEGmini let's you trim your picture size without any loss of quality

Image
Happy photo dieting! Author: Anna McNab Date Posted: 3/21/2014  Description: The immense proliferation of digital photography has made every one of us a photographer and with the ever improving technology and constantly increasing size of the picture files we are storing on our computers, the time has come to figure out a way to downsize these huge folders filled with hundreds of pictures of our children playing with toys, playing at a park or in the first snow. Don't get me wrong, these moments are invaluable, but they are starting to take up all of the storage space on our computers. You may also wish to read more if you have a website with many images, because shrinking them will decrease the load time for your content, or if you make presentations that include many images.  JPEGmini offers a possible solution to this problem by dramatically reducing the size of our JPEG files without the loss of quality in our pictures. Let me take you on a tour that will  show you how