Microsoft Office: Page 21

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 97th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the AVEDEV function to measure the spread (variation) in a data set. Also see the STDEV function and learn how to measure whether a mean represents its data points fairly.

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 91st installment in their series of digital spreadsheet magic tricks, you'll learn how to use the FORECAST function to solve linear algebra problems.

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 572nd installment in their series of digital spreadsheet magic tricks, you'll learn about how to use conditional operators in your formulas.

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 two-part Excel tutorial from ExcelIsFun, the 564th installment in their series of Excel magic tricks, you'll learn how to create a cell chart using conditional formatting with Logical TRUE FALSE formulas to create a Gantt Chart. Functions used include WORKDAY, AND, NOT, NETWORKDAY.

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 336th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the ROWS, COLUMNS, MOD, ROUND, and WEEKDAY functions to increment numbers in Excel formulas.

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 574th installment in their series of digital spreadsheet magic tricks, you'll learn how to remove duplicate records using the Remove Duplicate feature which was new in Excel 2007.

Scanning is an awesome, fast way to transport a document into your computer. But, what if you want to edit it once you've scanned it? Most scanner programs will import your document as a read-only PDF or image file. With this tutorial, learn how to use the program ClaroRead on a Mac to scan your document directly into Microsoft Word for editing. This will save you a lot of time and a lot of annoying formatting and copy and pastes!

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.

This video helps you to Pin Recent Documents in Excel to the Start Menu or Office Button Menu in Excel 2007. When you click the office button on the left corner, your recent documents will appear by default. If you open a new document, it will push the other documents down and it will appear on the top. So, if you want a particular document to open whenever you open the excel, you have to click that particular document by clicking the pin that appears in the right side of it. This will turn the...

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 371st installment in their series of digital spreadsheet magic tricks, you'll learn how to calculate the average time between customer orders by adding a new column to a data set with an IF function formula.

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 293rd installment in their series of digital spreadsheet magic tricks, you'll learn two cell formulas and a named formula that will dynamically count unique words in a column. As you add new records, the count will automatically update. This is accomplished through use of Excel's MAX, ROW, OFFSET, SUMPRODUCT, ISTEXT and COUNTIF...

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 194th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the SUM, VLOOKUP and ROUND functions to create a gradebook based on percentage scores that will calculate grade for you automatically. See also how the VLOOKUP and the percentage format can deliver the wrong grade when you dont use the...

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 162nd installment in their series of digital spreadsheet magic tricks, you'll learn how to deal with duplicates with the MATCH function by using the COUNTIF function. This is accomplished with recourse to Excel's IF, OR, LARGE, ISERROR, MATCH, INDEX and COUNTIF functions.

This video provides step-by-step instructions for how to insert sounds or music into a PowerPoint presentation, using Microsoft Office 2007. The narrator uses the insert sound tool and selects an audio file that, and demonstrates how to make it play automatically when the PowerPoint slide show is played. He also shows how to customize the effect options by using the animations tab, which allows you to choose when the track starts and finishes, for how many slides, and at what volume. After...

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 can...

Some savings plan pays interest 365 days in a year but you make deposit monthly. You can use Excel functions to calculate the maturity value of the of the monthly plan. To do this you have to use the nominal and effect functions before using the future value functions. First enter the know data like the monthly payment, the number of years of payment, the number of days in a year, and the annual percentage rate. First take the nominal rate and calculate the effective rate with the help of...

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 choice....

Teach Excel demonstrates how to change the columns from letters to numbers in Excel 2007. The first step is to click on the Office button in the top left part of the window. Next, you click on Excel Options and click on the Formulas tab. There should be a heading labeled "Working with Formulas." The checkbox for R1C1 reference style should be unchecked by default. Check that box and click OK. This changes the column headers from letters to numbers. In order to change back to letters, simply go...

Mike Callahan aka Dr. Filefinder of Butterscotch explains how to adjust the margins in Microsoft Word 2007. While working on a document navigate your mouse to the 'Page Layout' tab at the top, center of the page. On the far left of the resulting page you will find 'Margins', click on that. A drop down window will display some default options that may suit your needs. If not, then click on the bottom option 'custom margins' to change the margin width to any size that you choose. You will now be...

In this how-to video, you will learn how to change the font size with Microsoft Word 2007. First, open the program and type in a sentence or two. Now, move your cursor to where the font name is. To the right of this should be a drop down menu with numbers. These are the sizes of the font. Highlight the text. Now, click and change the number to change the size of the text. The larger the number, the bigger the font will become. This video shows you just how easy it is to change the font with...

Teach Excel describes how to create a dynamically updating named range that goes from left to right using Excel. First, you define the named range by highlighting the cells containing numbers in a certain row. In the name box to the left of the formula bar, type the name of the data. In this example, the numbers correspond to sales, so type "sales." To check if the named range works, click on an empty cell and enter =sum(sales). That should return the sum of the highlighted cells. However, as...

Microsoft PowerPoint can be used to create power presentations. These presentation can contain images, animations, audio and video. Open your PowerPoint presentation. Go to the insert and select the audio and video option. Now browse to the file on your hard disk and select it. You can even select a video file to make your presentation better. Now this video will be added to your slide in the presentation. You can also choose different settings to the video and customize it. You can also select...

In Word 2007 a lot of things have been changed since word 2003. For instance the file menu is no longer present, it has been replaced by a glowing yellow button which is the office button. If you click on this button, a menu will pop up. In this menu click the save button. It'll give you the option to save your document with a docx extension. The problem with this is that a file with this kind of extension does not open in anything but Word 2007. Instead go into save as and save it as a word...

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. For...

Microsoft Excel is used to store and work on data by storing them in rows and columns in tables. You can use a macros to check if a cell is empty. To do this you have to know two short cuts. The first is the VBA Window short cut which is Alt + F11 and the other one is View Macros short cut which is Alt + F8. So open an Excel spread sheet and insert some data into a small table. Now create a macro for this tutorial. You can use and IsEmpty() functions to check if a cell is empty. Use this...

In this video tutorial, viewers learn how to remove the macro warning in Microsoft Excel. When you see the warning, click Enable Macros. Then right-click on of the sheet tabs and select View Code. Open the Modules folder menu. Now right-click on the module and select Remove Module. Click No to prevent the Module from exporting as a saved text. To go back to Excel, click on File and click on Close and Return to Microsoft Excel. Click on Save to save your workbook. This video will benefit those...

In this video tutorial, viewers learn how to open a Microsoft Word 2007 file by double-clicking it on Ubuntu 9.10. Begin by right-clicking on the file and go to Properties. Click on the Open With tab and select Use a custom command. Now type in [playonlinux --run "Microsoft Office Word 2007" and click Add. Select the custom command from the list and close the window. This video will benefit those viewers who use a Linux computer, and would like to learn how to open Microsoft Word 2007 files by...

This video is a Microsoft Word 2007 tutorial on working with pictures. To insert a picture in your document, click on Insert and select Picture, then find the picture, select and insert it. To resize the picture without distorting it, click and hold on the corner circles. You can adjust Brightness and Contrast by using the various choices within these settings. The Recolor setting gives you a number of options for changing the coloring of the picture, such as sepia, black and white, or...

This video shows you how to idiot-proof a data set in Excel pretty much. It demonstrates how to enable data validation in a cell, so that when you type something in it must be in a predetermined list or will not work. Start by typing in your data table in a second tab. His example is a date, then information about certain employees based on that day. To enter the data validation menu, click the cell you want to use and then hit ALT+D+L to bring it up. Go to settings, then under the Allow menu....

Chris Davis with the Educational Technology Center shows us a few easy steps to putting YouTube videos in our Microsoft PowerPoint 2007 presentations. To start you'll need to have an active internet connection and you should have the developer tab in PowerPoint active. To do this go to the Office menu, PowerPoint options, popular and click show developer tab. Locate the hammer looking more control option button and scroll down to Shockwave Flash Object and click it. This allows you to draw a...

Microsoft PowerPoint is used to create presentations. These presentation can contain images and animations. You can even add sound to the presentation. To do this go to the insert and select movies and sounds. Select the sound file from it. Make sure that the file inserted is in .wma format. Go to the slide show and select custom animation. Right click the song in the animations window. Under the effect option in the effect tab, there is the stop playing partition. Select the number of slides...

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. To...

Teach Excel demonstrates how to make an Excel dynamic named range across multiple rows. Highlight the cells that you want to include in your named range and give it a name. You can then use that name in formulas. But it's not a dynamic named range so it won't account for added information. Ctrl + F3 is the name manager shortcut and the F3 is the paste name shortcut. Use the name manager and highlight the named range. Delete the absolute cell references and type in offset. Then, select the first...

In this Software video tutorial you will learn how to add music to PowerPoint 2007. You will be using Partners in Rhyme for background music. On the site scroll down to 'free midi files'. On the right of the page, you will see all the genres to choose from. Select your genre and select the band or song of your choice. Preview the music, download and save it. Open up PowerPoint 2007, select 'insert', select 'sound' and select the file you saved. Next select 'animations' > custom animation and...

Microsoft excel is a powerful tool used to work with numbers and data by filling them down in rows and columns of a table. Excels also supports macros, which are small scripts to automate certain functions. In Microsoft Excel you can select entire rows and columns using the range property. You can also use macros to select individual rows and columns as well as multiple variations of rows, columns, and individual cells all at once. In Excel a horizontal line of data is called as row and a...

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 165th installment in their series of digital spreadsheet magic tricks, you'll learn how to use a logical formula to extract values associated with dates occurring in the next two weeks.

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 146th installment in their series of digital spreadsheet magic tricks, you'll learn how to extract records from table, putting one record on each sheet with records in rows. This is accomplished with Excel's VLOOKUP, COLUMN, FIND, REPLACE and CELL functions. See also how to create a formula for a sheet name (sheet tab name,...

The video demonstrates the way of calculating the interest rates for payday loans using MS Excel. The person presenting the video has got his MS Excel sheet with all the formulas and data ready. He first starts with the nominal & effect & future value tab. He gives us an example where you give the lenders a check of $250 that has a date 25 days in future and get $200 loan today. Now he teaches us hot to calculate APR and EAR. HE has got the data ready there, the period of the loan which is 25...

In this Software video tutorial you will learn how to change the font color in Word 2007. The default font color in Word 2007 is black. But, you can change the color of the font to just about any color that you want. Click on the 'home' tab of the ribbon on top of the page and you will see a small window with the letter 'A' in it. Click on the arrow next to it and it will display a color palette with automatic, theme colors, standard colors and more colors sections. Here you select any color...