How to use Excel

This chapter teaches you how to print a worksheet and how to change some important print settings in Excel.

This example illustrates two functions to chop off decimals in Excel. INT and TRUNC.

When you copy a formula Excel automatically adjusts the cell references for each new cell the formula is copied to. Use the fill handle in Excel to quickly copy a formula to other cells.

By default Excel copies both visible and hidden cells. However it is possible to copy visible cells only.

This chapter teaches you how to deal with macro errors in Excel. First let's create some errors.

The data form in Excel allows you to add edit and delete records (rows) and display only those records that meet certain criteria. Especially when you have wide rows and you want to avoid repeated scrolling to the right and left the data form can be useful.

Below we will look at a program in Excel VBA that reads data from a text file. This file contains some geographical coordinates we want to import into Excel.

This page teaches you how to quickly add error bars to a chart in Excel followed by instructions for adding custom error bars. First select the chart. Next click the + button on the right side of the chart click the arrow next to Error Bars and then click More Options.

To split a cell in Excel add a new column change the column widths and merge cells. To split the contents of a cell into multiple cells use the Text to Columns wizard flash fill or formulas.

Below we will look at a program in Excel VBA that highlights the row and column of the Active Cell (selected cell). This program will amaze and impress your boss.