Data AutoFilter in Excel - Excel tutorial

Category: Excel tutorials > Functions - Difficulty:

Formulas and functions provide the logic that powers spreadsheets. Managing programming logic is always a challenge, but keeping track of programming logic across multiple cells, sheets, and workbooks can be particularly difficult, especially as spreadsheets grow and are reused. What's more, the formula and function capabilities built into Excel might not always be what you want, further complicating the situation. Fortunately, there are a lot of ways you can keep your formulas and functions sane.

Offset allows you to refer to cells above, below, left or right of a reference cell. Very useful for cash flow forecasts where the receipt or payment of money can move between periods.

Step by step instructions with screenshots on how to create a toolbar button for an existing macro in excel. This a great little time saver when working with macros.

While exporting spreadsheets as XML is useful, Excel also lets you import information this way, letting you create spreadsheets using SpreadsheetML.

Excel supports SpreadsheetML for both import and export, providing a complete pathway for information. You can open a SpreadsheetML document, make a few changes, and re-open it in Excel if you want.

This video tutorial shows how to change the zoom settings in a spreadsheet