Synopses & Reviews
The I-Series leads the student through clear, error-free, and unambiguous steps to accomplish tasks that produce a finished document, work sheet or database table. The approach is not simply results-oriented; teaching how to accomplish a task is not enough for complete understanding and mastery. Prior to introducing steps, the authors discuss why each step is important and what roll all the steps play in the overall plan for creating a document, workbook or database. The I-Series Applications textbooks strongly emphasize that students learn and master applications skills by being actively engaged by doing.
About the Author
Stephen Haag is the Associate Dean of Graduate Programs and Director of the MBA program in the Daniels College of Business at the University of Denver. Prior to being Associate Dean, Stephen served as Chair of the Department of Information Technology and Electronic Commerce in the Daniels College of Business at the University of Denver. Stephen holds a B.B.A. and M.B.A. from West Texas State University and a Ph.D. from the University of Texas at Arlington. Stephen has been teaching in the classroom since 1982 and publishing books since 1984.
Stephen is the coauthor of numerous books including "Interactions: Teaching English as a Second Language" (with his mother and father), "Information Technology: Tomorrow's Advantage Today" (with Peter Keen), "Excelling in Finance," and more than 40 books within the "I-Series." He has also written numberous articles appearing in such journals as Communications of the ACM, Soio-Economic Planning Siences, the International Journal of Systems Science, Managerial and Decision Economics, Applied Economics, and the Australian Journal of Management.
Table of Contents
Chapter 1 Creating Worksheets for Decision Makers
Session 1.2 Getting Started
Session 1.2 Entering Data, Saving Workbooks, and Printing Worksheets
Chapter 2 Planning and Creating a Worksheet
Session 2.1 Writing Formulas, Using Functions, and Copying and Moving Cell Contents
Session 2.2 Printing and Documenting a Worksheet
Chapter 3 Formatting a Worksheet
Session 3.1 Aligning Data and Applying Character Formats
Session 3.2 Advanced Formatting
Chapter 4 Creating Charts
Session 4.1 Creating an Excel Chart
Session 4.2 Modifying and Improving a Chart
Chapter 5 Exploring Excel's List Features
Session 5.1 Creating and Using Lists
Session 5.2 Creating Filters and Subtotals
Session 5.3 Pivot Tables
Chapter 6 Employing Functions
Session 6.1 Using Data Validation, Names and IF and Index Functions
Session 6.2 Using Financial and Date Functions
Chapter 7 Developing Multiple Worksheet and Workbook Applications
Session 7.1 Working with Multiple Worksheets
Session 7.2 Working with Multiple Workbooks
Chapter 8 Auditing, Sharing, Protecting, and Publishing Workbooks
Session 8.1 Auditing a Workbook
Session 8.2 Sharing a Workbook and Tracking Changes
Session 8.3 Protecting and Publishing Workbooks