This video is a tutorial on using the Conditional Formatting function of Excel to automatically color alternating rows, which helps your eye to follow across the row. This can be done manually with the “Fill Color” button, but if you add or delete rows after applying the shading, the whole purpose is defeated.
Latest video files come in different formats. Some of the programs and devices are compatible with only a few formats and this requires you to convert files between different formats frequently. Lot of streaming files on the internet are in FLV or MPEG format and to use them on your portable devices you may need to convert them into MP3. To do this you will be needing a application called VLC media player. VLC is the most powerful open source medial player which almost supports all of the vid...
To format an external hard drive on Windows Vista, plug the hard drive in, then click on start menu, right click on "computer", and select "manage". Go to "storage" on the left hand menu and select "disk management". Right click on the letter of your external hard drive, and select "Shrink Volume". Choose the size of the partition you want to create, and click shrink. After it is done, there will be 2 seperate drives, with the new one being allocated. Right click on the unallocated drive and ...
Tearing yourself to pieces trying to format fractions in Microsoft Excel? Give this video tutorial from everyone's favorite YouTube Excel guru, ExcelIsFun, your undivided attention. With it, you'll learn how to format fractional values via the custom number formatting tool in the number tab in the format cells dialog box. This video discusses proper, improper, like, unlike and mixed fractions.
This video in the Software category will show you how to use multitrack live recording in Logic Pro 9 . This video is from Lynda. Say you are going to record a 4 piece band; drummer, base, guitarist and a singer. Use separate mikes for all four. First you make 8 different mono audio tracks. Go to track menu and click new. Type in 8 for number, select audio, format will be mono. Now you click the ascending box, order the inputs from one to eight and click create. Now you have 8 audio racks. Cl...
It is a great video tutorial about how to create a keynote presentation to run on a windows platform. After opening the keynote presentation, click on file menu and open up the export window. This window shows different file formats and types. By using this we can export a quick time movie, an html, PDF, images, flash or a PowerPoint presentation file.
In this video tutorial, viewers will learn how to change text alignment and formatting in Microsoft Word 2007. To format or align the text, you must high light it first. Once highlighted, users are able format the text in many ways. The formatting options are: font type, font size, bold, italics, underline, strike-through, subscript, superscript and change case. The alignment options are: right align, center, left align and line spacing. Users also learn how to add pictures and position the t...
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 the MediaInfo GUI on Ubuntu Linux.
Formatting a hard drive is not exactly an essential computer skill, but it certainly is if you're a technie who's looking to start building your own computers. Hard drive formatting involves erasing/formating a hard drive or USB flash drive to be compatible with different formats like MAC OS Extended and Windows OS.
A beginner's Microsoft Excel tutorial that covers working with formulas, formatting, auto-formatting, dates, and more in Microsoft Excel.
lyndapodcast teaches you how to apply conditional formatting withing Microsoft Access 2010. You click View - Design View. Click the Total tab and you'll notice some highlighted options above. Click Format and then Conditional Formatting. This where you will create rules. Click the new rule button. Now you will see the conditions with drop-down menus. Type in the numbers you want and then select the formatting you want when the rule is true. The preview below will show you how the numbers will...
Welcome back, my hacker apprentices! A you know, Mr. Robot is my favorite TV show this year, and not just for the realistic hacking. Rami Malek, the actor who plays Elliot, is incomparable in his depiction of a young man with social anxiety who is alienated from a superficial, materialistic society and wants to make a better world. I believe we will see a lot more of this actor in coming years.
Excel is great, and if you're a Mac user, Excel 2008 for Mac has a lot of new and useful great features you can use to maximize efficiency in your spreadsheets. Excel doesn't have to be the boss anymore, you can! The Microsoft Office for Mac team shows you all the great features in this how-to video.
Before you do any shooting on the Red One Camera, you must set up your project settings and format your media with the settings you plan on shooting with. 2K, 3K, or 4K and your FPS must be set or face bad consequences when you go to edit this footage.
Minimize loss of quality when you're changing a video from one format to another. This tutorial shows you how to take a film clip in high definition mp4 format and convert it into an avi format with minimal loss of data or quality.
Always make sure you've formatted your numbers correctly within the proper cells when you're developing a spreadsheet in Microsoft Excel. There are a variety of number formatting functions you can use to make your spreadsheet more readable, and this tutorial explains how to use number formatting correctly.
In this video tutorial, viewers learn how to save in .doc file format in Microsoft Word 2007. When saving a file, click on File and select Save As. In Format, change it to Word 97-2004 Document(.doc) and check Append file extension. To set .doc as the default format, go to Word and select Preferences. Under Output and Sharing, click on Save and change the format to .doc in Save word file as. This video will benefit those viewers who want to learn how to save files in .doc format so that it ca...
Reformatting a flash drive will update its drivers and rid it of all data. This can help in a lot of occurances. This tutorial will show you exactly how to format flash drive properly.
In this video, Steven Chong teaches you about when to use the "functional" resume format. In this video you will be introduced to the "functional" resume format, and when to use it. The Functional Format Resume lists your employment history into sections. These sections highlight areas of skill and accomplishment. Reasons to use this type of format include: When you are overqualified. If you have gaps in your employment history. When you are going to a completely different industry. If you fo...
What's better than Microsoft Excel's conditional formatting feature? Microsoft Excel's conditional formatting feature when used with multiple criteria, that's what! In this Excel tutorial from ExcelIsFun, the 544th installment in their series of Excel magic tricks, you'll learn how to build multi-variable conditional formatting formulas using the TRUE, FALSE and AND operators.
This is an Excel magic trick video in which the instructor shows how is time represented in Excel and how it is formatted before displaying it to us. He talks about the decimal representation of the time. He says that if O hour is mapped to the number zero and 24th hour of a day is mapped to number one then we can represent any time of the day in the format of a decimal number between zero and one. He shows the type of formatting that excel uses to convert the decimal number into a human read...
In this video, , peakDavid, demonstrates how to use and understand the APA (American Psychological Association) format for citing sources for references in papers, essays, and theses. You will learn the different types of citations used in APA format, and learn to understand how they are used to reference the works you used in your paper. Also, you will learn why you should use the APA format to cite your research, to avoid confusion by the reader, as well as any claims of plagiarism.
In this video the author shows how to perform custom number format for turnover ratio in a Microsoft excel document. He shows how to perform custom number formatting in which he shows how to display a decimal value in words. He opens the Format Cells option and there he shows how to set the Custom option. He shows how to configure different options so that we can format the decimal value and display it as text with some meaning attached to it. In this video the author shows how to use custom ...
Microsoft Office Excel 2007 spreadsheet manager is a powerful tool that enables information workers to format spreadsheets, as well as analyze and share information to make more informed decisions. In this MS Excel video tutorial, you'll learn about using conditional formatting in Excel to change background color. To get started learning about conditional formatting, watch this MS Office how-to.
Microsoft Office Excel 2007 spreadsheet manager is a powerful tool that enables information workers to format spreadsheets, as well as analyze and share information to make more informed decisions. In this Excel tutorial, you'll learn about simple formatting, background colour, gridlines, alignment. For more information on formatting spreadsheets within MS Excel, watch this helpful how-to.
Whether you're interested in learning Microsoft Excel from the bottom up or just looking to pick up a few tips and tricks, you're in the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the 270000000000000000000000000000000th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to use custom number formatting for cells and the TEXT function. Specifically, this lesson covers the following:
In this how-to video, you will learn how to format one of your hard drives in Windows 7. First, go to start and right click my computer. Select manage and a new window will pop up. Go to storage and select disc management. Now, right click the drive you want to format. Type in the name you want for the label and check quick format. Once this is done, press okay. Click okay to continue. This does not take too long. You have now formatted a hard drive. This video shows you the basic steps it ta...
This is a highly informative video tutorial on how to use the software CamStudio to screen record anything on one's desktop. One simply has to open a search engine like Google, type in 'camstudio' and hit the search button. On Google, the official website, camstudio.org, is the first one in the search results. Once that is opened, just scroll down, click on the link camstudio20.exe, and then click 'save file'. Once downloaded, this software can capture all the audio and video activity on the ...
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 72nd installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to turn off auto formatting so that column and row formatting or formulas are not automatically created.
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 101st installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use conditional formatting AND custom number formatting to add styling to a cell.
Android users have had access to live wallpapers since the Eclair days, but some newer apps have made this feature even more useful. Now, you have the ability to use GIFs as your wallpaper, and through the marvels of modern technology, you can even set a video as your home screen and lock screen background.
In this video tutorial, viewers learn how to use the MP4 video converter software, ImTOO. Begin by downloading the program from the link provided in the video. Once downloaded and installed, open the program. On the right side under Profile Settings, users are able to select name, video size, video quality, audio quality, channel and split of the video file. Then click on the Profile combo box and select an output format for the video. Now click Add Files to import a video into the software. ...
In this tutorial, we learn how to prepare a PowerPoint file or presentation. First, open up the software and start a new project. After this, you will start a page that has nothing on it. Insert the title of your page as well as any images or audio you would like displayed. After this, you will be able to add in a transition that will easily make this page go to the next one smoothly. Continue on to the next page inserting your information for your presentation. If you are adding bullets for ...
In the digital age, old fashioned film processing and developing may seem outmoded and obsolete. However, for professional and aspiring professional photographer who want o make classic-looking prints, this is far from the case. This three-part video describes how to do tray processing yourself for large-format sheets. It breaks down the equipment you will need, the advantages and disadvantages, and of course how to go about processing you own film sheets. The dark room is back!
In this video tutorial, viewers learn how to burn a CD or DVD on a Mac computer with the Burn application. Burn is able to create data, audio and video discs. The Inspector window allows users to edit extra information about the disc. To open Inspector, press the Command and I button. It is also able to create disc copies. To burn a disc, name the disc and select a format. Them simply drag the file(s) into the program and click Burn. This video will benefit those viewers who have a file on th...
In this video tutorial, viewers learn how to add custom music in the game, WWE Smack Down vs. Raw 2009. Users will need a blank recordable CD and cannot use MP3s or any other audio format. Begin by recording all the music files into the CD and the insert it into the Xbox360. In the Xbox360 dashboard, go to My Xbox and select Play CD. Click on Rip CD and name the information of the CD. Now select the song that you want and add in into a play-list. Now to select the song in the game, select use...
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 6th installment in their series of digital spreadsheet magic tricks, you'll learn how to add conditional formatting to a whole row of data in an Excel sheet.
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 137th installment in their series of digital spreadsheet magic tricks, you'll learn how to apply custom number formatting as well as how to conditionally format dates and weekends using a TRUE FALSE formula with the AND and WEEKDAY functions.
In this video tutorial, viewers learn how write a resume in the table format. A table formatted resume is one of the most effective formats. It highlights metrics in a particular field that potential employers are looking for in a presentable quick overview. At the top of the table, provide your name, contact information and location. In the table, list your skill, experience, role and products from each of your previous jobs and experiences. This video will benefit those viewers who are sear...
This is a software demo. This Mac software allows you to play a song or music or audio track and reduce its speed without affecting the pitch. Select a guitar riff or chord sequence, loop it, and speed up or slow down that loop so it runs faster or slower, without changing the pitch. The program has some sound editing functionality, like EQ, but is mainly a tool for changing a recording's speed. Import a track from iTunes, or directly from a CD, adjust the speed, apply the optional equalizer ...