How to Use IF ISNA and VLOOKUP in Excel: A Step-by-Step Guide
More than once my work colleagues got irritated by seeing the dreaded #NA or #N/A text breaking their beautiful tables and worksheets. Younger ones didn't even know that the #NA acronym stands for, so I had to explain it time and again. What If We Could Replace #NA...
How To Compare Two Columns in Excel using VLOOKUP
Comparing and matching data between two columns is a common task in Excel. For example, you may have one list of customer names and another list of email addresses, and you need to identify which emails match to each customer. Or you might have two sheets with product...
Limit Choices in a Cell To Restrict Data Entry in Excel
More often than not Excel users are prone to entering typos and other misspellings into cells, making a mess out of a database or table. The best way to prevent such errors is to limit choices in a cell to restrict data entry to a set of desired values. This article...
How To Reduce Excel File Size
Why would anyone want to reduce Excel file size or to compress such files? Main Reasons To Reduce Excel File Size There are multiple reasons for wanting to reduce Excel file size outcomes. Here are a few of them. I'm sure you can find others, if you think harder....
Excel Macros: A Beginner’s Guide
If you're a Microsoft Excel user, you probably know how much time repetitive tasks take. The good news is that you can speed up your work by recording and customizing macros. When it comes to Excel macros, sky is the limit. Just get creative and put your ideas into...
Excel Macros: A Beginner’s Guide
If you're a Microsoft Excel user, you probably know how much time repetitive tasks take. The good news is that you can speed up your work by recording and customizing macros. When it comes to Excel macros, sky is the limit. Just get creative and put your ideas into...
Cats Can Lough Out Loud Sometimes
Spottie, Tiger and their mom welcome you to this edition of 1001 Cats Blog Carnival. They worked hard to prepare for you some hopefully funny lolcats, so you get to know them better. But first, the serious stuff: Tiffany Holley presents Kitten Rescue posted at Life on...
How To Buy Halloween Costumes When Your Size Is 1X-4X
Shopping for plus size costumes online can be tricky. It's hard to find something that looks good on you, something sexy and cute, something that fits your curvy shapes. Men will find it easier, because they can go for very large costumes with plenty of room inside,...
Technology
How to Use IF ISNA and VLOOKUP in Excel: A Step-by-Step Guide
More than once my work colleagues got irritated by seeing the dreaded #NA or #N/A text breaking their beautiful tables and worksheets. Younger ones didn't even know that the #NA acronym stands for, so I had to explain it time and again. What If We Could Replace #NA...
Excel Macros: A Beginner’s Guide
If you're a Microsoft Excel user, you probably know how much time repetitive tasks take. The good news is that you can speed up your work by recording and customizing macros. When it comes to Excel macros, sky is the limit. Just get creative and put your ideas into...
Get a little bit more productivity in Windows XP
When I first started using Windows, I wasted a lot of time looking for the applications I wanted to launch or minimizing all applications to finally get to see my desktop. And these are only two examples. As I decided to get more productive, I discovered a bunch of...
How to make the PayPal button change on hover
If you use PayPal to sell products or services on your website, you probably noticed that Buy Now buttons don't change on mouse over. I believe it's much nicer if they did. The project I currently work on require PayPal buttons, because it's about selling services...
Essential Keyboard Shortcuts in Microsoft Excel
How often do you use keyboard shortcuts in Windows or in other programs? If you don't, then you don't know what you're missing. They are such a time saver! I'm so excited about such methods of improving my working speed, that I've even published No-Mouse Microsoft...
Life
How To Buy Halloween Costumes When Your Size Is 1X-4X
Shopping for plus size costumes online can be tricky. It's hard to find something that looks good on you, something sexy and cute, something that fits your curvy shapes. Men will find it easier, because they can go for very large costumes with plenty of room inside,...
Freedom: Debt Management Is the First Step
Freedom Debt Management is a 501c3 community service organization, a non-profit that provides free and confidential solutions related to personal finance management. I haven't used their services, as I live outside the USA, but I suppose that only the initial...
Five Questions New Entrepreneurs Could Ask Themselves
You decided to say goodbye to your 9 to 5 cubicle life. Very well, now you’ll start mastering your time, your mind, your decisions and your thoughts by doing things your own way. Welcome to the sunny entrepreneurship world! Before jumping in with all your momentum,...
Withings: Wi-Fi Internet Connected Body Fat Monitor and Scale
I just found the perfect gadget for people who want to lose weight and be in control of their body all the time. I’m talking about Withings WiFi Body Scale, a body fat monitor and scale which can send date to your iPhone, iPad or to your computer using a Wi-Fi...
Philips Sonicare HX6733/70 HealthyWhite Premium Edition Electric Toothbrush
Just after I wrote the Philips Sonicare FlexCare Electric Toothbrush review, I discovered another electric toothbrush which looked appealing to me: the Philips Sonicare HX6733/70 rechargeable sonic toothbrush. I was attracted to this one because it is also called...
How Christmas Gifts Can Ruin Relationships
Believe it or not, I'm afraid of Christmas. Not that I don't like to make presents: actually I adore it, I'm trying to fit every single gift I buy with the personality and needs of the person who is going to receive it. Yet, I'm scared that I could ruin years of...
How to Get More out of Your Yoga Session: 5 Easy Tips
This is a guest article by Maria Rainier. Whether you're new to yoga or you've been practicing for years, it's tough to get a handle on exactly what your body needs from a yoga session. Each person is different, so no instructor could possibly conduct a perfect...
Quick Tip For Online Learning Addicts
Distance learning programs were available long before Internet was born. I remember a friend of mine, taking marketing courses by correspondence: she got the materials by snail mail, she did her homeworks, sent them to that university, and finally got a diploma. It...
Home & Garden
How To Choose a Toddler Car Seat. Graco Nautilus 3-in-1 Car Seats Have Good Reviews
One of my best friends wants to buy a car seat for her little daughter. She came to me to ask for help, so we did the research together. We spent last evening looking at various models and we came up with a list of points one needs to check when buying a car seat for...
3M Filtrete Ultra Clean Air Purifier Claims To Be Better Than HEPA. Amazon reviews suggest it might.
Air purifiers have different effectiveness levels. There is a standard which measures this. It is called CADR and it stands for Clean Air Delivery Rate. It indicates the volume of filtered air delivered by the air cleaner per time unit, adjusted with the particle...
Did You Know You Can Use a Pressure Cooker for Canning? All American 921 Pressure Cooker / Canner Review
I love my pressure cooker. It helps me spend less time cooking, because foods boil so much faster in it. I have one of those basic stainless steel pressure cookers, without any bells and whistles such steam gauges or multiple pressure settings. Even so, I'm very happy...
Insomnia Makes Me Read Memory Foam Mattress Reviews at 3am
The advantage of insomnia is that you have a lot of time for thinking. The disadvantage is that you can't direct your mind to enjoyable thoughts only. I discovered that thinking about practical things helps keeping unwanted thoughts away. Last night was one of those...
Telescopic Ladders, Ideal For Small Spaces. Werner MT-22 Multi-Ladder Review
Each time I paint my walls, I wish I had a ladder. I never get to buy it, though. I use the kitchen table, which I drag around to do the ceiling and the upper part of the walls. It's usually fine, but moving from one room to the other is a bit of a hassle, because the...
Telescopic Ladders, Ideal For Small Spaces. Werner MT-22 Multi-Ladder Review
Each time I paint my walls, I wish I had a ladder. I never get to buy it, though. I use the kitchen table, which I drag around to do the ceiling and the upper part of the walls. It's usually fine, but moving from one room to the other is a bit of a hassle, because the...
Portable Propane Gas Grills: Weber 386002 Q 100 BBQ Grill Review
Before starting this research for buying a food smoker, my idea of barbecue grills was simple: a solid grate over a metal box filled with coal, set on two bricks in the backyard. Now that I'm into barbecue smokers and I already love Weber Smokey Mountain Cookers, I...
10 Reasons Why Barbecue Smokers Are Better Than Grills
I am about to buy a Weber Smokey Mountain Cooker. I haven't ordered it yet because I have a hunch Amazon is not going to deliver it here. I'll see if there are any good local alternatives. Another reason for giving it a second thought is that I discovered an electric...