Microsoft Office

From Wikibooks, open books for an open world
(Redirected from Excel)
Jump to: navigation, search
A Macintosh 128k running Finder 4.1 This wikibook contains characters (such as the Apple logo) that display only on Apple Macintosh computers. These characters will not appear on computers running Microsoft Windows.
Symbol version newer.svg

This book applies to version 2010 of Microsoft Office.

Symbol version specific.svg

This book applies only to version 2011 of Microsoft Office for Mac.


Welcome to the Microsoft Office wikibook. This book aims to be a comprehensive reference for the use of Microsoft Office for Windows, Microsoft Office for Mac, and Microsoft’s Office Online and Office 365 services. While this book doesn’t teach basic computer skills or general Windows or OS X usage, this book will cover a few core techniques that complement the use of Microsoft Office. In addition, many of the concepts in this book can be applied to other office packages; however, please note that the Microsoft Office user interface is relatively unique, so if you use another office package, you’ll need to find ways of performing the same task that work in that program.

Table of Contents

Computing Basics

Windows 7 vs. Windows 8
Logging In & Out (WindowsOS X)
File Management Techniques

Word

Create and Edit a Document
Spacing and Special Characters
Create and Edit a Flier
Create and Edit a Research Paper in MLA format
Create and Edit a Research Paper in APA format
Create and Edit a Cover Letter
Create and Edit a Resume
Opening a Word File as Read Only
Create a Proposal with collaboration
Edit your Cover Letter into a form letter with mailing labels
Create a Newsletter
Ribbon Reference (WindowsMac)

Excel

Excel Terminology
Navigating Cells
Working with Data
Working with Formulas
Making Beautiful Charts
Printing in Excel
Create a Workbook to Analyze your Field of Interest with Embedded Chart
Create a Personal Budget with functions
Create a College Expense Analysis Workbook
Troubleshooting Excel Errors
Loan Payment Amortization Schedule
Create a Pivot Table
Create a spreadsheet with lists
Create a spreadsheet with multiple worksheets
Excel Basic Exam

Access

Create a basic two table database with reports
Create queries for a database
Using and updating a database
Creating Forms and Reports from multiple tables
Creating Sub-forms
Creating a data access point for the internet
Reports
Access Basic Exam

PowerPoint

PowerPoint Terminology
Strategies for College Success
Creating and Editing a Presentation
Formatting Text Slides
Using Graphics and Animations
Creating a Custom Design Template
Preparing to Deliver a Presentation

Publisher

Create a Greeting Card
Create a Business Card
Create a Poster
Create a Banner