Protecting Excel 2007 Data - Excel tutorial

Category: Excel tutorials > Formatting - Difficulty:

Although Excel and other spreadsheet programs are the traditional interfaces for creating and reading spreadsheets, sometimes you might need to create .xls files directly from other programs.

Whether you're creating Excel files from databases on an Apache server or you just want to present the information stored in a Java program to Excel users, there are a variety of packages out there that will enable you to create and access .xls files without actually using Excel.

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.

This video tutorial shows how to use the roman function to format numbers as roman numerals in Excel.

Don't waste time copy and pasting, learn to work with the same data within multiple sheets.

Organize into columns from raw data that you got from somewhere else.