Microsoft Office Features
How To: Find the absolute value max of a set of integers 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 718th installment in their series of digital spreadsheet magic tricks, you'll learn how to find the Absolute Value Max of a set of integers (positive, zero and negative) using the MAX and ABS functions.
How To: Retrieve cell references with INDEX & MATCH 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 341st installment in their series of digital spreadsheet magic tricks, you'll learn how to use the INDEX and MATCH functions together to retrieve a cell reference that the OFFSET function can use for its reference argument.
How To: Do look-up addition with VLOOKUP & HLOOKUP 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 684th installment in their series of digital spreadsheet magic tricks, you'll learn how to do single-condition lookup adding for both the VLOOKUP and HLOOKUP functions. You'll also learn how to use an array constant in the row/column num argument for the HLOOKUP and VLOOKUP functions.
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: Average times entered as text 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 682nd installment in their series of digital spreadsheet magic tricks, you'll learn how to to average times values that were exported from a database as text values instead of number values.
How To: Enter Excel data into cells with drop down menus
In this video tutorial, viewers learn how to create drop down menus in Microsoft Excel. This task is very easy, fast and easy to do. Begin by highlighting a desired cell. Then click on the Data tab and click on Data Validation under Data Tools. When the Data Validates window opens, click on the Error tab and deselect "Show error alert after invalid data is entered". Then click on OK. Now simply type in the data into the selected cell. This video will benefit those viewers who use Microsoft Ex...
How To: Set up costs in MS Project 2007
In this tutorial, we learn how to set up costs in MS Project 2007. First, go to your resource sheet and enter in the cost option in the type column. Write in how much you paid for this, because it's not a regular cost. Assign this cost to a task to specify the cost per task. At the end of the project, you will be able to see how much you spent on airfare. Enter in all the different costs you paid and then the amount for each one. When you are finished, you will be able to see how much you spe...
How To: Prevent duplicate entries in an Excel spreadsheet
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 41st installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use a true/false formula with the COUNTIF function to prevent duplicate entries in a list. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.
How To: Create a dynamic data validation list 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.
How To: Use My Day in Microsoft Entourage: Mac 2008
There's a lot of great features in Entourage 2008 for Mac, and one of the new features in "My Day". It's a small integrated app that helps you stay organized and helps you manage all of your upcoming events and tasks. The Microsoft Office for Mac team shows you just how to manage tasks and events by using My Day in this how-to video.
How To: Record narration for a PowerPoint presentation
Need to record narration for a PowerPoint presentation. Watch this video to learn how. Adding narration to PowerPoint presentations is easier than it sounds. You can record your voice to narrate your slide show and then link to or embed the sound file to your presentation. This video shows you the steps. Record narration for a PowerPoint presentation.
How To: Calculate probabilities with Excel's BINOMDIST feature
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 21st installment in their series of digital spreadsheet magic tricks, you'll learn how to use the BINOMDIST function to calculate probabilities for a binomial experiment - binomial distribution!
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: Calculate the present value of annuity 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 function to calculate the present value of an annuity.
How To: Use data forms in Microsoft Excel 2003 or 2007
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 97th installment in their series of digital spreadsheet magic tricks, you'll learn how to use a data form in both Excel 2003 and 2007 as well as how to add a button to Excel's Quick Access toolbar.
How To: Sum only certain items in Microsoft Excel with SUMIF
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 13th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the SUMIF and COUNTIF functions to add and count given certain conditions.
How To: Create a simple table in Microsoft Access
The Microsoft Office Access 2007 relational database manager enables information workers to quickly track and report information with ease thanks to its interactive design capabilities that do not require deep database knowledge. In this Microsoft Access video tutorial, you'll learn about basic table setup in MS Access. Several different fields used and lookup wizard used are used in this tutorial. For more information, and to get started creating your own tables in Access, watch this how-to.
How To: Add a scenario button to a ribbon or toolbar 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 680th installment in their series of digital spreadsheet magic tricks, you'll learn how to add a scenario button to a tToolbar or Ribbon in Excel 2010.
How To: Use COUNTIF in Microsoft Excel
Microsoft Office Excel 2007 spreadsheet manager is a powerful tool that enables information workers to format spreadsheets, as well as analyze and share information to make more informed decisions. In this MS Excel video tutorial, you'll learn about Using COUNTIF function to count the number of As, Bs and Cs. For more on using the Microsoft Excel COUNTIF fucntion, watch this how-to.
How To: Use the Left, Mid, and find function in Excel 2007
This video demonstrates uses of the left, mid, and find function in Excel 2007 to pull out specific pieces of text from a longer text string.
How To: Embed a YouTube video into PowerPoint 2003
First thing you want to do is to find a video that you want to embed in a PowerPoint file (it might be PowerPoint 2007 also). After that you might see the video and decide of the final quality of it (dependent on your internet speed ). In the right side of the video you will see a URL link to it, copy that to your PowerPoint to have it ready for next step. On your PowerPoint file enable the Control Toolbox and follow the instruction .Be sure that you modified properly the web address . Voila,...
How To: Embed a YouTube video into MS Powerpoint 07
Chris Davis with the Educational Technology Center shows us a few easy steps to putting YouTube videos in our Microsoft PowerPoint 2007 presentations. To start you'll need to have an active internet connection and you should have the developer tab in PowerPoint active. To do this go to the Office menu, PowerPoint options, popular and click show developer tab. Locate the hammer looking more control option button and scroll down to Shockwave Flash Object and click it. This allows you to draw a ...
How To: Write a macro by hand in Excel for beginners
The speaker in this video introduces the concept of macros used in Excel, very simply and lucidly. Two sets of shortcut keys are used, one set to create the macro and the other set to run it. The first shortcut opens up the VBA window (Alt+F11), with a workbook along with the 3 default sheets. This video puts the macro in a module. The procedure starts with typing sub and a name which can be easily recalled. The rules for naming the macro are also covered briefly. After the macro code is writ...
How To: Count the number of days between dates 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 102nd installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to count the number of days between two dates using an array formula.
How To: Run a two-way lookup on a table array 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 very first installment in their joint series of digital spreadsheet magic tricks, you'll learn how to do a two-way lookup on a table array.
How To: Validate data with dynamic VLOOKUP functions 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 675th installment in their series of digital spreadsheet magic tricks, you'll learn how to do data validation using a custom logical formula with 2 VLOOKUP functions that will change when different products are entered. For example, if shirt product is entered, the data validation will let only values between $50 and...
How To: Add Calculating Expression in MS Word 2007
Step 1: Calculating Expression in MS Word Step 2:
How To: Embed YouTube videos in PowerPoint 2003
This video uses screenshots to show you step-by-step how to add a YouTube video to your Microsoft Office 2003 Powerpoint presentation. It's a great way to help support an argument that you may be trying to make and keeps people's attention. It's easy to do and will help you in whatever you may be doing. Enjoy!
How To: Store lookup tables in memory in Microsoft Excel
Looking for a primer on how to create and work with names 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 10th installment in his series of Excel name tricks, you'll learn how to store lookup tables in memory using a named array.
How To: Randomly generate whole numbers 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 17th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the RANDBETWEEN function to randomly generate whole numbers as well as how to randomly assign numbers to employees.
How To: Use Microsoft Excel 2007 for statistics
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 very first installment in his "Excel Statistics" series of free video lessons, you'll learn how to get started doing statistical analysis in Microsoft Excel 2007.
How To: Pull an Excel cell value from the first non-blank row
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 365th installment in their series of digital spreadsheet magic tricks, you'll learn how to use an amazing non-array formula to return the cell content from the first non-blank cell in a specified row.
How To: Chart assumed constant growth rate changes 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 64th installment in his "Excel Finance Class" series of free video lessons, you'll learn how to chart assumed constant growth rate changes in Excel.
How To: Automatically create a table of contents in Word 2007
Putting together a table of contents is as easy as 1, 2, 3, especially when you use built-in heading levels as you begin writing your first draft. Then let Microsoft Office Word create the TOC with your headings. Watch the demo to see how to insert a table of contents and make revisions that Word will update automatically.
How To: Create random dates within a set range 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 26th installment in their joint series of digital spreadsheet magic tricks, you'll learn how to create random dates between upper and lower dates using the 4 different formulas that use functions such as RANDBETWEEN, RAND, INT and DATE.
How To: Solve simple fraction word problems in Microsoft Excel
Having trouble solving fraction word problems? Give this video tutorial from YouTube Excel guru, ExcelIsFun, your undivided attention. With it, you'll learn how to format fractions as decimals with up to 15 places, come to understand divisibility rules for numbers 1-9, and work with a number of real-world examples.
How To: Ignore nested subtotals with AGGREGATE 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 664th installment in their series of digital spreadsheet magic tricks, you'll learn how to make a calculation on a column of values that contain subtotals that you do not want to include in the calculations. The AGGREGATE function will ignore nested SUBTOTAL and AGGREGATE functions when making calculations.
How To: Count blanks in an dynamic range 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 532nd installment in their series of digital spreadsheet magic tricks, you'll learn how to count blanks in a dynamic range using the COUNTIF, INDEX, MATCH, COUNTA and OFFSET functions. Learn about the difference between an empty cell and a blank. Also see how to create dynamic ranges with INDEX and OFFSET (Index:Index).
How To: Use the Ribbon and Backstage view in MS Outlook 2010
After you launch Outlook 2010 in your computer, you will see the Ribbon strip immediately in the main window. The button for writing a new e-mail is separated from a button for creating new items in the calendar, contact list or task manager. An independent Quick Steps section offers functions allowing you to move a message into different folders, to save it into a calendar as a meeting reminder, to quickly forward it to a chosen person or to more people and to forward it with a FYI note. If ...
How To: Add custom animation in PowerPoint 2007
This screencast from E.A. Vander Veer, author of PowerPoint 2007: The Missing Manual, guides you through adding custom animation to an object in your PowerPoint 2007 presentation.