 |
Official Site |
| Microsoft | |
Excel [Web] |
|
| Download | |
| Excel Viewer [Web] | |
|
Learn Excel |
| never used | |
| Introduction | |
| Data entry | |
| Data editing | |
| formatting | |
| save / open | |
| printing | |
| beginner | |
| formulas | |
| functions | |
| date | |
| copy / past special | |
| daily user | |
| filters | |
| subtotals | |
| charts | |
| lookup, index | |
| pivot tables | |
| templates | |
| lists | |
| power user | |
| advanced filters | |
| custom toolbars | |
| keyboard shortcuts | |
| add-ins | |
| macro recorder | |
| expert user | |
| VBA - VSTO | |
|
Reference |
| basics | |
| Cells | |
| Columns | |
| Functions | |
| Rows | |
| Sheets | |
| Workbooks |
|
Reviews |
| A-Z | |
| - |
|
Awards |
| International |
Create professional spreadsheets.
useful : Interactive website showing where to find a command in 2007 when ou click on the 2003 old style menu [Web]
Excel 2007
Completely new interface, no menu, but tabbed ribbon ith options
More than 16000 columns, more than 1 million rows
Rich conditional formatting
Structured references
Tutorial
goal: learn everything from the basic formulas to the most advanced VBA programming of your favorite spreadsheet. Including detailed instructions, images and even videos!
Learn Excel
If you have never used Excel and have no idea what it is all about, then read the following.
Microsoft Excel is a spredsheet software with a table-like (rows and columns) layout (see above screenshot). It is very easy to create basic tables with a fine formatting and add some formulas to automatically update the results based on the data.
Columns are labeled with letters from A...Z, AA, AB, AC, ... IV
Rows are simply numbered from 1...65536
The intersection of a row and a column is called a cell.
Beginner
Formulas
What are Excel formulas?
Excel formulas are expressions with arithmetic operators, brackets and intrinsic functions or UDFs (user defined functions) to calculate a result.
How to enter an Excel formula?
Enter a formula into a cell (B8) simply by starting with the = sign. Excel will now accept basic formulas like =A3*B5 resulting in the multiplication of the value in cell A3 by the value of the cell B5. If one of these cell does not contain numeric value, then an error message will be shon next to the result cell.
