Neighborhood Office Search Results

How To: Apply conditional formatting to a row 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 80th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to highlight an entire record (row) in a database that matches a bounced email addresss. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.

How To: Embed a YouTube movie into PowerPoint 2007

Ever wish you could embed a YouTube video into a Microsoft Office PowerPoint 2007 presentation? If you have a live Internet connection when designing your presentation, and will have one when showing it, you can. And it's an easy process to boot. For complete instructions on how to put a YouTube clip into a presentation in PowerPoint 2007, watch this helpful video tutorial.

How To: Extend the length of a class paper

Watch this video to learn a simple cheat that will make your paper longer. Good trick to know when you are in a crunch and need to stretch your class paper. You will need to use your existing term paper and either Microsoft Word or Open Office to use the Find&Replace command. Here's some forums you can post anonymously with other like-minded, less scrupulous people: http://academicdishonesty.net

How To: Set up signatures for multiple Outlook accounts

Microsoft Outlook 2007 Tip - Setup Signatures for Multiple Email Accounts - One of the difficulties with using multiple mail accounts is making sure your messages have the correct signature, or sig, attached to them. The new Signatures feature in Microsoft® Office Outlook® 2007 takes the hassle out of creating and applying signatures to your email.

How To: Transfer a call in Telephone English

Check out this instructional language video to learn how to transfer an English business call. "Telephone Talk" is a series of four short videos that deal with common English telephone situations at Fujikin. This is the first video in the series, and will show you how to transfer a call from an English speaker to someone in your office.

How To: Use Boolean math formulas in Microsoft Office 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 651st installment in their series of digital spreadsheet magic tricks, you'll learn see how to replace your IF function with a shorter Boolean Math formula! TRUE = 1, FALSE = 0, TRUE*2000 = 2000 and FASLE*2000 = 0.

How To: Disable quick fill handle & drag-drop Excel features

In this video tutorial, viewers learn how to disable the quick fill handle and drag and drop option in Microsoft Excel. This task is very easy, simple and fast to do. Begin by clicking on the Office button and click on Excel Options at the bottom. Then click on the Advanced tab and deselect "Enable fill handle and cell drag and drop" option under Editing Options. Finish by clicking on OK. This video will benefit those viewers who use Microsoft Excel for their work, and would like to learn how...

How To: Print an Excel worksheet or workbook with gridlines

In this video tutorial, viewers learn how to print the gridlines with a Microsoft Excel spreadsheet. This task is very fast, easy and simple to do. By default, Microsoft Excel will not print a spreadsheet with the gridlines. Begin by clicking on the Page Layout tab. In the Sheet Options box, under gridlines, check Print. To remove the gridlines, do the reverse of this operation. To view the page with gridlines, click on the Office button, go to Print and select Print Preview. This video will ...

How To: Create tables in MS Word 2007

In this video tutorial, viewers learn how to create tables in Microsoft Word 2007. Begin by clicking on the Insert tab and select Table. Then users are able to create a table by dragging the mouse across the squares to determine he amount of columns and rows. Make the final selection by simply clicking. Another option is to click on Tables and select Insert Table. Then users are able to input the number of columns or rows. This video will benefit those viewers who use Microsoft Office 2007, a...

How To: Do multiple regression with MS Excel's LINEST function

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 13th installment in his series of Excel array formula series, you'll learn how to do multiple regression and linear algebra problems with Excel's LINEST array function. Also see how to use the SLOPE, INTERCEPT and the FORECAST functions for linear algebra and how to create a s...

How To: Create an array constant from cell values in MS 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 10th installment in his series of Excel array formula series, you'll learn how to create an array constant from values in cells. This is a great trick that can save tons of time when you want your array stored in memory.

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: Extract records with an advanced filter in Excel

Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 95th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use the OR, AND, NOT, & COUNTIF functions and Excel's advanced filter tool to extract records from a table of data. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.

How To: Retrieve data from many tables on many sheets in Excel

Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 77th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to do a complicated payroll formula when tax data must be retrieved from multiple tables. See how to use the INDEX, INDIRECT AND MATCH functions in one big formula to retrieve tax data from multiple tables on multiple sheets. Learn to love digital spreadshe...

How To: Calculate variable commission totals in MS Exce

Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 46th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use the DOLLAR, VLOOKUP, INDEX and MATCH functions and a previous bracket commission formula trick to calculate total commissions when you have variable commissions paid out. Learn to love digital spreadsheets more perfectly with the tricks outlined in t...

How To: Extract the top 5 values from a given list 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 40th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use the filter and advanced filter tools to extract the top 5 values from a list. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.

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: Throw a cheap block party for the neighborhood

Throwing a block party is a great way to meet your neighbours! Block parties are perfect for hot summer nights when no one wants to be stuck indoors. These parties are fun and easy to throw, even on a budget. Check out this video for information on how to throw a rockin' party for your neighborhood without spending much money.

How To: Prevent Cats from Peeing Outside Your House

A lot of people have problems with their cats urinating inside the house, leaving behind the retched odor of cat pee. Others get frustrated when feral or stray cats pee on their porch, patio, or anywhere else outside of their house, as it's not the most welcoming odor when guests arrive.

How To: Use table styles in Microsoft Word for Mac 2011

Want to know how to style tables in Microsoft Word for Mac 2011? It's easy and this video will show you how it's done. Whether you're new to Microsoft's popular word processing application, new to MS Word 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 using table styles in your own Office for Mac 2011 projects, watch the video.

How To: Reformat a document with Quick Style Sets in Microsoft Word for Mac 2011

With Quick Style Sets, it's easy to quickly reformat a Word 2011 document. This video will show you how it's done. Whether you're new to Microsoft's popular word processing application, new to MS Word 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 using Quick Style Sets in your own Office for Mac 2011 projects, watch the video.

How To: Create a document for the web in Microsoft Publisher 2010

In this video tutorial, we learn how to create documents for the web in Microsoft Office Publisher 2010. Whether you're new to Microsoft's popular desktop publishing application or are a seasoned pro merely looking to brush up on Publisher 2010, you're sure to be well served by this clip. For more information, and to get started employing the lessons imparted by this free video software tutorial in your own Publisher projects, take a look.

How To: Select and manipulate objects in Microsoft Publisher 2010

In this video tutorial, we learn how to select and manipulate objects when working in Microsoft Office Publisher 2010. Whether you're new to Microsoft's popular desktop publishing application or are a seasoned pro merely looking to brush up on Publisher 2010, you're sure to be well served by this clip. For more information, and to get started employing the lessons imparted by this free video software tutorial in your own Publisher projects, take a look.