skip to content
Special edition using Microsoft Office Excel 2007. Preview this item
ClosePreview this item
Checking...

Special edition using Microsoft Office Excel 2007.

Author: Bill Jelen
Publisher: Indianapolis, Ind. : Que/Sams ; London : Pearson Education [distributor], 2007.
Edition/Format:   Print book : EnglishView all editions and formats
Summary:

Explains the most important features of Excel 2007 in an easy-to-understand format. Excel's backbone is its formulas and functions. Master those and you will master your spreadsheets. This book shows  Read more...

Rating:

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

Subjects
More like this

 

Find a copy in the library

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

Details

Document Type: Book
All Authors / Contributors: Bill Jelen
ISBN: 9780789736116 078973611X
OCLC Number: 123796009
Description: xxiii, 1048 pages : illustrations ; 24 cm
Contents: IntroductionI Mastering the New User Interface1 Introducing the Ribbon User Interface . . . . . . . . . . . . . 212 The Quick Access Toolbar . . . . . . . . . . . . . . . . . . . . . . . . . . . . 413 The Mini Toolbar and Other U.I. Improvements . . . 534 Keyboard Shortcuts . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 655 Galleries, Live Preview, and Themes . . . . . . . . . . . . . . . . 876 The Excel Options Dialog . . . . . . . . . . . . . . . . . . . . . . . . . . 103II A Tour of What's New7 The Big Grid . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1218 Fabulous Table Intelligence . . . . . . . . . . . . . . . . . . . . . . . . 1319 Visualizing Data in Excel . . . . . . . . . . . . . . . . . . . . . . . . . . . . 15310 Using Pivot Tables to Analyze Data . . . . . . . . . . . . . . . . 19111 Formatting Pivot Tables . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 21512 Pivot Table Data Crunching for Excel 2007 . . . . . . . 23713 Removing Duplicates and Filtering . . . . . . . . . . . . . . . . 27114 Sorting Data . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 28715 Using Excel Charts . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 29916 Using SmartArt, Shapes, WordArt, and Text Boxes . . 32717 Using Pictures and Clip Art . . . . . . . . . . . . . . . . . . . . . . . . 351III Working in a Legacy Environment18 File Format Differences . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 36519 Working with Prior Versions of Excel . . . . . . . . . . . . . . 371IV Calculating with Excel20 Understanding Formulas . . . . . . . . . . . . . . . . . . . . . . . . . . . 38521 Controlling Formulas . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 40922 Understanding Functions . . . . . . . . . . . . . . . . . . . . . . . . . . . 43123 Using Everyday Functions: Math, Date and Time,and Text Functions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 45124 Using Powerful Functions: Logical, Lookup, andDatabase Functions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 52525 Using Financial Functions . . . . . . . . . . . . . . . . . . . . . . . . . . 58726 Using Statistical Functions . . . . . . . . . . . . . . . . . . . . . . . . . 63127 Using Trig, Matrix, and Engineering Functions . . . . 73528 Connecting Worksheets, Workbooks, andExternal Data . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 79729 Using Super Formulas in Excel . . . . . . . . . . . . . . . . . . . . 82330 Using Names in Excel . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 84131 Using What If, Scenario Manager, Goal Seek,and Solver . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 863V Formatting and Sharing Information32 Formatting Worksheets . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 89133 Printing . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 92534 Sharing Workbooks with Others . . . . . . . . . . . . . . . . . . . 94135 More Tips and Tricks for Excel 2007 . . . . . . . . . . . . . . 949VI More Power36 Automating Repetitive Functions UsingVBA Macros . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 96937 Interacting with Other Office Applications . . . . . . 100538 A Tour of the Best Add-Ins for Excel . . . . . . . . . . . . . 1019Index . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1025

Reviews

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

Tags

Be the first.

Similar Items

Related Subjects:(1)

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

<http://www.worldcat.org/oclc/123796009> # Special edition using Microsoft Office Excel 2007.
    a schema:CreativeWork, schema:Book ;
   library:oclcnum "123796009" ;
   library:placeOfPublication <http://dbpedia.org/resource/London> ; # London
   library:placeOfPublication <http://id.loc.gov/vocabulary/countries/inu> ;
   library:placeOfPublication <http://experiment.worldcat.org/entity/work/data/58969488#Place/indianapolis_ind> ; # Indianapolis, Ind.
   schema:about <http://id.worldcat.org/fast/1366659> ; # Microsoft Excel (Computer file)
   schema:about <http://dewey.info/class/005.54/e22/> ;
   schema:about <http://experiment.worldcat.org/entity/work/data/58969488#CreativeWork/microsoft_excel_computer_file> ; # Microsoft Excel (Computer file)
   schema:bookFormat bgn:PrintBook ;
   schema:creator <http://viaf.org/viaf/323539> ; # Bill Jelen
   schema:datePublished "2007" ;
   schema:exampleOfWork <http://worldcat.org/entity/work/id/58969488> ;
   schema:inLanguage "en" ;
   schema:name "Special edition using Microsoft Office Excel 2007."@en ;
   schema:productID "123796009" ;
   schema:publication <http://www.worldcat.org/title/-/oclc/123796009#PublicationEvent/indianapolis_ind_que_sams_london_pearson_education_distributor_2007> ;
   schema:publisher <http://experiment.worldcat.org/entity/work/data/58969488#Agent/que_sams> ; # Que/Sams
   schema:publisher <http://experiment.worldcat.org/entity/work/data/58969488#Agent/pearson_education_distributor> ; # Pearson Education [distributor]
   schema:workExample <http://worldcat.org/isbn/9780789736116> ;
   umbel:isLike <http://bnb.data.bl.uk/id/resource/GBA684002> ;
   wdrs:describedby <http://www.worldcat.org/title/-/oclc/123796009> ;
    .


Related Entities

<http://dbpedia.org/resource/London> # London
    a schema:Place ;
   schema:name "London" ;
    .

<http://experiment.worldcat.org/entity/work/data/58969488#Agent/pearson_education_distributor> # Pearson Education [distributor]
    a bgn:Agent ;
   schema:name "Pearson Education [distributor]" ;
    .

<http://experiment.worldcat.org/entity/work/data/58969488#CreativeWork/microsoft_excel_computer_file> # Microsoft Excel (Computer file)
    a schema:CreativeWork ;
   schema:name "Microsoft Excel (Computer file)" ;
    .

<http://experiment.worldcat.org/entity/work/data/58969488#Place/indianapolis_ind> # Indianapolis, Ind.
    a schema:Place ;
   schema:name "Indianapolis, Ind." ;
    .

<http://id.worldcat.org/fast/1366659> # Microsoft Excel (Computer file)
    a schema:CreativeWork ;
   schema:name "Microsoft Excel (Computer file)" ;
    .

<http://viaf.org/viaf/323539> # Bill Jelen
    a schema:Person ;
   schema:familyName "Jelen" ;
   schema:givenName "Bill" ;
   schema:name "Bill Jelen" ;
    .

<http://worldcat.org/isbn/9780789736116>
    a schema:ProductModel ;
   schema:isbn "078973611X" ;
   schema:isbn "9780789736116" ;
    .


Content-negotiable representations

Close Window

Please sign in to WorldCat 

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