Microsoft Office: Page 18

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 344th installment in their series of digital spreadsheet magic tricks, you'll learn how to find the max value given more than one critereon (i.e., multiple criteria).

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 345th installment in their series of digital spreadsheet magic tricks, you'll learn how to locate the first positive number in a list and assign it the number 1.

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 347th installment in their series of digital spreadsheet magic tricks, you'll learn how to round to an increment when you do not have MROUND function.

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 12th installment in their series of digital spreadsheet magic tricks, you'll learn how to calculate the time between 2 dates like invoices past due. Learn how to calculate a loan due date or how many days you have been alive!

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 4th installment in their series of digital spreadsheet magic tricks, you'll learn how to add data or a formula to a range of cells by using the Excel's ever-useful ctrl+enter keyboard shortcut.

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 8th installment in their series of digital spreadsheet magic tricks, you'll learn how to take a column of text and break it apart into separate columns using Excel's text-to-column tool.

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 343rd installment in their series of digital spreadsheet magic tricks, you'll learn how to delete blanks rows en masse from a list within an Excel spreadsheet.

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.

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 332nd installment in their series of digital spreadsheet magic tricks, you'll learn how to insert text into a test string with the REPLACE function as well as how to insert a part of a product ID into a longer product ID.

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 333th installment in their series of digital spreadsheet magic tricks, you'll learn how to fix errors with the Excel 2007 IFERROR and the Excel 2003 IF & ISERROR functions.

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 267th installment in their series of digital spreadsheet magic tricks, you'll learn how to calculate percentage change using a simple universal formula: (End Value)/Beg Value)/Beg Value = Percentage Change.

In this Software video tutorial you will learn how to link tasks in Microsoft Project 2007. There are four ways to link a task. Finish to start is the default, then you have start to start, finish to finish and start to finish. Here you will see how to link up two tasks and what is the dependency between them. There are various methods of creating dependency between two tasks. One method is to select the two tasks and click on the ‘link tasks’ button on the tool bar or you can go to the...

This video shows us how to use the following functions in Excel: average, count, counta, min, max, and sum. First, start off by create a set of numbers to work with. After that, click on an empty cell that you want to use for the functions. To do an average, click on the functions button on the top right corner of the menu bar, you'll see a list of all the functions that are available. Select average, and then highlight all the numbers that you want to find the average of. Repeat the exact same...

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 2nd installment in their series of digital spreadsheet magic tricks, you'll learn how to create charts via keyboard shortcut as well as how to create dynamic charts with cell references.

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 22nd installment in their series of digital spreadsheet magic tricks, you'll learn how to use the NORMDIST function to calculate probabilities for a population with a normal (bell) distribution! You even get to see the four types of situations that you most commonly encounter -- plus visual pictures of each situation...

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!

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 18th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the ROW, CHAR and RANDBETWEEN functions to randomly generate letters. See also how to randomly create letter sequences.

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.

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.

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 327th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a Gantt Chart that will include highlight the workdays one color and weekends and holidays another color.

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 214th installment in their series of digital spreadsheet magic tricks, you'll learn how to deal with a circular reference warning in a formula.

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 324th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a dynamic list of dates for a data validation drop-down list.

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 326th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a hyperlink from one sheet to another in the same workbook.

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 320th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the SUMPRODUCT & SUMIF functions together to look up multiple items and add them in one cell.

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 317th installment in their series of digital spreadsheet magic tricks, you'll learn how to extract data (specifically, a substring from string) using the MID Function.

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 318th installment in their series of digital spreadsheet magic tricks, you'll learn how to extract data with the MID function and use VLOOKUP to retrieve a date.

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 322nd installment in their series of digital spreadsheet magic tricks, you'll learn how to create an advanced filter to extract with AND and NOT criteria.

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 323rd installment in their series of digital spreadsheet magic tricks, you'll learn how to run a partial text lookup query using a VLOOKUP function with wild card criteria.

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 314th installment in their series of digital spreadsheet magic tricks, you'll learn four different methods for converting TRUE and FALSE values to 1 and 0 (zeroes).

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.

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.

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 310th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the DSUM and DMAX with date criteria.

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 307th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the INDEX, ROWS, COLUMNS, LARGE, SMALL functions to create 4 different formulas that will invert a range of values.

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 316th installment in their series of digital spreadsheet magic tricks, you'll learn how to count & list unique values as well as how to concatenate a range of values with a separator.

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 304th installment in their series of digital spreadsheet magic tricks, you'll learn how to add a secondary axis to a chart so that you have axes on the left and right.

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 306th installment in their series of digital spreadsheet magic tricks, you'll learn how to use MCONCAT & LOOKUP functions to lookup values from a table and add results. Also see a formula that uses exponents instead of the MCONCAT concatenation function to look up and sum table values.

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.

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 297.5th installment in their series of digital spreadsheet magic tricks, you'll learn how to conditionally sum from various columns.

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 300th installment in their series of digital spreadsheet magic tricks, you'll learn how to use date and time functions together. Specifically, you'll see how to use the INT function to calculate total days worked and the TEXT function to calculate total hours worked.

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 300th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the YEAR, DATE and TEXT functions and the ampersand (concatenation) to create a date label that adds leading zeros appropriately.