Microsoft Office Features
How To: Look up and return two values to one cell 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 702nd installment in their series of digital spreadsheet magic tricks, you'll learn how to look up two values at once and return then both to one cell using 2 VLOOKUP functions and concatenation (Ampersand &) or two cells using a single VLOOKUP and the COLUMNS function.
How To: Record and use macros in Microsoft Excel 2007
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 52nd installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to record and use macros in Microsoft Excel 2007.
How To: Select a random name in Excel
Not sure about all the functions and abilities of Microsoft Excel? Luckily there are free video tutorials out in the world... or better said, the World Wide Web, to help you. In this video, learn how to use the RAND function and sort in Excel to select a random name from a list.
How To: Use the sum and autosum functions in Microsoft Excel
Learn how to use the sum and autosum functions in Microsoft Excel and you'll appreciate the efficiency of spreadsheets for dealing with data lists. You'll never use a calculator again!
How To: Use the CUMIPMT function for interest in MS 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 18th installment in his "Excel Finance Trick" series of free video lessons, you'll learn how to use the CUMIPMT function to calculate the cumulative interest on a loan for a 1 year period.
How To: Use the copy & paste tools in Microsoft 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 2nd installment in his series of Excel 2010 video tutorials, you'll learn how to use Excel 2010's new copy and paste options.
How To: Avoid errors with the COUNTIF function when using workbook reference 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 723rd installment in their series of digital spreadsheet magic tricks, you'll learn how to avoid errors with the COUNTIF function when using workbook references by using the SUMPRODUCT function.
How To: Use the Backstage view in Microsoft PowerPoint 2010
Learn how to use the new Backstage view feature in Microsoft PowerPoint 2010 to better manage your slideshows. 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 creating and using the Backstage view in your own PowerPoint projects, watch this free video guide.
How To: Convert text to table in Word 2007
This video demonstrates how to convert text to table 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 convert text to table in Word 2007, For Dummies.
How To: Count instances of a character in a string 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 223rd installment in their series of digital spreadsheet magic tricks, you'll learn how to count individual letters in a word. See how to count the occurrence of a given character in a text string.
How To: Use formulas, functions, formula inputs and cell references in Microsoft Excel
This tutorial aimed at someone new to Microsoft Excel shows you how to navigate the basic functions of a spreadsheet. It goes over formulas, functions, formula inputs and cell references, all of which you'll need to master in order to use Excel effectively.
How To: Create action plans & marketing campaigns in Outlook
Pinpointtools.com has created some great add-ins for Outlook and Business Contact Manager that allow you to create Action Plans for Business Projects, and to create Marketing Campaigns for your contacts.
How To: Customize Quick Access Toolbar and Delete Mini Toolbar in MS Word 2007
This video will show you how to customize quick access toolbar and delete mini toolbar in MS Word 2007. These 2 things are very useful. Watch the video and follow all the steps to employ it yourself.
How To: Use exact & approximate matching with VLOOKUP in 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
How To: Do a reverse two way look up 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 Microsoft Excel's Goal Seek tool to modify inputs
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 103rd installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use Goal Seek to change a formula input number so that the formula is a desired result. Also learn how to use the PMT function.
How To: Use new features in Microsoft Word: Mac 2008
Word 2008 for Mac is jam-packed with tons of cool and useful features and tools that you can use to make a great looking document. Starting with the pre-made templates is the best way to go, and from there, customize it the best you can, anyway you can. The Microsoft Office for Mac team shows you all the great features in this how-to video.
How To: Insert a movie into a PowerPoint 2007 presentation
In order to insert a movie into a PowerPoint 2007 presentation, you will need to create a placeholder for the insert, in your presentation. Click on the media center. A window will pop up, which will allow you to open your movie. If you have already have your presentation, but you haven't left a placeholder, you can add your movie by going to the point where you want to add the movie, in your presentation. Then, click Insert. Go to Media Clips group. Choose an option from the drop down menu t...
How To: Find an increase in value with an Excel rating scale
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 36th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use the VLOOKUP function to determine an increase in salary based on a rating scale.
How To: Find the percentage of total from a DB set in Excel
New to Excel? Looking for a tip? How about a tip so mind-blowingly advanced as to qualify as a magic trick? You're in luck. In this Excel tutorial from ExcelIsFun, the 480th installment in their series of digital spreadsheet magic tricks, you'll learn how to calculate a percentage of total from a database data set when the variable of interest is text (word). This is accomplished with recourse to the COUNTIF, SUM & COUNTA functions.
How To: Calculate the present value of an annuity for asset valuation 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 34th installment in his "Excel Finance Class" series of free video lessons, you'll learn how to calculate the present value of annuity in Excel.
How To: Use color categories to manage email in Outlook
This tutorial shows you how to use the color categories feature in Outlook 2007 to manage email.
How To: Follow naming conventions and best practices when using queries in Access 2007
In this clip, you'll learn how to observe naming conventions when using queries in 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, including step-by-step instructions, watch this free video guide.
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: Do bankers' and arithmetical rounding ways 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 521st installment in their series of digital spreadsheet magic tricks, you'll learn how to round numbers two different ways.
How To: Hide columns and select only visible cells in MS Excel
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 34th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to hide columns, select visible cells only, and then copy and paste just those visible cells (all with and without the use of formulas). Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.
How To: Sum every nth value in Excel with 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 466th installment in their series of digital spreadsheet magic tricks, you'll learn how to SUM every nth value using SUMPRODUCT, MOD and ROW functions.
How To: Use Excel's built-in SUM, MOD, LCM & PRODUCT functions
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 5th installment in his "Excel Business Math" series of free video lessons, you'll learn how to use Excel's built-in SUM, AVERAGE, PRODUCT, LCM, QUOTIENT and MOD functions.
How To: Record a macro in Excel 2007
This video demonstrates how to record a macro 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 record a macro in Excel 2007, For Dummies.
How To: Change the colour scheme in Word 2007
In this video, we learn how to change the color scheme in Word 2007. First, click on the Word orb in the upper left hand corner. After this, go to the options menu to change your settings. On the new window that pops up, you will see an option to change the color from blue to silver or black. Choose which color you want to have as your background on this software, then click on "ok". Now your color scheme will be changed to not reflect the blue that you usually see when you star this program ...
How To: Use the COUNTIF function in Microsoft 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 180th installment in their series of digital spreadsheet magic tricks, you'll learn how to count specific words, specific numbers, numbers greater than a hurdle, numbers between two values, values that are NOT equal to an amount, words that end in es, all words, all numbers, all content, all blanks, all things which aren't words ...
How To: Create a new notebook within Microsoft OneNote 2010
Need some help figuring out how to make a new notebook within OneNote? This guide will show you how it's done. 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 creating notebooks yourself, watch this free video guide.
How To: Use the bibliography feature in MS Word 2007
In order to use the bibliography feature in Microsoft Word 2007, you will need to begin by opening your document in Word. Find the place where you would like to add a reference. Place your cursor in that spot. Then, go to the tool bar. Click on "Insert Citation". Click on "Add New Source". When the pop-up opens, enter the information about the periodical or book that you are citing. Fill it in completely. Make sure you choose the type of material you are referencing in the top drop down menu....
How To: Enter data into nonadjacent cells in Microsoft Excel 2010
Looking for a guide on how to enter data into nonadjacent cells in MS Excel 2010? This clip will show you how it's done. Whether you're new to Microsoft's popular digital spreadsheet application or a seasoned professional looking to become better acquainted with the features and functions of Excel 2010, you're sure to benefit from this free video software lesson. Take a look.
How To: Build an amortization table for a consumer loan with Excel's PMT function
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 4nd installment in his "Excel Finance Class" series of free video lessons, you'll learn how to build an amortization table for a consumer loan in Excel with the PMT function.
How To: Extract dates and times from a database field 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 312th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the DATE, MID, LEFT and TIME functions to extract dates and times from a database field that stores dates and times as a text string.
How To: Find confidence intervals with a sigma value 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 80th installment in his "Excel Statistics" series of free video lessons, you'll learn how to construct confidence intervals when the sigma is known known using the CONFIDENCE and NORMSINV functions.
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: Run two-way lookups in Excel with VLOOKUP & MATCH
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 136th installment in their series of digital spreadsheet magic tricks, you'll learn how to do two-way lookups with the VLOOKUP & MATCH functions.
How To: Organize your life in Microsoft Access
Brand new to Microsoft Office Access? This seven-minute free video lessson, which presents a general orientation to using the popular database program, will see that that you're well versed in all of the fundamentals. Learn how to create databases and forms, how to run queries and more. For the specifics, watch this free MS Access video tutorial.