Hot Microsoft Office Posts

How To: Create a cumulative frequency distribution in MS Excel

If you use Microsoft Excel on a regular basis, odds are you work with numbers. Put those numbers to work. Statistical analysis allows you to find patterns, trends and probabilities within your data. In this MS Excel tutorial from everyone's favorite Excel guru, YouTube's ExcelsFun, the 26th installment in his "Excel Statistics" series of free video lessons, you'll learn how to create quantitative data cumulative frequency distributions with pivot tables.

How To: Calculate Commission Based on Varying Rates in 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 673rd installment in their series of digital spreadsheet magic tricks, you'll learn how to use the SUMPRODUCT formula to calculate commission amounts based on varying commission rates based on cumulative sales totals for each month.

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: Chart a categorical frequency distribution in MS Excel

If you use Microsoft Excel on a regular basis, odds are you work with numbers. Put those numbers to work. Statistical analysis allows you to find patterns, trends and probabilities within your data. In this MS Excel tutorial from everyone's favorite Excel guru, YouTube's ExcelsFun, the 13th installment in his "Excel Statistics" series of free video lessons, you'll learn how to create a column chart from a frequency distribution for categorical data.

How To: Make basic balance sheet calculations in Microsoft 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 9th installment in his "Excel Finance Class" series of free video lessons, you'll learn a number of handy formulas for making common balance sheet calculations.

How To: Change Excel options directly in the Registry

This video shows us the method to block the formula bar, scroll bars and the status bars in Excel. Click on 'Start' and type 'regedit'. Click on 'regedit' and go to 'HKEY_CURRENT_USER'. Open it and go to 'Software' and 'Microsoft'. Expand it and go to 'Office' and open the version of Office on your computer. Expand it and go to Excel. Choose the options folder. Go to the 'Options' item and right click on it. Go to 'Modify' and type 150 in the text box. Click on 'OK'. Now restart the Excel and...

How To: Use the Advanced Filter tool to extract data in Excel

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 19th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn about using Advanced Filter to extract data from an Excel List/Table/Database. See these 7 Advanced Filter examples:

How To: Calculate variance and standard deviation using Excel

This video shows the method to find the variance and standard deviation using Excel. The variance shows the variability of the data points from the median. We find the difference of the median and the mean. We write the formula using '=' sign. The median and data points are put in it by selecting the appropriate cell. The median is made an absolute constant by pressing the F4 key. This is squared by using '^2'. This is multiplied to the frequency using '*'. The result is found for all the dat...

How To: Create a dynamic break-even chart in Microsoft 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 576th installment in their series of digital spreadsheet magic tricks, you'll learn how to add a point and a dynamic label to a break-even chart that marks the breakeven point using INDEX and MATCH functions. This point is dynamic and will change if data is changed.

How To: Insert, format, resize & crop pictures in MS Word

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

How To: Add OLE objects to tables and forms in MS Access 2007

The Microsoft Office Access 2007 relational database manager enables information workers to quickly track and report information with ease thanks to its interactive design capabilities that do not require deep database knowledge. In this Microsoft Access video tutorial, you'll learn about adding an individual graphic to each record in MS Access. To get started using OLE objects in your own tables and forms, watch this MS Access video how-to.

How To: Sort data by multiple columns in Microsoft Excel

Today we are going to learn how to sort data in a Microsoft Excel 2003 spread sheet. We will go over single column and multiple column sorting. In a single column sort you may high light the data or just click on any cell in the column. Once the data is selected look for the sort icons just under the menu bars. There is a sort ascending and sort descending icon. Click on the icon and Excel will sort the list. When sorting multiple columns the data must be in columns next to each other. If the...

How To: Create a list of hyperlinks in Microsoft 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 139th installment in their series of digital spreadsheet magic tricks, you'll learn how to use a data validation list drop-down and the hyperlink function to create a list of links.

How To: Use SUMIFS or SUMPRODUCT to get invoice info in 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 497th installment in their series of digital spreadsheet magic tricks, you'll see a formula that uses SUMIFS or SUMPRODUCT functions that will take invoice information for inventory quantity sold and update inventory records to show correct amount on hand (in stock) for each store or branch of the company.

How To: Conditionally format a bar chart in Microsoft 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 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.

How To: Create budgets in MS Project 2007

These days it seems like budgets are on everybody's minds. Big or small, financial planning is an essential part of daily life following the latest recession. In this tutorial you will learn how to create budget resources, using MS Project 2007, that you can assign to your project to compare you actual hours and costs against your budget.

How To: Arrange email messages by date or sender in Microsoft Outlook 2007

Sort your emails by either date or sender within MS Outlook 2007. This clip will teach you how. 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 2007 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 guide.

How To: Extract records with 2 criteria with Excel's AGGREGATE

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 671st installment in their series of digital spreadsheet magic tricks, you'll learn how to use the AGGREGATE function to create a formula for extracting records with two criteria. This is a lookup problem where you want to return multiple records from two lookup values. This formula is not an array formula because it...

How To: Find statistical critical & p values in MS Excel

If you use Microsoft Excel on a regular basis, odds are you work with numbers. Put those numbers to work. Statistical analysis allows you to find patterns, trends and probabilities within your data. In this MS Excel tutorial from everyone's favorite Excel guru, YouTube's ExcelsFun, the 89th installment in his "Excel Statistics" series of free video lessons, you'll learn how to use the NORMSINV function for critical values and the NORSDIST function for p-values.

How To: Go to New Record in a form using macros in MS Access

The Microsoft Office Access 2007 relational database manager enables information workers to quickly track and report information with ease thanks to its interactive design capabilities that do not require deep database knowledge. In this Microsoft Access video tutorial, you'll learn about using a macro to force a form to open on new record. For more information on going to `New Record' in a form by using macros, watch this Access how-to.

How To: Create projections for sales numbers in MS Excel

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 10th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to create projections for sales numbers from a database using the SUMIF, VLOOKUP and COLUMNS functions and a percentage increase formula.

How To: Highlight Excel values repeated a set number of times

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 350th installment in their series of digital spreadsheet magic tricks, you'll learn how to use conditional formatting and the COUNTIF function to highlight values that are repeated a given number of times.

How To: Password protect databases with Microsoft Access

The Microsoft Office Access 2007 relational database manager enables information workers to quickly track and report information with ease thanks to its interactive design capabilities that do not require deep database knowledge. In this Microsoft Access video tutorial, you'll learn about creating a login form and password protecting your database.

How To: Create a new milestone in Microsoft Project 2010

In this clip, you'll learn how add a new milestone when working in MS Project 2010. Whether you're new to Microsoft's popular project management application or are just looking to better acquaint yourself with the Project 2010 workflow, you're sure to benefit from this free video software tutorial from Lynda. For more information, including detailed, step-by-step instructions, take a look.

How To: Use and assign categories in Microsoft Outlook for Mac 2011

Interested in sorting your mail with Outlook's categories feature? This video will show you how it's done. Whether you're new to Microsoft's popular word processing application, new to MS Outlook 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: Add, hide, and show columns in Project 2007

Suppose you created a project plan in Microsoft Office Project 2007, and you want to add a new column of information. You also want to be able to choose not to display the new information, but you don't want it to be lost. Take a look at this instructional video and learn how to create a column, hide a column, and show a column that you previously hid.

How To: Sync songs with PowerPoint

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

How To: Make distributions, ogive charts & histograms in Excel

If you use Microsoft Excel on a regular basis, odds are you work with numbers. Put those numbers to work. Statistical analysis allows you to find patterns, trends and probabilities within your data. In this MS Excel tutorial from everyone's favorite Excel guru, YouTube's ExcelsFun, the 22nd installment in his "Excel Statistics" series of free video lessons, you'll learn how to create a percent (%) cumulative frequency distribution with formulas, a histogram and an ogive chart. See how to add ...

How To: Create a histogram using data analysis in Excel

A histogram is a summary graph showing a count of data points that fall in various ranges. Histograms are used in statistics and other forms of mathematics. In this video, learn how to create your own histogram using data analysis on the computer. This tutorial will show you how to create a frequency distribution, a cumulative frequency distribution, a histogram chart and an ogive chart with the data analysis add-in.

How To: Automatically highlight negative numbers in MS Excel

Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 4nd installment of his "YouTubers Love Excel 2007" or YTLE2k7 series of free video MS Excel lessons, you'll learn how to use conditional formatting to add red to negative numbers and green to positive numbers using a single True/False formula!

How To: Use Word Viewer to open or print documents

Even if you don't have Microsoft Office Word 2007, you can open Word documents with Word Viewer. In this instructional video, a Microsoft employee shows how you and your coworkers can download Word Viewer and the Office Compatibility Pack for Word, Excel, and PowerPoint 2007 File Formats. With these 2 downloads, you can open, print, or copy and paste from Word documents without having to install Word on your computer.

How To: Merge spreadsheets in Excel

If you've ever entered a lot of data into an Excel spreadsheet before, then you know that putting together even one spreadsheet is a pain in the butt. So if you are required to place all the data on one spreadsheet onto another spreadsheet, don't slave away for hours copying and pasting.