Articoli correlati a The I-Series Microsoft Office Excel 2003 Complete

The I-Series Microsoft Office Excel 2003 Complete - Brossura

Haag, Stephen; Perry, James T

 
9780072830781: The I-Series Microsoft Office Excel 2003 Complete

Sinossi

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.

Le informazioni nella sezione "Riassunto" possono far riferimento a edizioni diverse di questo titolo.

Contenuti

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

Chapter 9 Using Data Tables and Scenarios

Session 9.1 Creating and Using Data Tables

Session 9.2 Using Scenarios

Chapter 10 Using the Solver

Session 10.1 Using Goal Seek

Session 10.2 Solving Complex Problems

Chapter 11 Importing Data

Session 11.1 Importing Text Data and Web Data

Session 11.2 Using Queries to Import Database Data

Chapter 12 Automating Applications with Visual Basic

Session 12.1 Creating Macros

Session 12.2 Writing Sub Procedures and Custom Functions

Product Description

Book by HaagStephen PerryJames

Le informazioni nella sezione "Su questo libro" possono far riferimento a edizioni diverse di questo titolo.