How-to articles, tips & tricks for MS Office

Feb
25

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

Feb
19

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

Feb
18

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

Feb
17

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

Feb
11

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

Feb
10

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

Jan
28

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

Jan
21

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

Jan
14

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

Jan
13

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

Older posts »