Nested Excel if Function

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 Excel ...more

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 ...more

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 568th installment in their series of digital spreadsheet magic tricks, you'll learn how to use a SUMI ...more

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 670th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the ...more

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 672nd installment in their series of digital spreadsheet magic tricks, you'll learn how you can us ...more

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 656th installment in their series of digital spreadsheet magic tricks, you'll learn see how to use ...more

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 350th installment in their series of digital spreadsheet magic tricks, you'll learn how to use con ...more

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 671st installment in their series of digital spreadsheet magic tricks, you'll learn how to use the ...more

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 584th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the ...more

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 595th installment in their series of digital spreadsheet magic tricks, you'll learn how to resolve ...more

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 707th installment in their series of digital spreadsheet magic tricks, you'll learn how to rank va ...more

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 599th installment in their series of digital spreadsheet magic tricks, you'll learn how to ROUND o ...more

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 586th installment in their series of digital spreadsheet magic tricks, you'll learn how to enumera ...more

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 203rd installment in their series of digital spreadsheet magic tricks, you'll learn how to create ...more

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 139th installment in their series of digital spreadsheet magic tricks, you'll learn how to use a d ...more

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 678th installment in their series of digital spreadsheet magic tricks, you'll learn how to SUM onl ...more

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 Excel ...more

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 657th installment in their series of digital spreadsheet magic tricks, you'll learn see howto calc ...more

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 632nd installment in their series of digital spreadsheet magic tricks, you'll learn how to create ...more

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 593rd installment in their series of digital spreadsheet magic tricks, you'll learn how to add dat ...more

Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 103rd installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use Goal Seek to change a formula ...more

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 693rd installment in their series of digital spreadsheet magic tricks, you'll learn how to calcula ...more

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 631st installment in their series of digital spreadsheet magic tricks, you'll learn how to add con ...more

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 633rd installment in their series of digital spreadsheet magic tricks, you'll learn how to create ...more

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 351st installment in their series of digital spreadsheet magic tricks, you'll learn how to create ...more

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 30th installment in his "Highline Exce ...more

Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 92nd installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how the AVERAGE function sees zeroes and ...more

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 nth installment in his "Highline Excel ...more

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 234th installment in their series of digital spreadsheet magic tricks, you'll learn how to convert between degr ...more

In this installment of the Excel Basics Series you'll learn how to use formulas to calculate an annual interest rate, as well as breaking it down to a monthly rate and an effective annual rate. A general knowledge of Excel is helpful for navigating the menus in Excel, but if y ...more

Whether you're interested in learning Microsoft Excel from the bottom up or just looking to pick up a few tips and tricks, you're in the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the 11th installment in his "Highline Excel Cla ...more

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 31st installment in his "Highline Exce ...more

As you might guess, one of the domains in which Microsoft Excel really excels is finance math. Brush up on the stuff for your next or current job with this how-to. In this tutorial from everyone's favorite digital spreadsheet guru, YouTube's ExcelIsFun, the 43rd installment in ...more

As you might guess, one of the domains in which Microsoft Excel really excels is business math. Brush up on the stuff for your next or current job with this how-to. In this tutorial from everyone's favorite digital spreadsheet guru, YouTube's ExcelIsFun, the 9th installment in ...more

The video demonstrates the way of calculating the interest rates for payday loans using MS Excel. The person presenting the video has got his MS Excel sheet with all the formulas and data ready. He first starts with the nominal & effect & future value tab. He gives us an examp ...more

This video is a tutorial on using the Conditional Formatting function of Excel to automatically color alternating rows, which helps your eye to follow across the row. This can be done manually with the “Fill Color” button, but if you add or delete rows after applying the s ...more

In this Excel magic trick video the tutor shows how to change operator in a formula from a drop down using Choose function. He shows a basic work book which can be downloaded from the internet for hands-on to the tutorial. In this trick the tutor shows how to include some oper ...more

In this video we learn how to use the AutoCorrect function found in Microsoft Excel 2007. This video is the second part of the Microsoft Excel 2007 tips series. The video shows on screen and the host explains how to find the AutoCorrect function and gives an address to downloa ...more

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.

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 536th installment in their series of digital spreadsheet magic tricks, you'll learn how to list al ...more

So you need to find the p-value for your hypothesis test. To do so, employ the spreadsheet program Microsoft Excel. Using a simple formula, you can easily determine the p-value for your tests and thereby conclude strong or weak support of the null hypothesis. Probability valu ...more

hether 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 35th installment in his "Highline Excel ...more

return a descending sorted list of country names based on the values in a row using an array formula that itself makes use of Excel's INDEX, MATCH, RANK, COLUMN and COLUMNS functions. Using an array formula, return a descending sorted list of country names based on the values ...more

Microsoft Office Excel 2007 spreadsheet manager is a powerful tool that enables information workers to format spreadsheets, as well as analyze and share information to make more informed decisions. In this MS Excel video tutorial, you'll learn about Using COUNTIF function to c ...more

Today we are going to learn how to sort data in a Microsoft Excel 2003 spread sheet. We will go over single column and multiple column sorting. In a single column sort you may high light the data or just click on any cell in the column. Once the data is selected look for the s ...more

New to Excel? Just looking for a few new tips and tricks? Whatever the case, you're sure to enjoy this free video software tutorial, which will walk you through how to sesarch table arrays within Microsoft Excel 2007. Learn how to dynamically search table arrays in Microsoft E ...more

Are you looking for a way to make your Microsoft Excel formulas simpler, faster and more efficient? If so, you're in the right place. With this free video lesson from everyone's favorite digital spreadsheet guru, YouTube's ExcelsFun, the very first installment in his "Excel Fo ...more

New to Excel? Looking for a tip? How about a tip so mind-blowingly advanced as to qualify as a magic trick? You're in luck. In this Excel tutorial from ExcelIsFun, the 514th installment in their series of digital spreadsheet magic tricks, you'll learn three methods for conditi ...more

This video introduces how to use Excel to sort data, perform the Frequency function, and present data in line chart. See how to apply condition formatting when working in Microsoft Excel 2007. Whether you're new to Microsoft's popular word processing application application or ...more

hether 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 43rd installment in his "Highline Excel ...more

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 ...more

Are you looking for a way to make your Microsoft Excel formulas simpler, faster and more efficient? If so, you're in the right place. With this free video lesson from everyone's favorite digital spreadsheet guru, YouTube's ExcelsFun, the 7th installment in his "Excel Formula E ...more

Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 36th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use the VLOOKUP function to determ ...more

Microsoft Office Excel 2007 spreadsheet manager is a powerful tool that enables information workers to format spreadsheets, as well as analyze and share information to make more informed decisions. In this MS Excel video tutorial, you'll learn about using the HLOOKUP function ...more

New to Microsoft Excel 2010? Looking for a few good tips and tricks? In this free video tutorial from everyone's favorite MS Excel guru, YouTube's ExcelIsFun, the very first installment in his series of Excel 2010 video tutorials, you'll learn how to use use the RANK.AVE funct ...more

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 Excel ...more

Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 75th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use name, the INDIRECT function an ...more

Need to compare two datasets and extract the new values? In this the 539th installment of ExcelIsFun's series of Excel magic tricks, you'll see how to use the MATCH function, the Join Symbol (& Ampersand), and the Filter feature to check two 2 lists of transactoinal records an ...more

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 162nd installment in their series of digital spreadsheet magic tricks, you'll learn how to deal with duplicates ...more