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.
About Spreadsheets Microsoft Excel / Functions and Formula
The basics of spreadsheets, on the other hand, are not always so basic. Even getting data entered into a spreadsheet the way you want can sometimes be a challenge.
Learning Microsoft Excel Microsoft Excel / Getting Started
In this class, students will learn how to set up and format simple to moderately complex spreadsheets. We will focus on using simple formulae to automatically total columns and rows and perform various calculations. We will earn how to format your spreadsheet so it prints properly. We will also learn how to turn information in a table into a chart using Excel's built in wizards and tools.
Conditional color formatting in Excel Microsoft Excel / General Formatting
Let's say you are making an Excel table where you shall input how many hours did you work for everyday. And you would like to make designation with colors. Red number for less than 8, blue for 8 and green color for more than 8. Did you know you can make that process automatic in MS Excel? Here's how.
Load an XML Document ito Excel Microsoft Excel / Functions and Formula
If someone sends you an XML file containing data that fits into tables, you don't need to read the text and all its angle brackets. You can load the document into Excel directly, tell Excel how you want to present it, and work with the data through maps.
Address Data by Name Microsoft Excel / Functions and Formula
Although cell numbers are at the foundation of everything Excel does, it's much easier to remember names, such as Item Number and Quantity, than it is to remember cell numbers, such as A1:A100. Excel makes this easy.
Excel uses the same technique for defining named cells and named ranges: the Name box at the left end of the Formula bar.
Working with Excel 2007 Files Microsoft Excel / Getting Started
This tutorial discover the new Excel interface that provides you with the right tools at the right time. In most Windows programs, you see menus and toolbars from which you select your options.