Special Edition Using Microsoft Office Excel 2007

My rating:

add to my books

Special Edition Using Microsoft Office Excel 2007

by Bill Jelen (Goodreads Author)

3.00 · rating details · 3 ratings · 0 reviews

"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. ...more"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 NEEDWe 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(R)""Office Excel(R) 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(R) Office Excel(R) 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(R) Excel(R) 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 only show you how it should be done, but how to be the local worksheet hero CONTENTSIntroductionI 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 . . . .(less)

Paperback, 1080 pages

Published December 16th 2006 by Que

more details... edit details

Get a copy:

More…

There is a good chance some of your friends read this book. Sign in to see!

Friend Reviews

To see what your friends thought of this book, please sign up.

Lists with This Book

This book is currently not featured on any Listopia lists. Add this book to your favorite list »

Community Reviews

(showing 1-6 of 6)

filter | sort: default (?) | rating details

Feb 04, 2012

Nathalie rated it

Shelves: computer-ms-office

Jul 25, 2011

Charles rated it

Jun 21, 2011

Matt Jeselnik added it

Shelves: own

Feb 06, 2010

C added it

May 31, 2009

Richard Beehner rated it

Nov 30, 2008

Lynda is currently reading it

new topic
Discuss This Book

There are no discussion topics on this book yet. Be the first to start one »

Recommend it | Stats | Recent status updates

Popular Shelves

computer-ms-office

1 shelf

currently-reading

1 shelf

Books by Bill Jelen

Charts and Graphs for Microsoft Office Excel 2007

Excel Gurus Gone Wild: Do the IMPOSSIBLE with Microsoft Excel

Learn Excel 97 Through Excel 2007 from Mr. Excel: 377 Excel Mysteries Solved!

More…

Share This Book

Facebook Twitter Your website

Pin It

Trivia About Special Edition U...

No trivia or quizzes yet. Add some now »

title link	preview: Special Edition Using Microsoft Office Excel 2007
avg rating	preview: Special Edition Using Microsoft Office Excel 2007 Goodreads rating: 3.00 (3 ratings)
small image	preview: click here [close]
med image	preview: click here [close]
BBCode	[url=http://www.goodreads.com/book/show/1970785.Special_Edition_Using_Microsoft_Office_Excel_2007?utm_medium=api&utm_source=blog_book][img]http://photo.goodreads.com/books/1191091222m/1970785.jpg[/img][/url] [url=http://www.goodreads.com/book/show/1970785.Special_Edition_Using_Microsoft_Office_Excel_2007?utm_medium=api&utm_source=blog_book]Special Edition Using Microsoft Office Excel 2007 by Bill Jelen[/url]