Hot Microsoft Office Posts
How To: Track cash on hand with a table Microsoft Excel 2010
Learn how to keep track of cash on hand via special table in your MS Excel 2010 workbooks. 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 tracking cash for your own budgets, take a look.
How To: Wrap text around an image in Microsoft Word 2010
Learn how to add use text wrapping in your Microsoft Word 2010 documents. Whether you're new to Microsoft's popular word processing application application or a seasoned MS Office professional just looking to better acquaint yourself with the Word 2010 workflow, you're sure to be well served by this video tutorial. For more information, and to get started wrapping text around images in your own Word documents, watch this free video guide.
How To: Edit and delete scenarios in Microsoft Excel 2007
Learn how to edit and delete scenarios in your Excel 2007 workbooks. 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 2007 workflow, you're sure to be well served by this video tutorial from the folks at Lynda. For more information, and to get working with scenarios in your own MS Excel projects, watch this free video guide.
How To: Use FREQUENCY array functions 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 and Mr. Excel, the 627th installment in their joint series of digital spreadsheet magic tricks, you'll learn how to create, edit and otherwise work with FREQUENCY array functions.
How To: Set a milestone in MS Project 2007
In this software video tutorial you will learn how to set a milestone in MS Project 2007. Milestone is an important task. Lot many times a milestone is like a goal or deadline to be completed by a particular date. It is defined as a task that doesn't have a duration. To make a milestone, enter a task and under duration, enter 0d. This will turn in to a milestone. To make task in to a milestone, double click on the task. On the next window that comes up, look for and click on the 'advanced' ta...
How To: Use elapsed duration in MS Project 2007
In this software video tutorial you will learn how to use elapsed duration in MS Project 2007. A simple project has been created with a few tasks and the durations have also been entered. Say you have an important task that's essential for the completion of the project. For example, if you are shooting a film, developing the film is an important task. You might know that this task may take 16 hours. If you enter the duration of 16hrs against the task, the start and finish dates will be, for e...
How To: Create a pdf document using Microsoft Word
In this software video tutorial you will learn how to create a pdf document using Microsoft Word. First you select the document you want to convert to pdf, click on file and select print. When the print window opens up, on the left had bottom, you will see the pdf button. Click on it and a dropdown menu comes up. Select 'save as pdf' from the dropdown menu, give the file a name and click 'save'. Exit the word program and you will see the pdf document on the desktop. You can now open it to see...
How To: Make sketches with Microsoft Excel
Not only is Microsoft Office Excel handy for drafting documents, it can also be used to make simple illustrations. Quite easily at that. The program's drawing tools are so easy to utilize, in fact, that this free video software tutorial can present a complete overview of the process in just under four minutes' time. For detailed instructions, as well as to get started doodling in your own Excel workbooks, take a look.
How To: Break up hours worked by shift 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 624th installment in their series of digital spreadsheet magic tricks, you'll learn how to break apart the hours worked in a given day into one part for the day shift and a second part for the night shift using the MEDIAN function instead of the IF function. The MEDAIN function can be used when there are different ca...
How To: Keep track of projects with a Gantt chart 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 626th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a Gantt Chart to show the amount of time a project takes during a day.
How To: Automate tasks with macros in Microsoft Access 2010
Learn how to use create macros 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 macros in your own Access projects, watch this free video guide.
How To: Format reports with the Layout view in MS Access 2010
Learn how to use the Layout 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 Layout view in your own Access projects, watch this free video guide.
How To: Use the Report Wizard in Microsoft Access 2010
Learn how to work with the Report Wizard tool 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 Report Wizard in your own Access projects, watch this free video guide.
How To: Creating data-entry forms in Microsoft Access 2010
Learn how to create data-entry forms 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 data-entry forms in your own Access projects, watch this free video guide.
How To: Create relationships & enforce integrity in MS Access
Learn how to use create relationships and enforce referential integrity 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 creating and managing relationships within Access, watch this free video guide.
How To: Use the Ribbon interface in Microsoft Access 2010
Before you can work in MS Access 2010, you'll need to learn how to work with it. See how to navigate the Ribbon interface when working in Microsoft Access 2010 with this guide. 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 Acces...
How To: Use the Backstage view when working in MS Access 2010
Learn how to take advantage of 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: 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: 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: 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: Freeze panes in Microsoft Excel 2010
Learn how to freeze panes when working 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 freezing panes in your own Excel 2010 projects, watch this free video guide.
How To: Insert SmartArt into Microsoft Excel 2010 spreadsheets
Learn how to add SmartArt to your Microsoft Excel 2010 workbooks. 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 SmartArt in your own Excel projects, watch this free video guide.
How To: Add numbers with SUM and AutoSUM in MS 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 using the SUM and AutoSUM functions in your own Excel projects, watch this free video guide.
How To: Use the Backstage view and File tab in MS Excel 2010
Learn how to use the Backstage view option when working in 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 using the Backstage view and File tab in your own Excel projects, watch this free video guide.
How To: Find APR, EAR & amortization for payday loans 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 623rd installment in their series of digital spreadsheet magic tricks, you'll learn how to see the pain that pay day loans inflict on people using Excel. Learn how to calculate APR (Annual Percentage Rate), EAR (Effective Annual Rate), an Amortization Table and the EAR for a loan that takes a fee out up front. Learn ...
How To: Merge, split & format cells in Microsoft Word 2010
Before you can work in Word 2010, you'll need to learn how to work with it. See how to join, split and apply formatting to cells within Microsoft Word 2010 with this free video software tutorial. Whether you're new to Microsoft's popular word processor or just wish to get to know Word 2010 a little better, you're sure to find much of value in this video lesson. For more and better information, and to get started working with cells in MS Word 2010 yourself, take a look.
How To: Changing line spacing settings in Microsoft Word 2010
Before you can work in Word 2010, you'll need to learn how to work with it. See how to adjust line spacing parameters within Microsoft Word 2010 with this free video software tutorial. Whether you're new to Microsoft's popular word processor or just wish to get to know Word 2010 a little better, you're sure to find much of value in this video lesson. For more and better information, and to get started changing line spacing settings in the Word 2010 UI yourself, take a look.
How To: Adjust font settings within Microsoft Office Word 2010
Before you can work in Word 2010, you'll need to learn how to work with it. See how to change and style fonts within the Microsoft Word 2010 user interface with this free video software tutorial. Whether you're new to Microsoft's popular word processor or just wish to get to know Word 2010 a little better, you're sure to find much of value in this video lesson. For more and better information, and to get started using custom font settings in Word 2010 yourself, take a look.
How To: Undo and redo actions in Microsoft Office Word 2010
Before you can work in Word 2010, you'll need to learn how to work with it. See how to undo and redo actions the Microsoft Word 2010 user interface with this free video software tutorial. Whether you're new to Microsoft's popular word processor or just wish to get to know Word 2010 a little better, you're sure to find much of value in this video lesson. For more and better information, and to get started undoing and redoing actions with ease in Word 2010 UI, take a look.
How To: Find and open documents the easy way in MS Word 2010
Before you can work in Word 2010, you'll need to learn how to work with it. See how to locate and open documents the easy when using Microsoft Word 2010 with this free video software tutorial. Whether you're new to Microsoft's popular word processor or just wish to get to know Word 2010 a little better, you're sure to find much of value in this video lesson. For more and better information, and to get started using this tip yourself, take a look.
How To: Create a new document from a template in Word 2010
Before you can work in Word 2010, you'll need to learn how to work with it. See how to generate a new document from a template in Microsoft Word 2010 with this free video software tutorial. Whether you're new to Microsoft's popular word processor or just wish to get to know Word 2010 a little better, you're sure to find much of value in this video lesson. For more and better information, and to get started using tempaltes in MS Word 2010 yourself, take a look.
How To: Use the Ribbon interface in Microsoft Office Word 2010
Before you can work in Word 2010, you'll need to learn how to work with it. See how to use the Microsoft Word 2010 Ribbon interface with this free video software tutorial. Whether you're new to Microsoft's popular word processor or just wish to get to know Word 2010 a little better, you're sure to find much of value in this video lesson. For more and better information, and to get started navigating the Word 2010 Ribbon UI yourself, take a look.
How To: Navigate the Microsoft Word 2010 user interface
Before you can work in Word 2010, you'll need to learn how to work with it. See how to use the Microsoft Word 2010 user interface with this free video software tutorial. Whether you're new to Microsoft's popular word processor or just wish to get to know Word 2010 a little better, you're sure to find much of value in this video lesson. For more and better information, and to get started using the Word 2010 UI yourself, take a look.
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: Create a site in Microsoft SharePoint 2010
Want to create a site within Microsoft SharePoint 2010? This clip 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, and to get started using SharePoint yourself, watch this free video guide.
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: Use the LARGE and SMALL 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 616th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the LARGE and SMALL functions to retrieve the 1st, 2nd, and 3rd largest values from a list. You'll also see how to do each of the following:
How To: Add fiscal year sales 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 617th installment in their series of digital spreadsheet magic tricks, you'll learn how see a SUMIFS and SUMPRODUCT functions formula to sum the fiscal year's sales when the year does not end on December 31st. Also see a formula for year-over-year percentage change.
How To: Add today's date & time via keyboard shortcut 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 618th installment in their series of digital spreadsheet magic tricks, you'll learn about a handy key command that will allow you to enter both today's time and date into a single Excel cell.
How To: Remove spaces from a Microsoft Excel formula
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 619th installment in their series of digital spreadsheet magic tricks, you'll see how spaces in cells cause trouble in formulas and learn how to use the REPLACE, COUNTIF, CLEAN & TRIM functions to solve space-related formula problems.