How to use Excel

This article describes how to import or export text files in Excel. Text files can be comma separated (.csv) or tab separated (.txt)

Although not used very often on this site you might find yourself in a situation where you want to use the Do Until Loop in Excel VBA. Code placed between Do Until and Loop will be repeated until the part after Do Until is true.

The DateDiff function in Excel VBA can be used to get the number of days weeks months or years between two dates. You can also use the DateDiff function to calculate the time difference between two times.

Calculating the difference between two times in Excel can be tricky. Times are handled internally as numbers between 0 and 1.

This example teaches you how to protect the workbook structure in Excel.

VBA (Visual Basic for Applications) is the programming language of Excel. If you're an Excel VBA beginner these 16 chapters are a great way to start. Excel VBA is easy and fun! With Excel VBA you can automate tasks in Excel by writing so called macros.

If you share a workbook in Excel 2016 or older versions you can work with other people on the same workbook at the same time. The workbook should be saved to a network location where other people can open it. You can keep track of the changes other people make and accept or reject those changes.

This example teaches you how to insert a calculated field or calculated item in a pivot table in Excel.

This chapter illustrates three functions to round numbers in Excel. ROUND ROUNDUP and ROUNDDOWN.

A list box is a list from where a user can select an item. To create a list box in Excel VBA execute the following steps.