Pearson eText Your Office: Microsoft Office Excel 2019 -- Access Card

by Amy Kinser / Kristyn Jacobson

• ISBN13: 9780136851370
• ISBN10: 0136851371
• Additional ISBN(s): 9780136851370
• Format: Nonspecific Binding
• Copyright: 2020-09-18
• Publisher: PEARSO
• More Book Details
• Purchase Benefits

Summary

Real-world problem-solving for business and beyond.
Your Office: Microsoft^®  Office 365^®, Excel^™  2019 Comprehensive  combines technical content with business cases to help you use Excel as a decision-making tool at work.

For courses covering Microsoft^® Excel^™. Ideal for business courses.

Pearson  eText  is an easy-to-use digital textbook that you can purchase on your own or instructors can assign for their course. The mobile app lets you keep on learning, no matter where your day takes you -- even offline. You can also add highlights, bookmarks, and notes in your Pearson  eText  to study how you  like.

NOTE: This ISBN is for the Pearson  eText  access card.  Pearson  eText  is a fully digital delivery of Pearson content. Before purchasing, check that you have the correct ISBN. To register for and use Pearson  eText, you may also need a course invite link, which your instructor will provide. Follow the instructions provided on the access card to learn  more.

Author Biography

Amy S. Kinser, Esq., Series Editor, holds a BA degree in chemistry with a business minor from Indiana University, and a JD 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 Director of Computer Skills and senior lecturer at the Kelley School of Business at Indiana University. She loves spending time with her two sons, Aidan and J. Matthew, and her husband, J. Eric.

Kristyn A. Jacobson  holds an MS degree in education from the University of Wisconsin-La Crosse and a BS degree 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 16 years. She also serves as the curriculum coordinator for Microsoft Excel^™  beginning, intermediate, and advanced level courses for the college. In addition to teaching, Kristyn enjoys providing trainings to businesses on the Microsoft Office Suite, including Microsoft 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  received his BS degree in biology from Indiana University and his MS 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 he’s not teaching, he enjoys experimenting with new technologies, traveling, and hiking with his family.

Brant P. Moriarity  earned a BA degree in religious studies/philosophy and an MS degree in information systems at Indiana University. He is a senior lecturer at 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 and custom database application development to small businesses and nonprofit organizations.

Jennifer Paige Nightingale, associate professor at Slippery Rock University of Pennsylvania, has taught information systems management since 2000. Before joining Slippery Rock University, she spent 15 years in industry with a focus in management and training. Her research expertise is in instructional technology, using technology as a teaching tool, and the impact of instructional technologies on student learning. She has earned numerous teaching and research honors and awards, and holds an EdD in instructional technology and two MS degrees in information systems management and education from Duquesne University, as well as a BA degree from the University of Pittsburgh.

Table of Contents

COMMON FEATURES
1. Understanding the Common Features of Microsoft Office

EXCEL

EXCEL BUSINESS UNIT 1: UNDERSTANDING THE FUNDAMENTALS
1. Create, Navigate, Work with, and Print Worksheets
2. Formats, Functions, and Formulas
Excel Business Unit 1 Capstone

EXCEL BUSINESS UNIT 2: CONDUCTING BUSINESS ANALYSIS
3. Cell References, Named Ranges, and Functions
4. Effective Charts
Excel Business Unit 2 Capstone

EXCEL BUSINESS UNIT 3: INTEGRATING COMPLEX FUNCTIONS INTO BUSINESS ANALYSIS
5. Complex Logical and Retrieval Functions
6. Integrating Complex Functions into Business Analysis
Excel Business Unit 3 Capstone

EXCEL BUSINESS UNIT 4: BUILD AN APPLICATION WITH MULTIPLE WORKSHEETS AND WORKBOOKS
7. Multiple Worksheets, Workbooks, and Templates
8. Building an Application with Multiple Worksheets and Workbooks
Excel Business Unit 4 Capstone

EXCEL BUSINESS UNIT 5: MANIPULATING DATA SETS FOR DECISION MAKING
9. Organize, Import, Export, and Cleanse Data Sets
10. Data Tables, Scenario Manager, and Solver
Excel Business Unit 5 Capstone

EXCEL BUSINESS UNIT 6: BUILDING FINANCIAL AND STATISTICAL MODELS
11. Loan Amortization, Investment Analysis, and Asset Depreciation
12. Business Statistics and Regression Analysis
Excel Business Unit 6 Capstone

EXCEL BUSINESS UNIT 7
13. The Excel Data Model and Business Intelligence
14. Visual Basic for Applications--VBA
Excel Business Unit 7 Capstone

Appendices
A. Leveraging Microsoft's Power Business Intelligence (‘BI') Desktop Suite
B. Mac Appendix
C. MOS Core
D. MOS Expert