Microsoft Excel xp 2004 tutorial. Free Course. Index

Excel2003 Tutorial. Index

1. Introduction. Excel Elements
2. Starting to work with Excel
3. Operations with files
4. Formulas and Functions
5. Manipulating cells

6. Cell formats
7. Structure changes
8. Insert and eliminate elements
9. Spelling correction
10. Printing

Detailed index

Unit1. Introduction. Excel2003 Elements

Initiate Excel2003
The opening page
The bars
Help
What is Excel2003 and what does it do for us?
Combining two sessions
Intelligent menus

Unit 2. Starting to work with Excel

Rapid movement within the sheet
Rapid movement within the workbook
Introducing data
Modifying data
Types of data
Data errors
Basic Excel concepts
Types of Excel data
Formulas

Unit 3. Operations with files

Save a workbook
Close a workbook
Start a new workbook
Open an existing workbook
Buttons in the Save dialogue box
Automatically create security copies
Protect workbooks
Close all open workbooks
Using templates
Creating templates
More options from the New workbook bar
Open various workbooks at the same time
Opening workbooks for reading purpose
Buttons in the new dialogue box

Unit 4. Formulas and functions

Introducing formulas and functions
Inserting functions with the wizard
Date and time functions
Text functions
Search functions
Financial functions
Other functions
References and names
Most used operators
Operator priorities
Analysis toolpack

Unit 5. Manipulating cells

Cell selections
Adding to a selection
Extend or reduce a selection
Copy cells using the clipboard
Copy cells using the mouse
Copy cells in adjacent cells
Pegado especial
Moving cells using the clipboard
Moving cells using the mouse
Deleting cells
Autofill
Select cells using the keyboard
Select various worksheets

Unit 6. Cell formats

Font
Alignment
Borders
Patterns
Numbers
Cell protection

Unit 7. Structure changes

Row height
Autofit
Column width
Autofit the selection
Standard column width
Change the name of the sheet
Hide sheets, show hidden sheets
Add a background to a sheet
Change the colour of the tags in a sheet
Hiding rows
Hiding columns

Unit 8. Insert and eliminate elements

Insert rows in a sheet
Insert columns in a sheet
Insert cells in a sheet
Insert sheets in a workbook
Eliminate rows and columns from a sheet
Eliminate sheets from a workbook
Move a worksheet
Copy a worksheet

Unit 9. Spelling correction

Configure the autocorrect
Spelling verification
Create a new dictionary
Add to the dictionary
Intelligent tags

Unit 10. Printing

Print preview
Page setup
Print
Page header and footer

Video tutorials

1. Basic Excel2003 environment
2. Introduce and modify text
3. Save a workbook
3. Close a workbook
3. Create a new workbook
3. Open a workbook
4. Insert functions
5. Selecting rows, cells, and columns
5. Copy cells
5. Copy cells with the mouse

5. Special paste
5. Move cells
5. Delete cells
6. Change the font
6. Align the contents of cells
6. Borders
6. Colouring cells
6. Cell formatting
7. Row height
7. Hide rows
7. Column width
7. Hide columns

7. Change the name of a sheet
8. Insert rows
8. Insert columns
8. Insert sheets
8. Copy and move a worksheet
8. Eliminate elements
9. Autocorrect spelling
9. Spelling correction
10. Page setup
10. Print

Step by step exercises

2. Shifting in a worksheet
2. Shifting in a workbook
2. Introduction of data
3. Operations with files
4. Date and time functions
4. Text functions
4. Search functions
4. Financial functions
4. Other functions

5. Selecting cells
5. Copy cells
5. Move cells
5. Delete cells
6. Cell font f ormat
6. Cell alignment format
6. Cell border format
6. Cell pattern format
6. Cell number format

6. Cell formats
7. Row formats
7. Column formats
7. Sheet formats
8. Insert elements in a workbook
8. Eliminate elements from a workbook
9. Spelling correction
10. Printing

Proposed exercises	Evaluation tests
2. Start working with Excel2003 3. Operations with files 4. Functions 5. Manipulating cells 6. Cell formats 7. Structure changes 8. Working with rows, columns, cells, and sheets 9. Spelling correction 10. Printing	2. Start working with Excel2003 3. Operations with files 4. Functions 5. Manipulating cells 6. Cell formats 7. Structure changes 8. Working with rows, columns, cells, and sheets 9. Spelling correction 10. Printing

Page 0

Legal warning: Authorised on-line use only. It is not allowed the use of these courses in companies or private teaching centres.