Merge and Center Shortcut in Excel
If you work as a data analyst or marketing specialist, you may already know how time consuming formatting tables and reports can be. Keyboard shortcuts are more than welcome, as they can save you lots of time on repetitive formatting tasks. The Merge and Center...
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...
Paragraphs to Him
Finding the perfect words to express your love and make your partner feel special can be challenging. Whether it's through sweet good morning texts, reminiscing on memories, or gushing about how he makes you feel, the paragraphs you craft for him can melt his heart...
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...
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...
Technology
Merge and Center Shortcut in Excel
If you work as a data analyst or marketing specialist, you may already know how time consuming formatting tables and reports can be. Keyboard shortcuts are more than welcome, as they can save you lots of time on repetitive formatting tasks. The Merge and Center...
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....
Life
Paragraphs to Him
Finding the perfect words to express your love and make your partner feel special can be challenging. Whether it's through sweet good morning texts, reminiscing on memories, or gushing about how he makes you feel, the paragraphs you craft for him can melt his heart...
Learn & Master Photography with Vince Wallace, Special Offer
Disclosure: This article contains affiliate links. This means that if you click on such a link, I am compensated with a commission in case you decide to buy something from the vendor's website. My website is independently owned and the opinions expressed here are my...
How to Convert Old Photos and Negatives to Digital: Three Ideas
While doing research for this article, I found GoPhoto, a service that scans your old photos, negatives and slides and helps you put them online, for only $0.28 per scan. GoPhoto is based in San Francisco area, but they provide services across the entire US. Digital...
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...
Christmas Gift Idea For Your Children
Browsing the campaigns in shareasale.com and NeverblueAds, I discovered a cool Christmas gift idea for children within 3 and 10 years of age: a photo personalized DVD movie, in which your child's photo will appear more than 30 times. If you order it before December...
Car Insurance Comparison Guide
This is a guest article by Samuel Stone. Car insurance comparison is a must if you want to get the best possible deal. You can't just call the first insurance company you hear about and sign with them without even knowing what other companies have to offer. This is a...
The 7 Wonders Of Working From Home
Wonder 1: I wonder why people associate working from home with being always available for them? Wonder 2: I wonder why people see working from home as a good pretext for lazyness? Wonder 3: I wonder why that sink is always full of dishes, although I wash them many...
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...
Good Coffee Makes Great Mornings. Looking to Buy a Keurig B70 Platinum Coffee Maker
How many appliances can one buy during a lifetime? I can buy lots! There’s always something I need more than what I already have. Like coffee makers: I’ve got one, but it makes lousy coffee. I can’t stop myself wishing to buy a better coffee machine. At my last job,...
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...
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...