Microsoft Office Features
How To: Changing line spacing settings in Microsoft Word 2010
Before you can work in Word 2010, you'll need to learn how to work with it. See how to adjust line spacing parameters 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 changing line spacing settings in the Word 2010 UI yourself, take a look.
How To: Count between two numbers with Excel's DSUM & DCOUNT
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 90th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the DSUM and DCOUNT functions to sum or count between an upper and lower limit.
How To: Count with Boolean criteria in Microsoft Excel 2010
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 683rd installment in their series of digital spreadsheet magic tricks, you'll learn how to count with Boolean criteria in Excel 2010.
How To: Make a dynamic named range in Excel (left to right)
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...
How To: Fill in the blanks with custom number format in Excel
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 ...
How To: Use Microsoft Outlook
In this Microsoft Outlook video tutorial, learn how to use Microsoft Outlook from systems administrator and MS Outlook expert Gary Zier. Gary will teach you Microsoft Outlook techniques such as how to permanently delete items in MS Outlook, how to selectively send read receipts in Outlook, how to prevent multiple prefixes in emails, how to create and save searches in Microsoft Outlook, how to configure the desktop alert in Outlook, how to print select pages from an email, and how to create cu...
How To: Make calculations for 30 day months 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 522nd installment in their series of digital spreadsheet magic tricks, you'll learn how to make calculations for companies that use 30 day months.
How To: Import external data in Excel
Learn how to Import External Data (i.e data from web pages) dynamically into Excel in Microsoft's Office 2007.
How To: Use the BINOMDIST & NORMSDIST functions 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 274th installment in their series of digital spreadsheet magic tricks, you'll learn how to calculate various probabilities for a binomial distribution when there are additional complicating factors. This is accomplished with recourse to Excel's BINOMDIST, NORMSDIST, SUMIF, SUM, INDEX and MATCH functions. See also how to create th...
How To: Convert HTML data to either a PDF or Excel file using DeskPDF
The DeskPDF programs, published by DocuDesk, offer several methods for converting files in one format to an entirely different format - such as turning an HTML table on a web page into an Excel file or turning an RSS feed into an ebook file.
How To: Insert & delete rows, columns, and works in Excel 2007
In Microsoft Office Excel 2007, you can quickly insert new rows, columns, cells, and worksheets and just as easily delete them — with a few clicks.
How To: Link tasks in Microsoft Project 2007
In this Software video tutorial you will learn how to link tasks in Microsoft Project 2007. There are four ways to link a task. Finish to start is the default, then you have start to start, finish to finish and start to finish. Here you will see how to link up two tasks and what is the dependency between them. There are various methods of creating dependency between two tasks. One method is to select the two tasks and click on the ‚Äòlink tasks‚Äô button on the tool bar or you can go to the ‚...
How To: Create Word Art in Microsoft Publisher
Add some personal style to any calendars or newsletters you may have created- Learn how to use Microsoft Publisher to add Word Art to all of your Publications.
How To: Extract all the letters from a text string in Microsoft Excel 2010
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 699th installment in their series of digital spreadsheet magic tricks, you'll learn how to extract all the letters from a text string with a VLOOKUP function in Excel 2010.
How To: Set up work resources in MS Project 2007
In this tutorial, we learn how to set up work resources in MS Project 2007. First, go into your chart and click on the resource sheet from the file menu. Now, you will be able to change the different sections that show up on this sheet. Go through the different columns to change the information and type in additional information, the more you insert the better. When you click on the tabs, you will have more options where you can enter in notes and make custom fields. Go through the entire she...
How To: Filter records to a new workbook 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 249th installment in their series of digital spreadsheet magic tricks, you'll learn how to use Advanced Filter to extract records from a database (table or list) to a new workbook.
How To: Apply conditional formatting to a row of data 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 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.
How To: Remove tracked changes from a Word document
Leaving visible revision marks and comments in a document that you thought was "final" can be embarrassing. In this instructional video, a Microsoft employee demystifies what's going on with those tracked changes that you thought were gone from your Microsoft Office Word 2007 document. He also shows you how to banish those markings permanently in two ways and gain peace of mind.
How To: Edit and delete scenarios in Microsoft Excel 2007
Learn how to edit and delete scenarios in your Excel 2007 workbooks. Whether you're new to Microsoft's popular digital spreadsheet application or a seasoned business professional just looking to better acquaint yourself with the Excel 2007 workflow, you're sure to be well served by this video tutorial from the folks at Lynda. For more information, and to get working with scenarios in your own MS Excel projects, watch this free video guide.
How To: Create a grade book based on a total score 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 193rd installment in their series of digital spreadsheet magic tricks, you'll learn how to use the SUM and VLOOKUP functions to create a grade book based on a given total score that will automatically calculate grades.
How To: Use the NORMSINV & NORMSDIST in Microsoft 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 93rd installment in his "Excel Statistics" series of free video lessons, you'll learn how to use the NORMSINV and NORMSDIST functions to complete a hypothesis test about a population proportion.
How To: Create relationships in 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 relationships between tables. For more on creating and managing relationships in MS Access, watch this how-to.
How To: Look up a picture 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 and Mr. Excel, the 42nd installment in their joint series of digital spreadsheet magic tricks, you'll learn how to look up a picture in Excel. See a VBA solution and a formula Solution using the INDIRECT function and named ranges.
How To: Import word styles in Microsoft Publisher
Strapped for time? Learn how to quickly format a Microsoft Publisher document so it looks like your other word processing files.
How To: Use the VLOOKUP function in Excel 2007
Several examples of using the VLOOKUP function in Excel 2007.
How To: Use ctrl-enter keyboard shortcuts 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 208th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the keyboard ctrl-enter keyboard shortcuts to speed up common tasks in Microsoft Excel.
How To: Set-up Outlook 2007 on Windows 7, XP, or Vista
In this how to video, you will learn how to set up Outlook 2007 in Windows 7, XP, or Vista. First, open the program. Click next and and check manual configuration. Select the top option in the next window. Now you must fill in your name, email address, and server information. Lastly, fill in your user name and password. Click more settings and select the outgoing server tab. Here you will authenticate your email address. Once this is done, click okay and next. Click finish and the program can...
How To: Create a dynamic date list for a DV dropdown 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 324th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a dynamic list of dates for a data validation drop-down list.
How To: Replace an Excel IF formula with a VLOOKUP function
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 66th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use the VLOOKUP function in a formula to replace a long IF function formula.
How To: Make NeoOffice documents Microsoft Word compatible
Microsoft Office is the defacto standard for document creation, but you can get that functionality and compatibility without paying a dime. For Macintosh users, use NeoOffice and learn to save your docs automatically in the MS Office formats.
How To: Create message rules and auto-sort with Outlook
How to create message rules and do auto-sorting with Microsoft Outlook. f you ever wish every email from your Uncle Lou could be put into a folder (or the trash) automatically -- or you want to flag message from your boss -- or you want to have a sound play when an ebay outbid notice comes in, then this tutorial is for you.
How To: Do basic statistical analysis in Microsoft 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'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 do basic statistical analysis in Excel. Specifically, this video covers the following topics:
How To: Embed a YouTube movie into PowerPoint 2007
Ever wish you could embed a YouTube video into a Microsoft Office PowerPoint 2007 presentation? If you have a live Internet connection when designing your presentation, and will have one when showing it, you can. And it's an easy process to boot. For complete instructions on how to put a YouTube clip into a presentation in PowerPoint 2007, watch this helpful video tutorial.
How To: Edit images and video in Microsoft PowerPoint 2010
This video describes how to edit images and videos in MS Power Point 2010. For example, we will take a slide with picture added. If you want to edit the picture, first go to the "Picture Tool" button and click on the format tab. If you want to change the contrast and sharpness of the picture use the "Corrections" menu, and to change the saturation, tones, and to do recoloring we can use the color option tab, and then the "Artistic effects" which can be used to see a real time preview like usi...
How To: Change the font size in Word 2007
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 t...
How To: Create linkage formulas in Microsoft Excel 2007
Learn how to create linkage formulas 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 using linkage formulas in your own 2007 workbooks, watch this free video guide.
How To: Create custom formulas for data validation in Excel
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 84th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use custom true/false formulas for data validation and also see how to add an error message.
How To: Use the formula functions in MS Office 2007
Learn about the New Formula Features in Microsoft's Office 2007 and how to use them to do calculations in MS Office and Excel documents.
How To: Use navigation & selection techniques in MS Word 2007
User mel_bone teaches you how to use navigation and selection techniques in Microsoft Word 2007. You will notice in the bottom right corner of the main window a slider. This controls the zoom. You can thus increase the page size or decrease it, as you need. When you have a document that has more than one page, you can go to the end of the document by pressing ctrl+end. Ctrl+home brings you to the start of the document. Clicking and holding the mouse button pressed on the navigation bar lets y...
How To: Run a chart lookup with defined names 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 637th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a dynamic two data series line chart for blood pressures — how to look up a chart using defined names, a data validation list, and a formula using the INDIRECT function inside a picture of a chart.