Description
Book SynopsisAbout 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 Colleg
Table of Contents
Table of Contents 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
