Excel: featured articles
- How to use Excel COUNTIFS and COUNTIF with multiple criteria
- Creating a drop down list: static, dynamic, from another workbook
- Excel formulas for conditional formatting based on another cell value
- COUNTIF in Excel - count if not blank, greater than, duplicate or unique
- Using IF function: formulas for numbers, text, dates, blank cells
- How to use Excel SUMIFS and SUMIF with multiple criteria
- Change background color based on cell value
- INDEX & MATCH functions in Excel - a better alternative to VLOOKUP
- How to count and sum cells by color
Outlook: featured articles
I love the program!
I love the program, and I can't imagine using Excel without it! Ultimate Suite saves me many hours of effort with the projects I manage within Excel. The program paid for itself the first day I used it. You created a really great set of tools for use within Microsoft Excel. Thank you!!!
One word... WOW!
I recently bought the package of add-ins for Excel. I've used it ONCE and it has paid for itself. It literally saved me HOURS of work. KUDOS!
In this tutorial, you will learn what an Excel array formula is, how to enter it correctly in your worksheets, and how to use array constants and array functions in Excel. Continue reading
This tutorial shows how to count cells with text and characters in Excel 2010-2013. You will find several helpful Excel formulas for counting characters in one or several cells, character limits for cells and get a link to see how to get the number of cells that contain specific text. Continue reading
In this tutorial, you will find a number of Excel INDEX formula examples that demonstrate the most efficient uses of INDEX in Excel. Continue reading
What a beginning of the year it was! Not sure about you but I feel like the year is already flying by. Last week we officially finished the BETA version of new Merge Tables Wizard (whew!). So I'll take some time to kick my feet up while waiting for your feedback. Continue reading
Learn how to make your own Excel templates and where to find the best collections of free templates for your Excel such as calendars, budgets, invoices, inventory, charts, and more. Continue reading
The tutorial explains the compound interest formula for Excel and provides examples of how to calculate the future value of the investment at annual, monthly or daily compounding interest rate. You will also find the detailed steps to create your own Excel compound interest calculator. Continue reading
Last week we tapped into the insight of Excel logical operators that are used to compare data in different cells. Today, you will see how to extend the use of logical operators and construct more elaborate logical tests to perform more complex calculations and more powerful data analysis. Excel logical functions such as AND, OR, XOR and NOT will help you in doing this. Continue reading
Many tasks you perform in Excel involve comparing data in different cells. For this, Microsoft Excel provides six logical operators, which are also called comparison operators. This tutorial aims to help you understand the insight of Excel logical operators and write the most efficient formulas for your data analysis. Continue reading
The tutorial provides a variety of advanced IF formula examples that demonstrate how to use the Excel IF function with other functions, make nested IF formulas with multiple conditions, use IFERROR and IFNA. Continue reading
- ABOUT US