Microsoft® Excel 2010: A Case Approach, Complete

Valutazione media 2
( su 2 valutazioni fornite da GoodReads )
 
9780077331368: Microsoft® Excel 2010: A Case Approach, Complete

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 O’Leary is a professor of IS at ASU, and has written many books on Computing and Information Systems.

Linda O’Leary is a professional trainer in Computing. She has developed training manuals for large corporations, presented seminars on a wide variety of application programs, and has co-authored severalbooks with her husband, Tim.

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

Summarising 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

Customising 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

Analysing 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.

I migliori risultati di ricerca su AbeBooks

1.

Timothy OLeary and Linda I. OLeary
ISBN 10: 0077331362 ISBN 13: 9780077331368
Nuovi Quantità: 1
Da
Castle Rock
(Pittsford, NY, U.S.A.)
Valutazione libreria
[?]

Descrizione libro Condizione libro: Brand New. Book Condition: Brand New. Codice libro della libreria 97800773313681.0

Maggiori informazioni su questa libreria | Fare una domanda alla libreria

Compra nuovo
EUR 14,07
Convertire valuta

Aggiungere al carrello

Spese di spedizione: EUR 22,88
Da: U.S.A. a: Italia
Destinazione, tempi e costi

2.

Linda O'Leary; Timothy O'Leary
Editore: McGraw-Hill/Irwin (2011)
ISBN 10: 0077331362 ISBN 13: 9780077331368
Nuovi Paperback Quantità: 1
Da
Irish Booksellers
(Rumford, ME, U.S.A.)
Valutazione libreria
[?]

Descrizione libro McGraw-Hill/Irwin, 2011. Paperback. Condizione libro: New. book. Codice libro della libreria 0077331362

Maggiori informazioni su questa libreria | Fare una domanda alla libreria

Compra nuovo
EUR 26,34
Convertire valuta

Aggiungere al carrello

Spese di spedizione: EUR 10,98
Da: U.S.A. a: Italia
Destinazione, tempi e costi

3.

O'Leary, Timothy, O'Leary, Linda
Editore: McGraw-Hill/Irwin (2011)
ISBN 10: 0077331362 ISBN 13: 9780077331368
Nuovi Paperback Quantità: 2
Da
Murray Media
(North Miami Beach, FL, U.S.A.)
Valutazione libreria
[?]

Descrizione libro McGraw-Hill/Irwin, 2011. Paperback. Condizione libro: New. Codice libro della libreria P110077331362

Maggiori informazioni su questa libreria | Fare una domanda alla libreria

Compra nuovo
EUR 38,76
Convertire valuta

Aggiungere al carrello

Spese di spedizione: EUR 18,29
Da: U.S.A. a: Italia
Destinazione, tempi e costi

4.

O'Leary, Timothy; O'Leary, Linda
Editore: McGraw-Hill/Irwin
ISBN 10: 0077331362 ISBN 13: 9780077331368
Nuovi PAPERBACK Quantità: 1
Da
Cloud 9 Books
(West Palm Beach, FL, U.S.A.)
Valutazione libreria
[?]

Descrizione libro McGraw-Hill/Irwin. PAPERBACK. Condizione libro: New. 0077331362 New Condition. Codice libro della libreria NEW6.0035717

Maggiori informazioni su questa libreria | Fare una domanda alla libreria

Compra nuovo
EUR 47,12
Convertire valuta

Aggiungere al carrello

Spese di spedizione: EUR 36,59
Da: U.S.A. a: Italia
Destinazione, tempi e costi