Coverart for item
The Resource Special edition using Microsoft Office Excel 2007, by Bill Jelen - MrExcel

Special edition using Microsoft Office Excel 2007, by Bill Jelen - MrExcel

Label
Special edition using Microsoft Office Excel 2007
Title
Special edition using Microsoft Office Excel 2007
Statement of responsibility
by Bill Jelen - MrExcel
Title variation
  • Using Microsoft Office Excel 2007
  • Microsoft Office Excel 2007
Creator
Subject
Language
eng
Summary
Special Edition Using Microsoft Office Excel 2007 will ease the upgrade path to the lastest version of Microsoft best-selling spreadsheet program. The author, "Mr. Excel " introduces you to the new interface, allowing you to quickly get back up-to-speed in performing your job, and will then introduce the powerful new features available in Excel 2007. Among other skills, you will learn how to create amazing data visualizations using conditional formatting and in-cell data bars. This is the only book you need on Microsoft Office Excel 2007! " Excel 2007 is the biggest, most exciting release of Excel ever. This book's straightforward approach explains the most important features of Excel 2007 in a thorough, easy-to-understand format. Further, it clearly compares older versions of Excel with Excel 2007, which makes for a seamless transition to this newest version of the program. It is a must-have desk reference for today's business professional."--David Gainer, Group Program Manager, Microsoft Excel THE ONLY EXCEL BOOK YOU NEED We crafted this book to grow with you, providing the reference material you need as you move toward Excel proficiency and use of more advanced features. If you buy only one book on Excel, Special Edition Using Microsoft® Office Excel® 2007 is the book you need. Does your life play out in a spreadsheet? Do numbers in columns and rows make or break you in the work world? Tired of having numbers kicked in your face by other Excel power users who make your modest spreadsheets look paltry compared to their fancy charts and pivot tables? If you answered yes to any of these questions, Special Edition Using Microsoft® Office Excel® 2007 is the bookthat will make it all better. Learn quickly and efficientlyfrom a true Excel master using the tried and true SpecialEdition Using formula for success. Here, you'll findinformation that's undocumented elsewhere-even inMicrosoft's own Help systems. You'll learn from finelycrafted, real-life examples built by an author who livesand dies by the integrity of his spreadsheets. Excel's backbone is its formulas and functions. Master those and you will master your spreadsheets. Special Edition Using Microsoft Office® Excel® 2007 provides more down and dirty help with your formulas and functions than you'll find in any other book! See how it's done in real life! Don't settle for lame pivot table and chart examples found in other books ... This book provides beautifully detailed examples that not ..
Member of
Cataloging source
UMI
http://library.link/vocab/creatorName
Jelen, Bill
Index
index present
LC call number
HF5548.4.M523
LC item number
J45 2006
Literary form
non fiction
Nature of contents
dictionaries
http://library.link/vocab/subjectName
  • Electronic spreadsheets
  • Electronic spreadsheets
  • Electronic spreadsheets
Label
Special edition using Microsoft Office Excel 2007, by Bill Jelen - MrExcel
Instantiates
Publication
Carrier category
online resource
Carrier category code
  • cr
Carrier MARC source
rdacarrier
Content category
text
Content type code
  • txt
Content type MARC source
rdacontent
Contents
  • 5.
  • Galleries, live preview, and themes
  • 6.
  • Excel options dialog
  • 7.
  • big grid
  • 8.
  • Fabulous table intelligence
  • 9.
  • Visualizing data in Excel
  • 1.
  • 10.
  • Using pivot tables to analyze data
  • 11.
  • Formatting pivot tables
  • 12.
  • Pivot table data crunching for Excel 2007
  • 13.
  • Removing duplicates and filtering
  • 14.
  • Sorting data
  • Introducing the ribbon user interface
  • 15.
  • Using Excel charts
  • 16.
  • Using SmartArt, shapes, WorldArt, and text boxes
  • 17.
  • Using pictures and clip art
  • 18.
  • File format differences
  • 19.
  • Working with prior versions of Excel
  • 2.
  • 20.
  • Understanding formulas
  • 21.
  • Controlling formulas
  • 22.
  • Understanding functions
  • 23.
  • Using everyday functions : math, data and time, and text functions
  • 24.
  • Using powerful functions : logical, lookup, and database functions
  • quick access toolbar
  • 25.
  • Using financial functions
  • 26.
  • Using statistical functions
  • 27.
  • Using trig, matrix, and engineering functions
  • 28.
  • Connecting worksheets, workbooks, and external data
  • 29.
  • Using super formulas in Excel
  • 3.
  • 30.
  • Using names in Excel
  • 31.
  • Using what if, scenario manager, goal seek, and solver
  • 32.
  • Formatting worksheets
  • 33.
  • Printing
  • 34.
  • Sharing workbooks with others
  • mini toolbar and other U.I. improvements
  • 35.
  • More tips and tricks for Excel 2007
  • 36.
  • Automating repetitive functions using VBA macros
  • 37.
  • Interacting with other office applications
  • 38.
  • tour of the best add-ins for Excel
  • 4.
  • Keyboard shortcuts
Control code
85872462
Dimensions
unknown
Extent
1 online resource
Form of item
online
Isbn
9780789736116
Media category
computer
Media MARC source
rdamedia
Media type code
  • c
http://library.link/vocab/ext/overdrive/overdriveId
cl0500000008
Sound
unknown sound
Specific material designation
remote
System control number
(OCoLC)85872462
Label
Special edition using Microsoft Office Excel 2007, by Bill Jelen - MrExcel
Publication
Carrier category
online resource
Carrier category code
  • cr
Carrier MARC source
rdacarrier
Content category
text
Content type code
  • txt
Content type MARC source
rdacontent
Contents
  • 5.
  • Galleries, live preview, and themes
  • 6.
  • Excel options dialog
  • 7.
  • big grid
  • 8.
  • Fabulous table intelligence
  • 9.
  • Visualizing data in Excel
  • 1.
  • 10.
  • Using pivot tables to analyze data
  • 11.
  • Formatting pivot tables
  • 12.
  • Pivot table data crunching for Excel 2007
  • 13.
  • Removing duplicates and filtering
  • 14.
  • Sorting data
  • Introducing the ribbon user interface
  • 15.
  • Using Excel charts
  • 16.
  • Using SmartArt, shapes, WorldArt, and text boxes
  • 17.
  • Using pictures and clip art
  • 18.
  • File format differences
  • 19.
  • Working with prior versions of Excel
  • 2.
  • 20.
  • Understanding formulas
  • 21.
  • Controlling formulas
  • 22.
  • Understanding functions
  • 23.
  • Using everyday functions : math, data and time, and text functions
  • 24.
  • Using powerful functions : logical, lookup, and database functions
  • quick access toolbar
  • 25.
  • Using financial functions
  • 26.
  • Using statistical functions
  • 27.
  • Using trig, matrix, and engineering functions
  • 28.
  • Connecting worksheets, workbooks, and external data
  • 29.
  • Using super formulas in Excel
  • 3.
  • 30.
  • Using names in Excel
  • 31.
  • Using what if, scenario manager, goal seek, and solver
  • 32.
  • Formatting worksheets
  • 33.
  • Printing
  • 34.
  • Sharing workbooks with others
  • mini toolbar and other U.I. improvements
  • 35.
  • More tips and tricks for Excel 2007
  • 36.
  • Automating repetitive functions using VBA macros
  • 37.
  • Interacting with other office applications
  • 38.
  • tour of the best add-ins for Excel
  • 4.
  • Keyboard shortcuts
Control code
85872462
Dimensions
unknown
Extent
1 online resource
Form of item
online
Isbn
9780789736116
Media category
computer
Media MARC source
rdamedia
Media type code
  • c
http://library.link/vocab/ext/overdrive/overdriveId
cl0500000008
Sound
unknown sound
Specific material designation
remote
System control number
(OCoLC)85872462

Library Locations

    • Ellis LibraryBorrow it
      1020 Lowry Street, Columbia, MO, 65201, US
      38.944491 -92.326012
    • Engineering Library & Technology CommonsBorrow it
      W2001 Lafferre Hall, Columbia, MO, 65211, US
      38.946102 -92.330125
Processing Feedback ...