If you have an Excel file that contains formulas, formatting, layouts, etc. that you use often, then saving it as an Excel template may help save you time. The template can become a model for other spreadsheets. To create an

Compound interest is used in mortgages, loans, investments, and anything else that pays interest multiple times. It basically means that interest is paid on both the principal AND the past interest. Microsoft Excel Compound Interest can run these computations for

Excel allows you to reference or display values from other worksheets within a workbook. This is called a 3D reference. In the example below, we are going to pull the quarterly total from Sheet 1 to the Total Sales Sheet.

Here is a quick formula that calculates the current date each time you open your spreadsheet. Select a cell Type the following formula: <Today() Press Enter Excel Today’s Date Formula Now that cell will always display the current date and

The F5 key is a great shortcut key in many of the Office programs for everything from navigating, inserting named ranges into formula, and starting a slide show.. F5 hotkey in Excel In Excel, pressing F5 will bring up the

With Excel open, click the File Tab Click Options (towards the bottom of the menu) Click Advanced. In the Editing Options section, where it says “After pressing Enter, move the selection” change the direction to right Close out of the

When you have a document that spans multiple pages, you might want your column titles/headers to be repeated on each page. Print Excel title columns and rows with these instructions. Click the Page Layout tab In the Page Setup group,

By default, Excel shows the number of decimal places that can comfortably fit in a cell. If the cell is narrow, it might only fit one or two. A wider cell can fit many more. Sometimes, however, I want to

Identify cells and data with Excel name ranges. Excel name ranges make finding and identifying data easier. They can also be used in formulas in place of cell references. This makes formulas easier to understand and build. To use Excel

Have you ever needed to reformat data so that the columns were the rows and the rows were the columns? Transposing in Excel is straightforward and easy. Select your data Copy your data with Control + C Click on the