Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 43rd installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn use a data validation drop-down list to change conditional formatting in a table. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.
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 504th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the borders tab in the Format Cells dialog box to create a 3D effect.
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 501st installment in their series of digital spreadsheet magic tricks, you'll learn how to work with time in Excel, making calculations and formatting temporal values.
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 507th installment in their series of digital spreadsheet magic tricks, you'll learn how to take badly setup data (not in database/table format) and summarize it by date and shipping name into table format report.
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 566th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the IF functions and a bar chart to create a conditionally formatted chart for students scores that exceed a given hurdle.
Learn how to extract .rar or .zip file formats on a Windows computer. These file formats are often used to package larger files into files that take up less memory space. First, a new folder is created to house the extracted file, and the file is dragged inside. Next, the user must right-click on the .rar file to be extracted and select the "Extract Here" option from the dropdown menu. In addition, this video will also show helpful sites from which to download the WinRar or WinZip programs, w...
This video teaches us to partition a hard drive. Open 'Disk Utility' and go to 'Seagate FreeAgent Media'. Go to 'Partitions' and select '2 partitions' in the 'Volume Scheme'. Click on 'Untitled 1' and put the name of the partition, its format as Mac OS Extended (journaled) and Partition Table from 'Options'. Name the second partition and choose 'MS DOS (FAT)' in format. Choose 'Master Boot Record' in 'Options'. Click 'Apply' and 'Partition'. This creates the two partitions of the hard drive a...
In this video tutorial, viewers learn how to change/convert a pivot animation into an AVI video format. Begin by loading the animation in the Pivot program. Now click on File and select the Save as type to Animated gif. Nam the file and click on Save. Then open Windows Movie Maker and add the pivot animation into the time line. click on Publish Movie and select This Computer. Name the file and select the save location. Click on More Settings and select DV-AVI (PAL) and click on Publish. This ...
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 346th installment in their series of digital spreadsheet magic tricks, you'll learn how to format your numbers to show exponents and see how to create a formula that uses exponents.
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 296th installment in their series of digital spreadsheet magic tricks, you'll learn how to add conditional formatting to a row, a column and the intersection of the two with three different colors.
Here the New Boston shows you some tips about using the Spry Validation Text Field. To begin you will go to the Spry Validation Text Field, on Dreamweaver CS4. Looking at the bottom of the page notice the various options that are available for Properties. You find drop-down boxes for Type, Pattern, Minimum or Maximum values, Required, Enforce pattern, Format, Validate on, Blur or Change and Preview States. You can see the types of text available for validating by left mouse clicking the Type ...
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 177th installment in their series of digital spreadsheet magic tricks, you'll learn how to format a column as text numbers to avoid data validation trouble.
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 98th installment in their series of digital spreadsheet magic tricks, you'll learn how to use a TRUE/FALSE formula and the TODAY function to format a calendar within a two-week period.
In this how-to video, you will learn how to convert a file from .docx to .doc. First, go to the Microsoft Office website and install the Open XML Converter program. Open the program. Navigate to the file you want to convert. Drag the file into the program. The program will convert the file to a .rtf file. Microsoft Word will open the document. The file will be saved in the same folder as the original document. You will be able to use files created in the latest version of Office in older vers...
Thinking of switching to a Mac using an external hard disk, you'll need to format it so that the Mac can recognize it. In your Mac, go to finder, then applications. Scroll down to where it says disk utility and then select it. Here select your hard disk and press the partition button in the screen that comes up. Make two partitions and rename them to whatever you want. After that change the format of the partition to Mac OS extended. Now just press the apply button to apply the changes, be su...
New to 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 270th installment in their series of digital spreadsheet magic tricks, you'll learn how to
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 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 ...
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.
First, insert a bootable XP cd in your hard drive. Then the setup will start. Press "enter" to setup XP and then press F8 to accept the agreement. After that, press "enter" to setup Windows XP on unpartitioned space. After this press "Format using the NTFS file system". Then a new window will appear which will start the formatting process which will take several minutes depending upon the ram on the computer. This will help you quickstart your new PC on your own.
This video shows you how to calculate weighted average cost from a transactional data set using SUMPRODUCT function. It explains things very clearly. If you're working with a very large database transactions the SUMPRODUCT function makes it. It works as text if you do the formatting first and then type the number. We put the number in first and then format as text, then press F2 and ENTER.
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. This Microsoft Office video tutorial presents an extremely introduction to Excel. In it, you'll learn about names of bits and really simple formatting. To get started using Excel for yourself, take a look.
Got a song or two you need to convert from WAV to MP3 format? This music editing software tutorial will show you how to do it using Music Morpher Gold. See how to convert WAV to MP3 with MMG and this video.
Check out how to read a binary clock in this how to video. You'll see how to read the BCD (binary-coded decimal) format like so many can't. Just watch this if you have trouble determining the hours, minutes, or seconds on your binary clock. You can read it in standard or military time if you'd like.
Learn how to write a simple prank program that will make someone think that their hard drive is being formatted and completely erased.
How to convert videos to various formats (including web format) with VLC Media Player, free open-source media player
This tutorial goes over the tools in Pages '08 that you can use to format a document properly. It goes over customizing margins, headers, footers and page orientation.
Create an effect in your video where the video footage is converted to black & white, pauses, and resumes playback in regular color. This effect is demonstrated by Aharon Rabinowitz with Spy Photo, a brand new set of free presets for Adobe After Effects.
In this video, expert resume writer Susan Ireland gives you advice for writing a letter of recommendation - for yourself! She offers you quick tips so that you can get past writer's block and start writing an effective cover letter. Let Susan help you get the job of your dreams.
A cover letter is a document sent with your resume to a prospective employer to indicate your interest in a position at their company. This how to video teaches you how you can write a concise and intelligent cover letter that will impress the company where you are applying.
This video is describing how to preview the pasted items such as from another PowerPoint or any other articles. These are all features available in the "Microsoft Office Power Point 2010". We will take the "conference1" presentation in that the first slide and we would like to add some text from another "Document" from another application like "Microsoft Word". So, we click and drop the mouse to select that and click the Copy button on the top of the word file or we can copy by the keyboard i...
Sure, you can make boring tables inside PowerPoint 2008 for Mac, but who wants to add that dull element to their slideshow presentations? Nobody! Tables can be more than just numbers, they can be eye-catching and visually striking. The Microsoft Office for Mac team shows you just how to create great-looking tables by using Tables Styles in this how-to video.
In this Business & Money video tutorial you will learn how to make a successful curriculum vitae or resume. This is the first step in getting your dream job. A well written CV captures the interest of the person who is reading it. Think yourself as a product and the CV is a piece of paper that is going to sell you. Don't be afraid to sell your skills and abilities. If you don't do it, nobody else is going to do it for you. First thing on top is to put your name; centered and bold. Then leave ...
In this video from macmostvideo we learn how to import unsupported video in iMovie. This happens sometimes when you buy a camera that is not compatible with iMovie. You can add certain video formats to your Mac to make your Mac understand these video formats that don't work with your iMovie. A common one is called mpeg2. You can get this trough Apple. In other cases you get the software with the camera. If you need to convert a video file, try to open it through QuickTime first. If that works...
In this clip, learn how to use the Format Dropdown Menu, Underline, Align Full and color adjustment buttons in the WordPress editor. Every version of WordPress brings with it new features, new functions and new ways of doing things. Fortunately, the very same technology that allows an open-source blog publishing application like WordPress to exist in the first place also makes it easy for its users to share information about the abovesaid things through videos like this one. Take a look.
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 631st installment in their series of digital spreadsheet magic tricks, you'll learn how to add conditional formatting to a transactional record when the date is 90 days past due using the TODAY function and mixed cell references in a logical TRUE-FALSE formula.
Before you can work in Word 2010, you'll need to learn how to work with it. See how to join, split and apply formatting to cells within Microsoft Word 2010 with this free video software tutorial. Whether you're new to Microsoft's popular word processor or just wish to get to know Word 2010 a little better, you're sure to find much of value in this video lesson. For more and better information, and to get started working with cells in MS Word 2010 yourself, take a look.
Whether you're interested in learning Microsoft Excel from the bottom up or just looking to pick up a few tips and tricks, you've come to the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the nth installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to create and work with pivot tables (PivotTables) in Microsoft Office Excel. Specifically, this video covers the following topics and examples:
In this video by Tinkernut, we are taught all about the basics of converting and encoding videos into their various formats. He starts off by covering the video containers. Then he breaks down what is contained in these containers. He goes over the what data per second you need for each way of watching the videos. Then he suggests a couple of programs that help you convert your videos in the appropriate format for watching your videos in the many different ways out there.
One of the best features of Apple's Final Cut Studio is the disc designing feature DVD Studio Pro. With its ability to create high-end DVD masters, you can easily make discs for your indie film, or maybe even a professional movie. DVD Studio Pro is tightly integrated with Final Cut Pro and Motion, rendering the projects into DVD format without encoding to intermediary formats.
