How-to articles, tips & tricks for MS Office

Mar
26

How to convert text to date in Excel

The tutorial explains how to use Excel functions to convert text to date and how to turn text strings into dates in a non-formula way. You will also learn how to quickly change a number to date format. Continue reading

Mar
18

How to insert dates in Excel - add today's date, auto fill a column with dates

This tutorial demonstrates various ways of entering dates in Excel. See how to insert today's date and current time as static or dynamic values, how to auto populate a column or row with weekdays, and how to auto fill random dates in Excel. Continue reading

Mar
11

How to change date format in Excel and create custom formatting

The first part of our tutorial focuses of formatting dates in Excel and explains how to set the default date and time formats, how to change date format in Excel, how to create custom date formatting, and convert your dates to another locale. Continue reading

Mar
4

Excel array formula examples for beginners and power users

The tutorial focuses on Excel array formula examples and demonstrates how to use Excel functions that support calculations in arrays to count cells that meet several conditions, sum values in every Nth row, count any given character in a range, and more. Continue reading

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

Older posts »