In this Excel basics video, the instructor talks about the basics of charts. There is an enormous difference in how you make charts between Microsoft Excel 2003 and 2007. In both the versions, to make charts the first thing you do is highlight the data cells in your workspace. Now use the toolbar and click on the charts button there. Now Excel automatically generates the charts based on the data and the column and row names. But there are various changes between the charts produced in the dif...
Make your embroideries more accurate and beautiful by designing the letters and words on a computer software called Compucon EOS 3.
If you need to draw a demon monster in a hurry then watch this video to see how you can sketch one up in a flash. The great thing about sketching is that you can just sort of etch out the form, refining it until you have the scary demon you are looking for.
Would you like to learn how to draw amazing anime cartoons? This excellent and entertaining video demonstrates step by step how to draw a flawless female anime face in 3/4 view. It discusses the challenges of 3/4 views, how to practice difficult facial drawing techniques, and offers helpful tips on how to produce anime drawings that really stand out. It provides helpful tips on proper pencil and lead choice to quickly and easily get fine, clean and perfect lines that are a must for modern ani...
In this Excel magic trick video the tutor shows how to change operator in a formula from a drop down using Choose function. He shows a basic work book which can be downloaded from the internet for hands-on to the tutorial. In this trick the tutor shows how to include some operators in a drop down box of a cell and based on this drop down value change the operators in equations that are using this cell there by dynamically altering the equation and the value produced using the equation. For th...
In this Adobe Photoshop tutorial the instructor shows how to make a torn image effect. He shows you a sample image of what it is going to look like after producing that effect. It basically looks like as if the photograph was torn to pieces and then put back together with the cracks visible. To do this first open the image in Photoshop. Now make a rough outline of the tear with the polygonal lasso. After generating the tear go to filter and in the distort sub menu choose the ripple. Now it ap...
A bloody knuckle knot is the result of a row of half hitches fused with a blood knot--this video teaches you how to tie one. Make two loops with your rope then loop them over your thumb. Take the tail of the rope and keep making loops and adding them to the others on your thumb, to produce a row of loops. When you have five loops, slide them off your thumb, take the end of the rope and pass it through the loops. Pull out the slack but do not tighten, then take the other tail and pass it throu...
To find a vertical asymptote, you are trying to find values of x that produce 0 in the denominator but not in the numerator. If 0/0 occurs, that means you have a "hole" in the graph. A vertical asymptote is a place in the graph of infinite discontinuity, where the graph spikes off to positive or negative infinity. To find the vertical asymptote, set the denominator equal to zero and solve for x. Check that the values also do not give a zero in the nominator. If the values work, you have found...
Professional furniture makers have used pocket hole joinery for years... and for good reason. It's a simple way to achieve a strong, permanent joining of two pieces of wood.
How you manage stress is very important. Stress is an important part of the work environment. It helps to keep you productive and motivated to get the job done. Stress helps to keep you focused on your goals for the job. Setting goals helps to produce necessary stress for the job. If there isn't enough stress, setting higher goals can help. Keeping stress balanced is important. If there's too much, you might need to take a step back and maybe go to lunch by yourself. After hours to relieve th...
In this tutorial the author explains the concept of Newton's Second Law of motion which states that force is equal to mass times acceleration. So the equation to compute force F is F = m * a, where m is the mass of the body and a is the acceleration produced by the force on that body. He explains that even our weight is our mass times the gravity. So now he explains that mass of a body is constant and only our weight changes depending up on the situation we are in. If you want a clear underst...
David Epstein shows a simple and yet creative way to add contrast to any garden with bare or no interest areas. To add a little extra winter color, David introduces three varieties of the "Small leaf Rhododendron" including; "Midnight Ruby", "Westons Mayflower" and "Dora Ainateis". Although these smaller leafed varieties require a little more sunlight, they do however produce flowers in Spring and hold their leaves all winter long. So, for a continuation of color throughout winter, be sure to...
Does your model have an unsightly blemish that you'd rather not have in your final photos? Is this blemish dark and hard to ignore, like a mole? No problem! Check out this tutorial and learn how to use Photoshop's healing brush to remove any skin imperfections including moles. This video will show you step by step how to accomplish this and produce cleaner photos. Learn secrets of the pros in this video and be on your way to more professional looking images.
In this video, Mark Donovan of Home Addition Plus shows you to remove ceramic tiles from a shower. Before you begin, remove the shower head and shower handle, leaving the walls bare. A lot of dust and debris will be produced so you should wear safety glasses and to protect the shower pan from damage, you should cover it up. Card board should suffice. Starting from the bottom, place the chisel on the edge of the tiles and tap it with a hammer. For the tiles in the middle, you can use a flat ba...
Lingonberries are really popular in Sweden. One fact about Lingonberries that people don't know is that they are high in vitamin C. Lingonberry plants produce berries once in the summer and once in the fall, so you get two harvests from this crop which is a really nice. The Lingonberry bushes grow to be one and a half feet wide and one and a half feet tall. So they don't get too large. Take the plants out of the containers very gently. Place the plant in a pot and add some potting soil to fil...
Learn intarsia knitting using a graph in this five part video tutotial series. When knitting intarsia, blocks of color are worked with separate balls or bobbins of yarn, producing a sweater only one layer thick. Get the free simple heart chart used in these videos, here.
An Adobe Flash preloader screen is something anyone who has browsed a website is familiar with: It's that "Loading" bar that you encounter before a Flash-heavy site pops up. Sometimes all you see is a simple "Loading" bar, and other times it's much more interactive and interesting (like an hourglass where the sand drops down until you get to 100% page loaded).
This is how to make a Kugel. Get out your eggs, noodles, sour cream, cottage cheese, sugar, and fruit salad. This is a classic kosher Passover treat or dish for any Jewish holiday.
Like a lemon, a potato can produce electricity. This science experiment was prepared by Ebtisam Al Anzoor and demonstrated by Mustafa Daif. The electricity is proven using an analog micro ameter. The positive is copper from a penny or copper coin while the negative is a galavanized nail. The potato releases a charge and is further proven when it is connected to a calculator. You can daisy chain the potatoes for a greater charge.
Somewhere in between prison tats and a professional tattoo gun, comes the tattoo machine in this how-to video. You will need a tape deck motor, a stereo fly wheel, a 12 volt charger with different settings, a bobby pin hair clip, a brace, a wide pen, and a screw. Since most of these parts are scavenged from around the home, this is a cheap tattoo machine that still produces relatively good quality results. Watch this video tutorial and learn how to build a tattoo machine gun.
Many young players have a too tight, smile embouchure with the flute high on their lip and the hole almost entirely covered. Some were initially taught the coke-bottle method of blowing straight across the hole. This video addresses these common problems that many flutists have. This flute playing method is based on the techings of Bradley Garner, who teaches the lower roll out into the flute technique. The angling the air toward the crown idea was taught by Alain Marion. It may feel very str...
35mm lens adapters cost thousands to buy, hundreds to build, degrade the objective technical quality of your video and make your camcorder an entire magnitude more difficult to use. And they won't make your video magically look like film. Nothing will. On the other hand, by adding selective focusing options to small consumer camcorders, 35mm lens adapters have the potential to produce some absolutely gorgeous images. Watch this video tutorial and learn how to adapt a video camera to a 35mm le...
Watch this instructional ceramics video to learn how to throw and shape with two ribs at the same time. Learn some basic tips of coning on a pottery wheel by squeezing slowly all the way up. It's another process in the wedging department that compresses the clay. Once you get the rhythm of the pottery wheel, give it a try and soon you'll be producing your own ceramics.
Learn how to produce Roy Lichenstein style Pop Art from your photographs using GIMP image editing software.
Using Maya you'll learn to produce an alpha to use in Zbrush. Very easy method to make a controlled alpha without using Zdepth tools in Zbrush. In part two, Using Zbrush tools to make a tileable texture. Texture sculpting techniques and the 2.5d tools within Zbrush. Part three covers setting up the Maya render for the texture and attaching maps to the node.
This four part tutorial is Lesson 11 in the Zbrush series from Jason Welsh. It explains almost everything you need to know to texture a 3D creature in Zbrush. Part one teaches you how to produce a color map, part two goes over 32 bit normal maps and Displacement maps, part three covers 16 bit displacement and normal maps, and the last section covers spectral maps.
While we personally like to learn a new software program by playing around with its buttons and various functions, sometimes it's a nice primer to actually read the instruction manual. And when it comes to video editing, knowing the particularities of each and every function is crucial to producing professional-quality results.
A very easy to make rocket made from a drinking straw, and launched using air pressure. Almost everyone will be able to make this, it does not require any hard-to-find items, but also can it be made in very little time. Therefore the rockets themselves will be very easy to mass produce. They will fly HIGH up in the air, and then land on the ground, completely safe! Use this doc for reference.
Are you worried about how your bathroom cleaning supplies are damaging the environment and your own air? Use these recipes to create non-toxic, homemade bathroom cleaners instead. Never mix homemade cleaners with commercial cleaners, because when mixed, they can produce toxic gases. Use the same safety precautions as you would with store bought cleaners- keep them out of reach of children and pets, and out of your eyes and mouth. Always work in a well-ventilated area. Store your cleaning ingr...
Corn is everywhere, and there are a large amount of methods for preparing it. If you're a corn on the cob kind of guy, you may be fascinated to know that a microwave is all you need to cook it. Bring the fresh taste of summer to the dinner table in a few short minutes by using your microwave to cook corn on the cob.
The economy is rough at the moment, and we all need our jobs more than ever. Check out this tutorial, and learn how to make yourself so valuable at your job that no one would ever want to fire you.
This daring docu-drama explores the esoteric underground of hard-cider brewing. This fast paced thriller is sure to captivate the mind, and leave you on the edge of your seat. OK, it's just a video shot with a 3mp Cannon digital camera on video mode and edited with some lousy free software. There are two different methods used to make this hard cider. 5 gallons of fresh cider with a starting specific gravity of 12 were pitched with White Labs liquid English Cider Yeast. This should yield arou...
The worldwide health crisis around the coronavirus has gripped the live events industry, particularly in the tech sector, with the cancellations of Mobile World Congress, the Game Developers Conference, Facebook's F8, Google I/O and now South by Southwest.
With today's release of iOS 13.4 developer beta 4, it seems Apple is closer than ever to releasing the official build for its upcoming iOS update. If you've been following the beta closely, you know that means new Memoji stickers, CarKey API support, and Mail toolbar updates, in addition to general bug fixes. Public testers can now take that extra step, as Apple just released 13.4 public beta 4 today.
The Oscars are just a couple of days away when Hollywood will celebrate the best crop of films from 2019 in the US and internationally.
The wait is finally over. Apple just released iOS 13.2 for iPhone, the latest update to this year's iOS 13 release. The update contains a slew of exciting new features, such as Deep Fusion for 2019 iPhones, a suite of new emojis, the long-awaited Announce Messages with Siri, among many, many others.
All those Apple commercials encouraging people to use their iPhones to make their smartphone movies look amazing, but how can you achieve some of the same looks? That's the question many often ask after plunking down over $1,000 for a brand new iPhone, shooting some video, and getting somewhat mediocre results.
Samsung's not one to make drastic changes to what already works. They've continued on with the IP68 rating under IEC 60529 first given to the Galaxy S8 all the way to the the Galaxy Note 10. If you're a little confused as to what this rating means, don't worry, it's actually pretty simple once you get to the meat and bones of it.
Let me paint a picture for you. You're on a long flight home, and while listening to music on your Samsung Galaxy S10, a great song comes on. You want your friend to hear it too, who's also listening to music using a pair of Bluetooth headphones. Thanks to Dual Audio, you can easily share your experience.
As the premiere app for chatting and video calls, it only makes sense for Skype to provide a dark theme to help prevent eye strain and minimize battery drain. Not only that, it has to also keep pace with popular messaging apps like Facebook Messenger that also have the feature built-in.
