Microsoft Office Features
How To: Use your computer's Print Manager to convert files to PDF
It is possible to convert your Excel spreadsheets into a PDF file by using your PC's Print Manager and Save As functions. This video shows you a step by step to create a password-protected PDF version of your Excel file.
How To: Add images to a Word 2007 document
This video demonstrates how to add images to a Word 2007 document. From the people who brought you the Dummies instructional book series, brings you the same non-intimidating guides in video form. Watch this video tutorial to learn how to add images to a Word 2007 document, For Dummies.
How To: Create an Out of Office message with Outlook
Learn how to use the "Out of Office" message feature in Microsft Outlook to automatically send email replies when you are out of town or away from your computer.
How To: Create a dynamic area 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 351st installment in their series of digital spreadsheet magic tricks, you'll learn how to create an area chart for x and f(x) data as well as how to use the IF function to show a second data set plotted to show a specific area section.
How To: Use drag-and-drop calendaring in Outlook
Watch this software tutorial video to learn how to uncover Outlook 2007's best features: drag-and-drop calendaring and color-coding. This how-to video will allow you to use drag-and-drop calendaring in Outlook to make your calendars better.
How To: Create simple formulas with cell references 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 very first installment in their series of digital spreadsheet magic tricks, you'll learn how to build your spreadsheet smartly, so it updates automatically by creating formulas with cell references!
How To: Count codes from a column of text 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 290th installment in their series of digital spreadsheet magic tricks, you'll learn how to count codes from a column of text strings that have multiple codes.
How To: Create PDF and XPS files in MS Office
Learn how to create PDF and XPS files directly from Microsoft's Office 2007.
How To: Create a basic presentation quickly in Powerpoint 2007
If you're new to Microsoft Office PowerPoint 2007 and just want to pick up the basics, watch this tutorial and learn how to get started fast. You'll see how to create your own slides for a show and add headings, bulleted lists, and pictures. Use built-in layouts to organize your slide content. And see how the new Preview feature helps you choose theme colors and background design, minimizing the guesswork and giving you a polished result.
How To: Use Excel's VLOOKUP function without a first column
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 328th installment in their series of digital spreadsheet magic tricks, you'll learn how to use VLOOKUP when you do not have a first column to use for lookup.
How To: Encrypt your Microsoft Office documents
Check out this tutorial and learn how to encrypt Microsoft Office files to help prevent unauthorized people from opening a workbook, document, or presentation. Watch the video to see how easy it is to set a password to help you control who can open or modify the Office files you create.
How To: Find confidence intervals without a sigma 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 84th installment in his "Excel Statistics" series of free video lessons, you'll learn how to construct confidence intervals when the sigma is NOT known using the Descriptive Statistics data analysis add-in.
How To: Protect MS Word Document with Password
This video will provide an idea how to protect your ms word document with password. Whenever anyone wants to open the document it will ask for password.
How To: Get up to speed with PowerPoint 2007
Microsoft Office PowerPoint 2007 has a new design. The new Ribbon keeps the commands that you use most often visible while you're working instead of hiding under menus or toolbars that you have to hunt for. Also, commands that you may not have known about before are now very easy to discover. When it comes to designing your slides, live preview of style galleries lets you see how things such as backgrounds and shape formatting will look before you apply them. A new SmartArt graphics feature o...
How To: Format your numbers correctly when working on a spreadsheet in Microsoft Excel
Always make sure you've formatted your numbers correctly within the proper cells when you're developing a spreadsheet in Microsoft Excel. There are a variety of number formatting functions you can use to make your spreadsheet more readable, and this tutorial explains how to use number formatting correctly.
How To: Work with PowerPoint themes
This video demonstrates how to work with PowerPoint themes. From the people who brought you the Dummies instructional book series, brings you the same non-intimidating guides in video form. Watch this video tutorial to learn how to work with PowerPoint themes, For Dummies.
How To: Delete only cell content or formatting 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 575th installment in their series of digital spreadsheet magic tricks, you'll learn how to selectively delete. Specifically, you'll se how to delete the cell contents only, formatting only, the entire cell, or formatting and content together.
How To: Use the user interface in Microsoft SharePoint 2010
Meet the Microsoft SharePoint 2010 user interface. Whether you're new to Microsoft's popular content management system (CMS) or a seasoned MS Office professional just looking to better acquaint yourself with the SharePoint 2010 workflow, you're sure to be well served by this video tutorial. For more information, and to get started using the new SharePoint interface yourself, watch this free video guide.
How To: Count with two criteria 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 529th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the SUMPRODUCT and COUNTIFS functions to count how many sales you made for a given product over the last 7 days.
How To: Sum values after a deadline 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 678th installment in their series of digital spreadsheet magic tricks, you'll learn how to SUM only the values after a deadline using a dynamic range formula using INDEX Function. Also see a SUMPRODUCT function method.
How To: Add a video to a PowerPoint presentation
The video demonstrates how to add animated images and video content to your Microsoft PowerPoint presentation.
How To: Use the new Paste features in MS PowerPoint 2010
Learn how to use the new Paste functions in Microsoft PowerPoint 2010. Whether you're new to Microsoft's popular presentation application or a seasoned MS Office professional just looking to better acquaint yourself with the PowerPoint 2010 workflow, you're sure to be well served by this video tutorial. For more information, and to get started using the new PowerPoint Paste tools yourself, watch this free video guide.
How To: Find a weighted percent dropping 2 scores 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 340th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the SMALL and LARGE functions and array syntax to retrieve more than one value.
How To: Get started using Microsoft SharePoint 2010
Looking for a primer on how to get started using Microsoft SharePoint 2010? Look no further. Whether you're new to Microsoft's popular content management system (CMS) or a seasoned MS Office professional just looking to better acquaint yourself with the SharePoint 2010 workflow, you're sure to be well served by this video tutorial. For more information, and to get started using SharePoint yourself, watch this free video guide.
How To: Change a function in a Microsoft Excel pivot table
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 86th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to create a TRUE/FALSE formula to change the function of pivot table as well as how to filter one.
How To: Use the SmartArt feature in MS Office
Learn about the New SmartArt Feature in Microsoft's Office 2007 which allows you to create interactive graphics in your documents.
How To: Make present value calculations in 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 58th installment in his "Excel Business Math" series of free video lessons, you'll learn how to make simple value calculations for the present.
How To: Deliver words to a cell via IF, AND & VLOOKUP in Excel
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 35th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use the IF, AND and VLOOKUP functions to deliver the words Bid, No Bid, or Alert to a cell. Is VLOOKUP better than IF AND? Find out with this free video lesson.
How To: Navigate and use the Outlook for Mac 2011 user interface
Need some help making sense of the Outlook 2011 Ribbon UI? 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: Use the text-to-column tool 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 192nd installment in their series of digital spreadsheet magic tricks, you'll learn how to extract the middle name in quotes from a cell that has last, middle and first name using Excel's in-built text-to-column tool.
How To: Count dates falling within a given year 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 632nd installment in their series of digital spreadsheet magic tricks, you'll learn how to create a formula using the SUMPRODUCT and YEAR function to count instances of the year 2009 or 2010 from a list of dates with different years.
How To: Use the contextual spelling feature in MS Office 2007
Learn about the New Contextual Spelling Feature in Microsoft's new Office 2007 and how to use it to better proofread your documents.
How To: Add & count above a specified limit 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 15th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the SUMIF and COUNTIF functions to add and count above some limit.
How To: Add and customize data graphics on Visio 2007
Take a look at this instructional video and learn how to customize progress meters, icons, color coding, and other graphical elements to emphasize sales trends, product performance, critical deadlines, or whatever information is contained in the data behind your diagram.
How To: Begin a new project in MS Project 2007
In this tutorial, we learn how to begin a new project in MS Project 2007. First go to your start menu, then click on "Project 2007". When this opens, you will see a panel on the left hand side, which is a project guide. Once you are in this project, you can open up a stored one that you were previously working on, or continue with a new one. You will have different task bars that correspond to the information you type in. Click on each individual task to see the information for each one. Ente...
How To: Use the UPPER & EXACT functions in Microsoft Excel
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 82nd installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use the UPPER & EXACT functions to create a TRUE/FALSE formula to determine whether or not uppercase text has been entered into a cell.
How To: Format a cell with reference to another 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 270th installment in their series of digital spreadsheet magic tricks, you'll learn how to
How To: Apply conditional formatting to a row 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 80th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to highlight an entire record (row) in a database that matches a bounced email addresss. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.
How To: Base a PivotChart on a PivotTable 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 641st installment in their series of digital spreadsheet magic tricks, you'll learn how to create a PivotChart based on a PivotTable in one click.
How To: Use relative and absolute macros together 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 89.5th installment in their series of digital spreadsheet magic tricks, you'll learn how to use absolute and relative macros in concert with one another.