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 655th installment in their series of digital spreadsheet magic tricks, you'll learn see how to create a statistical frequency polygon using a line chart. Also see how Excel mistakenly interprets number category label data as Number Series data.
This video tutorial is in the Language category which will show you how to describe problems in English. When describing problems in English, many people use the word trouble. When you frame a question, you can frame it in the present or the present continuous tense. For example; what do you have trouble with or what are you having trouble with? Similarly, when you answer the question you can use the present or the present continuous tense. Examples of this are; I have trouble with my car or ...
This video tutorial is in the Software category which will show you how to map multi-sub objects in 3D Studio Max. What this means is you can apply two textures to a single 3D object. First you select the 3D object, say a box and go to editor > standard > multi sub-object > OK. Now change the number of materials from 10 to 2 and follow through the next steps to select the two textures. Then go to modify panel > edit mash. Select polygons, and apply the texture to the front of the box, move ar...
In this video tutorial, viewers learn how to use Spotlight to find files in Mac OS X. To activate Spotlight, click on the blue magnifying glass icon in the top right corner. Then type in the term to search. Spotlight will display all the documents and files that match your search. If you click on Show All, you will have more options in Spotlight. In the Spotlight Preferences, users are able to select the categories for Spotlight to search in or not search in. This video will benefit those vie...
In this how-to video, you will learn how to use the website Wefollow for twitter. This will allow you find more people to follow you on twitter. You can list yourself under a category so people can find and add you. If you are an antique dealer, you can label yourself as one. This allows you to be searched for and added. You will get higher on the search list as you get more influence and more people following you. If you are looking for people to follow in your niche, you can type in the nic...
This video in the Fitness category will show you how to do squats correctly. This exercise is meant for the legs. The easiest way to do this is to sit down and stand up using a bench. The bench should be about knee height. Technically the line from the ankle to the knee and the line from the hip to the shoulder should be parallel as you go up and down. The legs should be about one and a half feet apart. This is the body weight squat. As you progress, you can do the dumbbell squat. The video ...
This video tutorial is in the beauty and style category and it is going to show you how to tie your shoe laces with only one hand. First you need to tighten up the laces and then you will have to tie the laces with the overhand knot. Take the lace on the side of the hand and hold it between your thumb and the forefinger. The distance you go is equal to the size of the hand. Pull the lace and grab it with the first joint of the little finger. Now you got to free your thumb and the forefinger g...
This instructional video Nehal Kazim from Site shows you how to make a complete Facebook fan page. Before creating a fan page evaluate the reasons of making a fan page. A fan page lets you connect with your future clients and fans and keeps them updated and gives them a platform to talk about your organization. To create a fan page go to the bottom of any page and click 'Advertising', select pages and click create a page. Select a suitable category and a suitable name make sure to select it c...
This video tutorial from Muaaz5903 presents how to copy music from an iPod that is synced to another Mac computer. First, visit Senuti, download and install Senuti application.Make sure your iPod is connected to your computer. You can use the application free for 30 days after that period you will have to buy it for 18 $.Once it's installed, run the program. Senuti main window will show all music files on your iPod. Select songs you want to copy and click Transfer on top menu and dialogue box...
Finding Linux hard to handle after using Windows? Well this should help, here is how to install software on Linux. Start off by clicking on application launcher. Here go into applications, then into 'system' where you should find software management. In this program go straight into the settings and then edit software sources. Under 'downloadable from internet' make sure every option has a check against it. Now press the software management tab on the side. Now this is where you can get which...
One thing you couldn't do in the Shortcuts app when building a shortcut was browsing the entire list of available actions for all of the apps and services on your iPhone. That all changes in iOS 15.
Tuning into a favorite station on Pandora has become part of a routine for many, and it's easy to see why. The app automatically plays songs tailored to your tastes to ensure a relatively hands-free experience. And if you're a subscriber, Pandora even has you covered in moments where there's poor cellular service by letting you keep listening to your go-to tracks uninterrupted.
After hosting millions of free 3D models online, Sketchfab is betting that augmented reality and virtual reality developers and creators will be willing to pay for premium 3D content.
There's no doubt Kali has established itself as the most popular penetration distribution available. However, just because it's the fan favorite of beginners and security researchers doesn't make it right for everyone. Manjaro Linux is a beginner-friendly Arch-based distribution which can be easily weaponized with the Black Arch expansion, creating a friendlier first-time Arch experience.
If you're an Android user, Google probably has almost your entire digital life stored on its servers. Family pictures are backed up on Google Photos, your e-book library resides with Google Play Books, videos are on YouTube, chat logs in Gmail and Hangouts, starred places and location history in Google Maps, and so much more.
Sony's Xperia line of smartphones are beautifully crafted and have many great features. But considering the fact that Sony has evolved into a media company over the last two decades, it's their media-related apps that stand out the most.
This is a video tutorial in the Arts & Crafts category where you are going to learn how to tie a Bowline knot with one hand. Doing this is really simple and easy and doesn't take any time at all. Hang a line from any support. Take the lower end, that is the running end in one hand and pass it around the standing end. Then take it out through the loop and pass the running end around the standing end and pull it out through the loop. Tighten the knot and it's done. It's really that simple and e...
This is a video tutorial in the Home & Garden category where you are going to learn how to make a sign using a wood router free hand. For this you will need a router. The kind of router you use is not so very important. But, what is important is the router bit. It should be a “V” shaped bit for doing free hand work. There are lots of bits you can use. First you fix the depth of the cutter so that only a little bit of the router bit is exposed. You should not be seeing too much of the bit abov...
This is a video tutorial in the Education category where you are going to learn how to convert top heavy fractions to mixed numbers. Top heavy fractions are fractions with numerators greater than denominators. Mixed numbers are combination of whole numbers and fractions. To convert 12/5, find out how many 5s are in 12. The answer is 2 and after you remove two 5s from 12, you are left with 2. So, 12/5 is equal to 2 2/5. Similarly, in 10/3, you have three 3s in 10 and you are left with 1. So, 1...
This video tutorial is in the Electronics category which will show you how to make a Beetlebot from your parts bin. The Beetlebot project can be found in Make Volume 12. You will need a couple of small motors, 2 momentary switches, 2 AA battery holders, a piece of metal, a small bead, 2 paper clips, heat ring tubing and a couple of connectors. Cut off two pieces of the tubing and using a soldering iron melt them over the ends of the motors. Hot glue the 2 momentary switches at an angle with t...
This video tutorial is in the Education category which will show you how to understand chemistry and chemical change. The question here is 10g of Mg ribbon reacts with 0.15 mol decimeter cubed of hydrochloric acid at 25 degree Celsius. What is the balanced equation for this reaction? When magnesium reacts with hydrochloric acid, you will get magnesium chloride and hydrogen. So, the equation will be Mg + 2HCl = MgCl2 + H2. Mg is in group 2 of periodic table and has a valance of 2, whereas Cl i...
This is a video tutorial in the Arts & Crafts category where you are going to learn how to make origami llamas. Take a square sheet of paper and fold it in half. Open the fold and then fold each half further in halves. The sheet is now divided in to 4 parts. Next fold the outer flaps inwards so that they meet at the center. Flip the folded sheet and fold it in half to make it a square size. Next you fold the top back over itself in a triangular shape. Open up the last fold and watch the video...
This is a video tutorial in the Education category where you are going to learn how to draw an isosceles trapezoid. This video demonstrates how to draw an isosceles trapezoid with a long base (B), a short base (b) and a 35 degree angle. First you draw the long base. Now center the short base at the center point of the long base and mark the end points of the short base with dots. Next draw perpendicular dotted lines from the dots extending upwards. Draw 35 degree angles from either end of the...
This is a video tutorial in the Outdoor Recreation category where you are going to learn how to tie a snell knot to a fishing hook. This knot is different from the usual ones and is one of the strongest fishing knots for tying a fishing hook to fishing line. It is also the easiest to tie. Take a fishing line about a meter long and a number 6 tuna circle hook. Pass the line through the eye starting from the front and coming out at the back. Hold the end of the line and the hook together, wrap ...
This video tutorial is in the Food category which will show you how to make scrambled eggs using a flashlight. Break an egg and pour it in to a small metal container. Clamp a Wicked Lasers torch in an upright position so that the bulb end is facing upwards. Now switch on the torch and place the container over it. After sometime as the container gets heated, the egg will start to cook. Mix the egg with a spoon while holding the container with the other hand to prevent it from falling over. Don...
This video tutorial is in the Sports category where you will learn how to glue a tubular tire using Tufo rim tape. Gluing a tubular tire is very simple. You will need a tire, rim, Tufo rim tape, scissors and a pump. Stretch the tire with your foot and your hand as shown in the video and then inflate it. Take the Tufo rim tape, find the side labeled rim side, remove some protective foil and press the tape into the rim inching your way along the wheel. Leave a 2-3" tape unglued so that you can ...
This video tutorial is in the Film & Theater category which will show you how to shoot deceptive and multiple camera angles. Camera and shooting techniques can add to the magic of your videos along with some simple special effects. One of the techniques is called the Zolly. It adds drama by creating a disorienting visual effect to the viewer. By zooming out a camera while using a dolly to move in, the subject stands out as separated from the background and appears to be floating towards the c...
This video tutorial is in the Fine Art category in which you will learn how to chroma key green screen video. Chroma key is the magical process of making images where the background or any object in your scene can be made transparent so that you can replace it with a different image. First shoot some footage in front of your Chroma key backdrop. Then shoot the background footage. Next put the 1st video track over the background track in the editing time line. With Chroma key you can have some...
This video tutorial is in the Arts & Crafts category which will show you how to make crumpled flowers for scrapbooking. Cut out three circles of 2", 1 1/2" and 1" diameter out of a sheet of paper. Then wet the pieces of paper lightly with water or colored ink and crumple them one by one as shown in the video. Then place the three pieces together and pin them up with a split pin. Now crumple the edges of the paper further to give them the look of a flower. Allow it to dry and your flower is re...
This video tutorial belongs to the Education category which is going to show you how to create a research binder. This binder will hold all your "how to" articles or research guides. You will need page dividers which you can make yourself or purchase. The dividers are meant to separate sections in the binder for ease of storing and retrieving all your research materials. You can have dividers for events, dates, contact details of people, places and "how to" articles. The dividers can have a f...
This video tutorial is in the Arts & Crafts category where you will learn how to use the rolling marble technique in scrapbooking. Take a piece of 2" x 5 1/2" whisper white. Then take the stamp set container with three marbles in it and add 4 -5 drops of color from a bashful blue refill inside the container. Then shake the container till the marbles get coated with the ink. Put some dotto on the back side of the whisper white and stick it to the inside top of the container. Flip it over and r...
In this tutorial, we learn how to lock and unlock cells in Excel. First, right click one cell and click on format cells. Go to the protection cell, and then un-check the locked category. Click ok, then go to protect sheet, inside of tools. Now, do now allow locked cells to be checked. Now, you will not be able to select cells in the worksheet except cells that are unlocked. This is a great way to protect your information, so it won't accidentally get deleted or ruined. You can do this for ent...
This video tutorial belongs to the Film & Theater category which is going to show you how to build a light diffuser to improve your film lighting. Joe Richardson explains how to do this. You will need four pieces of pine wood 1" x 2" x 8 feet long, framing nails, duct tape and light cloth material. Cut the wood at the edges at a 45 degree angle and lay them out on ground to make the frame and hammer in the framing nails. Now spread the cloth over the frame and start stapling it. Pull the clot...
This video tutorial is in the software category where Kerry Garrison will show you how to use vignettes with Adobe Photoshop Lightroom. By this you can remove the dark corners in a photo created by some zoom lenses. Select the photo, kick in the vignettes and fade out the corners focusing on the main subject matter. For this, select 'lens correction' on the right hand side and with the help of the sliders apply the vignettes. You have the choice of applying either a light or a dark vignette. ...
A Shino glaze is an umbrella term for a category of pottery glazes that range in color from milky white to orange and even charcoal gray. Chino glazes add a very pretty luster to pottery pieces and are made using a carbon trap, or trapping carbon in the glaze during kiln firing.
This video tutorial is in the Arts & Crafts category where you will learn how to make a mini Big Shot Box with Stampin' Up! For this you got to use the Bigz Die Box #2. Cut a Whisper white card stock at 6" x 11", place it on the die box and run it through the machine to get the box template. Cut off one edge of the template along the score line with scissors. This will be the top part of the open box. Now fold the bottom part of the box along the score line. Take a strip of cottage wall desig...
This video tutorial is in the Music & Instruments category which will show you how to sing octave and unison. Unison singing is two or more people singing on the same note. The singing has to be in sync. It is important to make sure that the phrasing and the lines are together. Also the tones should be identical. One should not be too loud or overbearing. Octave singing is like unison singing except for the fact that one person will be above or below the other person in terms of tones and not...
This video tutorial is in the Computers & Programming category where you will learn how to save multiple locations in Yelp. Yelp is great for finding businesses in your neighborhood. You can also search for something in other cities. You can enter the location in the 'near' box to search for something somewhere else. You can also save locations to easily search later. Click on 'account' and then on 'manage saved locations'. Here you click on 'add new location', type in the location name and t...
This video tutorial belongs to the software category which is going to show you how to add a watermark in Camtasia Studio. Open up Camtasia Studio and either import a video or open up a saved video to add a watermark. You got to edit your video and be ready to publish it because adding a watermark is the last step. Now click on 'produce video as' and the production wizard will come up. Here you can select a preset mode or create a custom one. Then you go to 'add / edit preset' and click on 'e...
This video tutorial is in the Computers & Programming category which will show you how to use the online discussion site Voice Thread. Voice thread enables you to create an online discussion with your students. In this video you will learn how to open an account, how to open a thread and how to post a comment on it. Go to the site. On the right hand top corner you will find a coffee cup. If you click on that, it will ask you for a username, password and email for opening an account. After you...
