(0) items

Your Office Getting Started with Advanced Cases for Microsoft Office 2010

by ; ; ;


Pub. Date:
Prentice Hall
List Price: $40.00

Rent Textbook


Buy New Textbook

Currently Available, Usually Ships in 24-48 Hours

Used Textbook

We're Sorry
Sold Out


We're Sorry
Not Available

More New and Used
from Private Sellers
Starting at $0.01

Questions About This Book?

Why should I rent this book?
Renting is easy, fast, and cheap! Renting from can save you hundreds of dollars compared to the cost of new or used books each semester. At the end of the semester, simply ship the book back to us with a free UPS shipping label! No need to worry about selling it back.
How do rental returns work?
Returning books is as easy as possible. As your rental due date approaches, we will email you several courtesy reminders. When you are ready to return, you can print a free UPS shipping label from our website at any time. Then, just return the book to your UPS driver or any staffed UPS location. You can even use the same box we shipped it in!
What version or edition is this?
This is the 1st edition with a publication date of 9/6/2012.
What is included with this book?
  • The New copy of this book will include any supplemental materials advertised. Please check the title of the book to determine if it should include any CDs, lab manuals, study guides, etc.
  • The Rental copy of this book is not guaranteed to include any supplemental materials. You may receive a brand new copy, but typically, only the book itself.


For introductory computer courses on Microsoft Office 2010 or courses in computer concepts with a lab component for Microsoft Office 2010 applications. Your Officeis the Office Applications textbook written for instructors who want more than a 'skill & drill' book that enables students to learn discreet tasks but fails to illustrate the big picture of how these skills work together. Your Officebridges the gap between skill and application, and empowers students to master Office 2010 as a tool to solve problems and make decisions. The casesprogress students from learning the skills in each Office Application to using the applications as tools to make business decisions. The unique modular structureprovides a strong foundation for students through practice in each workshop and then synthesizes the objectives covered over two workshops, challenging students to really retain what they learned as opposed to learning and then forgetting soon after. The series scenariointroduces a large global business (the resort and spa) made up of smaller businesses (golf pro shop, spa, restaurants, event planning, etc) featured in the cases that run throughout all four applications. This approach gives students a solid understanding of how an organization works by exposing them to how individuals in all facets of a business interact with tools like Microsoft Office and use information to make decisions. For a behind-the-scenes look at Your Office, visit **This is a one-chapter supplement.**

Author Biography

Amy S. Kinser, Esq., Series Editor
Amy holds a B.A. degree in Chemistry with a Business minor and a J.D. from the Maurer School of Law both at Indiana University. After working as an environmental chemist, starting her own technology consulting company, and practicing intellectual property law, she has spent the past eleven years teaching technology at the Kelley School of Business in Bloomington, Indiana.   Currently, she serves as the Director of Computer Skills and Senior Lecturer at the Kelley School of Business at Indiana University.  She also loves spending time with her two sons, Aidan and J. Matthew, and her husband J. Eric.

Table of Contents


Advanced Problems Module 1

Workshop 1 : Business Problem Solving

Prepare Case: Golf Nook Clothing Store Sales, Inventory and Customer Analysis

Define the Business Problem

Planning Steps to Solve the Problem

Problem Definition

To Create the Relationships

Creating the Queries

Information Requirements

To Create Queries of Month’s Sales

Intrinsic Functions

To Create Query of Total Month’s Sales

To Create Query of Current Inventory

To Create Query of Cumulative Sales

To Create Query of Starting Inventory

To Combine Queries to Compute Percentage

To Create a Query of Percentage of Starting Inventory Sold

Exporting Data to Excel for Analysis and Charting

Analysis and Charting

Create a Report of the Problem Solution

To Complete the Sales Analysis Report

Analysis Presentation of Recommended Action

To Create the Presentation Based on the Sales Analysis Report

Inventory Analysis

Problem Definition

To Create Query of Annual Demand by Product

To Create Query of Annual Sales by Product

To Export Data to Excel for Analysis and Calculations

Analysis Report

To Complete the Inventory Analysis Report

Analysis Presentation

To Create the Presentation Based on the Inventory Analysis Report

Customer Analysis

Problem Definition

To Create Query of Customers That Have Made a Purchase

To Create Query of Customers That Have Not Made a Purchase

To Create Query of Customers and their E-mails

To Create Query of Customers That Have Made a Popular Product Purchase

To Create Query of Customers That Have Not Made a Popular Product Purchase

To Create E-mail Messages to Customers That Have Not Made a Purchase

To Create Letters to Customers That Have Not Made a Purchase

To Complete the Customer Analysis Report

To Create the Presentation Based on the Customer Analysis Report

Concept Check

Key Terms

Visual Summary

Problem Solve

Problem Solve Case 1


Perform in your Career

Perform in your Career



Please wait while the item is added to your cart...