Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 41st installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use a true/false formula with the COUNTIF function to prevent duplicate entries in a list. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.
Ever have the problem of people messing with your word documents? This guy shows you the solution by telling you how to create password protected encrypted word documents. The process starts with your open file. Clicking on save as... and in the popup window clicking the tools button in the bottom left corner and clicking general options. There it shows you text entry boxes, one for setting a password to open the file, another to set a password for rights to modify the file. Enter your passwo...
As you might guess, one of the domains in which Microsoft Excel really excels is finance math. Brush up on the stuff for your next or current job with this how-to. In this tutorial from everyone's favorite digital spreadsheet guru, YouTube's ExcelIsFun, the 53rd installment in his "Excel Finance Class" series of free video lessons, you'll learn how to record bond discount and premium journal entries in Excel.
Once you learn some of the basics, Excel is an easy program to use. With the use of some simple formulas, you can streamline your whole data entry process. Just by typing in =SUM you can set a row or column to show the sum of other entries. It really is that easy. This video will show how to use these formulas and take advantage of Excel date math and time formatting.
Some times malicious programs can infect your registry and fill it with lots of unwanted information. You may need to clean it to prevent the virus from causing any further damage to your computer or to even disable the virus. It is a very lengthy and complex process to do this manually. So you will need to use one of the powerful free tools available online. Hijack This is one of the most powerful program that can be used for this purpose. So go the website and download this free tool. Insta...
The video demonstrates how to get started with MLA (Modern Language Association documentation format) for an article. One of the first things that is important to understand is how to name your paper, and add a header format that will automatically paginate your paper so that you do not have to worry about it. The entries in your Works Cited need to be alphabetized and also need to be indented. Note that there is no extra space between the entries. You do not have to know how to manually form...
This travel tutorial video explains the visa procedure for a tourist visa into Ghana. The process is simple. Visa costs include the following:
Starcraft 2 came out today, and it's fantastic. Unfortunately for those of you who are new to the game, it's pretty complex and the barrier to entry can be high especially if you want to play online. This video will help you get started by teaching you how to use basic build orders and micros and some basic tactics. This is a great video for any Starcraft 2 n00b who wants to improve their skills.
In this video, learn how to enter mail-in sweepstakes, what supplies you need, tricks and tips for filling out entries, how to organize your entries, and how to not get disqualified. This clip will walk you through the entire process so that you can increase your chances of winning and getting one of those oversized checks delivered to your door. So, follow along and enter those contests the right way to maximize your opportunities to win.
In this video tutorial, viewers learn how to copy and paste multiple text entries in a Windows computer. Users will need to download the free clipboard manager, Ditto form the link provided in the video description. Once downloaded, users will be able to manage multiple strings of text to copy and paste anywhere. Simply select the text field of the copied text and click on the icon in the system tray. Copied images will be displayed as a thumbnail. This video will benefit those viewers who us...
Halo Reach is the final entry in the Halo series (at least according to Bungie), and if you're looking to chomp up some achievements with little to no effort, you're covered! In this video, IGN shows you how to cheat the multiplayer settings of the game to allow you to get as many of the game's multiplayer cheats with little to no effort. Just be sure you can handle Legendary mode!
Starcraft 2 is finally upon us after 12 years of waiting, and it is just as majestic as you would hope it would be. If you're new to the series or just haven't played in five years, the barrier to entry for the unskilled can high, especially if you prefer playing online multiplayer. Fortunately for you, we've compiled videos on just about everything you need to know about the game, including strategies and tips for winning with different races in different modes and situations, and even how t...
If you know how to perfrom an ollie on a skateboard, why not try for somthing bigger and more challenging? This how-to video with professional skateboarder Danny Way shows you how to do an ollie blunt on a skateboard.
By default, Android limits your call history to the last 500 incoming, outgoing, or missed calls. When you reach this limit, older entries get trimmed off the bottom of the list and deleted forever. This isn't an issue with storage space, because even the biggest call logs only occupy mere kilobytes, so it's really just an artificial limit.
Android 6.0 introduced a new feature called Direct Share that allows apps to pin a more specific set of targets to Android's share menu. You've probably seen it already—messaging apps will allow you to share a file directly to a specific contact instead of just to the main app, and there are several other implementations like this.
Dr Haljand instructs on position your elbows and shoulders for the butterfly stroke. This is a dry land exercise for perfecting the entry of your hands for the butterfly in swimming. This is a very detailed breakdown of how your body is positioned in the water.
This is a dry land tutorial on backstroke swimming technique. Learn proper form for your stroke, broke down to entry and exit positions of stroke. This is an incredibly well detailed breakdown by Dr Rein Haljand.
In this video, we learn how Canadian citizens can get visas to Brazil. You must obtain an entry Visa before you can travel into Brazil. Without this, you will be denied entry at the Brazilian border. To get this, you need to have the correct forms and information filled out and submitted to receive your visa. There are different types of visas you need, make sure you choose the one that is correct for you. After this, you will need to figure out how long the processing time is and what the fe...
In this video tutorial, viewers learn how to add location shortcuts to KDE open file dialog. This task is very easy, fast and simple to do. Begin by opening the program. Then click on File and select Open. In the Open File window, right-click on the left side panel and select Add Entry. In the Edit Quick Access Entry window, type in the description, URL and select an icon. Finish by clicking OK. This video will benefit those viewers who use the KDE program, and would like to learn how to add ...
In this video tutorial, viewers learn how to draw an animated birdhouse. The materials required are paper and a drawing utensil. Begin by drawing a rectangular base. A bird house is usually geometric, show the base should only contain rectangle and square shapes. It is recommended to use a ruler, instead of drawing the lines free handed. Add a rectangular roof on top and an entrance in the front. Draw a circle to represent the entry way and add a post. Draw another circle inside the entry hol...
This video presented by Cris Ippolite makes a comparison between flat files and relational databases made with FileMaker Pro 10. It starts by showing flat files, which programs like Microsoft Excel use. Flat files have a big disadvantage: they cannot communicate with other files, even those with related data. If you wish to make your job easier, you should use relational databases. With databases, the tables communicate between one another. Once you store an entry in a table, you can use it i...
This video, presented by Cris Ippolite, makes a comparison between flat files and relational databases made with FileMaker Pro 10. It starts by showing that programs like Microsoft Excel uses, what in the databases circles, are called flat files. This flat files have a big disadvantage: it cannot communicate with other files even those have related data. So, instead of using those, if you want to ease your job, you should use relational databases. With databases, the tables communicate betwee...
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 set up SSH tunneling to securely transmit HTTP traffic.
Carriers like to distinguish their Android phones from the competition by making small changes to the interface here and there. This practice is so common that Android now has a built-in system for managing these small tweaks.
Samsung catches a lot of flak for all of the "bloatware" it preinstalls on its Galaxy line of devices. Many users complain that "TouchWiz," Samsung's custom Android skin, causes lag with its overabundance of features. But some of these features can actually be pretty handy, like Multi-Window Mode or Milk Music.
With every version bump, Android gets a new Easter egg that can be accessed by tapping the "Android version" entry in Settings. For the most part, these have generally been little animations or live wallpapers that depict the Android code name, but starting with version 5.0 Lollipop, things got a bit more interesting.
Whether you use a third-party keyboard or the stock offering, your Samsung device keeps a history of the last 20 words you copied on its clipboard. Samsung added this feature to Android to help make multitasking a bit easier, but if you use a password manager like LastPass, this feature quickly becomes a gaping hole in security. While you're copying and pasting your various passwords, the last 20 of them become freely available to anyone that gets their hands on your device.
The problem with striving to be on the bleeding edge of what's new for your smartphone, or really anything else in life, is having to constantly check websites and forums for new content. And with lots of that browsing happening on our phones, the aimless page loading and refreshing is not just annoying when there isn't new content, but can lead to wasted data usage, not to mention time.
Replicate the Predator-style video camouflage in After Effects by using displacement maps. This uniquely stunning and groundbreaking visual effect has been seen countless times in film and television to show video camouflage, invisibility, heat distortion, holograms, and static interference, among others. This video shows how to replicate this effect by using green screen footage, Fractal Noise and Displacement Maps, all within Adobe After Effects.
You can drag and drop an email onto your Calendar icon in Microsoft Outlook, which then immediately gives you the option of setting up a new calendar entry. You can even color code your various events for easy reference later!
Looking for a primer on how to create and work with arrays in Microsoft Office Excel? You've come to the right place. In this free video tutorial from everyone's favorite MS Excel guru, YouTube's ExcelIsFun, the very first installment in his series of Excel array formula series, you'll learn how to create a basic array formula. Learn about the syntax, the Ctrl + Shift + Enter method of formula entry and the curly brackets that get entered automatically by Excel.
Nick from Greyscale Gorilla demonstrates how to do the effect from "The Matrix" in which time stands still and the camera whips around, continuing the action from another perspective. Go here for Nick's blog entry:
Nick from Greyscale Gorilla gives a great tutorial on not only how to adjust the hue and saturation of various objects in Photoshop, but he also demonstrates how to select and isolate these objects for better chromatic keying.
Whenever you right click a file in Windows it opens up the context menu, which gives you options of what to do with the file. Learn how you can add your own custom options to the context menu by editing the Windows registry.
One of Android's biggest strengths relative to iOS is how simple it is to sideload apps that aren't on the official app store. Rather than having to sign IPA files or tell your phone you trust a developer every two weeks, you can just enable a setting and be done with it.
For every contact photo you add, Android keeps two copies. The first is stored at a 720p resolution, and this is used for high-definition imagery when you're looking at a full-sized contact card. But the second image is only 96 pixels by 96 pixels, and this is used for all thumbnails throughout the operating system.
One of Android's biggest strengths relative to iOS was the ability to switch to a third-party keyboard. While Apple has finally included this feature in its latest OS and leveled the playing field a bit, the variety of options still pales in comparison to what's available on Android.
With the new version of Android due out very soon, Android 5.0 "Lollipop" has received a ton of press lately. It's all well-deserved, of course, because the new "Material Design" interface is absolutely beautiful.
With all of the personal data that's stored on our smartphones, it's of vital importance that we have some sort of lock screen security enabled. One of the Galaxy S5's killer features is obviously the fingerprint scanner. It makes the process of dealing with a secure lock screen a bit easier than typing in a password or PIN.
In this tutorial, we learn how to open an Xbox 360 tray with a paperclip. If you cannot open up your Xbox and need a tool to open it, use a paperclip! First, take the paperclip and open it up so it's long and straight. Then, take the cover off of the Xbox. After this, use the paperclip to poke inside the Xbox near where the CD entry is. Once you do this, the tray will pop open and you will be able to insert or remove the disk from it. Once finished, you can use this anytime it gets stuck and ...
