skip to content
Introduction to Excel Preview this item
ClosePreview this item

Introduction to Excel

Author: David C Kuncicky; Ronald W Larsen
Publisher: Upper Saddle River, NJ : Pearson Prentice Hall, ©2006.
Series: ESource--the Prentice Hall engineering source.
Edition/Format:   Print book : English : 3rd edView all editions and formats

Provides a comprehensive, customizable introductory engineering and computing library. Featuring over 25 modules and growing, this title allows professors to fully customize their textbooks through  Read more...


(not yet rated) 0 with reviews - Be the first.

More like this


Find a copy in the library

&AllPage.SpinnerRetrieving; Finding libraries that hold this item...


Document Type: Book
All Authors / Contributors: David C Kuncicky; Ronald W Larsen
ISBN: 0131464701 9780131464704
OCLC Number: 58451780
Notes: Includes index.
Description: xxi, 266 pages : illustrations ; 26 cm.
Contents: 1Microsoft Excel Basics1.1 Introduction to Worksheets1.2 How to Use This Book1.3 Typographic Conventions Used in This Book1.3.1 Selection with the Mouse1.3.2 Multiple Selections1.3.3 Multiple Keystrokes1.3.4 Literal Expressions1.3.5 Key Terms1.4 Understanding the Excel 2003 Screen1.4.1 Title Bar1.4.2 Menu Bar1.4.3 Toolbars1.4.4 Customizing Toolbars1.4.5 Formula Bar1.4.6 Task Pane1.4.7 Workbook Window1.4.8 Sheet Tabs1.4.9 Scrollbars1.4.10 Status Bar1.5 Getting Help1.5.1 Choosing from the Table of Contents1.5.2 Searching the Help Section1.5.3 Using the Office Assistant1.5.4 Learning from the Tip of the Day1.5.5 Accessing Help from the World Wide Web1.6 Manipulating Windows1.6.1 Minimize Control Button1.6.2 Restore/Maximize1.6.3 Close Control Button1.7 Creating and Saving Worksheets and Workbooks1.7.1 Creating a New Workbook1.7.2 Opening an Existing Workbook1.7.3 Creating a New Worksheet1.7.4 Introduction to Templates1.7.5 Opening Workbooks with Macros1.7.6 Saving Documents1.7.7 The AutoRecover Feature1.7.8 Naming Documents1.8 Moving around a Worksheet1.8.1 Movement by Using the Keyboard1.8.2 Movement by Using the Mouse1.8.3 Movement by Using the Go To Dialog Box1.9 Selecting a Region.1.9.1 Selection by Using Cell References1.9.2 Selection by Using the Mouse1.9.3 Selection by Using the Keyboard1.10 Cutting, Moving, Copying, and Pasting1.10.1 Cutting a Region1.10.2 Moving a Region1.10.3 Copying a Region1.11 Inserting and Deleting Cells1.11.1 Deleting Cells1.11.2 Clearing Cells1.11.3 Inserting Cells1.12 Shortcut Keys1.13 Finding and Correcting Mistakes1.13.1 Undoing Mistakes1.13.2 Checking Spelling1.13.3 The AutoCorrect Feature1.14 Printing1.14.1 Setting the Print Area1.14.2 Previewing a Worksheet1.14.3 Printing a Worksheet2Entering and Formatting Data2.1 Introduction to Entering and Formatting Data2.2 Entering Data2.2.1 Entering Numeric Data2.2.2 Entering Text Data2.2.3 Entering Date and Time Data2.3 Using Fill Handles2.3.1 Using the Fill Handle with the Left Mouse Button to Copy Cells2.3.2 Using the Fill Handle with the Left Mouse Button-More Options2.3.3. Creating a Linear Series with a Non-Unity Increment2.3.4 Using the Fill Handle with the Right Mouse Button for Additional Options2.4 Formatting for Appearance2.4.1 Changing the Appearance of Cells2.4.2 Changing the Appearance of Columns and Rows2.4.3 Changing the Appearance of Entire Worksheets2.5 Formatting Tables2.5.1 Table Autoformats2.5.2 Sorting Tables2.6 Conditional Formatting3Formulas and Functions3.1 Introduction3.2 Referencing Cells and Cell Ranges3.2.1 Cell References3.2.2 Referencing a Range of Cells3.2.3 Naming a Cell or Range of Cells3.3 Creating and Using Formulas.3.3.1 Formula Syntax3.3.2 Arithmetic Operators and Operator Precedence3.4 Using Excel's Built-In Functions3.4.1 Examples of Statistical Functions3.4.2 Examples of Trigonomic Functions3.4.3 Examples of Matrix Operations3.4.4 Examples of Financial Functions3.5 Absolute and Relative Cell References3.6 Error Messages3.7 Debugging Excel Worksheets3.7.1 Debugging by Using Cell Selection3.7.2 Debugging by Using Tracing3.8 Using Macros to Automate Computations3.8.1 Recording a Macro3.8.2 Executing a Macro3.8.3 Editing a Macro4Working with Charts4.1 Introduction4.2 Using the Chart Wizard to Create a Chart4.2.1 Creating an XY Scatter Plot4.2.2 Creating a Line Chart4.3 Creating a Chart by Using a Shortcut Key4.4 Formatting Charts4.4.1 Formatting Markers and Lines4.4.2 Chart Titles and Labels4.4.3 Formatting the Plot Area4.4.4 Formatting Axes4.4.5 Formatting the Legend4.4.6 Formatting Gridlines4.5 Previewing and Printing Charts4.6 Adding Data to Charts4.6.1 Adding Data to an Existing Series4.6.2 Adding a Data Series to an XY Scatter Chart4.7 Charting Features Useful to Engineers4.7.1 Adding a Trendline to a Chart4.7.2 Adding Error Bars to a Chart4.7.3 Using a Log Scale Axis4.7.4 Using a Secondary Axis5Performing Data Analysis5.1 Introduction5.2 Using the Analysis ToolPak5.3 Creating a Histogram5.4 Providing Descriptive Statistics5.5 Computing a Correlation5.6 Performing a Linear Regression5.7 Trend Analysis.5.7.1 Trend Analysis with Data Series5.7.2 Trend-Analysis Functions5.7.3 Trend Analysis for Charts5.8 Using the Goal Seeker5.9 Using Solver for Optimization Problems5.9.1 Introduction to Microsoft Excel Solver5.9.2 Setting Up an Optimization Problem in Excel5.9.3 Linear Optimization Example5.9.4 Nonlinear Optimization Example6Database Management within Excel6.1 Introduction6.1.1 Database Terminology6.2 Creating Databases6.3 Entering Data6.4 Sorting a Database6.5 Searching and Filtering6.5.1 Filtering with the Data Entry Form6.5.2 Using the AutoFilter Function6.5.3 Using the Custom AutoFilter6.5.4 Using Wild-card Characters6.5.5 Using the Advanced Filter Function6.5.6 Logic within Rows6.5.7 Logic between Rows7Collaborating with Other Engineers7.1 The Collaborative Design Process7.1.1 Microsoft Excel and Collaboration7.2 Tracking Changes7.2.1 Highlighting Changes7.2.2 Creating an Identity7.2.3 Incorporating or Rejecting Revisions7.3 Adding Comments to a Document7.4 Maintaining Shared Workbooks7.4.1 Sharing a Workbook7.4.2 Keeping a Change History7.4.3 Timed Updates7.4.4 Managing Conflicts7.4.5 Personal Views7.4.6 Merging Workbooks7.4.7 Viewing the History of Changes7.4.8 Restrictions for Shared Workbooks7.5 Password Protection7.5.1 Open Protection7.5.2 Write Protection7.5.3 Sheet Protection7.6 Importing and Exporting Data from External File Formats.7.6.1 Importing by Using the File Open Option7.6.2 Importing Text Data by Using the Text Import Wizard8Excel and the World Wide Web8.1 Engineering and the Internet8.2 Accessing the World Wide Web from within Excel8.3 Web Sites Related to Microsoft Excel8.4 Retrieving Data by Using a Web Query8.5 Accessing Excel Files on the Web8.6 Creating Hyperlinks within a Worksheet8.7 Converting a Worksheet to a Web PageAppendix AIndex
Series Title: ESource--the Prentice Hall engineering source.
Responsibility: David C. Kuncicky and Ronald Larsen.


User-contributed reviews
Retrieving GoodReads reviews...
Retrieving DOGObooks reviews...


Be the first.
Confirm this request

You may have already requested this item. Please select Ok if you would like to proceed with this request anyway.

Linked Data

Primary Entity

<> # Introduction to Excel
    a schema:CreativeWork, schema:Book ;
   library:oclcnum "58451780" ;
   library:placeOfPublication <> ;
   library:placeOfPublication <> ; # Upper Saddle River, NJ
   schema:about <> ; # Business--Computer programs
   schema:about <> ; # Microsoft Excel (Computer file)
   schema:about <> ; # Electronic spreadsheets
   schema:about <> ; # Microsoft Excel (Computer file)
   schema:about <> ; # Business--Computer programs
   schema:about <> ;
   schema:bookEdition "3rd ed." ;
   schema:bookFormat bgn:PrintBook ;
   schema:contributor <> ; # Ronald W. Larsen
   schema:copyrightYear "2006" ;
   schema:creator <> ; # David C. Kuncicky
   schema:datePublished "2006" ;
   schema:exampleOfWork <> ;
   schema:inLanguage "en" ;
   schema:isPartOf <> ; # ESource--the Prentice Hall engineering source.
   schema:name "Introduction to Excel"@en ;
   schema:productID "58451780" ;
   schema:publication <> ;
   schema:publisher <> ; # Pearson Prentice Hall
   schema:workExample <> ;
   wdrs:describedby <> ;

Related Entities

<> # Pearson Prentice Hall
    a bgn:Agent ;
   schema:name "Pearson Prentice Hall" ;

<> # Microsoft Excel (Computer file)
    a schema:CreativeWork ;
   schema:name "Microsoft Excel (Computer file)" ;

<> # Upper Saddle River, NJ
    a schema:Place ;
   schema:name "Upper Saddle River, NJ" ;

<> # ESource--the Prentice Hall engineering source.
    a bgn:PublicationSeries ;
   schema:hasPart <> ; # Introduction to Excel
   schema:name "ESource--the Prentice Hall engineering source." ;
   schema:name "ESource--the Prentice Hall engineering source" ;

<> # Business--Computer programs
    a schema:Intangible ;
   schema:name "Business--Computer programs"@en ;

<> # Microsoft Excel (Computer file)
    a schema:CreativeWork ;
   schema:name "Microsoft Excel (Computer file)" ;

<> # Business--Computer programs
    a schema:Intangible ;
   schema:name "Business--Computer programs"@en ;

<> # Electronic spreadsheets
    a schema:Intangible ;
   schema:name "Electronic spreadsheets"@en ;

<> # David C. Kuncicky
    a schema:Person ;
   schema:familyName "Kuncicky" ;
   schema:givenName "David C." ;
   schema:name "David C. Kuncicky" ;

<> # Ronald W. Larsen
    a schema:Person ;
   schema:familyName "Larsen" ;
   schema:givenName "Ronald W." ;
   schema:name "Ronald W. Larsen" ;

    a schema:ProductModel ;
   schema:isbn "0131464701" ;
   schema:isbn "9780131464704" ;

Content-negotiable representations

Close Window

Please sign in to WorldCat 

Don't have an account? You can easily create a free account.