Microsoft Office Features
How To: Add, hide, and show columns in Project 2007
Suppose you created a project plan in Microsoft Office Project 2007, and you want to add a new column of information. You also want to be able to choose not to display the new information, but you don't want it to be lost. Take a look at this instructional video and learn how to create a column, hide a column, and show a column that you previously hid.
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: Calculate yield to market & effective annual yield from bond price in 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 49th installment in his "Excel Finance Class" series of free video lessons, you'll learn how to calculate yield to market and effective annual yield from a bond price.
How To: Use statistical functions in Excel (STDEV/MODE/MEDIAN)
If you use Microsoft Office Excel on anything resembling a regular basis, odds are you work with numbers. Put those numbers to work with this free MS Excel video tutorial, which will teach you how to use a number of Excel's basic statistical functions (e.g., STDEV, AVERAGE, MEDIAN, MODE, RANK, ROUND, LARGE & SMALL).
How To: Share your calendar 3 ways with Outlook 2007
This tutorial shows you how to share your calendar three ways in Microsoft Office Outlook 2007. If your company uses Microsoft Exchange Server, you can share your calendar within the organization by using that feature. You can also send a snapshot of your calendar in e-mail to people outside your company. And you can publish your calendar on the Microsoft Office Online Web site and restrict how much detail is shown and who can access it.
How To: Create a bibliography with MS Word 2007
In order to create a bibliography with Microsoft Word 2007, you will need to access the reference tool bar, at the top of your screen. Click on references. Open your document. Put your cursor where you want to make the entry. Then, click on Manage sources. Fill in the pop-up that comes up. This will ask you for all of the information needed for the type of citation you are using. Click OK.
How To: Use Adobe Presenter for presentations in PowerPoint
The ability to create professional and clean presentations can be a valuable asset to one’s career. With this video tutorial, learn how to use Adobe Presenter in order to augment Power Point presentations. Presenter offers users the ability to record narration under a set order of slides in a simple interface, and provides an interactive quiz option to further engage audience members. Alternatively, users may also convert a presentation into PDF format, for use as a physical or virtual document.
How To: Conditionally format cell data bars in MS Excel 2010
New to Microsoft Excel 2010? Looking for a few good tips and tricks? Look no further. In this free video tutorial from everyone's favorite MS Excel guru, YouTube's ExcelIsFun, the 5th installment in his series of Excel 2010 video tutorials, you'll learn how to apply conditional formatting to cell data bars.
How To: Use the order of operations correctly when working with Microsoft Excel
You'll need to use lots of math if you're working with formulas and numbers in Microsoft Excel. This tutorila gives you a brief introduction to the different math operators avaiable to users of Excel, as well as reviewing the order of operations you'll need to be aware of.
How To: Speed up Excel calculations with helper columns
Are you looking for a way to make your Microsoft Excel formulas simpler, faster and more efficient? If so, you're in the right place. With this free video lesson from everyone's favorite digital spreadsheet guru, YouTube's ExcelsFun, the 7th installment in his "Excel Formula Efficiency" series, you'll learn how to count unique records with a formula with a helper column to speed up calculations.
How To: Make credit card calculations with Microsoft Excel
As you might guess, one of the domains in which Microsoft Excel really excels is business 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 36th installment in his "Excel Business Math" series of free video lessons, you'll see how to make credit card calculations using the ROUND function.
How To: Create a list of items with a 2-array formula 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 187th installment in their series of digital spreadsheet magic tricks, you'll learn two different array formula types for creating a unique list of items for a large list containing duplicates.
How To: Build confidence intervals & test hypotheses in Excel
If you use Microsoft Excel on a regular basis, odds are you work with numbers. Put those numbers to work. Statistical analysis allows you to find patterns, trends and probabilities within your data. In this MS Excel tutorial from everyone's favorite Excel guru, YouTube's ExcelsFun, the 47th installment in his "Excel Statistics" series of free video lessons, you'll learn how to use the NORMSINV function for critical values and the NORSDIST function for p-values. Compare building confidence int...
How To: Create a pivot chart in Excel 2007
This video demonstrates how to create pivot chart in Excel 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 create pivot chart in Excel 2007, For Dummies.
How To: Convert currency with data from a web query 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 94th installment in their series of digital spreadsheet magic tricks, you'll learn how to use and link a currency web query to a data validation cell drop-down list for money conversion.
How To: Add contacts to groups in Entourage
The fastest way to keep people you know in the loop is to add them to an e-mail group, using Entourage. Add contacts to groups in Entourage.
How To: Optimize Microsoft Word
This Microsoft Word tutorial discusses some tips and tricks for speeding up your work and adding extra function to Microsoft Word.
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: Find an item's relative position via MATCH in MS 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 43rd installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to use the MATCH function to find the ordinal position (relative position) of an item in a list.
How To: Reverse two way lookup for date & time in Excel
In this Excel magic trick video the tutor shows how to perform reverse two way look up for date and time columns and row headers. In this tutorial he shows a spreadsheet that contains dates in columns and times of a day in rows which makes up a small table schedule. Now he shows how to use those values of the cells in that schedule table and summarize and print out the values based up on a name or some other text value. He also refers to a previous video of his which he says to watch to get g...
How To: Use the FORECAST function for linear algebra 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 91st installment in their series of digital spreadsheet magic tricks, you'll learn how to use the FORECAST function to solve linear algebra problems.
How To: Incorporate music into a PowerPoint presentation
This video provides step-by-step instructions for how to insert sounds or music into a PowerPoint presentation, using Microsoft Office 2007. The narrator uses the insert sound tool and selects an audio file that, and demonstrates how to make it play automatically when the PowerPoint slide show is played. He also shows how to customize the effect options by using the animations tab, which allows you to choose when the track starts and finishes, for how many slides, and at what volume. After wa...
How To: Save an Excel 2010 document for use in Excel 2003
Learn how to make your Excel 2010 spreadsheets compatible with Excel 2003. 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, including step-by-step instructions, take a look.
How To: Calculate present value for an annuity in MS Excel
As you might guess, one of the domains in which Microsoft Excel really excels is business 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 61st installment in his "Excel Business Math" series of free video lessons, you'll learn how to use the Excel functions PV and PMT to make a present value calculation for an annuity.
How To: Set up your AIM/AOL e-mail accounts in Outlook
In this tutorial, we learn how to set up your AIM/AOL e-mail accounts in Outlook. First, go to Outlook and open up e-mail accounts through the tools menu. Now, add a IMAP serve, then add in your user information. After this, enter in your server information, and click the settings button. Change the name of your folder if you are using multiple accounts, so you don't confuse them. In the next tab, check the outgoing server mark, then on the advanced tab, change the last number to 587. Press o...
How To: Make read only/password protected docs in MS Word 2007
Ever have the problem of people messing with your word documents? This guy shows you the solution by telling you how to create password protected encrypted word documents. The process starts with your open file. Clicking on save as... and in the popup window clicking the tools button in the bottom left corner and clicking general options. There it shows you text entry boxes, one for setting a password to open the file, another to set a password for rights to modify the file. Enter your passwo...
How To: Value assets with discounted cash flow analysis 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 do asset valuation using discounted cash flow analysis.
How To: Insert a screen clip in Microsoft Word 2010
In this quick clip, you'll learn how to insert screen clips when using MS Word 2010. Whether you're new to Microsoft's popular word processing application or a seasoned professional merely looking to pick up a few new tips and tricks, you're sure to benefit from this video tutorial. For complete instructions, take a look.
How To: Embed a YouTube video in PowerPoint 2007
This video shows how to embed a YouTube video in a PowerPoint presentation in Microsoft Office PowerPoint 2007. First you want to copy the URL of the YouTube video that you want to embed in your PowerPoint. Then, open PowerPoint 2007 and click the office button in the top left corner (circular button with office logo). Then click "PowerPoint options" and check "show developer tab in ribbon". Then click "OK". Click on the developer tab, and click on "more controls". Then scroll down to "Shockw...
How To: Place watermarks in Word documents
With watermarks, you can add a new layer of information to your Microsoft Office Word 2007 documents. This tutorial shows you how to add a watermark to whatever section of your document you want and position it on the page where you want it. It demonstrates how to use graphics and text to create a custom watermark, such as your company logo.
How To: Rank values based on a single 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 707th installment in their series of digital spreadsheet magic tricks, you'll learn how to rank values based on one criteria using the SUMPRODUCT function.
How To: Extract only numbers from a text string array forumla
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 489th installment in their series of digital spreadsheet magic tricks, you'll learn how to extract only the numbers from a text string. This is accomplished with recourse to Excel's LEN, INDIRECT, ROW, MID, ISNUMBER, INDEX, LARGE, SUMPRODUCT, and SUM functions.
How To: Create a formula to count cells in Microsoft Excel 2011
Want to create a formula to count cells in Excel 2011? This video will show you how it's done. Whether you're new to Microsoft's popular digital spreadsheet application, new to Excel 2011 or even an expert merely looking to brush up on the fundamentals, you're sure to be well served by this quality video tutorial from the folks at Lynda. For all of the details, and to get started counting cells by formula in your own MS Excel '11 projects, watch the video.
How To: Format tables in MS Word 2007
In this video the instructor shows how to format tables in Microsoft Word 2007. To know how to format tables in Word, you will first have to know how to create them. This video assumes that you already know how to create tables. When you click inside a table in Word, a new tab label, Table Tools, appears above the Design tab in the tool bar. In the Design tab there are a lot of options available that can change the look of your table with just a click. To the extreme left there are three chec...
How To: Use the APR function to make loan payment calculations 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 12th installment in his "Excel Finance Class" series of free video lessons, you'll learn how to calculate average and marginal tax rates with Excel.
How To: Transpose columns to rows & rows to columns in Excel
Looking for a primer on how to create and work with arrays 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 2nd installment in his series of Excel array formula series, you'll learn how to use the array TRANSPOSE function to transpose a table, switching rows and columns to columns and rows.
How To: Create a drop down box in Excel
Learn how in this video to create a drop down box in a Microsoft Excel cell.
How To: Convert .docx format files to .doc in Microsoft Office
In this how-to video, you will learn how to convert a file from .docx to .doc. First, go to the Microsoft Office website and install the Open XML Converter program. Open the program. Navigate to the file you want to convert. Drag the file into the program. The program will convert the file to a .rtf file. Microsoft Word will open the document. The file will be saved in the same folder as the original document. You will be able to use files created in the latest version of Office in older vers...
How To: Use the AVERAGE IF function 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 145.75th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the AVERAGEIF (AVERAGE IF) function to create a formula that will calculate the average when you have more than 1 criterion.
How To: Use the FREQUENCY function in Microsoft Excel
Looking for a primer on how to create and work with array formulas 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 array formula series, you'll learn how to use the array FREQUNCY function correctly.