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 170th installment in their series of digital spreadsheet magic tricks, you'll learn how to use conditional formatting to hide or show items in a list using a TRUE/FALSE formula.
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 153rd installment in their series of digital spreadsheet magic tricks, you'll learn how to apply conditional formatting to the MAX value in a set of three incentive pay plans.
Microsoft PowerPoint is a powerful software to make presentations. It can also be used to make a Jeopardy board. To do this open a new PowerPoint presentation. Start with a title layout. Now add a gradient to its background. To do it right click on it and select the fill option from the menu. Select the color of you choice and fill the background. Now add the title in the layout with suitable fonts. Now add a new slide and insert a 5 X 6 table to it. Format the table with colors of your choic...
Patrick Norton and Veronica Belmont from Tekzilla will show you how to dual boot Windows 7 and download videos from YouTube. The hosts show viewers how to dual boot Windows XP Pro32 bit and Windows 7 RC 1 64 bit. In the first step as always you will want to back up your hard drive and at the very least they recommend to back up your most important files. In the case that something goes terribly wrong you can use a free program called EASEUS to make a complete image of your whole drive, this a...
To start off the process of publishing your access database online we first look at a sample MS ACCESS database with typical formats and a online searchable application where users can search by library name or city and get details of the library. There are 3 steps to publish the database. The first step is importing data which can be done through clicking on the file menu and then click on import data through a Microsoft Access Database. Now select the file you want to import through the bro...
Like it or not, Apple rules the world right now. Well, at least the electronic gadget world. Every single person and his or her mother has some sort of i-device: iPhone, iPod, iPad. So don't go iBroke the next time you want to add more songs to your iPhone or iPod by transferring all of your media files into iTunes readable formats.
In this video the author shows how to install any version of Linux from a USB thumb drive. He gives the requirements, which are a USB drive, the ISO of the Linux OS and a program called UNetbootin. He shows how to download the program from Sourgeforge.net. After installing it he shows how to set the version of Linux in the program. Later he shows how to format the USB drive quickly and he goes on to set the USB drive option in the UNetbootin program. Now all the Linux OS will be copied to the...
Learn to make HD Video With Windows XP's Movie Maker with this video tutorial. First, go to PapaJohn, there is WMV-HD at the left hand side of the screen. Expand that and click on the Introduction, then 1280*720 link. Download begins, save file on you hard drive. It has to be in the movie maker directory. It is in Program Files - Movie Maker - Shared Link. File must be added in the folder Profiles. Put it there, and if you don`t have such folder, create it. OK, we can start movie maker and ma...
This video shows people how to format and reinstall Windows XP on their PC from a CD.
As you might know, Tidal differentiates itself from the competition with its audio quality. Unlike Spotify and Apple Music, it aims to give its subscribers studio quality audio from any device. However, before you sign up for Tidal, be aware there are few steps you need to take in order to stream such high-quality music.
You can reach more people by using ebooks and epublishing - like the Kindle. But you can't just upload a Word or PDF to Amazon. You will need to format your book in a certain way to make it Kindle friendly.
In this handy home-computing how-to from WonderHowTo favorites Tekzilla, we learn how to use CleanHaven, an application that will remove unwanted formatting from snippets of text. For details on how to download, install and run CleanHaven on your own Microsoft Windows PC, watch this video guide.
First open up the Camtasia studio and click on the link make a recording. It will open up the Camtasia recorder but before you start the recording you need to click on the tools, options and make sure the "save as AVI" is selected in file menu. Then click on video tab and select the "manual" in "video configuration", 30 in frame rate and click ok. Now download and install the software called "free sizer". Now we need to set the recording area to 1280x720. To do that, right click on the maximi...
It's possible to partition and format your external computer hard drive into NTFS and FAT32 in order to make it compatible with your Xbox 360 or PS3. Watch movies and play music stored on your computer hard drive using your game console!
Looking for instructions on how to use TestDisk to recover files from a formatted hard drive on a Microsoft Windows PC? It's easy! So easy, in fact, that this home-computing how-to from the folks at Britec can present a complete overview of the process in just over six minutes. For more information, including step-by-step instructions, take a look.
Whether you're new to Microsoft's popular word processor or just wish to get to know Word 2007 a little better, you're sure to find much of value in this video lesson. For more and better information, and to get started formatting your own MS Word 2007 documents, take a look.
See how to create value-based formatting using data bars and color scales in Excel 2007. See how to use the Format Cells dialog box and the pop-up mini-toolbar in Microsoft Excel 2007. Whether you're new to Microsoft's popular digital spreadsheet application or a seasoned business professional just looking to better acquaint yourself with this particular iteration of the program, you're sure to be well served by this video tutorial. For more information, including step-by-step instructions, w...
See how to use the Format Cells dialog box and the pop-up mini-toolbar in Microsoft Excel 2007. Whether you're new to Microsoft's popular digital spreadsheet application or a seasoned business professional just looking to better acquaint yourself with this particular iteration of the program, you're sure to be well served by this video tutorial. For more information, including step-by-step instructions, watch this free video guide.
Speed up your MS Excel workflow with these handy formatting key commands. Whether you're new to Microsoft's popular digital spreadsheet application or a seasoned business professional just looking to better acquaint yourself with this particular iteration of the program, you're sure to be well served by this video tutorial. For more information, including step-by-step instructions, watch this free video guide.
Have an external hard drive that you'd like to use with both an Apple computer and a Microsoft Windows PC? With the FAT32 file format, it can be done! And this home computing how-to from the folks at CNET TV will show you how. For more information, including detailed instructions, and to get started sharing your own HDs between Mac and Windows computers, watch this free video tutorial.
New to Microsoft Excel 2010? Looking for a few good tips and tricks? Look no further. In this free video tutorial from everyone's favorite MS Excel guru, YouTube's ExcelIsFun, the 5th installment in his series of Excel 2010 video tutorials, you'll learn how to apply conditional formatting to cell data bars.
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 467th installment in their series of digital spreadsheet magic tricks, you'll learn how to apply conditional formatting every nth value using the SUMPRODUCT, MOD and ROW functions.
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 370th installment in their series of digital spreadsheet magic tricks, you'll learn how to apply conditional formatting to even and odd numbers using a TRUE/FALSE formula with the MOD function.
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 7th installment in their series of digital spreadsheet magic tricks, you'll learn how to remove the formatting from a given Excel cell without erasing the cell content!
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 Excel tutorial from ExcelIsFun, the 554th installment in their series of digital spreadsheet magic tricks, you'll learn how to apply conditional formatting to weekends and holidays with Excel's NOT and NETWORKDAYS functions.
New to Excel? Looking for a tip? How about a tip so mind-blowingly advanced as to qualify as a magic trick? You're in luck. In this tutorial from ExcelIsFun, the 474th installment in their series of digital spreadsheet magic tricks, you'll learn how to conditionally highlight every last value in a data set or each value which differs from the value preceding it.
Learn how to tie a Turk's Head Knot in a flat or matt format - A decorative knot that is tied flat and can, if desired, then be formed into the cylindrical form of the Turk's Head Knot. This is a fine knot for camping, climbing, sailing or Boy Scout training.
This is a shot how to tutorial on how to convert those HD mkv files you download from the web to a m4v file format. This way you will be able to play those files natively in HD on your Microsoft XBOX 360 and AppleTV.
The Toolbox in Office 2008 for Mac is more than just a simple formatting palette. There's so much you can do, so much you accomplish, but you need to know how to take advantage of everything offered in the Office Toolbox, whether in PowerPoint, Entourage, Word, or Excel. The Microsoft Office for Mac team shows you just how to format, insert, research, and clip with the Toolbox in this how-to video. Check out all of the things it can do!
Is your SD memory card getting a little too full? Is it not working? Try reformatting it. It's the first and sometimes last step to troubleshooting card problems. So, if your SD card has become too cluttered, this guide will restore it to a like-new condition with a simple format.
When shooting video on your phone, you have two cameras at your disposal, the rear camera and the selfie camera, and you can switch freely between the two. As for microphones, you may have more than one but, unlike with the cameras, it's not easy to switch between them. Filmic Pro solves this problem by isolating the mics so you can choose the best option for the audio track.
Format strings are a handy way for programmers to whip up a string from several variables. They are designed to save the programmer time and allow their code to look much cleaner. Unbeknownst to some programmers, format strings can also be used by an attacker to compromise their entire program. In this guide, we are going to look at just how we can use a format string to exploit a running program.
Welcome back, my neophyte hackers! In previous tutorials, we learned how to steal system tokens that we could use to access resources, how to use hashdump to pull password hashes from a local system, and how to grab password hashes from a local system and crack them.
If you have an older Samsung Galaxy Y smartphone, one thing you should be doing is using an microSD or microSDHC memory card to help improve your Android's processing speed and make it easier to transfer large or small files easily. These cards are also compatible with certain cameras and can be inserted into some computers. While all this is all good and well, you'll still need to know how and where to put your SD card in order to indulge in any of these benefits. Your Samsung Galaxy Y (the ...
In this clip, we learn how to format ActionScript code using the Adobe Flash Professional Actions panel. Whether you're new to the Adobe's popular Flash authoring application or are a seasoned Flash developer merely looking to better acquaint yourself with Flash Professional CS5, you're sure to be well served by this video guide.
The AMA architecture within Media Composer 5.0 has been expanding since 2009, to include the base of file formats which it is capable of supporting. This tutorial runs down many of these file formats, and how you can work with them After Effects and Avid Media Composer.
Internet whores (which would be all of us by now) are quite familiar with gifs. Just like popular internet memes like LOLCats, viral gifs are short videos or slide shows sequenced together for a comical - or at least unexpected - effect.
At its default setting, a Flip video camera will not take video in a format compatible with Windows Movie Maker, which makes it difficult if you wanted to turn your film into a clip or slideshow. This tutorial shows you how to convert content taken with a Flip camera to a Windows compatible format!
In this clip, you'll learn how to adjust timestamps from a MySQL database to the ago format (e.g., minutes ago, hours ago or days ago). Whether you're new to the PHP: Hypertext Preprocessor scripting language or are a seasoned web developer merely looking to improve your chops, you're sure to find benefit in this free video programming lesson. For more information, including detailed, step-by-step instructions, take a look
You love your PC, and heck, it probably loves you too. But sometimes, your drive can become infested with virus', spyware, adware, and all sorts of other nasty stuff. When an anti-virus program just is not enough, it's time to reformat. In this great, two-part video, you will learn how to reformat your computer with a fresh install of Windows XP.
