Your Office
$186.65
- Description
- Additional information
Description
For courses covering Microsoft® Excel™. Ideal for business courses.
Real-world problem-solving for business and beyond
Your Office: Microsoft Office 365, Excel 2019 Comprehensive prepares students to apply both technical and soft skills in real business settings. Hands-on technical content together with realistic business cases help students use Microsoft Excel as a decision-making tool for business areas such as finance and accounting, production and operations, and sales and marketing. Chapters are grouped by business units to align the text with AACSB requirements. Updated for Office 365, the 2019 edition includes 2019 MOS objectives, new resources for Mac users, and improved links between cases within the text and MyLab IT Grader projects.
Hallmark features of this title
Case-based learning
- Students complete a chapter-by-chapter Global Business Scenario (with case steps in blue boxes) challenged by critical-thinking questions.
- Chapter-ending Practice, Problem Solve and Perform Cases reinforce learning, as do Capstone cases.
Real-world focus
- Advice boxes simulate a manager’s best-practice advice; graduates share experience in Real-world Success features; and icons locate content on a specific business area or soft skill.
- Desktop Power BI suite Appendix; Get & Transform; and comprehensive functions review included.
Study Aids
- The MOS Certification Guide reflects 2019 objectives and locates them in the text; a Mac Appendix and Mac Troubleshooting guide support Mac users.
- Chapter objectives and Visual Summaries reinforce chapter objectives.
New and updated features of this title
- UPDATED: Detailed information on the updated ribbon helps students navigate Office 365 effectively.
- NEW: A more accessible design helps learners use the text more efficiently.
COMMON FEATURES
- Understanding the Common Features of Microsoft Office
EXCEL
EXCEL BUSINESS UNIT 1: UNDERSTANDING THE FUNDAMENTALS
- Create, Navigate, Work with, and Print Worksheets
- Formats, Functions, and Formulas
- Excel Business Unit 1 Capstone
EXCEL BUSINESS UNIT 2: CONDUCTING BUSINESS ANALYSIS
- Cell References, Named Ranges, and Functions
- Effective Charts
- Excel Business Unit 2 Capstone
EXCEL BUSINESS UNIT 3: INTEGRATING COMPLEX FUNCTIONS INTO BUSINESS ANALYSIS
- Complex Logical and Retrieval Functions
- Integrating Complex Functions into Business Analysis
- Excel Business Unit 3 Capstone
EXCEL BUSINESS UNIT 4: BUILD AN APPLICATION WITH MULTIPLE WORKSHEETS AND WORKBOOKS
- Multiple Worksheets, Workbooks, and Templates
- Building an Application with Multiple Worksheets and Workbooks
- Excel Business Unit 4 Capstone
EXCEL BUSINESS UNIT 5: MANIPULATING DATA SETS FOR DECISION MAKING
- Organize, Import, Export, and Cleanse Data Sets
- Data Tables, Scenario Manager, and Solver
- Excel Business Unit 5 Capstone
EXCEL BUSINESS UNIT 6: BUILDING FINANCIAL AND STATISTICAL MODELS
- Loan Amortization, Investment Analysis, and Asset Depreciation
- Business Statistics and Regression Analysis
- Excel Business Unit 6 Capstone
EXCEL BUSINESS UNIT 7
- The Excel Data Model and Business Intelligence
- Visual Basic for Applications–VBA
- Excel Business Unit 7 Capstone
Appendices
- Leveraging Microsoft’s Power Business Intelligence (‘BI’) Desktop Suite
- Mac Appendix
- MOS Core
- MOS Expert
About our authors
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.
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.
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.
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.
Now live! SUMMER 2020 DIGITAL UPDATE for digital content
Microsoft Office 365 updates are reflected in the eText and associated MyLab for this title. Instructors, to learn more, contact your Pearson representative.
For courses covering Microsoft® Excel™. Ideal for business courses.
Real-world problem-solving for business and beyond
Your Office: Microsoft Office 365, Excel 2019 Comprehensive prepares students to apply both technical and soft skills in real business settings. Hands-¿on technical content together with realistic business cases help students use Microsoft Excel as a decision-making tool for business areas such as finance and accounting, production and operations, and sales and marketing. Chapters are grouped by business units to align the text with AACSB requirements. Updated for Office 365, the 2019 edition includes 2019 MOS objectives, new resources for Mac users, and improved links between cases within the text and MyLab IT Grader projects.
Also available with MyLab IT
By combining trusted author content with digital tools and a flexible platform, MyLab personalizes the learning experience and improves results for each student. MyLab IT 2019 delivers trusted content and resources through an expansive course materials library, including new easy-to-use Prebuilt Learning Modules that promote student success. Through an authentic learning experience, students become sharp critical thinkers and proficient in Microsoft Office, developing essential skills employers seek.
Note: You are purchasing a standalone product; MyLab IT does not come packaged with this content. Students, if interested in purchasing this title with MyLab IT, ask your instructor to confirm the correct package ISBN and Course ID. Instructors, contact your Pearson representative for more information.
If you would like to purchase both the physical text and MyLab IT, search for:
0135825938 / 9780135825938 Your Office: Microsoft Excel 2019 Comprehensive, 1/e + MyLab IT w/ Pearson eText, 1/e
Package consists of:
- 0135394724 / 9780135394724 Your Office: Microsoft Office 365, Excel 2019 Comprehensive, 1/e
- 0135440343 / 9780135440346 MyLab IT with Pearson eText — Access Card — for Your Office: Microsoft 2019 Comprehensive, 1/e
Additional information
Dimensions | 1.30 × 8.50 × 10.80 in |
---|---|
Imprint | |
Format | |
ISBN-13 | |
ISBN-10 | |
Author | Amy S. Kinser, Brant Moriarity, Eric Kinser, Jennifer Paige Nightingale, Kristyn Jacobson |
Subjects | higher education, information technology, business and economics, IT / MIS, Computer Applications |