Are you looking for a way to make your Microsoft Excel formulas simpler, faster and more efficient? If so, you're in the right place. With this free video lesson from everyone's favorite digital spreadsheet guru, YouTube's ExcelsFun, the 3rd installment in his "Excel Formula Efficiency" series, you'll see how the Excel 2003, 2002, 2001, 1997 Database D functions (DSUM, DAVERAGE, DCOUNT) are much faster than SUMPRODUCT and SUM array formulas.
Are you looking for a way to make your Microsoft Excel formulas simpler, faster and more efficient? If so, you're in the right place. With this free video lesson from everyone's favorite digital spreadsheet guru, YouTube's ExcelsFun, the 7th installment in his "Excel Formula Efficiency" series, you'll learn how to use a helper cell to remove a time-consuming (expensive) section of your formula to speed up calculations.
Are you looking for a way to make your Microsoft Excel formulas simpler, faster and more efficient? If so, you're in the right place. With this free video lesson from everyone's favorite digital spreadsheet guru, YouTube's ExcelsFun, the 7th installment in his "Excel Formula Efficiency" series, you'll see how a helper column with concatenated fields can dramatically reduce the time a formula takes to calculate.
Are you looking for a way to make your Microsoft Excel formulas simpler, faster and more efficient? If so, you're in the right place. With this free video lesson from everyone's favorite digital spreadsheet guru, YouTube's ExcelsFun, the 9th installment in his "Excel Formula Efficiency" series, you'll learn see two running total formulas, one that is faster than the other.
Are you looking for a way to make your Microsoft Excel formulas simpler, faster and more efficient? If so, you're in the right place. With this free video lesson from everyone's favorite digital spreadsheet guru, YouTube's ExcelsFun, the 10th installment in his "Excel Formula Efficiency" series, you'll learn how to use Manual Calculation for huge spreadsheets so that recalculation only occurs when you want it to occur.
This dish is perfect for Thanksgiving and Christmas. It's a simple and easy to make side dish that goes well with any kind of meal, and is sure to keep others coming back for more. Now, although this tutorial doesn't follow the traditional methods of making green bean casserole, it doesn't mean that it's wrong at all. Everybody has their own unique style, and in this case the creators of the video decided to add some tasty bacon. So enjoy this tutorial and good luck!
Playdough is a fun toy for any age, but it can get expensive, and even though the package says it is non-toxic, how do you know exactly what is in it?
Face it, nothing in this world is perfect, especially computers. When it comes to these compact and sometime sportable devices, problems can occur almost frequently due to a number of reasons. In this tutorial, you'll be focusing on how to get out a certain issue on a Mac computer. If you ever find yourself confronted with the 'rainbow wheel of death' this tutorial could help you out. Just like ctrl+alt+delete, this method can be easier to use on a Mac and take little to no time at all. Find ...
NeaceDesign explains an easy method of setting up a website online without having to use FTP programs. He begins with correcting an error made previously in which the main web page was name 'Home'. This should be renamed to 'Index' and the file re-exported. NeaceDesign suggests going with well-known web-page hosting services such as 'hostmonster'. The first step is to go to File Manager and upload the image files to a new folder. This is done by sending all the files to a zip folder and then ...
This video tells us the method to partition the external hard drive for Time Machine. This process consists of a couple of steps. In the first step, go to 'Finder'. The second step involves clicking on the 'Applications' option on it. After choosing the 'Applications' and go to the next step involving going to 'Utilities'. Choose 'Disk Utility' from the options displayed. This step will open a new window. Choose the hard drive on the window opened after choosing 'Disk Utility'. Click on the '...
In this video tutorial, viewers learn how to create fog using Adobe Photoshop. Begin by importing the image into the program and duplicate the image. Now go to Filter, select Blur and select Radial Blur. Set the amount to 100, Blur Method to Zoom and Quality to Best. Now select the rectangular marking tool and select the sky. Then open the Hue/Saturation menu and set the Saturation to -100. Use the eraser tool to remove the gray from the edges. Now use the paint tool and paint white streaks o...
In this Software video tutorial you will learn how to sharpen blurry images using Photoshop. Open the image and duplicate the original layer. Then go to filter > other > high pass. In the window that pops up, enter a value of 4 – 6 pixels. Now simply change the blending mode of that layer to overlay by clicking on ‘layers’ and selecting ‘overlay’ from the dropdown menu. You will notice that you have a much clearer picture. Then go to filters > sharpen > ‘unsharp mask’ to add som...
This video shows us the method to find the median and the inter-quartile range. The first step involves the arrangement of the numbers in the ascending order. Median is the middle number. The middle number is the number at (number of numbers + 1)/2 if the number of numbers is odd or the (number of number)/2 if the number of numbers is even. In the example the number is located at [(11+1)/2] or the 6th number. The inter-quartile range is higher quartile - lower quartile. The higher quartile is...
This video shows you how to remove a tattoo from a photograph using Photoshop. First, select the tattoo using the pen tool, to get a very accurate line around the tattoo. Make sure the "Paths" button is punched in. Drag the mouse and click several times to make a path around the tattoo. Right click on the path and choose "make selection". Feather the selection with a feather radius of about 8 pixels. Use the clone stamp tool and a large size brush. Hover outside the selection and click to sam...
This video shows us the method to use Blackberry email more effectively. Firstly, let us go to the place for typing your emails. Click on the leftmost icon at the bottom of the home screen. Now press the button on the left side of the track ball and choose 'Compose Email'. Now, if you want to enter your phone number in the body of the email, type in 'Mynumber' and then the press the space bar. You will now see your mobile number in the body of the email. Enter 'Mypin' for displaying your Blac...
This video is a demonstration of two ways to tie your shoes. The first method is as follows. Cross the two strings over each other, tuck one under the other, and pull it to tighten. Make a look with one string, then make the same loop with the other string. Cross the two loops, take one of the loops and tuck it in the hole between the two strings, and pull it. The second way starts the same as the first. After you have the first knot, make one loop and hold it with your thumb and index finger...
In this how to video, you will learn how to crack a WPA encrypted wireless network. To do this, you will need the Air Crack package for Linux. First, disable the wireless adapter and enable monitor mode. Next, identify the channel in the wireless network and Mac address. Once you have this, you can listen to the traffic coming to and from this point. Wait for the handshake or disconnect something in order to force it to reconnect. From here, you are ready to perform the attack. With any encry...
Multi-Step inequalities are inequalities which take more than one step in solving them. You need to follow a step by step approach in solving these kind of problems. Through there is no general method to solve them you can follow a set of guidelines. First thing you have to do is make sure that only x terms remain on the left hand side of the equation. If there are any other numerical terms add the negative of that term to both the sides of the equation to eliminate it on the left hand side. ...
This video shows us the method to block the formula bar, scroll bars and the status bars in Excel. Click on 'Start' and type 'regedit'. Click on 'regedit' and go to 'HKEY_CURRENT_USER'. Open it and go to 'Software' and 'Microsoft'. Expand it and go to 'Office' and open the version of Office on your computer. Expand it and go to Excel. Choose the options folder. Go to the 'Options' item and right click on it. Go to 'Modify' and type 150 in the text box. Click on 'OK'. Now restart the Excel and...
This video shows us the method to transfer files between iTunes libraries in iTunes 9. First step involves downloading iTunes 9 from apple.com. Go to the 'Edit' tab and 'Preferences'. Go to the 'Sharing' tab and select the 'Share selected playlists'. Select the playlists you want to share and click 'OK'. Now go to 'Advanced' and select 'Turn on home sharing'. Make sure that both are under the same account. Type in the password and you will see an icon in the shape of a home in the left side. ...
This video shows us the method to use iPad as a touchscreen monitor for your Mac. You have to use iDisplay available on app store. Start the application on your iPad and Mac. Tap the server on your iPad and on the Mac click 'Confirm' to connect it to iPad. Hit 'OK' on iPad. Now you can open a window on the Mac. You can drag the window out of the Mac screen on to the iPad. Now it will act as a touch screen. You can use all the touch screen features of iPad for this window. You can drag the win...
This video teaches us the method to create PDF in OS X. The first step involves opening up the document which you want to convert to PDF. Go to 'File', 'Print Preview'. Select the magnification of the document. Check to see whether the whole file is there or not. Go to 'Print' option under the 'File' drop down menu. Go to the 'PDF' tab at the bottom of the window. Choose 'Save as PDF X'. Write the name of the file in the space provided in the dialog box. Choose 'Desktop' as the destination of...
This video shows us the method to make simple GIF animations in Photoshop Elements 6. First we have to make a file with different layers. Click on the icon below the 'Layer' option to make a new layer in the file. After finishing the file, go to 'File' and the 'Save for Web' option in it. On the right side of the window, select 'GIF' as the file type. Check the 'Animation' option. Check 'Loop' to play the file again and again. Click 'OK' and the window to ask you the name of the file will be ...
This video shows us the method to make a spinach omelet. First put about half packet of spinach in a pan and heat it. Cover the pan with a lid and let the spinach reduce. Heat the pan until most of the water in the spinach is gone. After cooling the resultant spinach, put it in the egg and mix it. Put this mixture on the frying pan on a very low heat. After one side of the omelet is ready, flip it into half. Press the omelet from the top so that the uncooked egg comes out and seals the omelet...
This video shows the method to make a line graph. First step involves drawing a horizontal and vertical line joined at one end. We have to plot the maximum and minimum temperatures during 5 days. Label the vertical with the temperatures(10, 20, 30...50) and the horizontal line with the days of the week(Monday....Friday). Label the vertical line as 'Temperature' and the horizontal line with 'Day of the week'. Plot the temperatures selecting the day from the horizontal line and marking at the c...
This video tells us the method to decorate an angel food cake with cranberry garnish. Cut the cake into half horizontally by using a serrated knife. Remove the upper portion of the cake. Mix together half cup of raspberry jam and two teaspoons of orange peel. This mixture is spooned over the top of the lower portion of the cake. Put the top of the cake back on the lower portion. Take 8 ounce of whip topping and apply it to the outer portion of the cake. Now, take frozen cranberries and thaw t...
Nick Spadaro shows how to make a fire with a fire piston. This device creates fire by compression, just like a deisel engine. You can find these online. Lubricate the gasket with just about anything, including chapstick or animal fat. Then put it in and make sure you have a nice fit. Pick your tender, preferably birch tender fungus, a nice spongy material. Put it in the piston, and put the piston on your leg. Your going to want to strike the piston sharply, straight down, so as not to break t...
In this Outdoor Recreation video tutorial you will learn how to abseil (decend) in rock climbing. You will need some friction device for this purpose. Earlier people used to wrap the rope around their body and used the body as the friction device. That is a painful process. In the modern method, a figure 8 friction plate is used. There should be no jewelry or other hanging material around the body that can get entangled with the figure 8 plate. Also check the harness is OK. Then carefully go ...
This video shows the method to turn off pop-up blocker in Internet Explorer and Firefox. Firstly, open Internet Explorer and go to 'Tools' option. Go to 'Internet Options' and click on the 'Privacy' tab. You will see an option of 'Block pop-ups' at the bottom of the window. You must uncheck it and hit 'Apply' to turn it off. For Firefox, go to 'Tools' and 'Options'. You will see 'Block pop-up windows' as the first option. Uncheck it and the pop-ups will not be blocked. You can also set except...
Marie was asked by a viewer how to go about being more orally engaging with other people, as most attention he gets is attributed to the fact that he is very quiet, which doesn't sit well with him. Just like anyone else, he would like to get attention for the things he says, not for being quiet! He is under the impression that "cramming," or being knowledgeable on current events and other trivia will give him more to talk about and thus help him to be more talkative. Marie suggests, though, t...
There are various ways to remove the timestamp on your photos using Photoshop. You can use the crop too and crop out the photo, but then you'll lose parts of the photo as well. You can use the patch tool, and draw a border around the date, then drag the date to another area, let go and press ctrl+D. The time will disappear and the area will be patched up with surrounding colors. Another method is to use the spot helium brush tool, and simply just brush over the text, and the spot helium brush...
This video demonstrates us the method to throw a boomerang. Firstly, hold the boomerang properly. It should be done by holding it in your hand from one of its arms. Hold it vertically at an angle to the ground. The hand, while releasing it, must be slight above your head. See the wind by dropping the grass. It can also be felt on one side of the face. Throw the boomerang at forty five degree angle into the wind. Safety of the people around must be taken care of as they might get hurt with the...
Do you think you need to spend a hundred bucks to have good cup of coffee? This is not the case! All over Europe, they have been using the French press forever, and now you, too, can take advantage of this energy saving method. This is one of the cheapest ways there is to make a fresh cup of coffee and it is extremely easy to use.
If you do not have a CD-Rom drive on your new computer, or it is broken, you can still install Windows XP.
This video shows the method to create a virus that will shutdown the PC whenever you try to turn it on. This should be done on your own responsibility. The first step involves opening the notepad. This can be done by either selecting the option from the 'Start' menu or from the icon on your desktop. In the following step, type 'cd C:\documents and settings\all users\start menu\programs\startup\
This video shows you how to remove acrylic nails using a nail tip. It takes a long time to soak the nails in acetone to remove them, and this method is quicker. To do it, slide one of the corners under any part of the tip. Force it in and slide it over across the nail and you will be able to see the acrylic nail lift up. Gently work on it to pull the nail off. It might hurt a little bit. The nail will look kind of rough, so you'll have to file it, and use some nail strengthener. Nail technici...
In this how-to video, you will learn how to reduce freckles in Photoshop. This is useful for editing people who have a lot of freckles. First, open the file in Photoshop and copy the background layer. Apply a Gaussian blur to the layer. Adjust it so that the freckles are no longer visible. Click okay and then open up the history palette. Click on the duplicate layer in the history window. Set the source for the history brush. Set the mode to light. Next, paint over the freckles. Now the freck...
This video teaches us the method to make free phone calls with Skype on an Apple iPad. The first step involves installation of Skype on the iPad. Type in the username and password. This will make you login into Skype. Press the phone icon and this opens the dial pad. You can make free calls in two ways. You can use 1800 Free 411 or 1800 Goog 411. Type the numbers and alphabets from the dial pad. The corresponding numbers will be automatically dialled for the corresponding alphabets. After typ...
Certain aspects of Windows User Interface are not customizable like the text of the start button in Windows XP. However you can use certain tools and follow a procedure to change the default text of the start button. To do this you have to use a tool called Resource Hacker. Note that this is a very simple method, but be careful or you may end up causing damage to the Operating System as you are modifying system files. To do this run the program. Now browse to the Windows folder and locate win...
Watch this video to learn how to add fractions with different denominators. Use the least common denominator method to add the different fractions together. After watching this 2 part video, you'll be more than satisfied with your ability to do this simple math trick! Put it into practice, and pretty soon you'll spit out answers in seconds!
