Microsoft Office 2007 Workbooks and Data Files
This page contains downloadable workbooks and data files on Microsoft Office 2007 applications. The workbooks are divided into multiple parts, with each part containing multiple lessons. Most lessons include sample data files that can be used for hands-on practice. The files are password protected and can be accessed by current Cal State L.A. students, faculty and staff with a myCSULA Identity account. Step-by-step instructions are available on how to authenticate and how to download the workbooks and data files.
- Exploring New Features
- Microsoft Access 2007
- Microsoft Excel 2007
- Microsoft Outlook 2007
- Microsoft PowerPoint 2007
- Microsoft Word 2007
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 - Outlook includes lessons on exploring the new Outlook interface, organizing Outlook items, working with new e-mail features, using the new calendar features, and exploring security and junk e-mail.
- Moving Up to Office 2007 - PowerPoint includes lessons on using the PowerPoint 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.
| Workbooks | Data Files |
|---|---|
| Moving Up to Office 2007 - Access (PDF) | Access Files (EXE) |
| Moving Up to Office 2007 - Excel (PDF) | Excel Files (EXE) |
| Moving Up to Office 2007 - Outlook (PDF) | Outlook Files (EXE) |
| Moving Up to Office 2007 - PowerPoint (PDF) | PowerPoint Files (EXE) |
| Moving Up to Office 2007 - Word (PDF) | Word Files (EXE) |
Microsoft Access 2007
Microsoft Access 2007 is a 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 1 includes lessons on exploring Access, creating, working with, and editing tables, and printing data.
- Part 2 includes lessons on modifying tables, using Access and the Internet, finding and filtering data, and setting field properties.
- Part 3 includes lessons on creating relationships, analyzing tables, using simple queries, modifying query results, and using operators in queries.
- Part 4 includes lessons on creating action queries, using advanced query wizards, designing advanced queries, and modifying query results.
- Part 5 includes lessons on creating basic forms, using design view, advanced form design, and subforms/subreports, and manipulating form controls in design view.
- Part 6 includes lessons on creating basic reports, using advanced report design, advanced database features, and charts, and exporting data.
| Workbook Parts | Data Files |
|---|---|
| Part 1: Introduction to Access 2007 (PDF) | Part 1 (EXE) |
| Part 2: Presenting Data (PDF) | Part 2 (EXE) |
| Part 3: Using Tables and Queries (PDF) | Part 3 (EXE) |
| Part 4: Working with Queries (PDF) | Part 4 (EXE) |
| Part 5: Using Forms (PDF) | Part 5 (EXE) |
| Part 6: Creating Reports (PDF) | Part 6 (EXE) |
Microsoft Excel 2007
Microsoft 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 1 includes lessons on exploring Excel, using basic workbook skills and page setup, working with ranges, printing and getting help.
- Part 2 includes lessons on formatting text, numbers, and cells, using conditional and custom formats, and templates.
- Part 3 includes lessons on working with columns and rows, and multiple worksheets, using large worksheets and worksheet protection, and managing worksheets.
- Part 4 includes lessons on creating simple formulas, copying, moving, and managing data, working with data series, and using advanced functions.
- Part 5 includes lessons on creating and formatting charts, using advanced charting features, drawing an object, and using additional effects and objects.
- Part 6 includes lessons on working with tables and advanced filters, using AutoFilter, and exporting and importing data.
| Workbook Parts | Data Files |
|---|---|
| Part 1: Introduction to Excel 2007 (PDF) | Part 1 (EXE) |
| Part 2: Formatting Worksheets (PDF) | Part 2 (EXE) |
| Part 3: Working with Worksheets (PDF) | Part 3 (EXE) |
| Part 4: Using Formulas and Functions (PDF) | Part 4 (EXE) |
| Part 5: Creating Charts (PDF) | Part 5 (EXE) |
| Part 6: Working with Tables and Filters (PDF) | Part 6 (EXE) |
Microsoft Outlook 2007
Microsoft Outlook 2007 is a comprehensive desktop information management program that integrates a number of applications to help you manage your communication and time. You can use Outlook to manage your electronic mail and contacts, organize your calendar and scheduling, and maintain a journal of your activities. This workbook is divided into two parts.
- Part 1 includes lessons on exploring Outlook, sending and receiving messages, using the address book, managing contacts, and getting help.
- Part 2 includes lessons on formatting and organizing messages, scheduling with the calendar, and working with junk mail and rules.
| Workbook Parts | Data Files |
|---|---|
| Part 1: Introduction to Outlook 2007 (PDF) | No Files |
| Part 2: Intermediate Outlook (PDF) | No Files |
Microsoft PowerPoint 2007
Microsoft 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 1 includes lessons on exploring PowerPoint, using basic presentation skills, slide show view, and slide sorter view, and working with presentations.
- Part 2 includes lessons on formatting, editing and proofing presentation text, and using the outline tab.
- Part 3 includes lessons on working with drawing objects, and using graphic images and SmartArt.
- Part 4 includes lessons on creating basic and custom charts, editing charts, and using tables.
- Part 5 includes lessons on applying special effects, setting up and expanding a slide show, editing multiple presentations, and inserting a photo album.
- Part 6 includes lessons on editing presentation, notes and handout masters, exporting outlines and slides, presenting to a wider audience, and printing.
| Workbook Parts | Data Files |
|---|---|
| Part 1: Introduction to PowerPoint 2007 (PDF) | Part 1 (EXE) |
| Part 2: Formatting a Presentation (PDF) | Part 2 (EXE) |
| Part 3: Enhancing a Presentation (PDF) | Part 3 (EXE) |
| Part 4: Working with Charts and Tables (PDF) | Part 4 (EXE) |
| Part 5: Creating a Professional Slide Show (PDF) | Part 5 (EXE) |
| Part 6: Working with Slide Masters (PDF) | Part 6 (EXE) |
Microsoft Word 2007
Microsoft Word 2007 is a word-processing program that can be used to create professional-looking documents. It includes many powerful tools that can be used to easily format and edit documents. This workbook is divided into six parts.
- Part 1 includes lessons on exploring Word, using basic document skills and text editing, checking spelling and grammar, printing and getting help.
- Part 2 includes lessons on using character, paragraph and document formatting, working with AutoFormat, using styles, and formatting with document themes.
- Part 3 includes lessons on setting tabs, indenting paragraphs, working with lists, using numbers and bullets, outline view, and newsletter-style columns.
- Part 4 includes lessons on working with document views, and headers and footers, using section breaks, quick parts, and find and replace.
- Part 5 includes lessons on working with and editing tables, sorting table data, and applying borders and shading.
- Part 6 includes lessons on inserting dates, symbols and graphics, creating citations and bibliography, and using SmartArt and templates.
| Workbook Parts | Data Files |
|---|---|
| Part 1: Introduction to Word 2007 (PDF) | Part 1 (EXE) |
| Part 2: Formatting Documents (PDF) | Part 2 (EXE) |
| Part 3: Working with Document Appearance (PDF) | Part 3 (EXE) |
| Part 4: Managing Documents (PDF) | Part 4 (EXE) |
| Part 5: Working with Tables (PDF) | Part 5 (EXE) |
| Part 6: Using Word Helpers (PDF) | Part 6 (EXE) |