Years' Sophistication Search Results

How To: Complete the Path of Ascension Challenge with a Gold rank in StarCraft 2

Starcraft 2 is finally upon us after 12 years of waiting, and it is just as majestic as you would hope it would be. If you're new to the series or just haven't played in five years, the barrier to entry for the unskilled can high, especially if you prefer playing online multiplayer. Fortunately for you, we've compiled videos on just about everything you need to know about the game, including strategies and tips for winning with different races in different modes and situations, and even how t...

How To: Use the SUMIF function with an array in Microsoft Excel

New to Microsoft Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. In this MS Excel tutorial from ExcelIsFun, the 694th installment in their series of digital spreadsheet magic tricks, you'll learn how the SUMIF function (and COUNTIF, etc.) cannot accept arrays. If you need to sum by year from transactional data the SUMIF and YEAR functions cannot be used together. Instead we can use the SUMPRODUCT function.

How To: Win playing the Protoss race in StarCraft 2

Starcraft 2 is finally upon us after 12 years of waiting, and it is just as majestic as you would hope it would be. If you're new to the series or just haven't played in five years, the barrier to entry for the unskilled can high, especially if you prefer playing online multiplayer. Fortunately for you, we've compiled videos on just about everything you need to know about the game, including strategies and tips for winning with different races in different modes and situations, and even how t...

How To: Play as the Terran race in StarCraft 2

Starcraft 2 is finally upon us after 12 years of waiting, and it is just as majestic as you would hope it would be. If you're new to the series or just haven't played in five years, the barrier to entry for the unskilled can high, especially if you prefer playing online multiplayer. Fortunately for you, we've compiled videos on just about everything you need to know about the game, including strategies and tips for winning with different races in different modes and situations, and even how t...

How To: Play and win as the Zerg race in StarCraft 2

Starcraft 2 is finally upon us after 12 years of waiting, and it is just as majestic as you would hope it would be. If you're new to the series or just haven't played in five years, the barrier to entry for the unskilled can high, especially if you prefer playing online multiplayer. Fortunately for you, we've compiled videos on just about everything you need to know about the game, including strategies and tips for winning with different races in different modes and situations, and even how t...

How To: Successfully attack with any race in StarCraft 2

Starcraft 2 is finally upon us after 12 years of waiting, and it is just as majestic as you would hope it would be. If you're new to the series or just haven't played in five years, the barrier to entry for the unskilled can high, especially if you prefer playing online multiplayer. Fortunately for you, we've compiled videos on just about everything you need to know about the game, including strategies and tips for winning with different races in different modes and situations, and even how t...

How To: Use the Nydus Worm to harvest resources in StarCraft 2

Starcraft 2 is finally upon us after 12 years of waiting, and it is just as majestic as you would hope it would be. If you're new to the series or just haven't played in five years, the barrier to entry for the unskilled can high, especially if you prefer playing online multiplayer. Fortunately for you, we've compiled videos on just about everything you need to know about the game, including strategies and tips for winning with different races in different modes and situations, and even how t...

How To: Make your own lipstick bullet

With thousands of beauty companies out there, we can generally find at least one lipstick shade that makes us look more dazzling than New Year's Eve. But sometimes, whether you need to match your lipstick to your dress or just can't seem to find The One, you need a specific color that no brand carries.

How To: Get rid of head lice with Dr. Su Laurent

Head lice can be a nasty, unwelcome visitor in your life. And if you have children, you're likely to be confronted with an infestation sooner or later. Dr. Su Laurent explains that getting rid of head lice can be a tricky undertaking, but the most important thing is to be persistent. You'll need to wash the hair with the latest lice treatment available, as the lice may adapt to chemicals from year to year. It's very important to follow up this treatment at least one more time, seven days late...

How To: Apply Cyndi Lauper inspired makeup

Wow! Watch as the talented make-up & hair extraordinaire, Kandee Johnson transforms herself into 80's rocker, Cyndi Lauper and proves that girls just want to have fun! By following this tutorial, you might just win next year's Halloween costume contest!

How To: Fold an origami box with a lid

This origami video tutorial shows how to make a box with a lid out of two sheets of paper. This fold makes a great gift box for small presents. This is relevant with the upcoming holidays like Christmas, Hanukkah and Valentine's Day all around us. It's also a good idea for adding a personal touch to a birthday present or to hold a first year anniversary gift... (the first year is paper guys).

How To: Make an Excel PivotTable year category from text dates

New to Microsoft Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. In this MS Excel tutorial from ExcelIsFun, the 612th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a Year Category for a PivotTable from dates entered as text using the RIGHT function and the ampersand (&) join symbol.

How To: Plant strawberries as ground cover

GardenGirltv shows viewers how to plant strawberries as a ground cover! With a strawberry patch or field you will have to always continually plant strawberries! The plants will last a few years and every year you should add new plants to your areas for each year. First, you need to get a bundle of strawberry plants you need to rake the area you are planting them in. Make sure you put each plant 18 inches apart. First, you should take your strawberry plant dig a trench, lay it flat and cover i...

How To: Take off 10 years with makeup

Using the improper types and colors of makeup may in fact add years to your appearance rather than take them off. This video shows some simple tips to reduce signs of aging in less than ten minutes. For example, rather than using shimmery eyeshadow, which can in fact enhance wrinkles and fine lines, use a matte colored eyeshadow in order to blend the lines in your face. Using light, non-heavy lip liner and moisturizing lip gloss will make your lips look fuller, giving you a more youthful appe...

How To: Perform the "year game" magic card trick

What else can you do with a deck of cards besides play games? Magic! There's nothing better for a magician's repertoire than a few great card tricks, so make sure you watch this video tutorial on how to perform the "year game" magic card trick. This is a lengthy trick, but it's sure to amaze and baffle anyone. To do this year game card trick, a little mathematics goes a long way, so don't fall asleep in math class.

How To: Make and freeze pesto using fresh basil

Pesto recipes keep summer going all year long. Rita Heikenfeld, from AboutEating.com, had a bumper crop of basil this year. And one of her favorite ways to keep that basil on her table year round is this pesto recipe for the freezer. Pair this basil pesto recipe with pasta for a fresh and delicious dish that will keep you thinking of your garden all year round. Watch this how to video and learn how easy it is to make homemade pesto with fresh basil. All you need is basil, olive oil, garlic, p...

News: The New Nokia 6.1 Is a Solid Upgrade to One of Last Year's Most Durable Budget Phones

HMD (the company currently making Nokia-branded phones) only released one flagship device last year, with the rest of the phones falling in the mid-range and entry-level tiers. However, at Mobile World Congress 2018, HMD announced their ambition to become a top five smartphone maker in 3–5 years. Meeting this goal will require penetration in all markets — especially the United States — and it looks like Nokia will get the ball rolling early this year.

User Testimonials: Why People Are Switching from iPhone to Pixel

Reading through various internet forums, it certainly sounds like the Google Pixel and Pixel XL are attracting more iPhone users than any of Google's previous Nexus devices. The sales figures seem to back that up, too, as the Pixel is outpacing last year's Nexus 6P, and pre-order demand has exceeded Google's expectations, causing delays in shipments. (We reached out to Google but they wouldn't give us any specifics on sales numbers or numbers of switchers.)

News: You'll Need New Accessories for the iPhone 7, Even Though It Looks the Same

In years past, Apple has always waited two years before redesigning the iPhone, but this year they broke the trend. Aside from a few minor changes, the overall design and style of the iPhone 7 models is the same as last year's iPhone 6s models, and the iPhone 6 ones before that, so it's almost as though they've switched to a three-year cycle—just as early reports suggested.

News: I'm a Mac, and I Kicked PC's Ass Last Year... Or Did I?

Apple computers have long been maligned as the computer for Starbucks aficionados and graphic artists. "Dude, have you used Excel on a Mac? It's terrible," says everyone that owns a Dell. The whole PC versus Mac battle was encapsulated in what I think to be the greatest ad campaign of all time, "I'm a PC and I'm a Mac." And yes, I know that PC really stands for Personal Computer, which means that a Mac would be a PC, but for the sake of the article, it will mean all things non Mac.

How To: Grow and take care of poinsettia year round

More likely than not this holiday season you'll either be buying a poinsettia plant or will receive one as a hostess present. Rather than letting yours wither away and die as you forget repeatedly that it may need a little water to survive, check out this gardening tip video to learn how to take care of them year round.