| Microsoft Excel Activities 2003/2004
by
Greg Bowden
The tutorials have
been developed for Microsoft Excel 2003 on the Windows system
and Microsoft Excel 2004 on the Macintosh system. They are available
in PDF format and Module 1 is also available as podcasts.
|
Module
1: Introduces the Excel basics of entering labels,
values and formulas, formatting cells and worksheets,
copying cell data, creating charts and using the drawing
tools.
Module
2: Introduces advanced Excel features including
IF statements, Lookup Commands, creating sales invoices,
payroll/payslip systems, creating macros, financial and
date calculations, AutoFormat, styles and save options.
More
Details and Examples | Download
Product
|
Contents and Sample Pages
Sample pages from each chapter
can be downloaded. The sample pages contain COMPRESSED screen
pictures so their quality is lower than the actual product. The
sample podcasts provide the first few minutes of the prodcast
and they are the QuickTime Player versions.
Module 1: Introductory Excel Activities
| Contents |
view
pages (88k) |
| Chapter 1: Introduction
to Microsoft Excel (24 pages) |
|
| Chapter
2: Formatting Cells (24 pages) |
view
sample prodcast (2.6MB) |
| Chapter
3: Further Formatting (15 pages) |
|
| Chapter
4: Copying Cell Data (20 pages) |
|
| Chapter
5: Larger Spreadsheets (15 pages) |
|
| Chapter
6: Using Worksheets (14 pages) |
view
sample pages (552k) |
| Chapter
7: Displaying Data in Charts (19 pages) |
view
sample prodcast (2.7MB) |
| Chapter
8: More Detailed Charts (22 pages) |
|
| Chapter
9: The Drawing Tools (15 pages) |
|
| Module
1 Project (Multi- user version only) |
|
Top
Module 2: Advanced Excel Activities
| Contents |
view
pages (88k) |
| Chapter
10: Making Predictions with Excel (12 pages) |
|
| Chapter
11: Making Decisions with Excel (16 pages) |
view
sample pages (532k) |
| Chapter
12: Lookup Commands (11 pages) |
|
| Chapter
13: Creating Sales Invoices (30 pages) |
view
sample pages (540k) |
| Chapter
14: Sharing Data Between Files (24 pages) |
|
| Chapter
15: Using Macros and Buttons (24 pages) |
|
| Chapter
16: Payroll Systems (16 pages) |
view
sample pages (504k) |
| Chapter
17: Financial Applications (17 pages) |
|
| Chapter
18: Date Calculations (14 pages) |
view
sample pages (432k) |
| Chapter
19: Useful Tools (12 pages) |
|
| Module
2 Project (Multi-user version only) |
|
Top | More
Details and Examples | Download
Product
Home | Products | Prices | Ordering | Podcasts | Downloads | Testimonials | Contact
|
