Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 77th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to do a complicated payroll formula when tax data must be retrieved from multiple tables. See how to use the INDEX, INDIRECT AND MATCH functions in one big formula to retrieve tax data from multiple tables on multiple sheets. Learn to love digital spreadshe...
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 70th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to clean up a bad data set with the TRIM function before building a pivot table (PivotTable) to calculate an average. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 46th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use the DOLLAR, VLOOKUP, INDEX and MATCH functions and a previous bracket commission formula trick to calculate total commissions when you have variable commissions paid out. Learn to love digital spreadsheets more perfectly with the tricks outlined in t...
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 44th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn use 4 different tricks to convert a text formula or function to a number. Also see how to convert text to numbers. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 40th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use the filter and advanced filter tools to extract the top 5 values from a list. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.
Learn how to stream DVDs to AVI using the VLC media player in this video tutorial. To begin, open your DVD disk on the computer. Save the stream and save it to a file (save it somewhere where you will remember it). Then, go with the default and press "OK.". Locate the file you just created and launch it. Then, launch the DVD. The VLC media player will open and you will hear your DVD. During this process, the media player will be transcribing your video, which will take a few seconds. To learn...
Tying it All Together shows how to do double loop knotting in this video tutorial. The tutorial outlines two different types of knots that can be done using two uncommon ways of tying the knots. The double coin know requires you to fold a piece of string in half laying the two sides of the string side by side. With a series of twists, turns, and coils you can create the coin knot. The second type of knot, cross knot, requires double loop knotting to create a squared-looking knot. As an additi...
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 34th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to hide columns, select visible cells only, and then copy and paste just those visible cells (all with and without the use of formulas). Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.
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.
in this video Evan Burse teaches us an easy way to draw Toothless from the 3D cartoon how to train your dragon.
This tutorial shows you how to resolve issues with your Nitro RC clutches. Sometimes applying the clutch can be difficult and result in damage to your vehicle. This shows you how to properly put it on and gives you some tips on how it shoule be put together and what to watch out for. Enjoy!
Changing the color of your eyes is very quick using Photoshop and this handy video. After using the selection tool of your choice to outline the eye (this video uses the pen tool) with a little bit of feathering, just change the hue of the eye. The video shows how to do this by pressing control + h, however it can also be selected by choosing the image menu, then adjustments, then hue/saturation. This great effect can be used as shown on close up eyes or on smaller eyes further away. Both way...
In this how-to video, you will learn how to draw a duck or a swan in the easiest way possible. To do this, you will need a writing tool such as a sharpie, pen, or pencil and a piece of paper. First, draw a v like shape smoothly. Next, Follow the shape once more, except make the outline of the swan. Next, fill the top in to complete the drawing, as well as the eye of the swan. You can add water to the drawing with a blue pen or marker. This video shows just how easy it is to create this drawing.
Learn how to make an e-mail server on your home computer to host your own web page and webmail service by following the steps outlined in this video tutorial. You will need a web server, an e-mail server, and a webmail interface. For the server, the most common program is WampServer, which you will need to download. Run through the installation process and grant the program access to your fire. Click on the new icon on your desktop and click Put Online and then Start All Services. This will g...
Adding domains to your GoDaddy hosting plan can be done by following the steps Ken Applebee outlines in this video tutorial. Once at the GoDaddy main home page, click on My Hosting Account under the Hosting tab at the top of the screen. Log in and go to your account with the hosting on it. Click on Your Domains and you will see your domain in there. On the right side you can choose to add a subdomain or you can just click on the Add Domain tab for a completely separate domain. This allows vis...
Learn how to make a mute plug for your computer by following the steps outlined in this tutorial. This plug can be used for anything, including computers, stereos, mp3 players, or anything else with speakers that has audio. A mute plug is useful to get back at someone that constantly plays their stereo too loud because you are essentially cutting off their audio with this plug. The plug is place into where the headphone equipment would normally go. What you need are some old headphones. Take ...
Learn how to make a balloon teddy bear using only one hand by following the steps outlined here in this tutorial. You will need one balloon already filled with air. At the end, create a nose. Then, add two bubbles for the back of the head. Twist the five bubbles that will comprise the head of the bear. Once the head has been formed, you will stick the nose in through your ring for the head to create the overall head and face. Pinch twist to create the ears at the top of the head. The body is ...
In this video the instructor shows how to change views in Microsoft word 2007 and navigate around the documents. In Microsoft word 2007 in the ribbon there is a view tab to the extreme right. Open the tab. Now in that bar the default layout selected is the Print Layout which is 'What you see is what you get' layout. Next to it the full screen reading option and clicking on it, the documents opens up as a two page book with all the other tool bars hidden. The next is web layout which is ideal ...
This video shows us how to draw a Dale character. First you draw a ball about the size of an orange. Insert construction lines in the shape of a cross. Starting with the small middle area, draw the mask outline and add the ears at the top. Draw in the nose under the middle line. Draw the cheeks outside the construction line on both sides. Add smile lines on each side and draw a curve between them for the mouth. Extend the lower part of the mouth outside the construction line. Insert teeth and...
For those interested in crochet, this video tutorial outlines the steps to doing a double treble stitch. This type of stitch is a much taller stitch than most others. To begin, you will start with a five chain series that will act as the first stitch. Wrap the yarn around the hook three times and insert it into the next stitch. You will then pull the yarn through working off two loops at a time. Working off essentially means dropping the loops off the crochet hook. Then, you just repeat these...
This video outlines the process used to turn a chunk of wood, specifically sweet gum, otherwise known as Liquidambar styraciflua, American sweetgum, redgum, liquidambar, or simply liquid amber.
This video will show you how to create a flow chart in MS Word 2007. First click on the Insert tab. You can see the smart art option, click on it. A "Smart Art Graphic" window will appear.
RichPin shows how to identify a rear axle on a Jeep Grand Cherokee to determine the correct replacement part. The first thing to do is to identify the axle by cleaning the fill plug on the back cover. Look at the inscription of the plug to find out the style of the rear end. In this example, Rich has a "Dana" style rear end. To determine if it is a 35 or 44 Dana, look at the web area to the right of the plug to locate the number. The two steps outlined in this video allow you to identify the ...
This video describes the process for inserting a 3D animation into a video clip. The video starts by outlining several software programs you will need to complete this project. Don't worry, the presenter gives web addresses and titles for all of the programs needed. After all software is loaded, the presenter beings inserting key frames and x, y coordinates to make the 3D animation move along the correct path. Finally, after the animation path is complete, the video shows how to render the fo...
Maria Bell demonstrates to create the watercolor project, add color to the watercolor paper by first outlining the image or the shape with the SU marker. Then, distribute the color from the edge of the image or shape to the center of the image or shape with an aqua painter or watercolor brush. Fill in the images with shading details as desired. The technique produces gradient shading and a quick spread of colors without the use of watercolor pencils or crayon. Painting watercolors with SU mar...
In this video tutorial by Tasktutorial, learn how to make a paper scroll in Photoahop. Select the rounded rectangle tool and draw a shape similar to the shape shown. Open layer options. Go to gradient. Select the indicated gradient and delete the marker shown. Adjust the other markers as indicated and use the control+g shortcut to duplicate the layer. Position the shape as shown and using the pen tool draw the paper outline by clicking and holding to obtain the required shape. move the paper ...
This video is a demonstration of how to make Sailor Moon style hair clips. Start with two alligator clips, six half pearls, craft foam, glue, a pencil and scissors. Draw an outline of a feather shape on the craft foam and cut it out. Trace around the cut-out to make several more and cut them out. Spread some glue on the top of an alligator clip and stick the feathers shapes on in an overlapping design. Put some glue on the back of each half pearl and stick it to the clip at the base of each f...
Learn how to sketch a realistic 3/4 profile of a female head and face. Begin by drawing a simple circle. Add a few more construction lines which outline the general shape of the drawing. The rough features of the face come next. Now you are ready for more artistic touches, such as shadows underneath the nose and lower lip. Experiment with different brushes and intensity of color until you like the result. Learn to play with lines and shadows to create a sketch of a female head.
You first want to start with doing the outlines of the arm. Basic shapes like tubes are given structure with cross sections. This is to know if your knee is bending or is it straight. To do a gesture properly is to use landmarks. You start from the toes positioning and work your way up from here. Your feet, knee, and torso are your three landmarks. Erasing sharp edges helps to give the effect of a more soft drawing and the limbs seem more realistic. Today we learned that drawing is more about...
Learn how to personalize birthday cards with this informative video! This tutorial will show you how in just a few steps, you can make a race car birthday card with the help of a simple pattern. Why go out and buy a card from the drugstore that looks like everyone else's when you can create something unique for your birthday boy? All you will need to make this fun card is some colorful card stock, the Cricut racer paper doll pattern, glue, and a little time. This video also shows you how you ...
Drawing of a horse is broken down into a helpful series of tips and tricks in this nice, succinct tutorial video. Step 1, the video describes the use of ovals and other simple shapes, to begin to plan the overall structure, for later. Step 2, around those ovals and simple shapes; begin a rudimentary outline of the horse you're trying to draw. Using the example given, see what's possible, and begin to erase your ovals and other structure-assisting shapes, in the middle, giving you now your act...
If you lay tile it is rare to do a job and not have to cut a curved piece of tile. If you do have to cut a curved piece there are two ways to do it. First, you have to draw outline of the cut that you need to make on the tile itself and mark the part you are going to remove with an X. The low tech method involves using a pair of tile nippers. You nip away pieces of the tile until you have nipped away the whole area until you have a circular cut out. For a more polished cut you can use a spira...
With the proper techniques you can have fuller-looking lips. Start by using a flesh-tone pencil to outline your lip line. This adds volume to thin lips. Then fill in your lips with the same flesh colored pencil. This helps your lipstick stay put all day long. Apply two coats of your favorite moisturizing lip stick. Dot your lower lip with clear lip gloss and press your lips together to blot the gloss. Gloss lips look plumper than lips with just lipstick applied.
Welcome to Digital Issues, your guide to help make a digital life a little less painful. In this video tutorial, Digital Issues covers how to make great tribute videos with these 5 tips.
Welcome to Digital Issues, your guide to help make a digital life a little less painful. In this video tutorial, Digital Issues covers how to create better home movies.
Here is a good knot. Do you know it? It's the quick release knot. Check out this instructional knot tying video that demonstrates how to tie the Quick Release knot. Just follow the simple instructions outlined in this boating tutorial and learn how to tie a Quick Release knot. Knot tying is a breeze with this video. Start practicing and reel in the big fish!
Check out this instructional knot tying video that demonstrates how to tie the Bowline knot. The bowline is an exceptionally versatile knot. It is quick to tie (once you practice), doesn't slip and doesn't jam. Just follow the simple instructions outlined in this boating tutorial and learn how to tie a Bowline knot. Knot tying is a breeze with this video. Start practicing and reel in the big fish!
If you're an iOS app developer, your Monday just got better; Apple just released iOS 12.2 developer beta 5 to your Software Updates today, March 11. This fifth beta includes a number of small UI changes and tweaks, and likely some degree of under-the-hood improvements and bug fixes.
Popping a shell is often the main goal of a hacker, and it can be exciting when executed properly, but sometimes they do have their limitations. Metasploit's Meterpreter probably needs no introduction, but this powerful, dynamic payload can offer a leg up over normal shells. To prove it, we'll show how to take a normal command shell and elevate it to a Meterpreter session.
Without a second beta like most other beta versions, Apple released iOS 12.1.2 to all iPhone users on Monday, Dec. 17. The update comes just one week after the iOS 12.1.2 beta went live, so why did it have such a quick turnaround? The answer likely revolves around eSIM issues on newer iPhone models, as well as legal issues with Qualcomm.
