Hot Software How-Tos

How To: Create a Basic Attendance Sheet in Excel

If you're a teacher in any type of school, whether it's high school, college, or middle school, it's imperative that you keep an attendance sheet. The paper and pen route can get pretty messy, and very disorganized, and that's where Microsoft Excel comes in. With this software, you can create a simple yet functional attendance sheet to keep track of your students.

How To: Generate random numbers (with decimals) in Excel

This video shows you how to generate random numbers with decimals in Microsoft Excel.When generating random numbers you must have a lower and upper limit, so that your number will be generated between the two limits. For a number without decimals, you only have to use the "=randbetween" function. If you want to use decimals, you will have to use a different but similar function. Start by typing "=rand()". Next, you multiply this by the difference between the limits and add the lower limit. Fo...

How To: Build a 15-minute schedule in Microsoft Excel

Want to make a time schedule in Microsoft Excel partitioned into perfectly regimented 15-minute intervals? It's easy, provided you know how to go about it. And in this Excel tutorial from ExcelIsFun, the 543rd installment in their series of Excel magic tricks, you'll learn how to do just that using the Fill Handle. For a complete walkthrough, watch this Microsoft Office how-to.

How To: Add comments to a document in Microsoft Word for Mac 2011

Want to know how to create annotated docs in Word for Mac 2011? This video will show you how it's done. Whether you're new to Microsoft's popular word processing application, new to MS Word 2011 or even an expert merely looking to brush up on the fundamentals, you're sure to be well served by this quality video tutorial from the folks at Lynda. For detailed, step-by-step instructions, watch the video.

How To: Find asset turnover, capital intensity and inventory turnover ratios in Excel

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 11th installment in his "Excel Finance Class" series of free video lessons, you'll learn how to calculate asset turnover, capital intensity, inventory turnover, days to sell inventory, receivable turnover, days to collect accounts receivab...

How To: Make an invoice from an external product list in Excel

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 334th installment in their series of digital spreadsheet magic tricks, you'll learn how to use VLOOKUP & data validation to make an invoice when the product list is on a different sheet or different workbook.

How To: Cut a person or object out of a picture in Photoshop

Ok, so you ditched the ex like a bad habit but now every picture on your Myspace features their face? No problem! You can use PhotoShop to cut objects out of your picture or to make people disappear. This video shows how to do both of those so you can forget the bad memories and move on! After you master the techniques shown you can also use them to cut the background out of your picture and then replace it with a background of your choice!

How To: Create a Powerpoint presentation

Need to make a Powerpoint presentation and you're not sure where to begin? In this three-part video tutorial, learn how to make a Powerpoint presentation from start to finish. A Powerpoint presentation is a great way to enhance a school project and impress your teacher!

How To: Insert movie files into a MS Word document

In order to insert movies into Microsoft Word 2007, Click on Insert. For AVI, go to Object, Create From File, and select the location of the file. Then, click on Insert. It will now appear on your document. The video should play. The video can be repositioned or adjusted. It can be saved with your document, although this is not true for other movie formats.

How To: View email messages by conversation in Microsoft Outlook 2010

Looking for an easy way to consolidate and view your email messages conversations into easy-to-ready threads? This clip will teach you everything you'll need to know. Whether you're new to Microsoft's popular email and scheduling application or a seasoned MS Office professional just looking to better acquaint yourself with the Outlook 2010 workflow, you're sure to be well served by this video tutorial. For more information, and to get started organizing your own inbox, watch this free video g...

How To: Calculate future value for a sinking fund in MS Excel

As you might guess, one of the domains in which Microsoft Excel really excels is business 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 48th installment in his "Excel Business Math" series of free video lessons, you'll learn how to use the Excel functions FV and PMT to make a future value calculation for a sinking fund.

How To: Make the Photoshop CS3 icon in Photoshop

Advance Photoshop shows viewers how to make the Photoshop CS3 icon in Photoshop. First in Photoshop go to File and then click New. Make a new blank at 500 x 500 pixels. Go to your layer button and create a new layer. Next, go to your rectangular marquee tool, hold down shift, and make the rectangle slightly smaller than the canvas itself. Set it from foreground to background and change the background color to a dark blue, enter 15396F for the color. Click on foreground color and enter 3070CA ...

How To: Create a 3D star in Illustrator

Do you have interest in creating 3D objects? Open illustrator and draw a star tool with gradient fill in it. Then go to effects>3D>Extrude/Bevel. Select preview to view the star in 3D while changing its settings. One can rotate the star in any angle as well as change the thickness of the star. Then go to object>expand appearance and then click on the gradient. Our star is ready. It will help in creating 3D objects and shapes.

How To: Use x-ray techniques in Photoshop to show naked skin through clothing (NSFW)

Do those new naked body scanners have you freaked out at the airports? As far as the TSA is concerned, those x-ray machines are here to stay, but you might as well take comfort in knowing that airport security guards aren't the only ones looking at your private parts. Practically anyone with a computer can manage to see through your clothes, and it's all thanks to a little program called Photoshop. Thanks, Adobe.

How To: Make breasts appear larger in Photoshop

In this tutorial, we learn how to make breasts appear larger using Photoshop. First, open up the image you want to change inside of Photoshop. Next, go to "filter", then choose "liquefy". Choose the float tool and then set the brush size to a size you want the breasts to be. Stay in the same spot while you boost the breasts, making small movements, so you don't create an unrealistic image. If you are using a close up, use the dodge tool to give the breasts color, then use the burn tool to add...

How To: Resize images and video in Sony Vegas

In this video tutorial, viewers learn how to re-size an image or video in Sony Vegas. Begin by opening the image or video that you want to re-size in Sony Vegas and drag it into the time line. Then click on Event/Pan Crop on the right side of the clip in the time line. Now re-size/rotate the video/image by dragging in and out. Finish by simply closing the window. This video will benefit those viewers who create videos using Sony Vegas and would like to learn how to make their video image smal...

How To: Copy and move worksheets in Microsoft Excel 2007

Learn how to copy and move sheets in MS Excel 2007. Whether you're new to Microsoft's popular spreadsheet application or a seasoned business professional just looking to better acquaint yourself with the unique features of Excel 2007, you're sure to be well served by this video tutorial. For more information, and to get started manipulating your own Excel 2007 worksheets, watch this free video guide.

How To: Create dynamic sub tables in Microsoft Excel

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 Excel tutorial from ExcelIsFun, the 538th installment in their series of digital spreadsheet magic tricks, you'll learn how to create dynamic sub tables based on master sheet array as well as how to create array formulae quickly with the Drill-Through method. All this is accomplished with recourse to the COUNTIF, IF, ROWS, INDEX, SMALL, ROW functions.

How To: Disable quick fill handle & drag-drop Excel features

In this video tutorial, viewers learn how to disable the quick fill handle and drag and drop option in Microsoft Excel. This task is very easy, simple and fast to do. Begin by clicking on the Office button and click on Excel Options at the bottom. Then click on the Advanced tab and deselect "Enable fill handle and cell drag and drop" option under Editing Options. Finish by clicking on OK. This video will benefit those viewers who use Microsoft Excel for their work, and would like to learn how...

How To: Extract part of a table from a larger table in Excel

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 185th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a formula to extract part of a table from a larger table. You'll accomplish this with an array formula that uses Excel's INDIRECT, IF, ROWS, COUNTIF, INDEX, SMALL, and ROW functions. The formula will extract records that meet one con...

How To: Hide scroll bars, sheet tabs & charts in Excel

This video is a tutorial on how to remove scroll bars, sheet tabs and objects in Excel. To remove scroll bars and sheet tabs, go to the Office button, then Excel Options. On the screen that comes up go to the Advanced tab and scroll down to “Display options for this workbook”, where you will see some check boxes. Uncheck the boxes for horizontal scroll bar, vertical scroll bar and sheet tabs. This will remove them from the current workbook. This feature only works with the current workbook.

How To: Create a bond discount or premium amortization table in Excel

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 52nd installment in his "Excel Finance Class" series of free video lessons, you'll learn how to create a bond discount or premium amortization table.

How To: Enter formulas in Excel with a macro

In order to enter formulas in Excels with a macro, you will need to open your spreadsheet. Formulas are used to do calculations. Go to the field, where you want to enter a formula. Type in the formula. Then, highlight the formula. Press Control + C to copy the formula. Next, delete the contents of the cell. Press Alt + F11.

How To: Cross-check two lists for discrepancies in MS Excel

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 528th installment in their series of digital spreadsheet magic tricks, you'll learn how to check two data sets (lists & tables) to see if there are discrepancies using the MATCH and VLOOKUP functions.

How To: Group duplicates & extract unique records in MS Excel

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 577th installment in their series of digital spreadsheet magic tricks, you'll learn how to use SUMPRODUCT and the join symbol (&/ampersand) to group duplicates and then see how to use advanced filtering to extract a list of unique records.

Prev Page