Articoli correlati a Microsoft® Excel 2010: A Case Approach, Complete

Microsoft® Excel 2010: A Case Approach, Complete - Brossura

 
9780071221269: Microsoft® Excel 2010: A Case Approach, Complete
Vedi tutte le copie di questo ISBN:
 
 
Timothy and Linda O'Leary and the Computer Information Technology Team at McGraw-Hill Higher Education offer your students a fully integrated learning program with time-tested quality and reliability. Office 2010: A Case Approach offers running case study throughout the text to help students understand the material in a consistent, relevant environment. Through this theme of “Making Office Relevant,” this text helps students understand why they need this course and these skills. Student success is assured through clear step-by-step instruction, plentiful screen captures and conceptual explanations. Each Lab, designed to be covered in 1 hour of class time, combines conceptual coverage with detailed software-specific instructions. Each Lab opens with a running case study that highlights real-world applications of each software program and leads students from problem to solution. The O'Leary Series helps students learn specific applications skills along with those that cross all Office applications, which is especially important in mastering this version of Office. The O'Leary Series also correlates with SimNet Online, our online training and assessment program for Office 2010.

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

L'autore:
Tim and Linda O’Leary live in the American Southwest and spend much of their time engaging instructors and students in conversation about learning. In fact, they have been talking about learning for over 25 years. Something in those early conversations convinced them to write a book, to bring their interest in the learning process to the printed page. Today, they are as concerned as ever about learning, about technology, and about the challenges of presenting material in new ways, in terms of both content and method of delivery. A powerful and creative team, Tim combines his 30 years of classroom teaching experience with Linda’s background as a consultant and corporate trainer. Tim has taught courses at Stark Technical College in Canton, Ohio, and at Rochester Institute of Technology in upstate New York, and is currently a professor emeritus at Arizona State University in Tempe, Arizona. Linda offered her expertise at ASU for several years as an academic advisor. She also presented and developed materials for major corporations such as Motorola, Intel, Honeywell, and AT&T, as well as various community colleges in the Phoenix area.Tim and Linda have talked to and taught numerous students, all of them with a desire to learn something about computers and applications that make their lives easier, more interesting, and more productive.
Contenuti:

O'Leary; Excel 2010: A Case Approach

Lab 1 Creating and Editing a Worksheet

Creating New Worksheets

Developing a Worksheet

Exploring the Excel Window

Exploring the Workbook Window

Moving around the Worksheet

Entering and Editing Data

Adding Text Entries

Clearing an Entry

Editing an Entry

Using AutoCorrect

Adding Number Entries

Modifying Column Widths

Dragging the Column Boundary

Using a Specified Value

Using AutoFit

Saving, Closing, and Opening Workbooks

Saving a New Workbook

Closing a Workbook

Opening an Existing Workbook

Using Proofing Tools

Checking Spelling

Using the Thesaurus

Copying and Pasting Cell Contents

Copying and Pasting Data

Selecting a Range

Using the Fill Handle

Inserting Copied Cell Content

Cutting and Pasting Data

Creating Formulas

Entering Formulas

Copying Formulas with Relative References

Summarizing Data

Using Pointing to Enter a Formula

Recalculating the Worksheet

Inserting and Deleting Rows and Columns

Inserting Rows

Deleting Columns

Formatting Cells and Cell Content

Changing Cell Alignment

Indenting Cell Content

Merging Cells

Changing Fonts and Font Sizes

Applying Character Effects

Clearing Formats

Using Format Painter

Formatting Numbers

Adding Font Color

Adding Fill Color

Adding and Removing Cell Borders

Hiding and Unhiding Rows and Columns

Creating a Basic Chart

Specifying Data to Chart

Selecting Chart Type

Formatting Values as a Date

Documenting a Workbook

Setting File Properties

Previewing and Printing a Worksheet

Previewing the Worksheet

Printing the Worksheet

Displaying and Printing Formulas

Changing Worksheet Orientation and Scaling Content

Lab 2 Enhancing the Worksheet with Graphics and Charts

Inserting and Formatting Illustrations

Inserting a Picture from Files

Inserting an Illustration from Clip Art

Deleting a Graphic

Sizing a Graphic

Enhancing the Graphic with a Picture Style

Using Themes

Selecting a Theme

Customizing a Theme

Saving a Custom Theme

Using Cell Styles

Applying Themed Cell Styles

Applying Heading and Total Cell Styles

Modifying Cell Styles

Applying a Number Cell Style

Creating Charts

Selecting the Data to Chart

Selecting the Chart Type

Moving and Sizing a Chart

Applying Chart Layouts

Applying Chart Styles

Adding Chart Labels

Changing the Chart Location

Creating a Multiple Data Series Chart

Changing the Data Source

Changing the Chart Type: Line, Bar, Area, Stacked

Moving the Legend

Formatting Chart Elements

Adding and Formatting Data Labels

Changing Worksheet Data

Creating and Formatting a Pie Chart

Selecting the Pie Chart Data

Adding Titles and Data Labels

Exploding and Rotating the Pie

Applying Color and Texture

Preparing the Worksheet and Charts for Printing

Scaling the Worksheet

Adding Predefined Headers and Footers

Printing the Entire Workbook

Aligning a Sheet on a Page

Lab 3 Managing and Analyzing a Workbook

Correcting Formula Errors

Identifying Formula Errors

Using Absolute References

Creating a Second Worksheet

Copying Worksheets

Renaming Sheets and Coloring Sheet Tabs

Filling a Series

Creating a 3-D Reference

Hiding Gridlines and Headings

Deleting and Moving Worksheets

Finding and Replacing Information

Finding Information

Replacing Information

Saving to a New Folder

Managing Large Worksheets

Going to a Specific Cell

Splitting Windows

Freezing Panes

Watching Cells

Forecasting Values

Performing What-If Analysis Manually

Using Goal Seek

Using Conditional Formatting

Creating Cell Rules

Using Rules Manager

Applying Top-Bottom Rules, Data Bars, Color Scales and Icon Set Conditional Formatting

Using Sparklines

Creating a Sparkline

Enhancing a Sparkline

Customizing Print Settings

Controlling Page Breaks

Adding a Custom Header and Footer

Printing Selected Sheets

Printing Selected Areas

Working Together 1: Linking and Embedding between Word 2010 and Excel 2010

Sharing Information between Applications

Copying between Excel and Word

Linking between Applications

Updating a Linked Object

Editing Links

Embedding an Object

Updating an Embedded Object

Deciding When to Link or Embed Objects

Lab 4 Using Solver, Creating Templates, and Evaluating Scenarios

Analyzing the Worksheet

Using Solver

Creating an Answer Report

Creating a Custom Template

Protecting the Worksheet

Protecting the Workbook

Saving the Template

Using the Template

Working with Multiple Workbooks

Opening a Second Workbook File

Arranging Workbook Windows

Hiding Workbooks and Worksheets

Arranging Worksheet Windows

Linking Workbooks

Updating Linked Data

Using Scenarios

Creating Scenarios

Showing and Editing Scenarios

Creating a Scenario Report

Creating SmartArt

Adding Shapes to SmartArt

Adding text to a Smart Art Graphic

Formatting the SmartArt Graphic

Unhiding Sheets and Workbooks

Lab 5 Using Data Tables, Using Lookup and If Functions, and Designing Forms

Calculating a Loan Payment

Using the PMT Function

Creating a Data Table

Setting Up the Data Table

Defining the Data Table

Adding Shapes

Creating a Text Box

Adding a Shape Style

Creating an Arrow Shape

Deleting Shapes

Rotating Objects and Sizing Elements

Splitting Cell content

Looking Up Values in a List

Creating a Form

Using Named Ranges

Naming Cell References

Using Name Manager

Using the IF Function

Using a Drop-Down List

Creating a Drop-Down List

Testing a Drop-Down List

Finalizing the Form

Adding Comments

Editing Comments

Viewing All Comments

Preparing the Workbook for Use

Protecting Worksheet Elements

Marking a Workbook as Final

Adding a Digital Signature

Protecting a Workbook File

Lab 6 Creating and Working with Tables

Creating a Table

Adding Field Names

Defining the Table Range

Adding and Editing Data in a Table

Entering Records

Inserting Rows

Using and Editing a Hyperlink Entry

Modifying a Table

Inserting Table Columns

Inserting Table Rows

Formatting the Table

Applying Table Styles

Using Special Cell Formats

Ensuring Data Integrity

Restricting Data Using Data Validation

Testing Data Validation

Sorting Data

Sorting on a Single Field

Sorting on Multiple Fields

Sorting on Cell Attributes

Filtering Data

Filtering on a Single Criterion

Filtering on Multiple Criteria

Creating a Custom Filter

Filtering for Unique Values and Removing Duplicates

Summarizing Data

Displaying a Total Row

Creating a Calculated Column

Grouping and Outlining Data

Grouping Data

Grouping Data and Calculating Subtotals

Printing a Summary Report

Creating a PivotTable Report

Creating a PivotChart Report

Hyperlinking Workbook Files

Creating a Hyperlink to another Workbook

Changing the Hyperlink ScreenTip

Using the Hyperlink to Open the Workbook

Restoring the Table

Working Together 2: Importing Access Data, Sharing Workbooks, and Creating a Web Page

Importing Data

Importing Access Table Data to Excel

Analyzing the Table

Collaborating on Worksheet Data

Comparing and Merging Documents

Accepting and Rejecting Changes

Creating a Web page

Previewing the Web Page

Adding a Worksheet Background

Saving the Worksheet as a Web Page

Making the Web Page Public

Adding a Watermark

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

  • EditoreMcGraw-Hill Education
  • Data di pubblicazione2011
  • ISBN 10 0071221263
  • ISBN 13 9780071221269
  • RilegaturaCopertina flessibile
  • Numero di pagine576

Spese di spedizione: EUR 19,00
Da: Spagna a: Italia

Destinazione, tempi e costi

Aggiungere al carrello

Altre edizioni note dello stesso titolo

9780077331368: Microsoft® Excel 2010: A Case Approach, Complete

Edizione in evidenza

ISBN 10:  ISBN 13:  9780077331368
Casa editrice: McGraw-Hill Education, 2011
Brossura

I migliori risultati di ricerca su AbeBooks

Foto dell'editore

O'leary
ISBN 10: 0071221263 ISBN 13: 9780071221269
Antico o usato Brossura Quantità: 1
Da:
Iridium_Books
(DH, SE, Spagna)
Valutazione libreria

Descrizione libro Condizione: Muy Bueno / Very Good. Codice articolo 100000000232432

Informazioni sul venditore | Contatta il venditore

Compra usato
EUR 545,29
Convertire valuta

Aggiungere al carrello

Spese di spedizione: EUR 19,00
Da: Spagna a: Italia
Destinazione, tempi e costi