Centro Digital Search Results

How To: Count words separated by commas 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 289th installment in their series of digital spreadsheet magic tricks, you'll learn how to count words separated by commas using the LEN & SUBSTITUTE functions in a formula.

How To: Count unique & duplicate records 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 272nd installment in their series of digital spreadsheet magic tricks, you'll learn how to count unique records and duplicate records using the SUMPRODUCT, COUNTIF, COUNT, COUNTA, IF and SUM functions.

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: Create a weighted gradebook 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 197th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the SUM and VLOOKUP functions to create a grade book based on a specified total score with weights assigned to different categories.

How To: Count data without an upper limit 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 198th installment in their series of digital spreadsheet magic tricks, you'll learn three different methods for counting quantitative data in categories that include a lower limit but not an upper limit.

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: Crop images in Adobe Photoshop for printing

Ready to bring your digital photographs into the world of tangible objects? Before you do, you'll need to understand a thing or two about aspect ratios and image cropping within Adobe Photoshop. Fortunately, this guide will tell you everything you need to know. For a complete overview, and to get started cropping your own images for printing, watch this free video guide.

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: Convert YouTube videos onto a DVD, MP3, and more

This video will show you how to convert YouTube videos into files that can be shared on a DVD, CD, iPod, iPhone, or any other type of device you use to view digital media. This is an easy way to share your favorite videos with others and carry them with you. This process is pretty easy and doesn't take long to do. So, check it out and start taking your YouTube addiction with you wherever you go!

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: Use VLOOKUP with TRIM 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 155th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the TRIM function to get rid of extra spaces when a VLOOKUP function should work but doesn't.

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: Use a MODE IF function 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 145.5th installment in their series of digital spreadsheet magic tricks, you'll learn how to a formula that will calculate the mode when you have more than 1 criterion.

How To: Use sheet cell references 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 MS Excel tutorial from ExcelIsFun, the 140th installment in their series of digital spreadsheet magic tricks, you'll learn how to save time in updating a system of data and information by using sheet cell references in formulas.

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: 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: Create a form from linked Access data 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 Excel tutorial from ExcelIsFun, the 574th installment in their series of digital spreadsheet magic tricks, you'll learn how to import data from Microsoft Access as well as how to use the VLOOKUP function to populate data into a printable form.

How To: Find the average time between orders in an Excel sheet

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 371st installment in their series of digital spreadsheet magic tricks, you'll learn how to calculate the average time between customer orders by adding a new column to a data set with an IF function formula.

How To: Install the D Focus DSLR Mount on a Canon 5D

When you're first working with a digital single-lens reflex camera, there's a lot to learn. Setting up a D|Focus DSLR mount can look particularly complicated, but in this tutorial you'll learn all the steps. Now you're ready to start taking shots like a pro. (Note that this tutorial is not for absolute beginners. You'll need to have some familiarity with these camera before you begin.)