In this Excel magic trick video the tutor shows how to perform reverse two way look up for date and time columns and row headers. In this tutorial he shows a spreadsheet that contains dates in columns and times of a day in rows which makes up a small table schedule. Now he shows how to use those values of the cells in that schedule table and summarize and print out the values based up on a name or some other text value. He also refers to a previous video of his which he says to watch to get g...
In this Excel magic trick video the tutor shows how to use the years worked formula using Yearfrac, Int and Datedif functions. He says that using this trick you can find out how many years some one has worked if we know his starting date and ending date i.e. he shows how to extract the difference in years directly by using formula to calculate it. He shows how to use Yearfrac function which gives the number of years in decimal form. He also shows how to extract integer from the decimal using ...
You just found out you are pregnant and you are anxious to calculate your due date. Learn how to calculate your due date even before going to see your doctor by watching this maternity how-to video. Keep in mind that most pregnancies last about forty weeks.
The date and time stamp on a digital photo is great--if wanted there. This how-to video offers tips on using the time stamp on the Canon PowerShot SD600 digital camera. Watch this photography tutorial video to learn how to use the date and time stamp on a Canon SD600 camera.
This Microsoft Excel tutorial goes over formatting dates and using dates in formulas including how to use the "today()" and "now()" functions.
East meets, well, east in this cross cultural stir fry dish by Guy Fieri. Fieri takes classic Chinese stir fry up a notch on the heat meter by adding spicy Korean kimchi.
In this video from FiveSprockets we learn how to light an interior space while filming on a budget. For this you need two Chinese lanterns which he found for $2.95 each. You need 2 light bulbs which he found for $3.95 each. Make sure you get extra ones. Then get a couple of pan lights. They are day light and mood light. They were $7 and $5. You also need a multi colored gel pack which is $6.00. He uses C-stands to hold the lights up but he suggests coming up with other ways if you don't have ...
Chef's Anuja and Hetal from Show Me the Curry! teach you how to make an amazing green bean dish called Szechuan Green Beans. Carefully add beans to a medium sized pan filled with the oil contents. Make sure green beans are coated with oil and cook until for 20 minutes until soft. Use a small pan and lightly toast the sesame seeds. Place beans on plate. Place the rest of the ingredients: soy sauce, ginger, garlic, and chili sauce in sauce pan to cook. Replace the beans in pan and allow to coat...
Making friendship bracelets are easy and keeps friends in touch even when apart. Not everybody wants to show off their friendship to everyone, but if you do, this video tutorial will show you how to make a friendship bracelet, specifically the Swirl N Braid friendship bracelet. This is a fun design and basically the Chinese staircase combined with braids.
Watch this two part instructional painting video to paint wisteria flowers from life with watercolor on Chinese rice paper. This fluid style of painting takes lot of practice and does not allow for mistakes. Every brush stroke counts. Get out some news print to practice painting the beautiful flowers in your backyard.
Bamboo shoot is commonly used in Chinese and Vietnamese cooking, but can be thrown into Thai cooking every now and then. This fish curry has enough of a sweet taste to keep it from being too spicy, but is still full of flavor. You will need bamboo shoots, Thai eggplants, coconut milk, red curry paste, catfish, kaffir lime leaves, sugar, and fish sauce. Watch this video cooking tutorial and learn how to prepare a red fish curry with Thai chef Kai.
Forget the take out tonight, cook some Chinese food at home instead. Watch this how to video tutorial as professional Thai chef Kai shows you how to cook up an authentic dish of stir fired beef noodles. You can serve your homemade stir fried beef noodles with a side of rice.
It's a notoriously preconceived notion that a man has to ask the woman out. But why can it not work both ways? It does, and it's the best way to bag the man of your dreams, especially if he's the shy type. If you're tired of waiting for your prince to appear with a Manolo Blahnik in your size, then stop waiting, and start taking control.
This video tutorial from Melrose Jewelers shows you how to set a Rolex Day-Date President wristwatch. Setting the Rolex Day-Date can be done with just a few simple steps. You will see how to set the day, the date, and time... just watch.
Just because Valentine's Day is over doesn't mean you should slack off the romance department. While it's oh-so-easy to just pull on your Victoria's Secret boyfriend sweats, tuck your hair into a quick ponytail, and pig out on Doritos and dip on a Friday night with your boyfriend, it's quite a pleasant surprise if you put some effort into your look.
Sort your emails by either date or sender within MS Outlook 2007. This clip will teach you how. Whether you're new to Microsoft's popular email and scheduling application or a seasoned MS Office professional just looking to better acquaint yourself with the Outlook 2007 workflow, you're sure to be well served by this video tutorial. For more information, and to get started organizing your own inbox, watch this free video guide.
Learn how to round dates and times to a given interval in MS Excel 2010. Whether you're new to Microsoft's popular digital spreadsheet application or a seasoned business professional just looking to better acquaint yourself with the Excel 2010 workflow, you're sure to be well served by this video tutorial. For more information, including step-by-step instructions, take a look.
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 593rd installment in their series of digital spreadsheet magic tricks, you'll learn how to add data validation to allow only Monday dates in a cell using the custom option and the WEEKDAY function.
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 102nd installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to count the number of days between two dates using an array formula.
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 310th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the DSUM and DMAX with date criteria.
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 301st installment in their series of digital spreadsheet magic tricks, you'll learn how to change Regional Settings to force Excel to accept 20th century (1900) dates.
All digital cameras automatically record the date and time each photo was taken and store this time stamp as metadata within each image file. In Aperture 2, you can change these time stamps. This is particularly useful if the clock in your camera is set incorrectly or if you're trying to synchronize photos taken by multiple cameras at a single event.
With Huawei's recent emergence as the second largest OEM in the world, the company was poised to finally make a big push into the US market. Instead, their efforts were derailed by an unlikely foe, the US government. As a result, American customers will miss out on the newly-released Huawei P20.
A new dating app has arrived, and it'll finally land you a date with your celebrity crush ... kind of. The app — Dating AI — uses face search technology to help you search for potential love interests that resemble a celebrity you're attracted to.
We're all looking to meet someone, and in this day and age the easiest way to do that is through one of the various dating apps out there. But we can all admit it can get disheartening swiping through all of those people for the frustration of someone not answering your messages after matching. The fact is, we could be missing out on great people just because they don't have time in their busy lives to answer their dating apps every day. Not to mention the fact that we as a society are becomi...
The Unicode Consortium just unveiled 72 new emojis that will be included in the upcoming Unicode 9.0 release, but we're not here to talk about the winners. Instead, let's take a look at the five poor emojis that will have to wait until at least next year to join the Unicode roster.
One of my favorite things about American Chinese food is how easy it is to eat: the pieces are bite-sized, the flavors are addictive, and the meat is always tender and easy to chew. But if you've ever tried to replicate any of your favorite takeout in the kitchen, you've likely noticed that the high heat required for most recipes thoroughly dries out the meat that you're trying to cook.
With each day that dawns, there is a new, major hack that makes the news headlines. If you are paying attention, there are usually numerous hacks each day and far more that never make the news or are kept private by the victims. Every so often, a hack is so important that I feel compelled to comment on it here to help us learn something about the nature of hacking and IT security. This is one of those cases. Last week, the U.S. Office of Personnel Management (OPM) revealed that they had been ...
The bread at your local supermarket will most likely always be fresh, but how do you know which loaf is the freshest out of the bunch? You can squeeze and inspect them like an annoying TSA agent, but there's actually a much simpler way to do it.
Just 94 days after the release of iOS 7, the team over at evasi0n have once again gifted us with their latest jailbreaking software for the newest version of iOS. The first iteration of evasi0n7 contained Chinese malware, but the subsequent release removed the malicious Chinese app store, so this evasi0n7 jailbreak should be just as safe as previous evasi0n jailbreaks were for iOS 6.
No one likes to think about the possibility of natural disasters, but we all know they could happen at any time. Some of us are a little more paranoid than others, but wouldn't it be nice to know that you'd be protected if anything really crazy ever happened? Like the zombie apocalypse?
For all of you who are knot fans, here comes a video tutorial showing step by step and in detail how to tie an Emperor's hat knot that realistically resembles one of the hats worn by Chinese emperors in the old days. In this video, a white piece of rope hanging from a hook is used against a black background. You will see each one of the twists and turns in slow speed (not in slow motion) so that you can easily follow what is being shown. The final result is a complex knot done in less than fi...
In this video, we learn how to do Visual Kei face theater makeup. First, apply your favorite foundation and blush to your face. Next, add eyeliner to the top and the bottom of the eye and then purple eyeshadow on the top. From here, you will apply a blue eyeliner to the outer corner of the eye and mix it with the purple. Next, apply more blue eyeliner over the lid and then apply black eyeliner from the inside corner of the eye all the way to the top near the eyebrow. Then, create another wing...
This video will show how to decorate duct tape creations with Japanese Kanji characters, which are Chinese-based characters. After creating your duct tape stencil which will serve as a backing, you should go online and find a Kanji character which you would like to copy, print it out on paper, and cut it out with scissors. Place the characters on your duct tape and trace around the character, making a stencil of the character you would like. Finally, you need an X-acto knife, which you will u...
If you don't have Chinese five spice powder now, you'll soon be purchasing some after you take a gander at how delicious this recipe looks. Five spice powder is a blend of five savory spices that instantly adds flavor to any dish.
You probably haven't played with marbles since you were a kid (anyone remember Chinese checkers?), but more likely than not you still have some marbles lying around your house, especially if you have a kid.
In this video, we learn how to make tasty baked chicken with Kai. First, take your chicken and add in 1-2 tsp of seasoned salt. Next, add in 1 tbsp Chinese spices. Next, mix all of these together so the herbs and spices cover up all the pieces of chicken. Let this sit and marinate for around 30 minutes, then place on a baking sheet. Bake these in the oven for 1 hour on 375 degrees. When these are done cooking, bring them out of the oven and let cool and sit for around 10 minutes. When they ar...
Fortune cookies are quite ephemeral things. You break 'em open after a nice meal of Americanized orange chicken and broccoli and beef, start overanalyzing your fortune that "your relationship will take an unexpected turn," and then chomp down on the delicious wafer as you contemplate if he really is The One.
Whether you are just starting out doing Chinese calligraphy and painting or a have been doing it your whole life, practice is crucial. Rather than wasting ink, paint, and paper on practice pieces that you are going to discard or throw away afterwards, now you can use a Buddha Board! These devices allow you to use a waterbrush pen and water, no paper, ink, or paint, to create images that will disappear after the water dries! No mess, no waste, just an effective way to practice your art and sav...
In this tutorial, Chef Ken Hom shows us how to make stir fry rice noodles with vegetables. First you will need to take 8 oz rice noodle and soak them in water until they are soft, then drain them. Now you need to prepare your vegetables. You will need: bean sprouts (8 oz), red peppers (4 oz), shredded water chestnuts (8 oz), spring onions (6 of them finely shredded). Now, stir fry your vegetables in oil and add in 1 tsp salt, 2 tbsp of soy sauce, 3 tbsp of rice wine, 2 1/2 tbsp tomato paste a...