This video teaches how to fill in the blanks with custom number format in Excel. Open any similar worksheet as shown in the video or type the same to use. Select all the cells in the columns E and F and press F5. Now click 'Specials', then select 'Blanks' and click 'OK'. All the blank cell will be highlighted, now enter the value and press 'Ctrl+Enter' to populate all the blank cells. Press 'Ctrl+1' to format cells, select custom if you want something to show up in the cell but not really be ...
TweenLite is a great engine for tweens which can be used for ActionScript 2.0 and 3.0. Copy the Gs folder available on TweenLite's website in your fla. file. Create a text movie clip (tlmc). Then open up action script. First type import gs.TweenLite. Next tween an object and type TweenLite.form (tlmc.2.{alpha:0}). That's it, the text will fade in 2 seconds. This will simplify writing scripts in flash for action script 2.0 and 3.0.
This video describes how to increase battery life on most of the LG phones", for that first we have to enter into the service by typing the numbers "##77647269700" and then clicking the call button. Now it will ask for 6 digit "service code" to enter into the service. Just type "000000" as a code and it will enter into the "services" Menu and from the menu click on the "Network Select" and from that choose "Mode Preference", by default "Digital Only Hybrid" mode will be in selected. Now to sa...
In this tutorial CreativeIceDesigns shows you how to make really cool electricity text effect by using Photoshop. To do this you need to open Photoshop and create new document. Layer will be black. Go to Type tool and type the word which you want to give effect. Now duplicate the layer and hide one. After that go to filter, stylize and wind option. Give this effect from all side. Change the color and unhide the text layer. After watching this you will be also able to make electricity text eff...
Just follow a few steps to simplify algebra with the minus one trick. First step is to take two algebraic equations with having numerator and denominator algebraic equations. Second step is to divide the denominator with numerator. For example, it have like -c/c, it gives like answer as -1, but we have another type like (c-a)/(a-c) - to solve these types of steps, like multiply numerator with minus(-), it gives the common the minus and -(a-c)/(a-c), then it gives -1 as a answer.
This video demonstrates how to use Photoshop to make text follow a path. First use the pen tool and draw the path you want your text to follow. They demonstrate by drawing a curved line above a circular logo. Select the type tool and start from the beginning of your path, then type your text. Select the path selection tool and fine tune the text placement by dragging the X. This video is easy to follow and shows how you can make text on a curved path.
In this video tutorial by Tasktutorial ,shows you how to . Select the rectangle tool and set the corner radius to 15px and draw a rectangle. Select gray stroke color and the stoke weight as shown. Select the gradient fill and set the angle to 90 degrees as shown. Resize the rectangle as desired, select the rectangle tool with white fill color, 1px stroke weight and draw the rectangle as show. Select the rectangle tool again with the corner radius of 5px and draw a rectangle as shown. Apply th...
This instructional video shows you how to reboot your iPod Touch 2G after shut down. First shut down the device and plug it to a computer via USB. Use the links in the description if you have the newest version of OS X. Put the device in to DFU mode by holding the home and power key for 10 seconds, letting go of the power key keep holding the home key. Download the RSlite folder from the link in the description. Open the terminal, change the directory to the Rslite folder and type the code re...
Have you ever wondered how sumo wrestlers are able to obtain and maintain such massive figures? Joseph Stickland, an applied clinical nutritionist, will explain to you exactly how a sumo wrestler is able to do this. Joseph will also explain the health detriments and the dangers to this type of lifestyle. Joseph explains that sumo wrestlers will skip breakfast, exercise, eat massive amounts of calories, (10,000 calories at least) for lunch, take a nap, and then have another mega calorie meal f...
Learn how to use Excel stylistic and number formatting by watching this video. You'll learn how to format a cell. These have different types of formats like general, time, date, etc. You'll also learn how to create a table. There are different types like names, values, time and time etc. Learn to create names like employee name and fill in the borders, and create thick lines. Watch this video for more information!
This video shows you how to easily change the default program associations of any file type. The movie shows you how to change the default program association of a JPEG file, but you can use it with any of the known file types. The first thing you have to do is right-click the desired file, hover your mouse to Open With and wait until a sub-menu appears. There, click Choose Default Program. Then, choose any other program that you want to open that specific file extension by clicking the Brows...
This video describes how to solve direct proportions in algebra which is an important and useful skill in everyday life, school and at work. In this video one would learn key elements of a direct proportion and learn to separate them into a more means more or less means less types of proportion. For example if one had a direct proportion of the more means more type one would simply gather the logical numbers and follow the two simple rules for solving. Overall this video is simple and useful ...
All those apps, but you can't preview them without buying. Wouldn't it be great if there was a way to check out these games for free. Check out this tutorial to get started!
Learn how to send a text message through e-mail. Just follow these steps. First step is to open a browser like Mozilla Firefox and other like Internet Explorer etc.
This video is about how to make fine hair thick and wavy with a flat iron. This technique is done with an Ed Hardy iron. Before you start, it's good to put heat protector on the hair. Taking small sections, as you run the iron down hair make sure you are turning the iron. It helps that this particular flat iron is good at creating this type of look. As you are working, you should add hair spray so that the curls stay in place. This type of look is great for those women who have little or thin...
Learn how you would bypass a school’s web filters so that you can go to content sites that are always blocked in examples of YouTube. Click the ‘Start’ button and then click on ‘Run’ and type in cmd and hit enter on your keyboard. This will bring up a command prompt where you type in ‘ping’ and then when that populates the next prompt you enter in the website to bring up the IP address. By entering the populated number you can get into a website from the search field of a web browser. It incl...
This video shows you how to change you Mozilla Firefox page to look like Safari. -First go into your Mozilla Firefox page and go to Google.
Some artists don't even deserve a full star. Learn how to give them the half-assed rating they deserve.
Bucky from The New Boston serves up this Python video tutorial on how to program parameters in Python. This is the program you use to write all of your Python code down. Different parameter types in the same function!
Oftentimes a friend will send you a PDF, MP3 or some other type of document such as a spreadsheet. When you open the file, an application opens. But sometimes it's not the application you wanted to associate with that file. In this video tutorial, you'll learn how to define which programs open what sorts of files. For more, and to learn how to set filetype application defaults in Mac OS X, watch this video tutorial.
In this tutorial, you'll learn how to use the emacs text editor, accessible through the terminal on any computer running Mac OS X, to play a simple version of Tetris. The steps are simple and as follows:
Whether you're a social type with a loooonnng list of friends or a PR gal with a bunch of people you've got to contact all at once to notify them of an event, it can often get time-consuming to type out the name of every single person you have to send the same email to.
This instructable aims to show you how to cut any type of disk to a desired shape. It is particularly useful in cutting down cheap 12cm DVD-+R 's into more expensive (can be up to 10 times more) 8cm DVD-+R disks. The technique shown here works with all disk types. The video below shows us cutting a music CD into a heart shape, and also illustrates the basics of cutting 12cm disks into 8cm ones. The actual cutting of a disk (and the guide) can be seen here:
Chef Don from HouseCallChef demonstrates how to grill mushrooms, asparagus, zucchini and yellow squash. You can also grill other vegetables such as parsnip, rutabaga, potatoes, tomatoes or peppers, and even some fruits like pineapple, watermelon, apples and oranges. You can use any type of grill that you want.
A great free video training from tasktutorial on how to create a cool movie text effect in Flash. Start by creating the text; type in "cool", rename the layer and lock it. Now type "movie" and rename the layer. Type in "effect" and rename this layer as well. Now focus on the first layer. Convert it to movie clip. Now convert the other two layers to movie clips as well. Stack the three layers on top of each other. Next add a key frame starting from frame 10. Select the "cool" layer. Re-size it...
Pixel Perfect is the "perfect" show to help you with your Photoshop skills. Be amazed and learn as master digital artist Bert Monroy takes a stylus and a digital pad and treats it as Monet and Picasso do with oil and canvas. Learn the tips and tricks you need to whip those digital pictures into shape with Adobe Photoshop and Illustrator. In this episode, Ben shows you how to transform a photo into a flashy poster in Photoshop.
Don't let Bejeweled Blitz get the best of you. Show it who's boss and get the highest score possible. Of course, you'll need Cheat Engine to overpower the game, so make sure you have Cheat Engine 5.5 or higher and check out this video for the hacking Bejeweled Blitz (10/09/10).
Whether you are protecting your children or hiding personal information, there are ways to block unwanted websites from your computer. Follow this tutorial and learn how to accomplish this on a Windows PC easily.
This video will show you how to use the ‘find’ and ‘replace’ text buttons in Microsoft Word 2007. Microsoft Word 7 is slightly different from the Microsoft you might be used to but with these instruction you’ll have no problem finding the buttons.
This video will go over how to insert a check box in Microsoft Word for printing or for electronic distribution. With just a few clicks you can get a check box. You can even add different symbols or styles for your check box.
Stan shows an easy way to see and clean the files that are hogging hard drive space in the computer using a free software called "windirtstat". Now enter the following address in the web browser "windirtstat.info" and scroll down the page until you get the downloading and installing section. Click on the link "windirtstat1.1.2Setup(Ansi&Unicode)" which will be right after the "for all flavors of windows" this will direct you to "SOURCEFORGE.NET" download creations. This will ask you to save t...
Daal makhani has a lot of different names. It is also known as kaali (black) daal or maa ki daal. It is a very typical dhabba dish and has a fantastic flavor. Watch this how to video and learn how to make Indian dall makhani.
In this series of videos you'll learn how to draw with charcoal from a professional artist. Expert William Cotterell shows you what types of art supplies you'll need to get started, including various types of charcoal, compressed and pencil varieties, types of erasers that work best with charcoal, and the best types of paper for making charcoal drawings. He also shares tips for choosing a subject, understanding light, blending techniques, adding highlights, and using Fixatif to protect your w...
Ever a hacker can have their own business that goes beyond cashing in on profitable bug bounties. With the right skill set and certifications, an ethical hacker could build a cybersecurity firm, become a penetration testing for hire, or even just consult on preventive measures to defend against black hats. But learning how to start and grow a business is rarely easy.
Apple released iOS 13.4.1 to the public on April 7 but also pushed out the update for the new second-generation iPhone SE model on April 23, one day before the device's official release. The update fixes a FaceTime bug and Bluetooth quick action failure that appeared in iOS 13.4.
As first reported by Next Reality last year, game developer Preloaded, in partnership with BBC Studios, has finally launched BBC Earth - Micro Kingdoms: Senses.
The UK has officially exited the European Union, completing the long and tumultuous Brexit story and putting the storied nation once again on its own on the international stage.
When attending networking events, a LinkedIn exchange is a common occurrence. Equally common is the awkward fumbling dance with how to add each other. Fortunately, we have the solution: the ultimate way to add LinkedIn contacts.
Remember when typing without physical keys seemed ridiculous? Now, touch typing is the smartphone norm. That said, mistakes are inevitable on small screens. So before you start hammering on that delete key or shaking your iPhone like a madman, know that there's a better way to undo text you didn't mean to type — no shaking involved.
The natural marriage between fashion and augmented reality is charging onward, but not just from the major brands we already know about.
