Microsoft Office Features
How To: Use Microsoft Project 2010 with Sharepoint 2010
This video is about combining Microsoft Project 2010 and SharePoint 2010. This combination helps project teams to collaborate and share project information. Information can be displayed on a dashboard. We will also discuss various levels of project management such as starting the project, planning, tracking and reporting on the projects progress.
How To: Use themes in Microsoft SharePoint 2010
Learn how to use custom themes when working in Microsoft SharePoint 2010. 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 themes in your own SharePoint projects, watch this free video guide.
How To: Customize Quick Access Toolbar in MS Word
This video will show you how to customize Quick Access Toolbar in MS Work. You could add, delete commands and can set the placement of the bar.
How To: Use the "Unique Records Only" filter 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 63.5th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use the advanced filter "Unique Records Only" option and the VLOOKUP, COLUMN, IF, ISERROR and IFERROR functions to merge 2 tables.
How To: View the logic in a form template with InfoPath
You don't have to check the settings for every control individually — you can use the Logic Inspector to see a form's business logic displayed in a single window, grouped by features such as data validation, calculated data values, rules, and programming. Take a look at this instructional video and learn how to view the logic in a form template with Microsoft InfoPath.
How To: Count dates with an array formula 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 142nd installment in their series of digital spreadsheet magic tricks, you'll learn how to create a complex array formula that counts weekends between two dates with the SUM, IF WEEKDAY, ROW and INDIRECT functions.
How To: Use the LEFT and RIGHT functions in Microsoft Excel
Microsoft Office Excel 2007 spreadsheet manager is a powerful tool that enables information workers to format spreadsheets, as well as analyze and share information to make more informed decisions. In this MS Excel video tutorial, you'll learn about concatenation using LEFT and RIGHT functions. For more information, watch this Microsoft Office how-to.
How To: Compare a list of numbers where one group is entered as text in 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 719th installment in their series of digital spreadsheet magic tricks, you'll learn how to compare two list of numbers and see what happens when one list is numbers is aligned right and the other list is numbers as text.
How To: Use the TRANSPOSE & FREQUENCY array functions in Excel
hether 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 38th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to use the TRANSPOSE & FREQUENCY functions.
How To: Run lookup queries with two values 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 606th installment in their series of digital spreadsheet magic tricks, you'll learn how to write a formula that can look up two 2 lookup values using the INDEX & MATCH functions and concatenated (joined) columns for the lookup value and lookup table.
How To: Count the max number of successive items in a data column 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 713th installment in their series of digital spreadsheet magic tricks, you'll learn how to count the max number of items in succession in a column of data using the FREQUENCY, IF, MAX and ROW functions.
How To: Send an email with Microsoft Outlook Express
In this video, we learn how to send an email using Outlook Express. First, click "create mail" in the Outlook program. In the "to" section, fill out the email address of the person you want to email to. You can also access your address book and choose recipients from that folder, double click them and make sure they show up in the recipient folder. After this, click "ok". In your subject line, fill in which subject the email is about. After you are done with this, move to the main body of thi...
How To: Apply a theme to a diagram in Visio 2007
Take a look at this instructional video and learn how to use themes in Microsoft Office Visio Professional 2007 to add color and style to your diagram with just a few clicks. Choose from a gallery of predefined themes, or customize themes with your own background colors, fonts, effects, and more. Your diagram will jump off the page, plus you can make it visually consistent with documents you create in other Microsoft Office programs.
Use MS Excel cell references: relative & absolute
If you're looking to learn how to use Microsoft Excel, a video series from digital spreadsheet guru ExcelIsFun is a great place to start. But which of his many series should you choose? The one titled "Excel Basics," that's which! In this free video MS Excel lesson, the 8th installment in said basics series, you'll learn how to use both relative and absolute cell references in MS Excel.
How To: Build an amortization table for a business loan with the PMT function
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 43rd installment in his "Excel Finance Class" series of free video lessons, you'll learn how to create an amortization table for a business loan with Excel's PMT function.
How To: Add a workbook reference to an Excel VLOOKUP formula
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 52nd installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to have one workbook look into another workbook using a workbook reference. See also how to update workbook references. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.
How To: Insert a picture into a Microsoft Word document using Leo from Kryon Systems
Learn. Evolve. Operate. That's the basis of Leo from Kryon Systems. It's a new application that runs on top of any program you have open (web and desktop applications), providing you with instant help. Leo can actually perform your duties for you! Like in Microsoft Word 2007. In this video demo, you'll learn how you can use Leo to help you insert a picture into Word 2007, making Office a whole lot easier. See it in action!
How To: Create dynamic ranges for formulas with Excel's OFFSET
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 584th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the OFFSET function and defined names to create dynamic ranges for formulas so formulas update each period when a new data dump (copy and paste) is completed.
How To: Switch from PowerPoint 2003 to PowerPoint 2007
There are many new features which will make you more comfortable in doing your work in PowerPoint 2007 which will force you to switch from PowerPoint 2003 to PowerPoint 2007. There are number of new features in PowerPoint 2007.
How To: Find the best value from a 2-category set 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 178th installment in their series of digital spreadsheet magic tricks, you'll learn how to alculate the best value from two categories of values.
How To: Calculate days with Microsoft Excel's INT function
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 300th installment in their series of digital spreadsheet magic tricks, you'll learn how to use date and time functions together. Specifically, you'll see how to use the INT function to calculate total days worked and the TEXT function to calculate total hours worked.
How To: Highlight rows that contain unique values 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 621st installment in their series of digital spreadsheet magic tricks, you'll learn how to write a logical formula using the AND and COUNTIFS functions with mixed cell references in the conditional formatting dialog box to highlight entire row (whole record) in data set (table) when record is unique and matches the s...
How To: Do date calculations 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 12th installment in their series of digital spreadsheet magic tricks, you'll learn how to calculate the time between 2 dates like invoices past due. Learn how to calculate a loan due date or how many days you have been alive!
How To: Create a Watermark MS Word Document
This video will provide an idea about the watermark which is a background effect of either text or graphics that prints in a lighter shade behind the content of your MS Word 2007 document. Watch the tutorial video and employ it yourself.
How To: Extract dates from a cell with dates and words 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 51st installment in his "Excel Finance Class" series of free video lessons, you'll learn how to use the DATEVALUE, RIGHT, IFERROR, LEN, TEXT, SEARCH, TRIM and REPLACE to extract dates from a cell containing both dates and words.
How To: User a hyperlink to open a different workbook 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 487th installment in their series of digital spreadsheet magic tricks, you'll learn how to use a hyperlink to open a different workbook, file or sheet within the existing workbook.
How To: Select numbers from a set without repeats 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 373rd installment in their series of digital spreadsheet magic tricks, you'll learn how to select 3 numbers from 50 with no repeats. Also see how to select 3 names from a list of 10 with no repeats.
How To: Put a YouTube video on a Powerpoint 2003 presentation
In this how-to video, you will learn how to embed a YouTube video on your PowerPoint presentation. First, open the program and select toolbars. Go to control toolbox and select more controls. Go to shockwave flash object and make a box. Now, get the link of the YouTube video. On the x box, right click and select properties Paste the link next to the movie and click the x on the control box. Now you can watch the presentation to see that the video is in place. Viewing this video shows you just...
How To: Setup Microsoft Outlook 2007 with email
In this video tutorial, viewers learn how to setup Microsoft Outlook 2007. Begin by opening the Outlook Express 2007 program. Then click on Tools and select Account Settings. Under the Email tab, click on New. Now type in your name, email address and password. Then click on Next. Select Internet Email and click on Next. Now type in your user information, server information and log on information. Then click on More Settings and click on the Outgoing Server tab. Check the first box and then cl...
How To: Make sure entries are unique in Microsoft Excel 2010
Looking for a way to ensure your entries are unique in Microsoft Excel 2010? This clip will teach you what you'll need to know. 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, watch this free video guide.
How To: Create an average with multiple criteria 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 91st installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to create an average with multiple criteria using pivot tables (PivotTable). Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.
How To: Use conditional & custom number formatting 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 101st installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use conditional formatting AND custom number formatting to add styling to a cell.
How To: Add different backgrounds to slides in PowerPoint
You can give your PowerPoint presentation a unique look by formatting the slides. Learn how to change the color, background, effects, and more in PowerPoint.
How To: Import and arrange media in a PowerPoint presentation
Want to spice up your PowerPoint presentations with images or even video? Learn how to import, adjust, and arrange media into your slides.
How To: Extract data with an AND/NOT advanced filter 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 322nd installment in their series of digital spreadsheet magic tricks, you'll learn how to create an advanced filter to extract with AND and NOT criteria.
How To: Use the MS Office Ribbon interface in PowerPoint 2010
Meet the Microsoft Office 2010 Ribbon interface. Whether you're new to Microsoft's popular presentation application or a seasoned MS Office professional just looking to better acquaint yourself with the Outlook 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: Make an Excel PivotTable year category from text dates
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 612th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a Year Category for a PivotTable from dates entered as text using the RIGHT function and the ampersand (&) join symbol.
How To: Calculate the present value of an investment 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 22nd installment in his "Excel Finance Class" series of free video lessons, you'll learn how to calculate the present value of an investment in Microsoft Excel.
How To: Select cells in a spreadsheet using hot keys in Excel
This video is an Excel magic trick which shows how to select cells in Excel through keyboard shortcuts. He starts by the basics where he shows how to select a range of cells in excel work book. He shows how to jump to the top and bottom of the selection area. He even shows how to use shift key to select the whole range. Finally he shows how to hold control, shift and click to select the whole ranges. He even shows how to select ranges top to bottom and from left to right. This video shows how...
How To: Apply themes in Microsoft SharePoint 2007
Learn how to use custom themes when working in Microsoft SharePoint 2007. 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 2007 workflow, you're sure to be well served by this video tutorial. For more information, and to get started using themes in your own SharePoint projects, watch this free video guide.