Microsoft Office 2010 Workbooks and Data Files
This page contains downloadable workbooks and data files on Microsoft Office 2010 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.
Microsoft Access 2010 
Microsoft Access 2010 is a database program that makes it easier to track, report and share data with others. It provides a powerful set of tools that you can use to quickly and easily develop relational databases to help you manage information.
- Part 1 provides an overview of the Access 2010 user interface and covers working with databases, sorting and filtering records, printing and getting help.
- Part 2 covers planning and creating a database, creating tables, working with records, controlling table data entry, and creating and using queries.
| Workbook Parts | Data Files |
|---|---|
| Part 1: Introduction to Access 2010 (PDF) | Part 1 (EXE) |
| Part 2: Working with a Database (PDF) | Part 2 (EXE) |
Microsoft Excel 2010 
Microsoft Excel 2010 is a spreadsheet program that can be used to create and format workbooks in order to analyze data. You can use Excel to track data, write formulas to perform calculations, and present data in a variety of professional-looking charts.
- Part 1 provides an overview of the Excel 2010 user interface and covers working with workbooks and worksheets, modifying rows and columns, adding and editing data, and getting help.
- Part 2 covers protecting and recovering workbooks, using formulas and functions, and working with sparklines.
| Workbook Parts | Data Files |
|---|---|
| Part 1: Introduction to Excel 2010 (PDF) | Part 1 (EXE) |
| Part 2: Excel Formulas and Functions (PDF) | Part 2 (EXE) |
Microsoft PowerPoint 2010 
Microsoft PowerPoint 2010 is a presentation program that offers various effects, themes, layouts and formatting options that can be used to quickly and efficiently develop dynamic, professional-looking presentations.
- Part 1 provides an overview of the PowerPoint 2010 user interface and covers basic presentation skills, managing files, and getting help.
- Part 2 covers adding graphics to your presentation, inserting and formatting pictures, and adding SmartArt, charts and tables.
| Workbook Parts | Data Files |
|---|---|
| Part 1: Introduction to PowerPoint 2010 (PDF) | Part 1 (EXE) |
| Part 2: Working with Visual Aids (PDF) | Part 2 (EXE) |
Microsoft Word 2010 
Microsoft Word 2010 is a word-processing program that can be used to create professional-looking documents such as reports, resumes, letters, memos and newsletters. Word 2010 includes many powerful tools that can be used to easily format and edit documents as well as collaborate with others.
- Part 1 provides an overview of the Word 2010 user interface and covers how to perform basic tasks such as creating a new document, saving, editing, formatting, printing and inserting images.
- Part 2 covers working with tabs, numbered and bulleted lists, document views, headers and footers, and page and section breaks.
| Workbook Parts | Data Files |
|---|---|
| Part 1: Introduction to Word 2010 (PDF) | Part 1 (EXE) |
| Part 2: Managing Documents (PDF) | Part 2 (EXE) |