Microsoft Office Features
How To: Create sparklines in Microsoft Excel 2010
Learn how to add sparklines to a Microsoft Excel 2010 spreadsheet. 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 2010 workflow, you're sure to be well served by this video tutorial. For more information, and to get started using sparklines in your own MS Excel 2010 projects, watch this free video guide.
How To: Sort data with sorting functions 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're in the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the 16th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to sort data in MS Excel. Specifically, you'll see the following:
How To: Find it fast with Instant Search in Outlook 2007
If you're buried in e-mail (and who isn't?), Instant Search in Microsoft Office Outlook 2007 can save the day for you. The new Instant Search helps you quickly find e-mail messages, appointments, contacts, or any Outlook item. You don't even need to know which folder the item is in. Watch the demo to see how to use this fast search feature in Outlook 2007, and start finding what you want instantly.
How To: Schedule a meeting in Office Live Meeting
Office Live Meeting is a conferencing solution that you can use to engage audiences in online meetings, training, and events. Learn how you can schedule, join, or present a Live Meeting by using new features such as audio, video conferencing, uploading handouts, and using Microsoft RoundTable. Watch the demo to learn how to schedule a meeting in Office Live Meeting.
How To: Tell if you are logged in as an Admin or User in Windows 7
Admin accounts are given special privileges to change the system (like installing programs) that user accounts are not. This tutorial shows you a quick way to check using Windows 7's calendar, and also how to go through the Control Panel to find out if you're an Admin or general User on your computer.
How To: Use relative & absolute cell references 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 6th installment in his "Excel Business Math" series of free video lessons, you'll learn about the importance of cell References in Excel formulas and functions. Learn about a relative and absolute cell references in Excel formulas with th...
How To: Set up a POP3 email account in Microsoft Outlook
Need to know how to set up a POP3 account within Microsoft Outlook? When you know how to go about it, it's simple. So simple, in fact, that this home computing how-to from the folks at Easily can present a complete (and somewhat talky) overview of the process in just over three minutes' time. For the specifics, and to get started using your own POP account in MS Outlook, just watch this handy how-to.
How To: Make annuity calculations in Microsoft 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 59th installment in his "Excel Business Math" series of free video lessons, you'll learn what an annuity is and how to make calculations for annuities.
How To: Set-up your Gmail account with Outlook
lakercoolman shows us how to set up our gmail account with this quick tutorial. Basically outlook express is a program that helps us to organize our email with added features such as contacts, to do lists and calender entries. Its an offline email client that allows us to work offline and also lets us set up exchange servers aswell. Ohter email servers such as hotmail and yahoo charge for thios service but the advantage of gmail is that IMAP or POP access is free. in ofer to set up, navigate ...
How To: Use the ADDRESS function 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 98th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use the ADDRESS function to make labels in templates easier for users to understand.
How To: Do dynamic range w/Excel's OFFSET function & top data
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 240th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a dynamic range with the OFFSET function and a named formula when new records are added at the top instead of the bottom.
How To: Use the Speak Cells on Enter 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 656th installment in their series of digital spreadsheet magic tricks, you'll learn see how to use the Speak Cells on Enter function.
How To: Sync your online calendar with Outlook 2007
Friends tired of you forgetting plans? Missing important business appointments? Use your personal computer to improve your organization! Many software programs can help. This video shows you how to sync a compatible online calendar with Outlook 2007, and never miss another appointment again!
How To: Set up & solve large word problems in Microsoft Excel
Looking for a primer on how to create and work with array formulas in Microsoft Office Excel? You've come to the right place. In this free video tutorial from everyone's favorite MS Excel guru, YouTube's ExcelIsFun, the 15th installment in his series of Excel array formula series, you'll learn how to set up, solve and write conclusions for larger-sized mathematical word problems.
How To: Set-up a new email address in MS Outlook Express
Carole Gallesie from Creative Media Web shows viewers how to set up a new account in Microsoft Outlook Express. Express is preferred because it is a scaled-down version of the popular email client and it is easier to navigate. From your Windows desktop, go to the start menu, all programs, and click on outlook express. When the program opens, look at the top of the page for the "tools" menu, select accounts, add, and mail. The new account wizard will then appear and will walk you through setup...
How To: Set data up for sorting & filtering 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're in the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the 14th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to set up data in Excel so sorting, filtering, subtotals and PivotTables (Pivot Tables) can be done easily.
How To: Use the Microsoft Office Ribbon UI in PowerPoint 2010
In this clip, you'll learn how to utilize the MS Office Ribbon interface when working within 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 creating and using the Ribbon interface in your own PowerPoint projects, watch this free video guide.
How To: Create array formulas for stock returns in MS Excel
Looking for a primer on how to create and work with array formulas in Microsoft Office Excel? You've come to the right place. In this free video tutorial from everyone's favorite MS Excel guru, YouTube's ExcelIsFun, the 14th installment in his series of Excel array formula series, you'll learn how to create array formulas for individual stock return and standard deviation given different assumed states of the future economy.
How To: Dock a Microsoft OneNote 2010 window
Learn how to dock an MS OneNote window. Whether you're new to Microsoft's popular notetaking application or a seasoned MS Office pressional just looking to better acquaint yourself with the OneNote 2010 workflow, you're sure to be well served by this video tutorial. For more information, and to get started docking windows yourself, watch this free video guide.
How To: Randomly generate letters in an Excel spreadsheet
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 18th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the ROW, CHAR and RANDBETWEEN functions to randomly generate letters. See also how to randomly create letter sequences.
How To: Change the default font in Microsoft Word 2007
Microsoft Word 2007 starts with Times New Roman as the default font. If you're tired of having to change the font every time you start a new document, this article will teach you how to choose the default font for all new documents you make in the future. Change the default font in Microsoft Word 2007.
How To: Match lists with lookup functions 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 607th installment in their series of digital spreadsheet magic tricks, you'll learn how to match three lists using 2 VLOOKUP functions and the AND function.
How To: Add video to a PowerPoint presentation
Check out this lesson from Dummies.com on how to add videos to your PowerPoint presentations. This is easy and greatly enhances your slideshow. Make your presentation extra engaging and professional by integrating video.
How To: Solve an interest loan problem for part/base 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 54th installment in his "Business Math" series of free video lessons, you'll learn how to solve a simple interest loan problem for part, base, or rate.
How To: Add graphics to your documents with SmartArt graphics
Learn how to add color, shape, and emphasis to your text and data in Microsoft SmartArt graphics in this tutorial. See which one works best for getting your point across. An organization chart? A time line? A process with sequential tasks? Non-sequential items? Pick one, and optionally customize it with colors, animation, effects such as shadows, bevels, and glows, and more.
How To: Format field names 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 378th installment in their series of digital spreadsheet magic tricks, you'll learn how to format field names. If field names have formatting, Excel understands that they are field names and should not be used as data.
How To: Search a notebook in Microsoft Office OneNote 2010
This clip presents instructions on how to search notebooks within MS OneNote 2010. Whether you're new to Microsoft's popular notetaking application or a seasoned MS Office pressional just looking to better acquaint yourself with the OneNote 2010 workflow, you're sure to be well served by this video tutorial. For more information, and to get started searching your own notebooks, watch this free video guide.
How To: Format dates with the WEEKDAY function in 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 534th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the OR and WEEKDAY functions to create a logical true/false formula that will automatically apply formatting to dates that are either weekends or holidays.
How To: Build a flowchart quickly with AutoConnect in Visio
The new AutoConnect feature in Microsoft Office Visio 2007 makes it a snap to accurately and quickly connect shapes. Take a look at this instructional video and learn how to build a flowchart quickly with this feature in Visio.
How To: Use SharePoint 2010 with other Microsoft Office apps
Want to make Microsoft SharePoint 2010 play nice with other programs from the Microsoft Office 2010 application suite? This guide will show you how it's done. 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, watch this free video lesson.
How To: Conditionally sum from varying columns 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 297.5th installment in their series of digital spreadsheet magic tricks, you'll learn how to conditionally sum from various columns.
How To: Create a data validation list in Microsoft Excel
If you want to manage what sort of data is entered into your Excel spreadsheet, data validation will help you to accomplish just that. In this Excel tutorial from ExcelIsFun, the 549th installment in their series of Excel magic tricks, you'll learn how to use data validation to full effect in your Microsoft Office projects.
How To: Create a personal budget in Excel
In this series Tom Noah a certified CPA will show us how to create a personal budget with Excel. Create a personal budget in Excel - Part 1 of 15.
How To: Get up to speed in Microsoft Access 2007
Check out this tutorial and learn how to get up to speed with the latest installment of Mircosoft Access 2007. Microsoft Office Access 2007 brings you a new look and new features designed to help you get your work done more easily than ever. You'll see differences right away, starting with the Getting Started with Microsoft Office Access page where you can open a blank or existing database, download a pre-built database template, and check out the offerings on Microsoft Office Online.
How To: Use tables in Word 2007
This screencast tutorial from Chris Grover, author of Word 2007: The Missing Manual, guides you through working with tables in a Microsoft Word 2007 document.
How To: Install the Microsoft Excel Data Analysis add-in
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 install the Excel 2007 Data Analysis add-in.
How To: Add hyperlinks to Powerpoint presentation for Dummies
In this software video tutorial you will learn how to add hyperlinks to PowerPoint presentation for Dummies. With hyperlinks you can link part of your presentation to another slide within the same presentation, a separate presentation, a website, an e-mail address or to a file like a word document. Say, for example, you want to create a hyperlink to a picture in your presentation. Click on the picture to highlight it, click on the 'insert' tab, and select the 'hyperlink' option. Choose the de...
How To: Use Excel formulas & functions
In this installment of the Excel Basics Series you'll learn how to use formulas to calculate an annual interest rate, as well as breaking it down to a monthly rate and an effective annual rate. A general knowledge of Excel is helpful for navigating the menus in Excel, but if you pay attention during this presentation you'll pick up the skills quickly! Several ideas covered in this video are Formulas with cell references, how to find various Excel functions to use in formulas, and the Effect f...
How To: Schedule, join and present in Office Live Meeting
Microsoft Office Live Meeting is a conferencing solution for online meetings, training, and events. Learn how you can schedule, join, or present a Live Meeting using features like audio, video conferencing, and uploading handouts. In this demo, learn about meeting permissions and how to record a meeting. Get an overview of meeting content options, see examples of meeting interactions, meet Microsoft RoundTable and really learn to use Office Live Meeting.
How To: Add pictures to a document from a scan in Word 2007
If you're baffled about how to get your own photographs into your Microsoft Office Word 2007 documents, watch this instructional video. A Microsoft employee who uses Word himself shows you how to insert your picture or digital photo into a document and format it the way you want. He addresses questions about terms like "inline" and "floating," and explains how easy it is to set up a watermark.