| Learning
Microsoft Excel 2007
by
Greg Bowden (406 pages)
The tutorials have
been developed for Microsoft Excel 2007 on the Windows system
as single or multi-user versions. The
multi-user version has assignments at the end of each chapter
and a detailed project at the end of each Module so
that students can practice the skills that they have learned
from that chapter or module. The tutorials can printed,
used on screen next to the software package or used on an iPad
or similar device.
|
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 Spreadsheet features including
IF statements, Lookup commands, creating sales invoices,
payroll/payslip systems, creating macros, financial and
date calculations, AutoFormat, styles and save options.
Click
to view Prices and Chapter Descriptions
|
Contents and Sample Pages
Sample pages from chapters
can be downloaded. The sample pages contain COMPRESSED screen
pictures so their quality is lower than the actual product.
Module 1: Introductory Excel Activities
| Contents |
view
pages (186k) |
| Chapter 1: Introduction
to Microsoft Excel (27 pages) |
|
| Chapter
2: Formatting Cells (26 pages) |
view
sample pages (481k) |
| Chapter
3: Further Formatting (15 pages) |
view
sample pages (592k) |
| Chapter
4: Copying Cell Data (22 pages) |
view
sample pages (654k) |
| Chapter
5: Larger Spreadsheets (17 pages) |
|
| Chapter
6: Using Worksheets (18 pages) |
view
sample pages (450k) |
| Chapter
7: Displaying Data in Charts (19 pages) |
|
| Chapter
8: More Detailed Charts (24 pages) |
view
sample pages (711k) |
| Chapter
9: The Drawing Tools (25 pages) |
view
sample pages (585k) |
| Module
1 Project (Multi- user version only) |
|
Top
Module 2: Advanced Excel Activities
| Contents |
view
pages (187k) |
| Chapter
10: Making Predictions with Excel (12 pages) |
|
| Chapter
11: Making Decisions with Excel (19 pages) |
view
sample pages (443k) |
| Chapter
12: Lookup Commands (11 pages) |
view
sample pages (437k) |
| Chapter
13: Creating Sales Invoices (30 pages) |
view
sample pages (582k) |
| Chapter
14: Sharing Data Between Files (24 pages) |
|
| Chapter
15: Using Macros and Buttons (26 pages) |
view
sample pages (464k) |
| Chapter
16: Payroll Systems (20 pages) |
view
sample pages (424k) |
| Chapter
17: Financial Applications (18 pages) |
view
sample pages (478k) |
| Chapter
18: Date Calculations (13 pages) |
|
| Chapter
19: Useful Tools (12 pages) |
|
| Module
2 Project (Multi-user version only) |
|
Top | More
Details and Examples
Home | Products | Prices | Ordering | Podcasts | Downloads | Testimonials | Contact
|
