Microsoft Search Results

How To: Conditionally format an Excel column-row intersection

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 296th installment in their series of digital spreadsheet magic tricks, you'll learn how to add conditional formatting to a row, a column and the intersection of the two with three different colors.

How To: Retrieve the name of a lowest-bidding vendor 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 283rd installment in their series of digital spreadsheet magic tricks, you'll learn how to use the INDEX, MATCH and MIN functions to retrieve vendors name when they have made the low bid.

How To: Autohighlight the highest value in a row 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 268th installment in their series of digital spreadsheet magic tricks, you'll learn how to apply a conditional format that will highlight the maximum value in a row using a true/false formula.

How To: Find & count the longest or shortest word 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 196th installment in their series of digital spreadsheet magic tricks, you'll learn how to find and count the longest and shortest words/strings with the MAX, MIN and LEN functions in an array formula.

How To: Analyze a CM statement with a data table 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 254th installment in their series of digital spreadsheet magic tricks, you'll learn how to do contribution margin income statement analysis across various units using a one-variable data table.

How To: Create a sudoku puzzle in Excel with array 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 MS Excel tutorial from ExcelIsFun, the 242nd installment in their series of digital spreadsheet magic tricks, you'll learn how to create a sudoku puzzle using array formulas, the INDEX function with criteria and data validation.

How To: Create a checkbook-balancing 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 233rd installment in their series of digital spreadsheet magic tricks, you'll learn how to create an efficient checkbook balance formula and see when to use the ROUND function on a sales invoice.

How To: Do a two-variable lookup given duplicates 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 225th installment in their series of digital spreadsheet magic tricks, you'll learn how to do a two-variable lookup when there are duplicates using the INDEX, IF, ROW and MAX functions.

How To: Take a picture of your computer screen

Want to take a picture of your Microsoft Windows PC's screen using the computer itself? It's easy! So easy, in fact, that this guide can present a complete and thorough overview of the process in under a minute's time. For more information, and to get started taking your own digital screen shots, watch this free video tutorial.

How To: Embed a YouTube video in PowerPoint presentation

Ever wish you could embed a YouTube video into a Microsoft Office PowerPoint 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 PowerPoint presentation, watch this helpful video tutorial.

How To: Randomly select an employee name from an Excel sheet

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 169th installment in their series of digital spreadsheet magic tricks, you'll learn how to randomly select an employee from a list using the INDEX and RAND and INT functions (also RANDBETWEEN).

How To: Create a personal budget based on past data 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 154th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a personal budget based on past data via the SUM function, cell references, subtraction and the VLOOKUP function.

How To: Apply conditional formatting to a calendar 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 98th installment in their series of digital spreadsheet magic tricks, you'll learn how to use a TRUE/FALSE formula and the TODAY function to format a calendar within a two-week period.

How To: Use tab control in Silverlight

In this video, Tim Heuer introduces the new Tab Control that is included in Silverlight. This is a new control that has been introduced in Silverlight. This is a step by step, extensive tutorial on exactly what you'll need to know when using Microsoft's Silverlight. This is a detailed, easy to follow video, to help you use the program, and all it entails.

How To: Customize the checkmark in a Silverlight checkbox

Steve White demonstrates how to edit the default template of a CheckBox control and use text instead of graphics to represent the Unchecked/Checked/Indeterminate states. This demonstration uses the Expression Blend 2.5 Preview. This is a step by step, extensive tutorial on exactly what you'll need to know when using Microsoft's Silverlight. This is a detailed, easy to follow video, to help you use the program, and all it entails.

How To: Create dynamic user controls

In this video Jesse Liberty demonstrates how to create user controls dynamically (at run time) and how these user controls can raise events to interact with the page that creates them. This is a step by step, extensive tutorial on exactly what you'll need to know when using Microsoft's Silverlight. This is a detailed, easy to follow video, to help you use the program, and all it entails.

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: 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: Turn JavaScript on in Internet Explorer

In this video, you will learn the steps to take to enable JavaScript in Microsoft's Internet Explorer (IE) web browser. Although JavaScript support is typically enabled by default in most modern browsers and many web applications depend on JavaScript being enabled to function properly, some persons and organizations may occasionally disable JavaScript to negate the effects of annoying or insecure implementation of JavaScripts on some web pages (such as pop-ups, hidden tracking links, unwanted...

How To: Develop a business workflow in Acrobat 9 Pro

In this Adobe Acrobat 9 Pro tutorial you will learn how to develop a business workflow. Learn how to work with Microsoft Office products like Excel, PowerPoint, CAD drawings and more to create PDF versions of your Office documents, or create entire portfolios to give to clients right in Acrobat 9. Learn how to send files for review, add comments and interactive elements, and enhance PowerPoint presentations in this Acrobat 9 Pro tutorial.