Ignoring Reality Search Results

How To: Use the AGGREGATE function in Microsoft Excel 2010

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 669th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the AGGREGATE function in Microsoft Excel 2010 and later. This new function is better than SUBTOTAL function because 1) the options argument set to 18 will calculate Percentile and 2) AGGREGATE can handle arrays. See how th...

How To: Create augmented reality apps

In this video, viewers learn how to create augmented reality applications, using Papervision 3D version 2.0. Augmented reality is a term for a live direct or indirect view of a physical real-world environment whose elements are merged with virtual computer-generated imagery - creating a mixed reality. To create augmented reality applications, users require the following programs and software: Adobe Flex Builder 3, TortoiseSVN and FLARToolkit. This video tutorial is not recommended for beginne...

How To: Install a printer on your Mac

In this video, Gary from MacMost gives some tips on how to set up a new printer with your Mac. Some printers don't work for Macs, so make sure it's compatible before purchasing it, by checking the internet. Check if a USB cable comes with a cable and buy one if necessary. Ignore the CD that comes with the printer, because it probably doesn't have the correct Mac drivers. Leopard or Snow Leopard systems will find the correct drivers for you automatically most of the time. You might need to dow...

How To: Use the Music Player app on a Samsung Reality phone

Whether you're the proud owner of a Samsung Reality smartphone or perhaps just considering picking one up, you're sure to benefit from this free video tutorial, which presents a complete overview of the phone's various features. Specifically, this video presents a look at the music player in the Reality's Media Center, discussing its Album views, equalizer, skins and homescreen player features.

How To: Multiply decimals together

In this tutorial we learn how to multiply decimals together. Start off by ignoring the decimal points on the equation and just imagining you have normal numbers. Then, multiply the two numbers that you wrote down together. Once you figure that out, it will be time to reintroduce the decimals. Look at the place the decimal is in each number in the beginning equation. Then, add the decimal places together between each of them. From here, place the decimal on the end of the answer you came up wi...

How To: Stop procrastinating by rewarding yourself

In this tutorial, we learn how to stop procrastinating by rewarding yourself. To do this, you should first select one task you've been putting off for a long time. Then, time yourself and give the task one full hour of your time. Ignore everything else you have to do during this time, don't take breaks and let anything bother you. When you are finished with the task, give yourself a reward for completing this job! This will help you finish your task at hand and get things done more effectivel...

How To: Convert numbers in and out of standard form

In this video, we learn how to convert numbers in and out of standard form. Standard form is a useful way of writing down very large numbers and very small numbers. To do this, you will look at the number you have and ignore the zeros that are just at the end. Then, write down the basic numbers. Put a decimal point in this number to make it between one and ten. Now, write down x 10 and put the power for how many places the decimal point moved to get to the new number. This will help you write...

How To: Stop being a hypochondriac

In this tutorial, we learn how to stop being a hypochondriac naturally. Your first step is to put your worry down, and take control of your life. Know that the chance of you catching a disease is small, and you have a full life to live. Ignore your anxieties, fall back to the principles that you are healthy, and live a healthy life. The odds will be in your favor if you take it slow and focus on living a healthy life instead of focusing on the problems and negative thoughts. Don't look up sym...

How To: Use Spellcheck/Thesaurus/AutoCorrect in MS Word 2007

As you type in Microsoft Word, take care to notice when the computer puts a red squiggly line underneath a word you typed. If you see a red squiggly line, the word is spelled incorrectly. If you right-click on the word, MS Word will show you a list of correctly spelled words that it guesses you were trying to spell. If you wish to check the entire document, you can click the Tools tab at the top of the page and then spell check. This will go through the document and point out every misspelled...

How To: Manage email with Conversation view in MS Outlook 2010

In this video David Rivers shows that the conversation look of Excel 2010 has greatly improved. Tracking and managing related emails, saves your inbox space to enable you to manage large number of emails effectively. By default, the conversations are arranged by date. Email interactions will have an arrow displayed. You can easily expand and collapse the conversation. The major improvement is the function of ignoring or clearing up conversation with just a few clicks. The future conversations...

How To: Jailbreak version 3.1.2 iPhone and iPod with Blackra1n

iPodTouchHelping teaches you how to Jailbreak version 3.1.2 iPhone and iPod using Blackra1n. Connect your iPod or iPhone to your computer and make sure it appears in iTunes. You need to go to Blackra1n and click on the Windows icon. Download the program and run it. Click Make it rain in the Blackra1n application. You might get some error messages, just ignore them. The process will finish and the device will reboot. You will see the Blackra1n icon on your device, tap that and select Cydia and...

How To: Make egg pasta with a pasta machine

It isn't intimidating. Pasta machines are common ignored kitchen appliances. You need flour, zero zero flour, olive oil, salt, egg and water. Make a little flour bowl. This dough should be worked with a dough scraper. Go for just enough liquid that your dough is soft, not sticky. It has some body. Practice will help you with kneading. You are working up the glutens to make the dough feel like baby skin. Let the dough rest.

How To: Deal with a traffic ticket & not raise your insurance

In this video tutorial, viewers learn how to deal with a traffic ticket. When you pay for a ticket, don't just ignore it because there is always a hidden cost to a speeding ticket. Speeding tickets may cause insurance rates to go up. To avoid the insurance penalty, users should either go to court or traffic school. Going to traffic school to take the ticket off of your driving record. Another method is to cut a deal with the prosecutor. The key is to keep the points off your record and not al...

How To: Secure a Zyxel P-660HW-t1 wireless router

This video shows how to secure a wirelees internet connection on your Zyxel P-660hw-t1. For this, first click on Start button and open Internet Explorer(or any other browser). On the address bar of the browser, type in the IP address of your router. On the next page, enter your password and on the next page, either change the password or ignore. On the next webpage, under Advance setup, click on Wireless LAN. On the next page, click on 8021xWPA. Select authentication required and then click a...

How To: Reset your iPod Touch

In this video, you will learn how to reset your iPod Touch. In order to do that, just follow these quick and easy steps: Click the power button which is located on the top of the iPod, and, at the same time, hold the home button. Press them for 10-15 seconds. In that time frame, a notification will appear on the screen, but you can ignore it. Continue to hold the two buttons until the iPod will close and reset itself. If you have done these easy steps and instructions like in the video, you w...

How To: Restore iPod Touch from lockout

To restore an iPod Touch from lockout or forgetting a password, pull up iTunes on whatever computer you are using. Plug the USB cord into the iPod touch and plug the USB cord into the computer. The iPod will say "locked out" or "access pass code" and the computer will says that it needs to be synched up to the original program. Hold down the top button and home button at the same time. A message will pop up. Ignore it and let the iPod turn off. Take your finger off the top button and leave yo...