Hot Microsoft Office How-Tos
How To: Copy an Excel formula through a range via the keyboard
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 630th installment in their series of digital spreadsheet magic tricks, you'll learn how to copy formula through a huge range using keyboard shortcuts.
How To: Apply special formatting to past-due invoices 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 631st installment in their series of digital spreadsheet magic tricks, you'll learn how to add conditional formatting to a transactional record when the date is 90 days past due using the TODAY function and mixed cell references in a logical TRUE-FALSE formula.
How To: Count dates falling within a given year 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 632nd installment in their series of digital spreadsheet magic tricks, you'll learn how to create a formula using the SUMPRODUCT and YEAR function to count instances of the year 2009 or 2010 from a list of dates with different years.
How To: Compare text with text & numbers with numbers 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 634th installment in their series of digital spreadsheet magic tricks, you'll learn how to build logical formulas for counting with criteria or conditional formatting so that the comparison is between text and text or numbers and numbers. Text-to-number comparisons (e.g., 2003 to "2003") do not yield matches. Learn h...
How To: Use Excel to sort data & present data in a line chart
This video introduces how to use Excel to sort data, perform the Frequency function, and present data in line chart. See how to apply condition formatting when working in Microsoft Excel 2007. 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 2007 workflow, you're sure to be well served by this video tutorial. For more information, and to get started creating your own li...
How To: Apply formatting to Excel cells that meet a condition
See how to apply condition formatting when working in Microsoft Excel 2007. 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 2007 workflow, you're sure to be well served by this video tutorial. For more information, and to get started using the useful formatting feature in your own Excel documents, watch this free video guide.
How To: Move and edit data validation ScreenTips 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 48th installment in their joint series of digital spreadsheet magic tricks, you'll learn how to break Excel by moving a data validation ScreenTip.
How To: Calculate interest on a loan payment in MS Excel 2007
Learn how to calculate interest on loan payments with 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 the Excel 2007 workflow, you're sure to be well served by this video tutorial. For more information, and to get started making your own loan payment calculations, watch this free video guide.
How To: Summarize budget data via PivotTable in MS Excel 2010
Learn how to create a summary of your budget data. 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 summarizing your own budget data, watch this free video guide.
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: 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: 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: Create a basic PivotTable in Microsoft Excel 2010
Learn how to create a simple PivotTable within 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 PivotTables (or Pivot Tables) 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: Use templates in Microsoft Excel 2010
Learn how to employ templates 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 using templates 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.