Microsoft Office Features
How To: Check whether quantities are equal in two lists 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 724th installment in their series of digital spreadsheet magic tricks, you'll learn how to check if quantities are the same in two lists and show the differences if not, list the word "equal" if they are the same, and "not in list" if the lookup items is not in list using the MATCH, INSA, VLOOKUP and IF functions.
How To: Publish a form template as e-mail ion InfoPath 2007
Take a look at this instructional video and learn how to create and distribute your own form templates with Microsoft Office InfoPath 2007. An easy way to get coworkers to fill out forms is to publish a form template as an e-mail message in Microsoft Office Outlook 2007.
How To: Use Excel keyboard shortcuts
This video is all about the keyboard shortcuts that are used in Microsoft Excel of the latest version. If you really need speed and efficiency then watch this video for its shortcut keyboard buttons. After typing all the data, if you need to see the page setup with the help of the mouse than it will take a pretty long time. By opting for keyboard shortcuts you can save much of your time and can invest it in another work. If you press 'alt' button then it will show keyboard shortcuts on the sc...
How To: Watermark a MS Work Document
Video: .
How To: Look up data from different Excel tables with INDIRECT
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 62nd installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use the VLOOKUP and INDIRECT functions to look up values from different tables. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.
How To: Connect to social networks in Microsoft Outlook 2010
Use the Microsoft Office 2010 Social Connector tool to reach out to friends in your favorite social networks. 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 2010 workflow, you're sure to be well served by this video tutorial. For more information, and to get started using the Outlook 2010 tool for yourself, watch this free video guide.
How To: Retrieve the last value from a row 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 6th installment in their joint series of digital spreadsheet magic tricks, you'll learn how to retrieve the last value in a row.
How To: Calculate equivalent earnings in Excel
In this video, ExcellsFun takes you step by step on how to calculate your employee payroll using an excel spread sheet. ExcellsFun teaches you how to take the base pay of various employees' salaries and determines how much you are paying them over a week, month, and year. Excellsfun also shows you how to incorporate various pay periods including weekly, semi-weekly, bi-weekly, and monthly on the same form using the same calculation for the entire spread sheet. After watching this video, you w...
How To: Get tips and tricks in Microsoft OneNote
This MS Office software tutorial shows you how to use some tips and tricks for the coolest features of Microsoft One Note. OneNote 2007 is great for notetaking during meetings or as a project communication tool at the office. Whatever you may need to keep track of, the tips and tricks in this OneNote tutorial will help you get started.
How To: Create a Powerpoint presentation
Need to make a Powerpoint presentation and you're not sure where to begin? In this three-part video tutorial, learn how to make a Powerpoint presentation from start to finish. A Powerpoint presentation is a great way to enhance a school project and impress your teacher!
How To: Customize the Ribbon bar in Microsoft Excel 2010
Learn how to add numbers using the SUM and AutoSUM functions within Microsoft Excel 2010. 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 adjusting the MS Excel 2010 Ribbon bar to your own liking, watch this free video guide.
How To: Calculate how much you'll need for retirement 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, part of his "Excel Finance Class" series of free video lessons, you'll learn how to use the PV and PMT functions together to decide how much you need at retirement and how much you should deposit each month during your working years.
How To: Insert tasks in MS Project 2007
In this tutorial, we learn how to insert tasks in MS Project 2007. First, go onto your project and use the insert menu to enter in the insertion point before the selected task. After his, enter in the task name and then enter in the duration and the start and finish time. If you need to enter multiple tasks, you can simply highlight the number of tasks you want to fill in to do it more quickly. If you want to delete a task, simply right click on it and click the delete button, then it will be...
How To: Return every tenth value 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 278th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the INDEX and ROWS functions to write a formula that will return each 10th value and place them all in a column.
How To: Create bulleted or numbered lists in MS Word 2007
This video explains how to add a bulleted or numbered list in Microsoft Word 2007. The shortcut to create a bullet-list is simple holding Shift and pressing the "A" key. After you hit the space bar or type a character the bullet will appear, and when you hit the Enter key it will continue the bulleted list. For numbering you just need to type the number you want and a dot after it and it should begin a numbered list. The list will continue if you press enter just like a bullet-list will. If y...
How To: Delete blank rows from a list 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 343rd installment in their series of digital spreadsheet magic tricks, you'll learn how to delete blanks rows en masse from a list within an Excel spreadsheet.
How To: Name cell ranges with relative references in MS Excel
Looking for a primer on how to create and work with names 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 8th installment in his series of Excel name tricks, you'll learn how to name cell ranges with relative cell references instead of the default absolute cell references.
How To: Insert and remove page numbers in MS Word 2007
This video will demonstrate the process to implement page numbers in your Microsoft Word 2007 documents. The video starts out by showing the Insert Tab on the Microsoft Word 2007 Ribbon. On the Insert Ribbon, you will see an icon titled Page Number. All of the Page Number options are available when you click the down arrow directly beside the icon. The are many different position options such top of page, bottom of page, page margins, or current position. The customization options are as endl...
How To: Customize your calendar in Outlook 2007
Did you know the views in your Microsoft Office Outlook calendar are fully customizable? View days and weeks in increments of 5 minutes, 60 minutes, or periods in between. Take a look into instructional video and learn how to adjust the view according to your work week and work day -- you can display Sunday-Thursday and show a normal day as 11 a.m.-7 p.m. Use different color schemes, and show more or less detail.
How To: Write and give a great PowerPoint Presentation
Here are seven tips you can use to make your PowerPoint presentation eye-catching and attention-grabbing. Never have your audience nod off. Keep your slides simple and organized, make good use of transitions, don't read directly from the slide and know your way around the keyboard and Presenter Mode.
How To: Create a new task in Microsoft Project 2010
In this clip, you'll learn how to create a new task when using 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: Apply formatting to alternate rows 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 685th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the MOD and ROW functions for applying formating to every other row in your chart.
How To: Force a function to becom an array 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 39th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how if an array or range is put into a function argument that is expecting a single value, the function becomes an array and delivers an array of values instead o...
How To: Extract records with an advanced filter in Excel
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 95th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use the OR, AND, NOT, & COUNTIF functions and Excel's advanced filter tool to extract records from a table of data. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.
How To: Use the MS Office Ribbon interface in SharePoint 2010
Learn how to use the Microsoft Office 2010 Ribbon interface within 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 the new Ribbon interface in SharePoint yourself, watch this free video guide.
How To: Use Excel to do math
This video describes how to use excel basics formulas to do math. Shows how to create new formulas so that you can complete math functions and how many formulas in excel work. Each step is displayed step by step with an explanation on what is going on so it may be understood. Keyboard short cuts among other tips and trick to help you navigate through microsoft's excel. After this video you would be able to use excel to do a variety of functions to complete math equations.
How To: Use the COUNT and COUNTA 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 658th installment in their series of digital spreadsheet magic tricks, you'll learn see how to use the COUNT & COUNTA functions correctly. COUNT counts numbers. COUNTA counts non-empty cells.
How To: Add holidays to your Microsoft Outlook calendar using Leo from Kryon Systems
Sometimes managing your calendar in Microsoft Outlook 2007 can be a tough job. Finding the information you need in Microsoft Office can be more than a chore, even when it comes to menial tasks, like adding a holiday to your calendar. But don't worry. There's an easier solution. Leo.
How To: Use conditional IF formulas in Microsoft Office 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 334th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the IF function. This video starts with IF function basics and then shows 12 different examples of how the IF function can be used in formulas. Also see how to use AND, OR, SUM, AVERAGE, STDEVP and VLOOKUP functions.
How To: Work with Microsoft Excel's LOOKUP function
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 42nd installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn ten tricks involving the LOOKUP function:
How To: Format a paragraph in Word 2007
This video demonstrates how to format a paragraph in Word 2007. 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 format a paragraph in Word 2007, For Dummies.
How To: Do time calculations with Microsoft Excel's MOD
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 286th installment in their series of digital spreadsheet magic tricks, you'll learn how to calculate hours worked for a night shift where workers start at 9 PM and end at 5 AM.
How To: Find data with Instant Search in MS Outlook 2007
Microsoft Windows Vista Tips - Finding Information with Instant Search in Microsoft Office Outlook 2007 - Somewhere in the hundreds, or perhaps thousands of messages in your Microsoft Office Outlook 2003 mailbox is the one that has the information you need about that client meeting on Thursday. So how do you find it without reading through every one of your messages? The new Instant Search feature in Microsoft Office Outlook 2007 allows you to find the information you need instantly. For more...
How To: Add a soundtrack in PowerPoint 2007
This screencast from E.A. Vander Veer, Author of PowerPoint 2007: The Missing Manual, guides you through adding an audio soundtrack from a CD to your Powerpoint Presentation.
How To: Count times exceeding 5 minutes 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 17th installment in their joint series of digital spreadsheet magic tricks, you'll learn how to create 5 formulas to count times greater than five minutes using Excel's COUNTIF and TIME functions.
How To: Add comments to cells 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 adding hidden comments (and metadata more generally) to data cells. For more information on commenting, watch this Microsoft Office Excel how-to.
How To: Get up to speed with Excel 2007
Microsoft Office Excel 2007 has a new design that makes your work easier, faster, and more efficient. The new Ribbon puts the commands you use most often in plain sight on your work surface instead of hidden in menus or dialog boxes. Ready-made cell styles let you quickly format your worksheet to make it easier to read and interpret. The new Page Layout view shows how your printed worksheet will look as you're creating it.
How To: Count with OR 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 674th installment in their series of digital spreadsheet magic tricks, you'll learn four different methods for counting OR criteria in Microsoft Excel 2010:
How To: Make PowerPoint animations
Thanks to How To Make Anything, learn how to make and do just about anything! In this episode, learn how to make things move around through the power of animation in Microsoft Powerpoint! Take your Powerpoint presentation to the next level with help from this video!
How To: Extract email extensions with filters 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 338th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the REPLACE and FIND functions in a new column to extract e-mail extensions, and then use Filter or Advanced Filter to Extract records according to e-mail extension.