How-to articles, tips & tricks for MS Office
Excel array formulas, functions and constants - examples and guidelines
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
How to count cells with text and characters in Excel 2010-2013
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
6 most efficient uses of the INDEX function in Excel
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
Try out super speedy Merge Tables Wizard BETA and share your feedback
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
Using OFFSET function in Excel - formula examples
The tutorial explains the arcane twists of the OFFSET function and covers the most efficient ways to use OFFSET in Excel. Continue reading
How to use INDIRECT function in Excel - formula examples
This Excel INDIRECT tutorial explains the function's syntax, basic uses and provides a number of formula examples that demonstrate how to use INDIRECT in Excel. Continue reading
Excel templates - where to download and how to make custom templates in Excel
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
How to calculate compound interest in Excel - formula for daily, monthly, yearly compounding
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
How to calculate percentage in Excel
In this tutorial, you will lean a quick way to calculate percentages in Excel, find the basic percentage formula and a few more formulas for calculating percentage increase, percent of total and more. Continue reading
How to show percentages in Excel
In this short tutorial, you will find many helpful details about Excel percent format and learn how to make Excel display percentages in the way you want. Continue reading
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