Microsoft Office Features
How To: Check to see if a string contains a value 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 530th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the OR, SEARCH and ISNUMBER functions to see if the descriptions in a data set contain a given value (in this case, "Repair" or "Rework").
How To: Create quick formulas with Excel names in MS 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 4th installment in his series of Excel name tricks, you'll learn to use short Excel names to expedite the formula creation process. For detailed instructions, watch this free video Excel lesson.
How To: Create a preview button in Microsoft Outlook Express
This video tutorial, designed for users of the Windows XP and Vista operating systems, offers instructions for creating a preview button in Microsoft Outlook Express or Windows Mail. For step-by-step instructions on disabling the automatic preview pane, watch this handy how-to.
How To: Use comparative operators in Microsoft Excel formulas
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 Excel tutorial from ExcelIsFun, the 572nd installment in their series of digital spreadsheet magic tricks, you'll learn about how to use conditional operators in your formulas.
How To: Use custom number formatting with zeroes 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 73rd installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to add custom number formatting in the format cells dialog box for 00001, 09745 and 989-85-1253. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.
How To: Use the borders tab when formatting cells 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 504th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the borders tab in the Format Cells dialog box to create a 3D effect.
How To: Split data in mulitple columns quickly in Excel
Don't fret if your boss has sent you a long Excel list of employees and asked you to separate the first and last names. In this video tutorial you will learn a neat trick to take a person's name in one column and separate the data into two columns, one for first name and another for last name. Learn the quick process without retyping or cut/paste! Split data in mulitple columns quickly in Excel.
How To: Extract items not having a given text value 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 and Mr. Excel, the 25th installment in their joint series of digital spreadsheet magic tricks, you'll learn how to extract records from databases that do NOT contain a given text value.
How To: Build confidence intervals given the sigma in MS 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 81st installment in his "Excel Statistics" series of free video lessons, you'll learn how to construct confidence intervals when the sigma (population standard deviation) is known. See how the CONFIDENCE and NO...
How To: Quickly create columns of words & numbers 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 390th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a column of words and numbers quickly with two different formulas as well a a mouse trick that will allow you to paste special values.
How To: Name a Microsoft Excel cell after its content
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 138th installment in their series of digital spreadsheet magic tricks, you'll learn how to name individual cells after their cell content (i.e., the name of the cell is in the cell).
How To: Use PowerPoint
In this video series, our expert Gary Zier will show you how to use the tools and navigate the menus in PowerPoint and will provide expert tips and advice for working with templates, objects, slides, images, charts and diagrams, and transitions. He will also show you how to print your slides and finalize CD presentations. Use PowerPoint - Part 1 of 19.
How To: Use the archive feature in MS Outlook
Is your Outlook inbox starting to seem overwhelming? No problem! In just a few minutes you can corral that growing pile of e-mail by using the 'archive' feature. Have a look at this video and learn how to use this handy option and clean up the mess in your inbox.
How To: Create Microsoft Word tables
Microsoft Word tables serve as an attractive way to organize information. See how to create and edit tables in Word.
How To: Use Excel stylistic & number formatting
Learn how to use Excel stylistic and number formatting by watching this video. You'll learn how to format a cell. These have different types of formats like general, time, date, etc. You'll also learn how to create a table. There are different types like names, values, time and time etc. Learn to create names like employee name and fill in the borders, and create thick lines. Watch this video for more information!
How To: Use MS Excel's Go-To tool to remove rows with blanks
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 87th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to quickly remove rows of a table where the row has a blank in column A.
How To: Use Microsoft Word shortcuts
Shortcuts can significantly increase your work speed and efficiency while typing. This video shows how to use important shortcuts in Microsoft Word, like italicizing and underlining text. Use Microsoft Word shortcuts.
How To: Extract characters without leading zeroes 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 331st installment in their series of digital spreadsheet magic tricks, you'll learn how to extract individual characters without extracting the leading zeroes through use of the MID, VALUE and COLUMNS functions.
How To: Format a column for text 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 177th installment in their series of digital spreadsheet magic tricks, you'll learn how to format a column as text numbers to avoid data validation trouble.
How To: Create tables in Word 2007
This video demonstrates how to create tables 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 create tables in Word 2007, For Dummies.
How To: Make PivotDiagrams in Visio 2007
A PivotDiagram is similar to an Excel PivotTable report: It arranges data in a visual way. Check out this tutorial and learn how to look at the same data from different angles to establish and analyze relationships that you might miss in a table or a worksheet.
How To: Use Excel databases for home improvement calculations
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 236th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a database for keeping carpentry measurements as well as how to use a COUNTIF function formula for calculating how many lumber pieces you'll need to cut for your home improvement project.
How To: Get started with MLA in Word
The video demonstrates how to get started with MLA (Modern Language Association documentation format) for an article. One of the first things that is important to understand is how to name your paper, and add a header format that will automatically paginate your paper so that you do not have to worry about it. The entries in your Works Cited need to be alphabetized and also need to be indented. Note that there is no extra space between the entries. You do not have to know how to manually form...
How To: Use conditional summing in Microsoft Excel
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 9th installment in his "Highline Excel Class" series of free video Excel lessons, you'll see three examples using the SUMIF function to do conditional summing.
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: Sort data in Excel
A major plus in using Microsoft Excel is its ability to sort large amounts of data. What's the use of Excel, if you don't know how to sort? In this short video clip, learn how to go about sort your data in the order needed.
How To: Verify an ID prefix 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 311th installment in their series of digital spreadsheet magic tricks, you'll learn three different methods for determing whether a Produt ID prefix matches a second specified prefix.
How To: Name ranges of data in Excel
Name ranges of data to make formulas a bit easier to read and write when working in Microsoft Excel.
How To: Start a new project in MS Project 2007
In this tutorial, we learn how to start a new project in MS Project 2007. First, open up MS Office Project 2007 and wait for it to launch. After this, click on file to start a new project that doesn't have anything on it yet. Enter in all of your information, then open up the project guide so you can see a list of resources in the software. Use the different tools to change the way your project looks, then use the format section to change the way it's laid out. Open up your information from a...
How To: Insert a sound into PowerPoint
Putting sound in Microsoft PowerPoint can be both practical and engaging. See how easy it is to add sound to PowerPoint.
How To: Pull the last item from an external column 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 176th installment in their series of digital spreadsheet magic tricks, you'll learn how to get the last number or word from a column on a different sheet.
How To: Create formulas with workbook references in MS 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 182nd installment in their series of digital spreadsheet magic tricks, you'll learn how to create formulas with workbook references. See how to make a formula that looks at a range of cells in another workbook.
How To: Use IS functions 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 101st installment in their series of digital spreadsheet magic tricks, you'll learn how to use IS functions (ISBLANK, ISERR, ISERROR, ISLOGICAL, ISNA, ISNONTEXT, ISNUMBER, ISREF &ISTEXT).
How To: Sum and average statistical data within 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 532nd installment in their series of digital spreadsheet magic tricks, you'll learn how to use the AVERAGE, STDEV, MAX, MIN and SUM function to add statistical data. Specifically, this video lesson discusses how to sum and average evidence in an age discrimination case.
How To: Use comparative operators with letters 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 386th installment in their series of digital spreadsheet magic tricks, you'll learn how to add conditional formatting for letters less than the letter M. Yes! Comparative operators like less than (<) work on letters!
Cozy How To: Microsoft Office Ribbon Interface & Work Space
PowerPoint Tutorials for Microsoft PowerPoint presentation software. In this introduction tutorial we will be using PowerPoint 2010 and will focus on the interface workspace by reviewing the ribbon, slide pane and slide tabs. The ribbon is designed much like a website navigation menu bar and has multiple categories to separate all of the tools into an organized bar. By default the Home tab is selected and will include most of the tools that are commonly used when editing and creating a PowerP...
How To: Work with array formulas 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 313th installment in their series of digital spreadsheet magic tricks, you'll learn how to get started using array formulas in your Excel projects.
How To: Enter task information in MS Project 2007
In this tutorial, we learn how to enter task information in MS Project 2007. Use the "gantt chart view" to have a task list next to the bar graph. Start typing in the information of the task, followed by the duration and other information you need. If you press enter, you will drop down to the next list. The task will then be given a number for each of the different tasks. Type in what the task names are, then continue to go down the list entering in all information. The duration can be as lo...
How To: Make multiple changes at once with Word 2007 themes
This video demonstrates how to make multiple changes at once with Word 2007 themes. 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 make multiple changes at once with Word 2007 themes , For Dummies.
How To: Validate data & look up values 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 5th installment in their series of digital spreadsheet magic tricks, you'll learn how to name a cell range, use data validation to add a drop-down list, and how to use the VLOOKUP function to look up values.