See how to create value-based formatting using data bars and color scales in Excel 2007. See how to use the Format Cells dialog box and the pop-up mini-toolbar in Microsoft Excel 2007. Whether you're new to Microsoft's popular digital spreadsheet application or a seasoned business professional just looking to better acquaint yourself with this particular iteration of the program, you're sure to be well served by this video tutorial. For more information, including step-by-step instructions, w...
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 and Mr. Excel, the 5th installment in their joint series of digital spreadsheet magic tricks, you'll learn how to create horizontal subtotals for a data set using the IF, SUM and SUMIF functions. Also see conditional formatting for non-contiguous cell ranges using a TRUE/FALSE logical formula with the NOT symbols.
Whether you're interested in learning Microsoft Excel from the bottom up or just looking to pick up a few tips and tricks, you're in the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the 2nd installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to get started using functions and formulas in MS Excel. Specifically, you'll see the different elements of formulas (the equal sign, cell references, math operator...
Whether you're interested in learning Microsoft Excel from the bottom up or just looking to pick up a few tips and tricks, you're in the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the 22nd installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to create a budget with formula inputs in an assumption area and formulas. Then do what-if analysis by saving and showing scenarios. Also see how to save variables...
If you use Microsoft Excel on a regular basis, odds are you work with numbers. Put those numbers to work. Statistical analysis allows you to find patterns, trends and probabilities within your data. In this MS Excel tutorial from everyone's favorite Excel guru, YouTube's ExcelsFun, the very first installment in his "Excel Statistics" series of free video lessons, you'll learn how to get started doing statistical analysis in Microsoft Excel 2007.
Need super fast directions? Google Maps has you covered, but what if you're using your new Motorola DROID mobile device? Could you believe it only takes two buttons to access Google Maps on your DROID? Best Buy has answers. The Best Buy Mobile team explains how simple it is to easily access Google Maps from the Motorola DROID cell phone.
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 33rd installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to sort by color in Excel 2007 as well as how to use the copy and paste tools to extract records. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.
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 5th installment in their series of digital spreadsheet magic tricks, you'll learn how to name a cell range, use data validation to add a drop-down list, and how to use the VLOOKUP function to look up values.
Skype is one of those programs that is not only easy and simple to use, but a great way to keep in touch with loved ones from across the globe. You have a couple different options to choose from when contacting someone. You can choose to have a live camera chat or you can even call them on their cell phone even if they're in a city like Paris! This video focuses on how to add contacts to your Skype account. Enjoy!
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 two-part Excel tutorial from ExcelIsFun, the 564th installment in their series of Excel magic tricks, you'll learn how to create a cell chart using conditional formatting with Logical TRUE FALSE formulas to create a Gantt Chart. Functions used include WORKDAY, AND, NOT, NETWORKDAY.
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...
At one point in time, Tesla coils were actually used for things like wireless telegraphy and electrotherapy, but as technology advanced, they shifted to a slightly more enjoyable purpose—entertainment. What's even more entertaining than using a Tesla coil? Building your own. One of the best portable Tesla coils out there is this mini acrylic version by Daniel Eindhoven, aka TeslaCommander. It's made almost entirely of acrylic plastic, minus the steel sphere, and copper wire and tubing. When t...
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...
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.
