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.
You're already spending a ton of money on your dress and everything else for prom, so why spend even more on getting your hair done? You can make sure you look beautiful for your special day at home and still look like a million bucks! In this tutorial, curl your hair in a Hollywood glam style that is actually quite easy to do.
In this video from theXBox360GameReview we learn how start and join an Xbox Live party. Once signed into Xbox live, scroll to the friends channel, and select the friend you want to have your party with and press Y. Now that you have a party going, you can play some Halo wars. If you want more friends to join the party go to your friends list using the guide button and tap X to select who you want to invite. If you want everyone in the party join in, select Party and choose Invite Party to gam...
There are about fifteen states of matter: solid, liquid, gas, plasma, et cetera. Plasma is commonly found in stars, and is a rare natural phenomenon here on Earth. In this video, I show you how to make artificial plasma in your microwave.
Add text and titles with Windows Live Movie Maker. There are three options for adding text in Movie Maker. This tutorial provides an overview for each type: title (which goes before the selected clip), caption (which is superimposed over the selected clip) and credits (which goes after the selected clip).
If you think you may have goofed on your tax return, you're going to want to file a 1040-X, which is an amended tax return. This quick video by the IRS shows how to do it, for this, or any of the previous 3 years.
Children hate going to bed, but they certainly need their sleep. How can you get a toddler to accept that it's bedtime without having to deal with a temper tantrum? Here are a few good stratgies for getting a toddler to go to bed peacefully.
This is a tutorial for the Yoyoskills.com contest on making great yo-yo instructional videos. This tutorial teaches the the yoyo concept "hugs" as well as a basic hug.
Kids can have fun using the iTunes music store while parents still control the credit card and content their children can access. Parents can restrict access to certain content, set up a shopping cart to review music choices before they're purchased, and give kids a monthly allowance.
Want to know how to set PDFs up so that they can be digitally signed? In this Adobe acrobat tutorial you'll see how to set up a PDF to accept a digital signature. You all also see how to create your own digital signature for signing and a strategy to work with your clients so that you know who is signing those documents.
Did you know that malicious people can use scanners to read the Radio Frequency Identification (RFID) chips in your credit cards and identification documents and steal your personal information? Learn to protect your personal information from hackers and scammers with this simple method involving aluminum foil.
Okay, Mr. Thrifty, you reserved the least expensive hotel room that you could. But your inner Donald Trump doesn’t want to settle for low-frills. Go ahead, it never hurts to ask. Watch this video to learn how to get a hotel upgrade.
PayPal is one of the most popular payment systems across the globe. It makes payments fast, easy, and secure, and with 250+ million users, it's not going anywhere. If you're new to the online service, one of the first things you should learn is how to add your bank account, credit card, or debit card to PayPal, and make your life easier when it comes to online payments and withdrawals.
Apple Card has generated quite the buzz since its March 2019 announcement. The iPhone maker's new credit card pairs with Apple Wallet on your device, is simple to sign up for, includes enhanced security over other cards, has zero fees, and provides daily rewards right to your Apple Cash account. And as good as that sounds, the fine print can complicate things real quick.
I think we all like the idea of getting paid games for free with minimal effort. Typically, though, anything claiming to help you do that is either illegal or a scam. But there are actually quite a few no-fuss methods that can get you paid games without going too far out of your way. From checking notifications to discovering hidden offers, you might have something waiting for you.
Contrary to popular belief, it takes more than just one artist to create the sound, lyrics, and vocals of a song. With most music being enjoyed digitally nowadays, it's harder to know all of a track's collaborators, as this info used to be in the CD booklet. Well with Tidal, you can now easily find this information and more.
Identity theft can happen anywhere, even in social networking. Why are we so careful when using our credit cards online but not when we sign on to Facebook?
Go to the US Money Factory store to get sheet money http://www.moneyfactory.gov/ This is a a quick folding demonstration. It shows exactly how you would fold bills to make a billfold simple wallet with sheets of dollar bills. This will provide great camoflague for your money and credit cards.
This video tutorial discusses high quality installation of home insulation procedures for raised floors and floors over garages. This video is a must-watch for all insulation contractors in California to ensure that they receive an energy compliance credit.
Watch this video and learn how to convert a Super Wide Polaroid camera into a pinhole camera. This conversion will also work for super shooter and colorpack cameras. Strip down the camera, "chop" the body and prep to recap for a super wide angle pinhole camera. This project works for cameras that accept 3.25 x 4.25 polaroid and fujifilm instant pack films.
Conducting phishing campaigns and hosting Metasploit sessions from a trusted VPS is important to any professional security researcher, pentester, or white hat hacker. However, the options are quite limited since most providers have zero-tolerance policies for any kind of hacking, good or bad. After researching dozens of products, we came out with 5 potentials that are ideal for Null Byte readers.
Flashing people in an oversized trench coat is both old-fashioned and exhausting (and also very illegal). But like the evolution from school-yard bullying to cyber-bullying, it seems as if the new trend is "cyber-flashing" (it's even has an official hashtag). In the U.K., police are now investigating what they are calling the first cyber-flashing case.
Skype is a great way to stay in contact with friends and family over the internet, and people tend to share a lot in their chats, so why not try and find a way to hack it! Once a Skype account is hacked, you can view all conversations within the last three months, see how long each video call was, and even access files that were shared through chat.
Want to get all possible golden eggs in the hit iPhone game, Angry Birds? This tutorial shows you where each of the fifteen eggs are found, and how you can collect them all. Some are quite cleverly hidden throughout the game, like after the credits!
Yes, there's an app for that - even video editing. You can get the Reel Director app from the Apple store for five dollars, and then use it it edit video stored on your iPhone. You can even add opening and closing credits!
The world of taxes and filling out the 1040 form itself is pretty confusing, especially if you're unsure about the terms, "deductions" and "credits". In this video you will get a full walkthrough of how tax deductions work and how to fill out the Schedule A portion of the 1040 form for your federal income taxes.
Looking for an easy way to make certain that your sensitive personal information is secure? With Identity Finder, it's easy! So easy, in fact, that this home-computing how-to from the folks at TekZilla can present a complete overview of the process in just over three minutes. For more information, including step-by-step instructions, take a look.
If your LEGO men are raring to get a rock band going, then who are you to stop them? With a few LEGO blocks, you can easily create some nifty instruments for them to start jamming with. In this video, watch and learn the steps to creating a guitar, bass and cello out of LEGOs. Also, after the credits, check out the cool LEGO microphone!
Ivy League schools are a students wet dream, but not everyone can get into them. Even fewer get scholarships for them. But in recent years, Ivy League universities have raised the number of scholarships they award to students. More students are seeking awards, making the application process for these scholarships very competitive.
This clip explains how to use Blender to title your video, layer your titles on top of video, or stencil your video on top of title text. Whether you're new to the Blender Foundation's popular 3D modeling program or a seasoned graphic artist just interested in better acquainting yourself with the application, you're sure to be well served by this free video tutorial. For more information, including detailed instructions, take a look!
Marvel's recent string of wildly successful films based on its wildly successful comics have ushered in a whole new era of comic book films. All of the Marvel films have a very cool Marvel logo effect during their opening credits. This video will teach you how to create the same effect for your logo at home using Flash CS3. Now your superhero movie will look much more authentic and professional.
You know those little clear pockets in your wallet that perfectly fit your driving license or school ID card? Didn't think you could get them in a homemade duct tape wallet, did you? Well, think again! In this clip, you will learn how to make a complex wallet out of tape including credit card slots and a see through ID holder. Follow along and get started.
It doesn't matter if you're a man or woman, but organizing a wallet is an important task for your daily life. Besides the fact that it is your main storage area for cash and credit, but it can also contain information about who you are and what it is you do. So in this helpful tutorial, find out how to keep your wallet nice and organized so when people see you, the first word that doesn't come to mind is messy. Enjoy!
There are all sorts of different teas out there, it's hard to keep up! But this video focuses particularly on one specific type: English tea. You have to give the English some credit they can produce some pretty tasty tea that is perfect for any time of the day. This tutorial will show you exactly how to make English tea. Enjoy!
1. Open the web browser and type www.facebook.com and press enter. 2. In order to be a member you will have to first sign up as a facebook member.
This video explains how to delete cookies in Windows XP, Mozilla Firefox, Internet Explorer and Opera. To delete cookies in Mozilla Firefox, choose the "tools" option from the tool bar, then choose "options", then choose "privacy". Many options will be given under the "privacy" menu, but make sure to choose the following options- "accept cookies from site" and "accept third party cookies", then choose the option "I close Firefox option" under "keep until" then choose "ok" to delete the cookie...
Take a folder and organize documents based on the actions required. Actions:
Fantasize about role playing? One of the most popular venues for role playing medieval fantasy is the board game, Dungeons and Dragons. Get a group of three or four together and have a blast!
Do you need a new wallet but don't have the cash to buy another one? Check your house for some duct tape. You can make your very own duct tape wallet in a few simple steps. Watch this tutorial to learn how to make a bi-fold duct tape wallet to hold cash and credit cards.
Catch a good pass defense off-guard with the classic flea-flicker. Tip: Once the defense sees the running back with the ball, they'll think it's a running play and lose track of the receivers. Did you know? University of Illinois coach Bob Zuppke is credited for inventing the flea flicker in the 1910's.
