Your Office Microsoft Office 2016 Volume 1

by Kinser, Amy S.; Jacobson, Kristyn; Kinser, Eric; Kosharek, Diane; Moriarity, Brant

• ISBN13: 9780134444758
• ISBN10: 0134444752
• Edition: 1st
• Copyright: 2016-03-17
• Publisher: Pearson

Summary

This is the eBook of the printed book and may not include any media, website access codes, or print supplements that may come packaged with the bound book.

This book covers introductory Word, Excel, Access, and PowerPoint, with additional sections on integrating those applications, as well as a Windows 8 workshop. Ideal for business courses.

Real world problem solving for business and beyond

The Your Office series prepares students to use both technical and soft skills in the real world. Hands-on technical content is woven into realistic business scenarios and focuses on using Microsoft Office^® as a decision-making tool. The series features a unique running business scenario that connects all of the cases together and exposes students to using Office to solve problems relating to business areas like finance and accounting, production and operations, sales and marketing.

 

Each chapter introduces a realistic business case for students to complete via hands-on steps that are easily identified in blue shaded boxes.  Each blue box teaches a skill and comes complete with video and interactive support. Chapters are grouped into Business Units, which collectively illustrate a specific set of business concepts to achieve AACSB-related outcomes.  Each Business Unit ends with a Capstone section, testing students' ability to apply concepts and skills beyond a single chapter.

 

Note: You are purchasing a standalone product; MyITLab does not come packaged with this content. Students, if interested in purchasing this title with MyITLab, ask your instructor for the correct package ISBN and Course ID. Instructors, contact your Pearson representative for more information.

 

Author Biography

Amy S. Kinser, Esq., Series Editor

Amy holds a B.A. degree in Chemistry with a Business minor from Indiana University, and a J.D. from the Maurer School of Law, also 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 15 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.

 

Kristyn A. Jacobson

Kristyn holds an M.S. in Education from the University of Wisconsin-La Crosse and a B.S. in Business Education from the University of Wisconsin-Eau Claire. She has been a faculty member and department chair of the Business Technology department at Madison College in Madison, Wisconsin for over 14 years. She also serves as the curriculum coordinator for Microsoft Excel beginning, intermediate, and advanced level courses for the college. As well as teaching, Kristyn provides training to businesses on the Microsoft Office Suite including MS Project, project management, customer service, personal productivity, and time management. Prior to teaching at Madison College, she taught at a business college in Des Moines, Iowa where she helped implement their online learning program while also teaching traditional business courses.

 

J. Eric Kinser

Eric Kinser received his B.S. degree in Biology from Indiana University and his M.S. in Counseling and Education from the Indiana School of Education. He has worked in the medical field and in higher education as a technology and decision support specialist. He is currently a senior lecturer in the Operations and Decision Technology Department at the Kelley School of Business at Indiana University. When not teaching he enjoys experimenting with new technologies, traveling, and hiking with his family.

 

Diane L. Kosharek

Diane is a full-time Business Technology faculty member at Madison College in Madison, WI. In addition to her faculty role, she works closely with business and industry specialists, developing and delivering tailored training solutions to employees in areas such as customer service, software applications and business writing skills. Prior to joining Madison College, she worked as a Technology Training Consultant, providing consultation and production assistance to teaching faculty and staff to incorporate appropriate technology in their courses to enhance learning. Diane holds a Bachelor’s Degree in Education from the University of Wisconsin-Madison and a Master’s Degree in Educational Computing from Cardinal Stritch University.

 

Brant Moriarity

Brant P. Moriarity earned a B.A. in Religious Studies/Philosophy and a M.S. in Information Systems at Indiana University. He is a Senior Lecturer at the Indiana University’s Kelley School of Business where he teaches topics such as data management and analysis, as well as the strategic use of Information Systems in business. He is also the founder of Beats Per Minute Technologies, LLC, bringing the benefits of business analytics to small businesses and non-profit organizations.

 

Table of Contents

Windows
    Chapter 1: Understanding the Common Features of Microsoft Office

Common Features
    Chapter 1: Explore Windows and File Management

Word
Word Business Unit 1: Understanding Business Documents
    Chapter 1: Review and Modify a Document
    Chapter 2: Create and Edit a Document
Word Business Unit 1 CAPSTONE
Word Business Unit 2: Impressing with Sophisticated Documents
    Chapter 3: Include Tables and Objects
    Chapter 4: Special Document Formatting and Mail Merge
Word Business Unit 2 CAPSTONE

Excel
Excel Business Unit 1: Understanding the Fundamentals
    Chapter 1: Create, Navigate, Work With, and Print Worksheets
    Chapter 2: Formats, Functions, and Formulas
Excel Business Unit 1 CAPSTONE
Excel Business Unit 2: Conducting Business Analysis
    Chapter 3: Cell References, Named Ranges, and Functions
    Chapter 4: Effective Charts
Excel Business Unit 2 CAPSTONE

Access
Access Business Unit 1: Understanding and Using a Relational Database
    Chapter 1: The Four Main Database Objects
    Chapter 2: Tables, Keys, and Relationships
Access Business Unit 1 CAPSTONE
Access Business Unit 2: Accessing, Maintaining, and Presenting Information
    Chapter 3: Queries and Data Access
    Chapter 4: Using Forms and Reports in Access
Access Business Unit 2 CAPSTONE

PowerPoint
PowerPoint Business Unit 1: Understanding the Art of Presentation
    Chapter 1: Presentation Fundamentals
    Chapter 2: Text and Graphics
PowerPoint Business Unit 1 CAPSTONE
PowerPoint Business Unit 2: Collaborating and Invoking Emotion with the Audience
    Chapter 3: Multimedia and Motion
    Chapter 4: Customization and Collaboration
PowerPoint Business Unit 2 CAPSTONE
    Chapter 1: Word and Excel Integration
    Chapter 2: Word, Excel, and Access Integration
    Chapter 3: Word, Excel, Access, and PowerPoint Integration

Appendix
Glossary
Index