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 559th installment in their series of digital spreadsheet magic tricks, you'll learn how to extract the first, last or nth word from a text string using Excel's SUBSTITUTE, LEN, SEARCH, REPLACE, LEFT, RIGHT and MID functions.
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 562nd installment in their series of digital spreadsheet magic tricks, you'll learn how to extract first, middle and last names when the list contains names where some have a middle name and some do not using the LEFT, SEARCH, LEN, SUBSTITUTE, LEN, MID and IF functions.
Skype is a very cool, useful communications tool that you can download online. This program is free and includes video chats, instant messaging, search functions and various other features.
In this how to video, you will learn how to unlock your iPhone 3G 3.0 firmware with Ultrasn0w. First, turn on your device and go to Cydia. Click manage and sources. From here, go to edit and click add. Enter repo666.ultrasn0w.com here and click add source. Once that is done, go back to Cydia. Go to search and look for Ultrasn0w. Click install and confirm to install it. Now you have Ultrasn0w installed. Reboot your iPhone. Next, insert your SIM card. Go to your settings to confirm that the SIM...
In order to Find, Replace, and Sort, using MS Excel, become familiar with your home tab. When you click on Sort, it will give you the opportunity to sort in different ways: e.g. alphabetically. If you accidentally shift your table, you can undo it by using Ctrl + Z. Custom Sort will allow you to be very specific in the way you want your data sorted. You can add or remove a filter with the same drop down menu, in order to be even more precise.
In this video tutorial, viewers learn how to pan for gold. Users will need a gold pan. Begin by add some dirt and rocks into the pan. Then pan has ridges that will keep the gold in the pan. Dip the pan and fill it in some water. Now gently shake the pan from side to side for 20-30 seconds. The gold will sink to the bottom as you shake. Then slightly tilt the pan forward to pour out some water as you're shake the pan. This video will benefit those viewers who are interested in searching for mi...
In this Electronics video tutorial you will learn how to use the browser on the Blackberry Storm 9500. To use your browser, select browser from the main blackberry menu. This will bring up your bookmark and the history of your previously visited websites. There is also a handy Google search bar. Type in the address of the site in to address bar at the top. Once the page loads, you can view it in landscape or portrait format by moving the handset. To zoom in and out, use the magnifying glass "...
In this Computers & Programming video tutorial you will learn how to format/partition an external hard drive on a Mac. This is really very easy and simple to do and takes practically no time. Click on spotlight search and look for disk utility. That will bring up the list of hard drives. Click on the external hard drive and click ‘erase’. Then on ‘security options’ select ‘zero out data’ and click OK. This will remove everything from the hard drive. Your external hard drive is now...
First you have to open your internet browser and then go to Google.com. Then search for "outlook connector download". Go to the top hit it gives you go to the site. Scroll down to where you can download the outlook connector and pick the top one of the two there. Run the file and agree to the terms and conditions. Run the install and once it is finished installing open up Outlook. Click next and input your hotmail user name and password. Enter the name you want to appear on emails sent, click...
Wayne with Vodafone Help Centre demonstrates how to use the application center on a Blackberry Storm 2 phone. First tap on the Blackberry key to bring up the main menu. Then choose the application center option. Click yes to update the application list. Choose app world and install it on your phone by downloading it. Then, click run and accept the software agreement. You now have access to the Blackberry app world. You can search for the applications that you want and filter the results by pa...
This video shows how to hack the computer password for Vista. We can change the computer password without knowing the actual password. First go to Start menu. Type in the Search "cmd". Then right click on that folder and run as administrator. Then we get a pop up. Type in their net users. Pick the user that we want to hack into. After picking the user type in net user the username and then * . After typing this hit enter key and it should say the command completed successfully and we have to ...
In this Computers & Programming video tutorial you will learn how to send a bulk email using Gmail. Go to www.download3000.com , search for ‘smartserialmail, download and install it. Open it up and create a profile by giving it a name, fill in the email address you are going to send messages from, your display name and the reply email address. In the last box type in ‘smtp.gmail.com’. Then click on advanced settings, type 465 for the port number, check the first and the third boxes, typ...
This videos is a tutorial for using custom FBML coding on facebook fan page.The video begins by logging into facebook account.Then go to the search bar at the upper right hand corner and tpe "static fbml" and hit enter.This takes to the application page and click on "add to my page" below the default fbml picture.A window opens up showing a list of user pages and after selecting the page click on "add to page".Close the window and go to your fan page and click on "edit page".This shows a list...
In order to install Windows 7 from a USB drive, while you are running XP, you will need a pen drive. You will also need a Windows 7 DVD and a pen driver.
In this Computers & Programming video tutorial you will learn how to run a Windows app on a Mac OSX using Crossover. Search for the program, download and install it. Open the program, go to configure and then to manage bottles. Then click on the little ‘+’ button, name your bottle, select a version of windows and click ‘create’. This will take a few minutes to create the bottle. Now click on applications > install software. In the crossover software installer window, click on ‘insta...
In this Computers & Programming video tutorial you will learn how to update websites from Firefox with the FireFTP add-on. Go to the Firefox add-ons page, search for FireFTP, add it to Firefox and install it. Restart Firefox to activate the add-on. Go to tools and click on FireFTP and that will open up a new tab with the FTP client. To configure the FTP to your account, create a new account by giving it a name. The host will be your domainname.com and use the login and the password for the ho...
1. Go to Control Panel from the start menu and select Uninstall a program. 2. Start Menu>Control Panel>Uninstall a Program
In this video, learn how to take exercises from the barre and take them to the center floor. Ballet dancing incorporates several positions and steps that combine to make interesting choreography. Learn a ballet routine from an expert: Lynda DeChane-Audette is the founding artistic director of the South Florida Ballet Theater and was born in Boston. Learn more ballet from this expert by searching WonderHowTo! You're only practice time away from ruling the dance floor!
Looking for a way to stop the clock and game your Bejeweled Blitz score? Check out this video tutorial to learn how to hack Bejeweled Blitz (04/11/10) with a Mozilla Firefox extension, which will teach you to do just that.
So, you want to be a hip hop dancer? Well, you need two things according to this expert: swagger and confidence. It's important to project these two qualities when hip hop dancing. Find out what else is takes to dance hip hop style with guidance from these two pros: Bliss & Zetta are professional hip-hop dancers and choreographers. Learn more dance moves from these two by searching WonderHowTo! You're only practice time away from ruling the dance floor.
Get started on the dance floor creating belly dancing routines with the help of layering. When layering various techniques and moves in belly dancing, perfect each individual movement before combining them together. Get closer to master a belly dancing routine by layering movements with this instructional video conducted by an expert: Yasmeen began dancing at the young age of 3 and studied ballet, flamenco, folkloric, hip-hop and modern dance styles, as well as tribal fusion belly dance and O...
In this free intermediate tape dancing lesson, several combinations of tap shuffles are gone over including the three-shuffle, front-side-back shuffle, and the shuffle ball change. Learn how to do these combos with help from an expert: Bonnie Gray is an award-winning choreographer in dance and musical theatre and here to teach you the basics of tap! Learn more tap dancing dance moves from this expert by searching WonderHowTo! You're only practice time away from ruling the dance floor!
If you're hoping to blow away Michael Jackson's moonwalk, you better be prepared for practice! In this video, learn from one expert how to dance the moonwalk like the King of Pop. Master the moonwalk dance with guidance from this video.
The moonwalk has been written in history and will go down as one of the most well-known dance crazes next to the Macarena and the jitterbug. In order to moonwalk like Michael Jackson, it's important to focus on the pivot and push of the feet and legs while sliding. Make your moonwalk smooth with the tips and tricks given in this free dance lesson.
This will illustrate us how to use the reverse auction site Dubli. Here are the following steps.Step 1: First of all enter the link and log onto the official website of DubliStep 2: Now you will find various options on the homepage of Dubli.Step 3: go and click the option of auction option.Step 4: The various product that are for auction will be displayed.Step 5: Search for the product that you want to auction for and enter the amount that you pay for the product and press the go button.Step ...
Love4Nails shows viewers how to paint nails with an aqua bohemian flower design. First, you want to apply a light blue nail polish as your background. Next, get a makeup sponge and brush green nail polish on this sponger. Place this green on the bottom part of your nail only. Now on the top, use your same makeup sponge and apply white nail polish on the side top of your nail and a little over the green. Next, use a shimmer polish and apply this over both the green area and the light blue area...
This video is about how to download movies, music, and software using torrents. The first thing that you will have to do is to download either uTorrent or BitTorrent. After you have download either of the two, go ahead and browse for a torrent website. After you have found the torrent website that suits you best, just browse or search for the file that you want to download. A list will appear, then you just have to look at the most number of seeds since this increases the speed download. Also...
In this video tutorial, viewers learn how write a resume in the table format. A table formatted resume is one of the most effective formats. It highlights metrics in a particular field that potential employers are looking for in a presentable quick overview. At the top of the table, provide your name, contact information and location. In the table, list your skill, experience, role and products from each of your previous jobs and experiences. This video will benefit those viewers who are sear...
In this video tutorial, viewers learn how to automatically play You Tube videos on My Space. Begin by going on the You Tube website and search for a video that you want. Then copy the embed code and paste it in a notepad document. There will be two URLs in the embed code in quotations. Type in "&autoplay=1" at the end of both URLs inside the quotations and then copy the embed code. Log into your My Space account and click on Edit Profile. Paste the embed code into the About Me section and cli...
The first thing to do to install tune-up utilities on Windows 7 is to, go to Google and search tune up utilities. Then you scroll down to CNET download website and click download now. After you clicked it hit save file and wait for it to load. After you finished downloading it in that box right click it and choose open containing folder. Then drag the file to your desktop and right click on the folder and go all the way down to properties. Once you are on to it go to compatibilities and check...
First of all you have to open your internet browser. Now you have to type in mYouTube. Now you have to type in 'psps3psn' in your browser and then click 'enter'. Now you have to select the first search item. This shall ask you to watch ‘YouTube’ video on your ‘PSP’ (slim or ‘phat’) with an official ‘firmware’. There is no need of computer, only your ‘PSP’ and internet connection are required. Now when you click on to it, the video link shall be opened in a new browser. You have to click on 'd...
In this video tutorial, viewers learn how to bypass web-sense filter using the software, Hopster. This program allows users to bypass firewall, bypass proxy and HTTP tunnel. To download this program, go to Google and search for the program. Click on the first result and select download. Once the file is downloaded, double-click on it and follow the instructions to install the program. This program runs silently and invisibly so that the administrator won't be able to detect it. This video wil...
This video is about how to install custom fonts on XP. The first thing to do is to open your browser and type "fonts" in the search bar. Several sites will appear and just simply click on any of the websites. Once you have found the site that suits you best, just start looking for fonts that you may like. And if you already have found a font, just simply press download then save it in your computer. Once you have saved it, other files need to be extracted so just simply extract it. After extr...
Learn how to draw a ‘Fake Tattoo’ using a ballpoint pen and some colored highlighters, by watching this video. Begin by drawing a faint design of your choice at the back of your palm, using a ballpoint pen. Darken the outlines when you are done with the image drawn. Now according to your choice, fill colors in the drawing using colored green, blue, yellow and pink highlighters. Begin with the yellow color and blend it together with the other color applied in each area, using your fingers. Use...
This video tutorial from JdudeTutorials presents how to download a torrent for the first time.To start, open your Internet browser. Browse to utorrent web page.Download and install uTorrent client version, suitable for your operating system (MacOS or Windows).Once you've installed application, browse to The Pirate Bay.This is the largest torrent source in the world.Check Video option under the search bar and type family guy (as an example).Click Enter. A list of torrents connected to family g...
Dr. Jailbait shows the viewers a new device called Smoothboard. With Smoothboard installed the Springboard will not lock while scrolling through your apps. It allows you to scroll and stay in between pages for your apps. You can scroll through multiple pages in one swipe, as opposed to it freezing on each page. To get this, open up Cydia. Go to search and type in Smooth B. Smoothboard from Big Boss will appear. Click on it and then click install. Once it finishes installing, your device will ...
In this video tutorial, viewers learn how to find an I.P. address. Every computer that has Internet connection has a unique identifier called a Internet Protocol Address. This video provides 2 methods on how to find your I.P. address. The first method is to simply open your web browser and search on the Internet. The second method is to click on the Start menu and select Control Panel. Click on Network and Sharing Center. Right-click on your connection and select Status. There, users will be ...
This video tutorial in Computers & Programming category will show you how to delete temporary files in Ubuntu, Linux Mint or Debian. For this you will need the program called bleachbit. You could get it from Bleachbit Sourceforge/ or from Synaptic package manager. For synaptic manager, click on ‘package manager’ in the ‘start’ menu and log into the program by typing your password. Then search for ‘bleachbit’, download and install it. Go to ‘terminal’, type in ‘su’ and enter, then type in your...
Madman McClinton demonstrates how to browse the internet on an Xbox 360 using the MCE browser. First, download the MCE browser by doing a Google search and clicking on the first link. Next, install the MCE browser on your system. Then, connect your Windows Media Center to your Xbox. Then, go to your Xbox and open up the Windows Media Center. Select the program library function from the online media option. Next, choose the MCE browser from the available choices. Enter your desired URL into th...
Charles M., an attorney and bonsai cultivator, demonstrates how to transfer a field grown Japanese Black Pine that is ready for training. A 5-gallong nursery specimen was purchased and planted in the ground with a bonsai compound soil to keep its roots close and compact during trunk thickening. The tree was allowed to grow for three years, with the main foliage under four feet, but with two “sacrifice” branches allowed to shoot out without trimming. One sacrifice branch at the top of the tree...
