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.
So, you've entered the world of cake decorating and fondant icing! What is one to do with their projects once finished? In this video, learn from the best ways to store your fondant icing projects. Take some final precautions and store your cake the best way possible. After all, your time, effort and creativity have made it very special!
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 82nd installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use the UPPER & EXACT functions to create a TRUE/FALSE formula to determine whether or not uppercase text has been entered into a cell.
This video will show you how to send a text message with the Samsung Galaxy I7500. Just follow these simple steps to start sending text messages from your Samsung Galaxy I7500: From the home page, tap the messaging icon. Select "New Message" Tap the "To" field and enter either the name or the number of the person you wish to send a text to. Type in your message, and when you are done, tap the "Send" key.
Do some niche research for your eBay affiliate site in these video tutorials, and see how to build an eBay affiliate partner site from scratch. Learn how to drill down into eBay Pulse and search for untapped niches. Finding a niche for your eBay affiliate site might seem daunting, but it's not. Also, learn about the Google Keyword tool and Wordtracker keyword tool along with a basic Google search to determine traffic levels and how easy it is to rank for a given keyword.
First, part the curtain to enter the voting machine. Then, start the voting process on the ELECTronic 1242 voting machine in Delaware. All that's left is to press the big green VOTE button on the voting machine and you're done. So get down to your county and VOTE in this coming election. The pol's need you.
Watch this video to learn how to create a beautiful and practical water wall (or water bottle wall) for energy savings at home. it helps to cut down the amount of sunlight that enters your home. You can make a frame that will fit into your window.
Once each day, or according to your doctor's instructions, you will need to clean the urethral meatus - the opening where the catheter enters the body. The procedure to do this is explained in this video.
If you're one of the lucky members of the Nintendo Ambassador Program on the Nintendo 3DS, take a look at this walkthrough of the perks available through the eShop on your 3DS. You'll be able access and download an Ambassador Certificate, Metroid, and more. Just enter the eShop and head to the 'Your Downloads' menu to start loading them up on your handheld.
If you're on the first mission of Deus Ex: Human Revolution, you can unlock the 'Ghost' achievement by entering the building from a special direction. Take a look at this guide to find out where you need to head in the manufacturing plant to get this achievement on the Xbox 360.
Wondering how you can allocate more RAM to Minecraft? Watch this video to learn how to dedicate more of your computer's RAM to Minecraft. This video contains the code to enter into your computer to change the allocation of RAM for Minecraft.
A fireplace is a beautiful, elegant way to light up a room that lets anyone who enters your home know you've got class. That's just as true in Minecraft as it is in real life. If you can't make it to the nether and get netherrock, stick to the instructions in this video.
No one likes a cheater! Well, you don't have to cheat in order to quickly make your farm and profits grow on Farmville. You can easily increase how much money you have on your FarmVille farm without having to use hacks or cheat codes. Follow these four tips - enter the daily raffle, share your friends bonuses, help out on their farms and see what happens!
There's a cache of weapons hidden in Portland, in the game Grand Theft Auto 3. You don't need to enter any cheats or cheat codes - just follow this video, and it'll show you exactly where to find all of them.
Why should console players have all the fun? This tutorial shows you how to enter in cheat codes when you're playing Grand Theft Auto: San Andreas on the PC. Get everything you can as an XBox or Playstion player with these codes!
Make sure you watch the very bottom of the video, that is where the cheat codes will appear. Poptropica has the ability to use codes to get some extra goodies, and this video demonstrates a few of the better ones for you.
Become the most feared gunslinger in the West! This Flash game is quite easy - just exchange six-shooter shots with your enemy. The video shows you several cheat codes you can enter for extra ammo, life or other goodies in Gun Blood.
This tutorial shows you several different hex codes you can enter so you can hack your game of Minecraft using the game hacking program Cheat Engine. This uses the most current version of Cheat Engine, so make sure you have 6.0 or better.
AT&T Online Account Management portal for small business customers is a great place to manage a sea of information, BUT, it won't do you any good unless you know how to log in. This clear how-to shows you how to enter your AT&T username and password so you can manage your account online.
Get as many points as you want when playing the game Pandemic 2. You will need Cheat Engine, the game and possibly a calculator so you can figure out the right values to enter in the fields to help you hack.
You will need to be playing Fallout: New Vegas on the PC, and make sure that you have enabled the console. This is not a mod, but you will need to enter a few console commands in order to get the enclave power armor.
Re-entering contact information every time you upgrade to a newer mobile device is pain, but the Android software on the Samsung Galaxy Tab allows you to copy over your existing contact information from a SIM card. This video will show you the steps to importing that data. Go to APPLICATIONS < CONTACTS < MENU < IMPORT/EXPORT < IMPORT FROM SIM CARD < MENU < COPY TO PHONE. Choose SELECT ALL to copy all of you contacts and then DONE.
Some players might encounter a few bugs when playing the Oh My Papa Melissa mission in Fallout: New Vegas. If you are playing on a PC, you can open up the dev console and manually enter a few commands to fix this bug.
When you enable the dev console for CoD 4, you can get into the developer's menu and give yourself all sorts of cool tricks, extra equipment and more! This video shows you a few commands you can enter when the console has been enabled.
This cheat will work for any copy of Dragon Age: Origins running on the PC. Use this trick to enable the developer's console, which gives you exactly the same kind of access a game developer has when making the game. Then enter any number of codes to give yourself extra cool stuff!
Give yourself all the sovereigns or XP you could possibly want, or have everyone wearing the Juggernaut armor. This tutorial shows you how to enable the console for Dragon Age, and then enter a variety of cheat codes to get all sorts of great stuff! (works with the Steam version, too!)
If you've already enabled the developer console, you know you can access the cheat menu in the game and enter codes to give you crazy cool stuff. But what to get? Here's a list of codes that you can use to give yourself immortality, kill every enemy in your immediate area, give yourself unlimited money and, of course, play in God Mode!
You can easily attach garages to your foundation homes when you're building a house in Sims 3! You'll need to open up the cheat editor first, but you only need to enter a few commands to make the garage work with the rest of the house.
Tree sap is hard to get off of things, and Christmas Trees are a great chance for sap to enter your home and stain your possessions and family. Watch this video to learn how to get sap stains out of carpet, clothes, hair, and your car.
If you're involved in biomedical research, identifying gene sequences might form a large part of your job. The NCBI's website contains a powerful search tool called BLAST that allows you to search for matches to any gene sequence you enter, and this video will show you how to use it.
Halloween is one of the best holidays for making them ed deserts, especially ones that can be enjoyed on the go. Enter the ghost lollipop, a perfect synthesis of portability, sweetness, and scariness you can learn how to make by watching this video.
If you enter in your password incorrectly too many times, your iPod will lock. If it locks too many times, you may need to unlock it. This tutorial shows you how to reset your iPod to undo the lock so you can keep using your iPod. This will let you unlock someones password on an ipod or iphone touch.
When setting up your decorations for Halloween, you want to make sure that you create a good spooky atmosphere. A simple effect is putting up signs warning away trick or treaters and "all ye who enter". In this video you will learn how to make an awesome yard sign for Halloween that'll help create the mood for any great decoration set up outside!
Peppers are delicious, but they are usually accent dishes and have a tendency to go bad before you use all of them. Enter the canned pepper. This video will show you how to can any pepper from bell to jalapeno, preserving them for a year.
Do you want an iTunes account, but either lack a credit card or the desire to give Apple your credit card information? Well, there's a way you can get around the part of the iTunes account creation process where you enter your credit card.
Enter your kitchen and bring your laptop, cause you're going to learn how to cook some delicious halibut fish! Watch and learn how to prepare your halibut, including an odd (but yummy) nut crust (in this case, almonds). Then, move out to the patio and heat up the grill to cook the halibut to the perfect temperature atop that cedar wood plank.
A whole new generation, the Millenials as they are somewhat awkwardly called, is entering the workplace and has as a group a different attitude then the previous generation. Many older managers have problems dealing with the younger generation, as they always have. This video offers tips for managers for dealing with Generation Y employees who may seem arrogant and entitled.
There are many benefits to growing your own vegetables and fruits. One of the most obvious is the fact you'll be saving money and preventing any harmful chemicals from entering the body. In this tutorial, you'll find out how to grow one of the most commonly eaten foods out there: potatoes. This time, it's not in a box or planter, but instead in a bag. Check it out and enjoy!
You can create forms on your iPad by using Numbers. You can use the forms to fill in the rows of a spreadsheet instead of entering data into the spreadsheet grid. This can come in handy if you are looking for a quick way to get your job done.
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 384th installment in their series of digital spreadsheet magic tricks, you'll learn how to use an easy go-to/enter keyboard shortcut trip that will allow you to highlight 1000 (100x100) cells.