Microsoft Office 2007 Workbooks and Data Files
Faculty and Staff
This page contains downloadable workbooks and data files for the major applications in the Microsoft Office 2007 suite (Access, Excel, PowerPoint, and Word). The files are password protected and can be accessed by current CSULA faculty and staff with a valid NIS or CSLA account.
The workbooks are divided into six parts, with each part containing multiple lessons. Most lessons come with data files that can be used to follow along with the step-by-step instructions.
Topics on this page:
Exploring New Features
The workbooks in the Moving Up series are designed to help make the transition from Office 2003 to Office 2007 smoother for all users who plan to upgrade. Each title introduces the new user interface and covers the basics and new features to help you get started with Office 2007.
- Moving Up to Office 2007 - Access includes lessons on exploring Access, creating and working with tables, finding and filtering data, working with queries and recordsets, forms, and reports.
- Moving Up to Office 2007 - Excel includes lessons on exploring new Excel features as well as using formula, sort and filtering, table, PivotTable, conditional formatting, graphic, file format, and help features.
- Moving Up to Office 2007 - PowerPoint includes lessons on using the Office 2007 interface, enhancing typography, slide layouts, graphic images, tables, and charts, using SmartArt, inserting a photo album, and sharing your presentation.
- Moving Up to Office 2007 - Word includes lessons on customizing Word preferences, using spell checker, quick parts, SmartArt, chart creation, and mail merge features, and working with revisions and comments.
| Microsoft Office 2007 | |
|---|---|
| Topics | Data Files |
| Moving Up to Office 2007 - Access (PDF, 1.6 MB) | Files (EXE, 0.8 MB) |
| Moving Up to Office 2007 - Excel (PDF, 3.7 MB) | Files (EXE, 0.2 MB) |
| Moving Up to Office 2007 - PowerPoint (PDF, 7.0 MB) | Files (EXE, 2.7 MB) |
| Moving Up to Office 2007 - Word (PDF, 3.0 MB) | Files (EXE, 6.6 MB) |
Microsoft Office Access 2007 
Microsoft Office Access 2007 is an easy-to-use relational database management system. It provides a powerful set of tools that help you to quickly start tracking, reporting, and sharing information. This workbook is divided into six parts.
- Part one is called Introduction to Access 2007 and includes lessons on exploring Access, creating, working with, and editing tables, and printing data.
- Part two is called Presenting Data and includes lessons on modifying tables, using Access and the Internet, finding and filtering data, and setting field properties.
- Part three is called Using Tables and Queries and includes lessons on creating relationships, analyzing tables, using simple queries, modifying query results, and using operators in queries.
- Part four is called Working with Queries and includes lessons on creating action queries, using advanced query wizards, designing advanced queries, and modifying query results.
- Part five is called Using Forms and includes lessons on creating basic forms, using design view, advanced form design, and subforms/subreports, and manipulating form controls in design view.
- Part six is called Creating Reports and includes lessons on creating basic reports, using advanced report design, advanced database features, and charts, and exporting data.
| Microsoft Office Access 2007 | |
|---|---|
| Parts | Data Files |
| 1. Introduction to Access 2007 (PDF, 1.5 MB) | 1 (EXE, 0.3 MB) |
| 2. Presenting Data (PDF, 0.9 MB) | 2 (EXE, 0.4 MB) |
| 3. Using Tables and Queries (PDF, 0.7 MB) | 3 (EXE, 0.3 MB) |
| 4. Working with Queries (PDF, 0.5 MB) | 4 (EXE, 0.3 MB) |
| 5. Using Forms (PDF, 0.7 MB) | 5 (EXE, 0.6 MB) |
| 6. Creating Reports (PDF, 0.9 MB) | 6 (EXE, 0.6 MB) |
Microsoft Office Excel 2007 
Microsoft Office Excel 2007 is a powerful tool you can use to create and format spreadsheets, create charts, and analyze and share information. This workbook is divided into six parts.
- Part one is called Introduction to Excel 2007 and includes lessons on exploring Excel, using basic workbook skills and page setup, working with ranges, printing, and getting help.
- Part two is called Formatting Worksheets and includes lessons on formatting text, numbers, and cells, using conditional and custom formats, and templates.
- Part three is called Working with Worksheets and includes lessons on working with columns and rows, and multiple worksheets, using large worksheets and worksheet protection, and managing worksheets.
- Part four is called Using Formulas and Functions and includes lessons on creating simple formulas, copying, moving, and managing data, working with data series, and using advanced functions.
- Part five is called Creating Charts and includes lessons on creating and formatting charts, using advanced charting features, drawing an object, and using additional effects and objects.
- Part six is called Working with Tables and Filters and includes lessons on working with tables and advanced filters, using AutoFilter, and exporting and importing data.
| Microsoft Office Excel 2007 | |
|---|---|
| Parts | Data Files |
| 1. Introduction to Excel 2007 (PDF, 4.3 MB) | 1 (EXE, 0.1 MB) |
| 2. Formatting Worksheets (PDF, 4.9 MB) | 2 (EXE, 0.2 MB) |
| 3. Working with Worksheets (PDF, 2.8 MB) | 3 (EXE, 0.2 MB) |
| 4. Using Formulas and Functions (PDF, 3.6 MB) | 4 (EXE, 0.2 MB) |
| 5. Creating Charts (PDF, 4.4 MB) | 5 (EXE, 0.2 MB) |
| 6. Working with Tables and Filters (PDF, 4.5 MB) | 6 (EXE, 0.3 MB) |
Microsoft Office PowerPoint 2007 
Microsoft Office PowerPoint 2007 offers new and improved effects, themes, layouts, and enhanced formatting options that you can use to create professional-looking, dynamic presentations. This workbook is divided into six parts.
- Part one is called Introduction to PowerPoint 2007 and includes lessons on exploring PowerPoint, using basic presentation skills, slide show view, and slide sorter view, and working with presentations.
- Part two is called Formatting a Presentation and includes lessons on formatting, editing, and proofing presentation text, and using the outline tab.
- Part three is called Enhancing a Presentation and includes lessons on working with drawing objects, and using graphic images and SmartArt.
- Part four is called Working with Charts and Tables and includes lessons on creating basic and custom charts, editing charts, and using tables.
- Part five is called Creating a Professional Slide Show and includes lessons on applying special effects, setting up and expanding a slide show, editing multiple presentations, and inserting a photo album.
- Part six is called Working with Slide Masters and includes lessons on editing presentation, notes, and handout masters, exporting outlines and slides, presenting to a wider audience, and printing.
| Microsoft Office PowerPoint 2007 | |
|---|---|
| Parts | Data Files |
| 1. Introduction to PowerPoint 2007 (PDF, 3.3 MB) | 1 (EXE, 0.3 MB) |
| 2. Formatting a Presentation (PDF, 6.3 MB) | 2 (EXE, 0.5 MB) |
| 3. Enhancing a Presentation (PDF, 4.7 MB) | 3 (EXE, 0.4 MB) |
| 4. Working with Charts and Tables (PDF, 5.9 MB) | 4 (EXE, 0.4 MB) |
| 5. Creating a Professional Slide Show (PDF, 4.4 MB) | 5 (EXE, 0.5 MB) |
| 6. Working with Slide Masters (PDF, 3.4 MB) | 6 (EXE, 0.4 MB) |
Microsoft Office Word 2007 
Microsoft Office Word 2007 is a powerful authoring program that allows you to create and share documents by combining a comprehensive set of writing tools with an easy-to-use user interface. This workbook is divided into six parts.
- Part one is called Introduction to Word 2007 and includes lessons on exploring Word, using basic document skills and text editing, checking spelling and grammar, printing, and getting help.
- Part two is called Formatting Documents and includes lessons on using character, paragraph, and document formatting, working with AutoFormat, using styles, and formatting with document themes.
- Part three is called Working with Document Appearance and includes lessons on setting tabs, indenting paragraphs, working with lists, using numbers and bullets, outline view, and newsletter-style columns.
- Part four is called Managing Documents and includes lessons on working with document views, and headers and footers, using section breaks, quick parts, and find and replace.
- Part five is called Working with Tables and includes lessons on working with and editing tables, sorting table data, and applying borders and shading.
- Part six is called Using Word Helpers and includes lessons on inserting dates, symbols, and graphics, creating citations and bibliography, and using SmartArt and templates.
| Microsoft Office Word 2007 | |
|---|---|
| Parts | Data Files |
| 1. Introduction to Word 2007 (PDF, 3.0 MB) | 1 (EXE, 0.1 MB) |
| 2. Formatting Documents (PDF, 4.6 MB) | 2 (EXE, 0.1 MB) |
| 3. Working with Document Appearance (PDF, 3.1 MB) | 3 (EXE, 0.1 MB) |
| 4. Managing Documents (PDF, 4.6 MB) | 4 (EXE, 0.2 MB) |
| 5. Working with Tables (PDF, 2.6 MB) | 5 (EXE, 0.1 MB) |
| 6. Using Word Helpers (PDF, 2.6 MB) | 6 (EXE, 0.1 MB) |