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...
AntiVirus Live is a fake antivirus software which comes onto your system and asks you to buy it. It doesn't provide any security to the computer. Here is the procedure to remove it: (1) disable the proxy server for your LAN in Internet Explorer. 2) download the process explorer from ms technet. 3) locate and kill the sysguard.exe. 4) finally remove AntiVirus Live. After following all these steps reboot the computer. Protection against future intrusion is mentioned. You should be aware of the ...
Interested in animation? Let's animate some photos with Adobe ImageReady. First, put all pictures in a single folder. Open ImageReady and import the folder with the pictures. The photos will be arranged in the timeline but they play too fast. You can adjust the timing of each picture which has an icon under it. To save it as a gift file, click Internet Explorer on the toolbar. Then right-click it to "save picture as" and save it. It will help you in making slideshows/presentations.
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.
In this how-to video, you will learn how to create a Facebook group. First, you must have access to a computer with the internet and a Facebook account. To create the group, you need to press the application button and press groups. Press the create new group button. Once this is done, fill out the information required and click create group to finish the process. Now you can invite other people into the group. You can bring a group of people together with a common interest using these groups...
The Facebook is one of many social community website with many features. To break into Facebook at school there are many ways. Some of them are listed below.
In this video the author shows how to burn a movie file to a DVD using free software. He explains the requirements are the movie to be burned, the DVD burning drive and a software called DVD Flick which is used to burn the movie to the DVD. He shows how to download the DVD Flick software from the internet and how to install it. He opens the installed software and shows the various settings of how to select the movie and explains about the supported video formats, how to set the title of the m...
This video will show you how to enable/disable the pop up blocker for a specific web page: 1. To allow pop ups on a specific website click on the pop up blocker button on your tool bar, the Icon will change to show that pop ups are now allowed.
Learn how to add a Mac Dock to your Vista or XP computer * Firstly go and open up your internet browser.
Want to get the Wii Opera Browser for free? This will not work with a USB, only a SD-card. Steps according to corradostyler94 listed below.
Taking photos is great, but what about being able to share them with the world wide web? There are countless of image hosting options out there to get your photos on the internet, but imgur is probably one of the simplest and easy image uploading sites out there.
Let's face it: Most people, even our friends and family, find it pretty boring to open emails with huge photo files attached to them. They're bulky and take forever to load.
Learn everything you could possibly want to know about the internet, multiplayer game Evony. Watch this video tutorial to learn how to make the most out of the Evony marketplace. These are basics ways to make more gold and get more resources when buying and selling in Evony.
New to Ubuntu Linux? This computer operating system could be a bit tricky for beginners, but fret not, help is here. Check out this video tutorial on how to install Frozen Bubble 2 on Ubuntu Linux.
Learn everything you could possibly want to know about the internet, multiplayer game Evony with help from ZaCoder. Watch this video tutorial to learn how to get maximum gold in Evony while offscreen.
Hak5 isn't your ordinary tech show. It's hacking in the old-school sense, covering everything from network security, open source and forensics, to DIY modding and the homebrew scene. Damn the warranties, it's time to Trust your Technolust. In this episode, see how to install a Wii homebrew hack using the Twilight Hack.
This video will show you how to stack plow in Facebook's Flash game Farm Town. This only works if you are using Internet Explorer (IE). This involves making a plot and then stacking a second plot atop the first plot. This is stack plowing. This is a cool cheat for Facebook's Farm Town.
Personalize your drinking glasses by etching names and messages on them. Your guests will be so impressed!
In this video tutorial, you'll find a step-by-step guide to how a n00b hacker (like you?) can get usernames and passwords easily through one of the security flaws of the Ethernet ADSL router. More than half of Internet users never change their default password which makes this "hack" easy. Take your time to read the text on the slide. For more, and to get started testing the security of your own Ethernet ADSL router, watch this hacking how-to.
This software tutorial shows you how to create an awesome background of your own design for your YouTube channel in Photoshp. The tutorial tells you to start with a template provided below, and adjust it as you see fit in Photoshop, then upload it to the internet with justupload.net, and add it to your YouTube page. Even if you don't like green and black, you can change the template in Photoshop and learn how to upload it as a customized YouTube channel background.
In this extensive three part video series, you'll learn, quite literally, how to build a fully furnished home in Blender 3D. Starting at the basic blueprint, to adding free furniture off of various internet websites, you'll get the full walkthrough in each part of the video.
Zune is a digital media players and services sold by Microsoft. It includes portable media players, client software, and the Zune Marketplace Internet music and video store. If you hate the Apple iPods, you probably have one of these MP3 players.
In this video tutorial, Chris Pels will show how to configure an ASP.NET web site to use a specific version of ASP.NET/.NET Framework. First see how to identify what version of the .NET Framework a web site is associated with by viewing the script map in Internet Information Server (IIS). See how a script map is associated with the root in IIS and then with individual web sites. Next learn about the ASP.NET IIS Registration tool (aspnet_regiis.exe) used to configure IIS or an ASP.NET web site...
Before you start sculpting in Pixologic's Zbrush 3.1 3D modeling software, you'll want to have references to follow by. So, check out this video to see how to use Andrew Loomis's art books for referencing while sculpting in Zbrush. You'll see where to get Loomis's books on the Internet and what best to work with for your 3D digital animation. Modeling with Zbrush will be a breeze if you have reference to go off of, because you need it.
With the convenience of internet poker games, everyone wants to play Texas Hold'em online. If you know the rules and good strategy you will have the advantage. The rules of an online Texas Hold'em tournament differ from game to game. Learn the basic structure of most online Texas Hold'em tournaments with this how to video. This lesson is a must have for anyone who wants to start playing Texas Hold'em poker tournaments online. You'll be a pro in no time with this Texas Hold'em tutorial.
While sliding doors is far from a new concept and will be obsoleted once we see wider support for multiple backgrounds (CSS3), it is still a good one for your bag-of-tricks. The theory is that if we have an extra hook in our markup, we can apply two overlapping background images to a single spot of text. When that text grows or shrinks, these overlapping images and reveal more of themselves creating the illusion it is a single expandable graphic. In this video screencast, we do a quickly exam...
Firebug is an essential Firefox extension for web designers and developers. You are able to quickly target any element on a page to see the markup, the CSS, the layout, and the DOM in an instant. Not only can you see all of this juicy information, you can edit and see the results directly in the browser window. This makes Firebug the go-to tool for debugging CSS trouble. Also indispensable for Javascript programmers. So all you Internet website designers out there, pay close attention to this...
Many sites do not use any fancy Content Managment System (CMS) to generate their pages, they are just just good ol' static HTML content. A site for your grandmothers pie baking business probably only has a few pages, perhaps a homepage, about page, and contact page. Each of these pages has different main content, but much of it stays exactly the same, like the header, navigation, and footer. Think of these sections as "modules" that you can easily use PHP to insert into the page. This way, ma...
Being organized and using good formatting in your CSS files can save you lots of time and frustration during your development process and especially during troubleshooting. The multi-line format makes it easy to browse attributes but makes your file vertically very long. The single-line format keeps your file vertically short which is nice for browsing selectors, but it's harder to browse attributes. You can also choose how you want to group your CSS website statements. Do you do it by sectio...
Notice: This is probably not new to many people. This *IS* new for some people however, and meant for them! Post interesting cameras you find.
We show you how to play video you download from the internet on your TV using an iPod Video and remote dock ...no need to wait for the iTV device from Apple. Then we give you an updated review on Parallels software which enables the use of Microsoft Windows and Windows applications on the Mac at the same time that the Mac OS X is running. The last segment presents a review of a couple of models of PowerPoint presentation remotes from Keyspan PR-US2 and Interlinkelectronics RemotePoint Navigat...
If you're an actress, dancer, or singer (or maybe all of the above), there's nothing more flattering than seeing your name on a marquee, especially if it's the first one listed. You can also get your name lit up in lights by creating this marquee in Photoshop.
Wouldn't it be great if we could all enjoy the music, photos and movies on our home computers even when we're not home? Some would think it a luxurious feature, but it's totally possible for anyone who has Windows 7 and an internet connection. See how!
Tired of walking everywhere? Does your only ride have two wheels and a bell? Check out this video and learn tips and tricks for convincing your parental units to buy you a car. Pretty soon you will be cruising through town and the envy of all your friends.
Pilates is fantastic exercise. If you are a beginner, though, it can be confusing to choose the right type of class. Check out this tutorial before you head to the studio and ensure you get the most out of your exercise routine.
Typically taught during the elementary school years, cursive writing builds on the letter formation of block letters or printing. The pencil doesn’t leave the paper in cursive writing and letters flow together. If you don't know how to do this, check out this video tutorial. Learn to write cursive, step by step.
Garlic is good for you and adds great flavor to your cooking. Add this versatile plant to your garden this fall and in no time at all you'll be pulling up fantastic cloves of fresh, home grown garlic that you can use and share with your neighbors.
Looking for a new twist on an old classic, then try Indian inspired mutton chops. Lamb mutton chops are a fantastic and filling main course and with the addition of Indian masala spice seasoning you will be left with an exotic fusion full of flavor. This is a condensed and hearty meal.
Learn how to browse the Internet at work and get away with it. Load Excel (Any version will do). Click on the Data tab. Click 'Import External Data'. Click 'New Web Query'. Once the window has loaded, click through the prompts, selecting Yes. When the window has loaded completely, go to your favorite website in any browser you want. For this example, Twitter is used. Go to the RSS Feed and copy the link that appears at the top. Paste the link into Excel and click the Import button. Accept any...
In this series of hobby videos, you will learn how to create your own model trail village. Our expert will help you to create a styrofoam base for your landscape, then suggest how to add buildings, cars, even sidewalks and roads to your model train layout. Watch this series to learn how to plan tracks and route your trains to create a fantastic world of your own.