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.
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 594th installment in their series of digital spreadsheet magic tricks, you'll learn how to calculate age in years using the TODAY and DATEDIF functions.
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...
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...
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.
This is a video by a beginner and for a beginner. It goes over the tuning, chords, and strumming for the song "Five years time" by Noah and the Whale.
Watch this video and learn how to pronounce the months of the year in Japanese.
Watch this how to video to learn how to make a sachet with common safe and natural household items. Use an old t-shirt, or any other old piece of garment, and your favorite sent
I love books. I've loved books before I could even read them. I remember spending any free moments poring over the pictures, trying to pick out the words. I can recall the first triumphant moments when words began to make sense to me. I grew up in a house filled with books and with parents who read me The Hobbit, Little House in the Big Woods, The Chronicles of Narnia and so many others. I brought stacks home from the library, browsed through my dad's office shelves, used up the batteries in ...
In a bombshell revelation of the depth of the food police state that now exists in LA County, California, NaturalNews has learned that the LA County health department has unleashed door-to-door raw milk confiscation teams to threaten and intimidate raw dairy customers into surrendering raw milk products they legally purchased and own.
In case you haven't figured out already, our government is always on the move to figure out new ways to extend their control. The CISPA, for one, is one of the best examples, along with "re-education" programs, and racial divide (Trayvon). What I've noticed in the past few months is that their new "ideas" are coming out at an increasingly alarming rate.
Police in Milledgeville, Ga., say they handcuffed a 6-year-old kindergartner for safety after she allegedly threw a tantrum at school, tearing items off the principal's wall and upending furniture, WMAZ-TV reports.
Police in Los Angeles have killed a motorist who was fleeing after a police chase on U.S. 10 in the San Fernando Valley. Eight cops fired more than 90 rounds at 19-year old Abdul Arian as he fled police after they rammed his car. The teenager was unarmed.
TOP MOVIES 2011 The Artist (2011)
Hi everyone! I love the ideas what you showed us and the how to make does electric stuffs, but I had some ideas:
Being from the south I am partial to cobbler, especially peach cobbler. However I had some cherries on hand that needed to be used before they went bad so decided to give this a try. The end result was a sweet decadent dessert with just the right amount of tartness. Was great served warm with vanilla ice cream but just as good the next day cold.
Back in 1962, a Zambian teacher vowed that his country would beat America as the first country to put a man on the moon, and then they would go on to Mars. Unfortunately, his dream never came to fruition. The Zambians worked hard though. His "astronauts" rolled down hills in barrels to get used to traveling through space. They practiced walking on their hands, as their leader - Edward Makuka Nkoloso - assured them that was the only way to get around on the moon. "My spacemen are ready, but we...
It's live! Google has finally unveiled the much-hyped makeover of their Gmail email service. As of yesterday, anyone who wants to update to the new Gmail look can, but in the coming days it will be forcefully pushed to Gmail users everywhere. If you enjoyed the look of the old Gmail, you've only got a few more days to bask in the design before it becomes a mere memory.
UPDATE: Minecraft 1.9.5 Has Been Leaked! Get it Here. You heard right. This one is hot off the presses! Last night, Notch promised a 1.9 Version 3 Update and here it is!
RHYOLITE 64 points (14 points without the bingo) Definition: a volcanic rock [n]
At GDC 2011 this past March, three of the world's best game designers participated in a contest called Game Design Challenge. Each presented their vision for a game that fit the prompt "Bigger than Jesus: games as religion" before an audience, with applause to determine the winner. Jenova Chen, John Romero, and Jason Rohrer all spoke, and Rohrer won in a landslide with his revolutionary game called Chain World.
For any scavenger hunt to become a hit, you need to contemplate the age groups or capability levels of your persons who are actually going to take part. It's fairly apparent that the scavenger hunt easy enough to end up being completed by young kids could jolly well be boring for grownups that wouldn't be interested in something so easy. However, it is also a fact that integrating exactly the correct quantity of intricacy for various age ranges is usually pretty difficult. What do seven year ...
A diary or personal blog is a great way to recapture the days behind you, but to a photographer, the best way to remember the glory days is with a picture—one single photograph that best describes the day and your mood at the time. Do it everyday for a year and you'll have 365 pictures that will not only bring a smile to your face, but will help you understand what was important to you in life.
Smartphones are impressive devices, to say the least. A smartphone user can consume TV, music & movies; communicate via streaming video; check the weather; record audio; take professional quality video footage; snap high quality photos… The list just continues to grow and grow. With all of these incredible capabilities, why not add surveillance?
For a long time, video games manuals were serious business. Especially for strategy games and RPGs on the PC, the manuals would often run to a hundred or more full-color pages in length. They explained in vivid and well-written detail the history of the game world and every facet of the gameplay system. There were pages upon pages of appendices explaining the statistics of every unit, faction, and terrain type. They were majestic, and I would spend an hour or more poring over each one before ...
Video games have been a purely digital medium for some decades now. They exist in the electronic nether, embedded on discs and projected on screens. Since digital distribution has gained popularity, even the physical manifestation of the game disc is going away, leaving games (especially digitally distributed indie games) more ethereal than ever before. It is unclear whether this slightly unsettling fact was on the minds of the three people who made Receipt Racer, but regardless, it stands as...
SCRABBLE: 14 points; GRAFFITI: 15 points; MARRIAGE: 11 points; YES: 6 points. When playing a game of Scrabble, those are the minimal amount of points for each of the given words (not including blank tiles). But for 28-year-old Jeff Gurwin, it's more than just 46 points on the board, it's a lifetime of happiness.
DIY is a far-reaching term—though culturally it tends to refer to hacks, mods, crafts and constructions, its meaning can also extend to the ongoing trials and tribulations of the evolution of mankind: astonishing developments in technology, desperate acts of self-preservation or as in today's topic, discoveries in science that truly move the needle.
Calling all curious minds—scientists, anthropologists, relentless tourists: Saturday, April 9th, is International Obscura Day, the day to "explore hidden treasures in your hometown," or so says Atlas Obscura, a website dedicated to public curiosities and esoterica. If you're the kind of person who appreciates public oddities every day of the year, tomorrow is icing on the cake. Celebrate Obscura Day in one of hundreds of locales—from Los Angeles to Sydney, from Berlin to Manila.
Not in the mood for a sappy ending? Well, strap in because "Emotional Response Cinema Technology" lets your own body physiology control the movie music, the special effects, and even the movie ending. A collaboration between BioControl Systems, Filmtrip, and the Sonic Arts Research Center at Queen's University Belfast, the technology was recently showcased at the SXSW film festival in Austin, TX, where the newly minted horror film Unsound interacted with the audience through wires connected t...
Pogo is Nick Bertke, originally from New Zealand who has been remixing and DJing since he was 9 years old.
This is the last week of an eight-week contest that I just happened upon. One winner is awarded from each week so it's not too late to enter if you have pictures of this theme. The voting starts next week and is open for a week. Submission and the rules are easy for a chance at $250.
In every nerd, there is a 12-year-old boy just dying to get out. This week, we bring you the ultimate in indulging your inner kid.
Wired posts a gallery of the original models of now iconic devices, with some fun tech-fetish facts. Did you know the first cell phone weighed a whopping 4.4 pounds? Or that the world's first super soaker was invented completely by accident? Examples below; click through for Wired's complete gallery.
Sad story: a 50-year-old businessman recently lost his lover, and grief stricken, created a sex doll replica of the deceased woman. The 18-month-long painstaking process required dozens of photos to recreate an "exact" plastic copy of her face and body shape. £15,000 ($23,169) later, the clone was finished, complete with articulated joints, a titanium skeleton and lifelike skin.
Nine-year-old Azura of Middle Road, Worcester (England) inadvertently pranked her whole neighborhood (and whoever else happened to be browsing the area on Google Street View) when she dropped "dead" to the pavement.
Androgynous. Stumpy. Creepy. The horror movie robot, created by the notorious Japanese roboticist Hiroshi Ishiguro, is projected to be available for around $8,000 later this year.
FarmVille added a new feature today in place of the old Mystery Boxes. This is a mystery game! It costs a bit more than the old boxes did, but you are guaranteed to get at least one of each of the mystery prizes by the time all the balloons are popped, instead of wasting tons of farm cash and perhaps opening a hundred mystery boxes and never getting that one thing you really wanted. So this is a great improvement and is much more interactive than the old 'purple sparkly poof'.