New to 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 Excel tutorial from ExcelIsFun, the 293rd installment in their series of digital spreadsheet magic tricks, you'll learn two cell formulas and a named formula that will dynamically count unique words in a column. As you add new records, the count will automatically update. This is accomplished through use of Excel's MAX, ROW, OFFSET, SUMPRODUCT, ISTEXT and COUNTIF f...
Microsoft excel is a powerful tool used to work with numbers and data by filling them down in rows and columns of a table. Excels also supports macros, which are small scripts to automate certain functions. In Microsoft Excel you can select entire rows and columns using the range property. You can also use macros to select individual rows and columns as well as multiple variations of rows, columns, and individual cells all at once. In Excel a horizontal line of data is called as row and a ver...
Mike Callahan will show you the tricky process of changing the screen timeout on your Android cell phone. While some people like their screen to black out right after they finish using it others prefer it to stay lit for a while. Mr. Callahan shows you how to change the setting regardless of how you like it. First tap on settings. Next, tap on sound and display. Then, you are going to want to scroll down until you get to screen time out. After selecting the screen time out option, you will ha...
1.Here 10-50 and 300-400 numbers are taken for example to generate the random numbers within the limit in Excel. We using the command of "randbetween" for generate the random numbers and we won't get the decimal or fraction values.2.Now type "=randbetween(10,50)" which means to generate the random value between the bottom value of 10 and top value of 50 and click enter now we will get 11 as random generated number.3.Do the same thing for 300-400 as "=randbetween(300-400)".You will the 303 wil...
New to Excel? Looking for a tip? How about a tip so mind-blowingly advanced as to qualify as a magic trick? You're in luck. In this Excel tutorial from ExcelIsFun, the 315th installment in their series of digital spreadsheet magic tricks, you'll learn how (and when) to use the SUMIF & SUMPRODUCT functions.
New to Excel? Looking for a tip? How about a tip so mind-blowingly advanced as to qualify as a magic trick? You're in luck. In this Excel tutorial from ExcelIsFun, the 477th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a Gantt cell chart using conditional formatting. This is accomplished with recourse to the WORKDAY.INTL, AND, NOT & NETWORKDAYS.INT functions.
Learn how to get free Redbox DVD rentals. Redbox movies can be found in large stores, usually supermarkets, where you can rent a movie, and return them to the same box when you are done. In order to get the free movie, you must obtain a code, which you will enter during the rental process. On the website, sign up for what is called "Free Movie Monday". Redbox will send a code to your cell phone on the first Monday of every month. One thing to remember is to not be late returning the movie, or...
Open Microsoft Office Excel. Across the top notice letters (columns), along the sides are numbers (rows). The columns and rows can be extended by highlighting sections and right clicking and choosing the high of the row. You can also select to add a border, and change the orientation of your cells.
Robert Scot, from ModernMom, shows viewers how to shrink an enlarged skin pore. Scott reminds us that genetics and aging do contribute to enlarged pores and skin condition, but there is still a way to deal with this. There is no way to permanently shrink enlarged pores but you can handle them with time. You can use cleansers and exfoliation to do the trick. Your cleanser should be for oily skin that will naturally purify your skin. You really want to focus on exfoliation and use exfoliates wi...
Watch this science video tutorial from Nurd Rage on how to make copper sulfate and zinc batteries. They show you how to make the classic copper sulfate and zinc battery using the incredibly easy "gravity" battery design approach. Great for science fairs and similar projects this battery can be used to explore many basic concepts in batteries.
This easy-to-follow video tutorial walks you through steps of converting old VHS tapes to DVD. Roxio Easy VHS to DVD is a combination of software and hardware that allows you to easily and quickly digitize old analog recordings. You simply attach the included hardware to a free USB 2.0 port on your computer, then capture from virtually any analog video or audio source.
An emergency battery charger for your mobile phone comes in handy, but it's not the ultimate solution; once it's dead it's useless (what a waste). If you want to really get off the metaphorical grid, you can follow the steps in this video to construct a more robust circuit that will not only bail you out of an inconvenient situation but also recharge in between uses. The simple addition of a low voltage solar panel and rechargeable batteries makes this possible. Enjoy!
This video from AT&T describes the process for giving your original iPhone to someone else when you buy iPhone 3G.
Watch this video tutorial, and learn how to turn an ordinary inexpensive webcam into a hidden home security system, viewable anywhere in the world from your cell phone! With a cute and cuddly teddy bear and a cheap webcam, you can make the perfect homemade security camera, or just a camera to spy on your sister and her friends during sleepovers. Follow along with the steps in this how-to video and learn how to set up this spy system. Note: this video is NOT recommended for people who are perv...
In this series of cooking videos you'll learn how to cook French fries in duck fat. Expert chef Brandon Sarkis shares his recipe for duck fat fries, showing you how to make them in easy-to follow, step-by-step instructions.
The new Samsung Galaxy Tab isn't a cell phone, but that doesn't stop you from making phone calls! With this Android tablet, it's a breeze to make phone calls. Just hit the PHONE icon on the homescreen and dial your number. Press CALL and wait for the connection. You can MUTE the mic, use a HEADSET or MINIMIZE the dial pad. See how!
If you want to save some money on an iPod holder, you might want to watch this video tutorial. You will learn how to make a cool iPod holder out of a sock. It's very easy to do and more importantly... it will save you money. You can even use that dirty, raunchy, gym sock to protect your iPhone or other cell phone too! Really though, make sure you wash your socks before making this iPod protector. You may not be protecting the ingenious mp3 player is you don't.
Want to set up WiFi tethering on your rooted T-Mobile G1 cell phone? How about save space by moving apps and onto your phone's SD card? Multi-touch? It's easy! All you have to do is install a custom ROM! Learn how to load a costom ROM onto your T-Mobile G1 Google Android smartphone with this six-minute mobile phone hacker's how-to.
Cleopatra was not modest about makeup. After all, this was the woman who bathed in tubs filled with rose petals and milk (a good idea even today, if extravagant, since lactic acid exfoliates dead skin cells), invented perfume, and always wore makeup.
This video tutorial is in the Education category which will show you how to make sodium bromate and potassium meta-periodate. This experiment uses toxic chemicals and releases harmful gases. First you have to make a saturated sodium bromide. To this solution then add a small amount of potassium dichromate. The solution now becomes concentrated. Then make the circuit as shown in the video. You need a 3 - 5 ohm resistor in order to reduce the current. Then let the cell run for around 6 hours. S...
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 722nd installment in their series of digital spreadsheet magic tricks, you'll learn how to calculate gross pay for the week from time values using the SUMPRODUCT function. Also see what to do if you get a #VALUE! error from blanks in cell using the IF function and an array logical test.
Interested in rooting your Sprint HTC Evo 4G Google Android smartphone but aren't sure how to proceed? Never fear: this three-part hacker's how-to presents a complete step-by-step overview of the rooting process. For the specifics, and to get started rooting your own HTC Evo 4G cell phone, take a look.
In this clip, you'll learn how to use layer styles, blending modes and cell pattern effect to create a fun, glamorous pre-roll sequence in Adobe After Effects CS3, CS4 or CS5. Whether you're new to Adobe's popular motion graphics and compositing software or a seasoned video professional just looking to better acquaint yourself with the program and its various features and filters, you're sure to be well served by this video tutorial. For more information, including detailed, step-by-step inst...
Despite the discontinuation of Microsoft's KIN mobile phones, some still have a KIN ONE or KIN TWO cell phone. Actually, it can probably be found on the market somewhere for a relatively cheap price. Almost too cheap.
The prank is one of the most cherished traditional forms of expression around the world, from Japan to the Middle East to the good ol' US of A. Without them, how would people settle their disputes with one another while having a good laugh at the same time? Every time a new phenomenon enters our lives, new pranks emerge that can be performed with it. We at Wonderhowto love pranks as much as anybody, and to that end we've scoured the internet for videos demonstrating the proper setup and execu...
This video tutorial belongs to the Beauty & Style category which is going to show you how to wear a wrist watch. These days not many people wear watches. They find out time with their cell phones. If you want to improve your image, wearing a watch will help. If you are going for a job interview or on a date, you should wear a watch. Because watches co-relate to responsibility and hence project a better picture of yourself. A solid stainless steel watch is universal and matches with formal as ...
In this tutorial, we learn how to calculate and add running percentages in Excel. First, write out your value and percentage into the different columns. Next, write the formula in the cell where you want the answer to appear. To have the answer appear, highlight the box and drag it down, then the answers will start to appear in each of the different columns for the different equations. This is an extremely simple way to calculate these percentages without having to do any math! As long as you...
In this tutorial, we learn how to use templates in Dreamweaver. First, go under "create new" and click on "hdml". Start with a table that has three rows and one column at 100% width. Click in the middle one and split the cell into two columns. Now, click "insert", "template objects", then "editable region". Type text into this box, then it will show up on your page. Whenever you open a file, this will be the part you can edit, while you won't be able to change anything else. Now go to "file" ...
In order to do the resting crocodile pose, you will need to lie on your stomach. Separate your legs. Space your legs greater than hip distance apart. Your toes should be pointed. Cross your arms. Your arms and chest should form a triangle with the floor as the base. Rest your head on your hands and breathe deeply. As you inhale this will work your lower abdominal muscles, while it sends more oxygen to the cells of your body. This pose is a recommended pose for anyone who is rehabbing muscle o...
To use yoga exercises to wake up and stay awake at work, begin by doing breathing stretches: i.e. cow to cat stretches. Inhale, expanding your chest out for the cow stretch, and exhale concaving your chest into the cat stretch. Next, do side stretches from left to right. Repeat these. Next, add 4 punches: left jab, right jab, undercut, and undercut. Extend your arms fully. Repeat all of the steps together.
Hordes of women live and die by their Clarisonic brushes, which they claim speeds up their cell turnover rate and decreases hyperpigmentation as well as old acne scars, creating fresh, youthful skin. But Clarionic newcomers may find this vibrating brush to be a little intimidating.
In this video, learn how to access a computer program online that will allow you to convert your MP4 files to basic MP3's. This is great if you would like to download items via iTunes but do not want to play them on an Apple product. For example, if you use a Zune, non-Apple MP3 player, cell phone or any other device to listen to music, you will need to have these files saved as MP3's. Follow along and learn exactly how to do this.
There's a new way to shop, and it's called your phone! On an Android mobile device, there'a handy shopping application called Shop Savvy, found in the Google Marketplace. Okay, so you can't actually buy things with it, but you can scan barcodes of products to get more information about them, making shopping in the mall so much easier. But how do use it to buy everything you want? Best Buy has answers. The Best Buy Mobile team explains how simple it is to use the Shop Savvy app on your Android...
If you're a novice looking to learn how to use Microsoft Excel, a video series from digital spreadsheet guru ExcelIsFun is a great place to start. But which of his many series should you choose? The one titled "Excel Basics," that's which! This free video MS Excel lesson, the very installment in said tutorial series, covers the following topics:
Are you a major networker with a cell phone full of digits? Are you horrible at remembering names and often times look at incoming calls with a look of confusion? There's a way to remember them from this day forward. Once you get a number, snap a picture of them and set it up as their caller ID. When calling, their photo will appear giving you a hint who it is! In this video courtesy of Best Buy Mobile, learn how to set a photo as caller ID.
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 532nd installment in their series of digital spreadsheet magic tricks, you'll learn how to count blanks in a dynamic range using the COUNTIF, INDEX, MATCH, COUNTA and OFFSET functions. Learn about the difference between an empty cell and a blank. Also see how to create dynamic ranges with INDEX and OFFSET (Index:Index).
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 28th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use the INDEX, RANDBETWEEN, COUNTA, IF, AND, & VLOOKUP functions together to select a random employee from a list, determine if they have meet the given criteria and then conditionally format the relevant cells according to the result. Learn to love digi...
This how to video shows you how to sort data in Excel in a custom order. First, open a spread sheet in Excel. Select a column of cells with words that you want sorted. Click the office button and select Excel options. Go to edit custom list. You will see different custom lists. Click import to import your selection as a custom list. Next, you can go back to a sheet with those words that you want sorted and click the sort command. Select custom list on the order tab and select your new custom ...
To sort data in Excel spreadsheets, have each category (for example, first and last names) in a single column. Click on any cell in the column you wish to sort. Be careful not to highlight the entire column, or results will be sorted only in that column. Click on DATA on the ribbon at the top. To sort in descending order, click on the z-a button. For more detail, click on the main SORT button, and you can specify which columns you want sorted and how. For instance, you can sort by descending ...
First, open the Excel worksheet you have previously created that you would like to create a table for. Click on any of the cell that contains data for your table. On the menu found on the upper portion of the application, go to the Insert Tab. Find and click Table. Your entire worksheet will now be selected. When a prompt window appears, click OK. Your table should now be created automatically.
