Hot Microsoft Office Posts
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: Return only even row data in an MS 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 622nd installment in their series of digital spreadsheet magic tricks, you'll learn how to to write an array formula using the SUMPRODUCT, MOD, IF, ROWS, INDEX, SMALL, and ROW functions that will retreive only even row values.
How To: Create budgets in MS Project 2007
These days it seems like budgets are on everybody's minds. Big or small, financial planning is an essential part of daily life following the latest recession. In this tutorial you will learn how to create budget resources, using MS Project 2007, that you can assign to your project to compare you actual hours and costs against your budget.
How To: Export an Adobe Illustrator CS5 image for use in Microsoft Office
Want to use an Illustrator CS5 illustration in a Microsoft PowerPoint presentation or Word document? This video clip will show you how it's done. Whether you're new to Adobe's popular vector graphics editor or a seasoned graphic arts professional interested in better acquainting yourself with the new features and functions of Illustrator CS5, you're sure to benefit from this free software tutorial. For more information, and to get started using this trick in your own Illustrator projects, wat...
How To: Create value-based formatting using data bars in Excel
See how to create value-based formatting using data bars and color scales in Excel 2007. See how to use the Format Cells dialog box and the pop-up mini-toolbar in Microsoft Excel 2007. Whether you're new to Microsoft's popular digital spreadsheet application or a seasoned business professional just looking to better acquaint yourself with this particular iteration of the program, you're sure to be well served by this video tutorial. For more information, including step-by-step instructions, w...
How To: Apply picture styles in a MS Excel 2007 workbook
See how to apply custom picture styles in Microsoft Excel 2007. Whether you're new to Microsoft's popular digital spreadsheet application or a seasoned business professional just looking to better acquaint yourself with this particular iteration of the program, you're sure to be well served by this video tutorial. For more information, including step-by-step instructions, watch this free video guide.
How To: Set colors and fonts for a full workbook in Excel 2007
See how to use themes to set color, font and effects settings for a Microsoft Excel 2007 workbook. Whether you're new to Microsoft's popular digital spreadsheet application or a seasoned business professional just looking to better acquaint yourself with this particular iteration of the program, you're sure to be well served by this video tutorial. For more information, including step-by-step instructions, watch this free video guide.
How To: Use the Format Cells dialog box in MS Excel 2007
See how to use the Format Cells dialog box and the pop-up mini-toolbar in Microsoft Excel 2007. Whether you're new to Microsoft's popular digital spreadsheet application or a seasoned business professional just looking to better acquaint yourself with this particular iteration of the program, you're sure to be well served by this video tutorial. For more information, including step-by-step instructions, watch this free video guide.
How To: Learn the most useful Excel 2007 formatting shortcuts
Speed up your MS Excel workflow with these handy formatting key commands. Whether you're new to Microsoft's popular digital spreadsheet application or a seasoned business professional just looking to better acquaint yourself with this particular iteration of the program, you're sure to be well served by this video tutorial. For more information, including step-by-step instructions, watch this free video guide.
How To: Migrate from Microsoft Access 2003 to Access 2007
Interested in upgrading from Microsoft Access 2003 to MS Access 2007? Whether you're new to Microsoft's popular data management application or a seasoned MS Office professional just looking to better acquaint yourself with the Access 2007 workflow, you're sure to be well served by this video tutorial. For more information, and to get started making the switch from Access 2003 to 2007 yourself, watch this free video guide.
How To: Convert old databases in Microsoft Access 2007 format
Learn how to modify your old databases for use in Microsoft Access 2007. Whether you're new to Microsoft's popular data management application or a seasoned MS Office professional just looking to better acquaint yourself with the Access 2007 workflow, you're sure to be well served by this video tutorial. For more information, and to get started using old databases in Access 2007 yourself, watch this free video guide.
How To: Use the Layout view in Microsoft Office Access 2010
Learn how to use the Layout view when working in Microsoft Access 2010. Whether you're new to Microsoft's popular data management application or a seasoned MS Office professional just looking to better acquaint yourself with the Access 2010 workflow, you're sure to be well served by this video tutorial. For more information, and to get started using the Layout view in your own Access projects, watch this free video guide.
How To: Use Application Parts when working in MS Access 2010
Learn how to work with Application Parts when using Microsoft Access 2010. Whether you're new to Microsoft's popular data management application or a seasoned MS Office professional just looking to better acquaint yourself with the Access 2010 workflow, you're sure to be well served by this video tutorial. For more information, and to get started working with Application Parts in your own Access projects, watch this free video guide.
How To: Use the Backstage view in Microsoft Access 2010
Learn how to use the Backstage view option when working in Microsoft Access 2010. Whether you're new to Microsoft's popular database management application or a seasoned MS Office professional just looking to better acquaint yourself with the Access 2010 workflow, you're sure to be well served by this video tutorial. For more information, and to get started using the Backstage view in your own Access projects, watch this free video guide.
How To: Customize Web Parts in SharePoint Designer 2007
Learn how to customize Web Parts 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 customized Web Parts in your own SharePoint projects, watch this free video guide.
How To: Customize the Quick Launch bar in SP Designer 2007
Learn how to customize the Quick Launch bar within SharePoint Designer 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, including step-by-step instructions, watch this free video guide.
How To: Begin with a minimal master page in MS SharePoint 2007
Start from a minimal master page when using Microsoft SharePoint Designer 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, watch this free video guide.
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.
How To: Manage documents in Microsoft SharePoint 2010
Learn how to manage documents 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 managing your own documents within SharePoint, watch this free video guide.
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: Use SharePoint 2010's social computing functionalities
Learn how to take advantage of Microsoft SharePoint 2010's new social computing tools. 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 taking advantage of SharePoint's social computing features yourself, watch this free video guide.
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 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: Crop digital images in Microsoft PowerPoint 2010
With Microsoft PowerPoint 2010, it's easier than ever to crop your digital photos. See how it's done with this free video software tutorial. 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 guide. For more information, and to get started creating and using the Ribbon interface in your own PowerPoint projects, take a look.
How To: Use the new presentation themes in MS PowerPoint 2010
Microsoft PowerPoint 2010 includes more than just a host of new features, it also offers a significant number of new presentation themes. 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 PowerPoint 2010's new themes in your own digital slideshows, watch this free v...
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: 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: Migrate from Microsoft Outlook 2003 to Outlook 2007
Need help making the switch from Outlook 2003 to 2007? Give this guide a gander. This free video tutorial presents an easy-to-follow overview of everything you'll need to know to migrate your data from one program to the other. For more information, and to get started using Microsoft Outlook 2007, watch this free video guide.
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: Create Quick Steps in Microsoft Outlook 2010
Quickly perform a sequence of tasks by creating custom Quick Steps in Microsoft Outlook 2010. 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 creating and using Quick Steps in Outlook 2010 yourself, watch this free video guide.
How To: Use Quick Filing to import information in OneNote 2010
Learn how to quickly import data into Microsoft OneNote 2010 with the Quick Filing tool. Whether you're new to Microsoft's popular note-taking application or a seasoned MS Office professional 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 quickly importing data into your own OneNote projects, watch this free video guide.
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: Share MS Excel 2010 documents through SharePoint
Learn how to take full advantage of MS Excel 2010's collaboration features. 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 2010, you're sure to be well served by this video tutorial. For more information, and to get started using SharePoint to share your own Excel 2010 worksheets, watch this free video guide.
How To: Customize the Ribbon Bar in Microsoft Excel 2010
Learn how to customize the Ribbon Bar MS Excel 2010. 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 2010, you're sure to be well served by this video tutorial. For more information, and to get started using your own custom Ribbon Bar layout within MS Excel 2010, watch this free video guide.
How To: Work with the VBA environment in Microsoft Excel 2007
Learn how to use the VBA environment within MS Excel 2007 to create custom macros. 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 working within Excel 2007's VBA environment yourself, watch this free video guide.
How To: Record custom macros in Microsoft Excel 2007
Want to record your own custom macros within MS Excel 2007? See how it's done. 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 recording your own macros, take a look.
How To: Use macros in Microsoft Excel 2007
Looking for an introduction on how to work with macros 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 absolute and relative macros in your own Excel 2007 workbooks, watch this free...
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: Sum year-over-year sales from daily data 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 609th installment in their series of digital spreadsheet magic tricks, you'll learn how to build a pivot table to calculate year over year sales showing percentage change.
How To: Sum year over year sales using MS Excel's SUMPRODUCT
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 611th installment in their series of digital spreadsheet magic tricks, you'll learn how to create an array formula to summarize year over year sales using the SUMPRODUCT and YEAR functions. Also see how to calculate a formula for percentage change.