Location: Home » Bill Jelen Books » Special Edition Using Microsoft(R) Office Excel 2007

Other Locales

Canada

U.K.

USA

Special Edition Using Microsoft(R) Office Excel 2007

enlarge

Author: Bill Jelen
Publisher: Que
Category: Book

List Price: ~~$39.99~~
Buy New: $21.05
as of 3/14/2010 07:23 EDT details
You Save: $18.94 (47%)

New (36) Used (13) from $21.05

Seller: fantastic_shopping
Rating: 3.0 out of 5 stars

10 reviews
Sales Rank: 41989

Format: Deluxe Edition
Media: Paperback
Edition: Special
Pages: 1080
Number Of Items: 1
Shipping Weight (lbs): 3.6
Dimensions (in): 9 x 7 x 2.2

ISBN: 078973611X
Dewey Decimal Number: 005.54
EAN: 9780789736116
ASIN: 078973611X

Publication Date: December 16, 2006
Availability: Usually ships in 1-2 business days

Also Available In:

•	Digital - Special Edition Using Microsoft(R) Office Excel 2007
•	Kindle Edition - Special Edition Using Microsoft Office Excel 2007

Similar Items:

Special Edition Using Microsoft Office Word 2007

Special Edition Using Microsoft Office PowerPoint 2007

Special Edition Using Microsoft Office Access 2007

Special Edition Using Microsoft Office Outlook 2007

Special Edition Using Microsoft Office Home and Student 2007

Editorial Reviews:

Product Description

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 only show you how it should be done, but how to be the local worksheet hero!

CONTENTS

Introduction

I Mastering the New User Interface

1 Introducing the Ribbon User Interface . . . . . . . . . . . . . 21

2 The Quick Access Toolbar . . . . . . . . . . . . . . . . . . . . . . . . . . . . 41

3 The Mini Toolbar and Other U.I. Improvements . . . 53

4 Keyboard Shortcuts . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 65

5 Galleries, Live Preview, and Themes . . . . . . . . . . . . . . . . 87

6 The Excel Options Dialog . . . . . . . . . . . . . . . . . . . . . . . . . . 103

II A Tour of What’s New

7 The Big Grid . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 121

8 Fabulous Table Intelligence . . . . . . . . . . . . . . . . . . . . . . . . 131

9 Visualizing Data in Excel . . . . . . . . . . . . . . . . . . . . . . . . . . . . 153

10 Using Pivot Tables to Analyze Data . . . . . . . . . . . . . . . . 191

11 Formatting Pivot Tables . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 215

12 Pivot Table Data Crunching for Excel 2007 . . . . . . . 237

13 Removing Duplicates and Filtering . . . . . . . . . . . . . . . . 271

14 Sorting Data . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 287

15 Using Excel Charts . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 299

16 Using SmartArt, Shapes, WordArt, and Text Boxes . . 327

17 Using Pictures and Clip Art . . . . . . . . . . . . . . . . . . . . . . . . 351

III Working in a Legacy Environment

18 File Format Differences . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 365

19 Working with Prior Versions of Excel . . . . . . . . . . . . . . 371

IV Calculating with Excel

20 Understanding Formulas . . . . . . . . . . . . . . . . . . . . . . . . . . . 385

21 Controlling Formulas . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 409

22 Understanding Functions . . . . . . . . . . . . . . . . . . . . . . . . . . . 431

23 Using Everyday Functions: Math, Date and Time,

and Text Functions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 451

24 Using Powerful Functions: Logical, Lookup, and

Database Functions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 525

25 Using Financial Functions . . . . . . . . . . . . . . . . . . . . . . . . . . 587

26 Using Statistical Functions . . . . . . . . . . . . . . . . . . . . . . . . . 631

27 Using Trig, Matrix, and Engineering Functions . . . . 735

28 Connecting Worksheets, Workbooks, and

External Data . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 797

29 Using Super Formulas in Excel . . . . . . . . . . . . . . . . . . . . 823

30 Using Names in Excel . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 841

31 Using What If, Scenario Manager, Goal Seek,

and Solver . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 863

V Formatting and Sharing Information

32 Formatting Worksheets . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 891

33 Printing . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 925

34 Sharing Workbooks with Others . . . . . . . . . . . . . . . . . . . 941

35 More Tips and Tricks for Excel 2007 . . . . . . . . . . . . . . 949

VI More Power

36 Automating Repetitive Functions Using

VBA Macros . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 969

37 Interacting with Other Office Applications . . . . . . 1005

38 A Tour of the Best Add-Ins for Excel . . . . . . . . . . . . . 1019

Index . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1025

Customer Reviews:

Showing reviews 1-5 of 10

1 2 Next »

Where's the code? January 17, 2010
scg (Colorado Springs, CO, USA)
I cannot believe that Bill Jelen wrote this almost 1,000 page tome and did not include a single bit of code/example of tables used in the book. Neither the Safari nor InformIT websites (quepublising is owned by them) have any downloadable code for the examples used in this book. So you are reduced to not only the time to read this monster but to have to stop and enter all the code manually and hopefully without entry errors. Duh!!!!!!!!! What a concept that I would want to actually learn by practicing using the examples in the book.

I sincerely hope Mr. Jelen doesn't teach his formal classes this way. Per Mr. Jelen's reputation I have given this book a single star because he is suppose to know better. There is simply no viable excuse for this short coming from either the author, publisher or anyone else involved with this.

As a side note this seems to be a claring fault with the computer book publishing industry as a whole.

Try Excel 2007 the Missing Manuel because it does have downloadable examples to learn with.

Best wishes, Steve

5 out of 5 stars

Great series and great book August 31, 2009
S. F. Castillo (Houston, TX)
I love the Special Edition series. Microsoft Excel 2007 is truly a different and complicated animal and this book really simplifies it but you have to be very familiar with Excel in general or the language and the graphics might be a bit overwhelming. I also purchased the Special Edition series Access 2007 and am planning to purchase Word 2007 next.

1 out of 5 stars

Extremely Disappointing Book August 8, 2009
J. Sanders (Atlanta, GA USA)
2 out of 2 found this review helpful

I consider myself an intermediate level user of Excel. After upgrading to Excel 2007 from 2003, the new menu interface was confusing to me. I purchased the book to get pointers on the totally new menu "ribbon", as well as to learn more about pivot tables, lookups, and other advanced features of Excel 2007.

The book covered all of the topics that I was interested in learning more about, but did so in a manner that was very hard to follow. Even when I tried to work my way through some of the many specific examples, the directions seemed to be inconsistent. I found myself backing up to try and pick up what I "missed" over and over.

Even the general explanations on features, procedures, and functions were incoherent in many instances, with the author giving long, irrelevant histories of the way the task was done in previous versions (prior to Excel 2003), and interjecting his own opinions that took away from the "lesson" that was being described.

Perhaps it's just a clash between the authors style of writing and my way of processing information, but the book was of very little use to me. I also read the Word 2007 version of the series, and would highly recommend that volume. This manual is written in a completely different style that did not convey information in an effective manner.

3 out of 5 stars

This should not be your first book on Excel June 12, 2009
Joshua Davies (Dallas, TX United States)
1 out of 1 found this review helpful

I've been using Excel for close on to 20 years now - if you work in an office, you have no choice. People e-mail spreadsheets to you, ask you to fill them out/add to them, etc. I've noticed along the way that Excel is sort of the "power tool" of choice for Windows users - the tool they turn to the way I turn to, for example, awk & sed in Unix. In spite of its ubiquity, I had never really taken the plunge and made an effort to actually learn how to use it. This year, I finally broke down and decided to buy a book on Excel and see what I was missing.

I wish I had chosen a different book.

This book is not an introductory book on Excel, in spite of its packaging that implies that it is. The first part of the book is written for somebody who has quite a bit of experience with Excel and is now becoming accustomed to using the 2007 version. There's a lot of discussion about how, "if you used to do X in Excel 2003, you should now do Y in Excel 2007." Although I've dabbled with Excel in the past, most of this discussion was wasted on me - I'd rather just see how to do new and interesting things with the version for which I bought the book. Everything is eventually covered, but the organization is not for somebody who's new to Excel (or somebody like me, who's been muddling along for decades but wants a firm foundation in the tool).

For example, in chapter four, keyboard shortcuts were listed, but most of them were for functions that hadn't been presented yet; this list would have made a lot more sense in an appendix where it could be easily referenced later, after everything had been covered. Chapter 8 discusses how to "freeze" rows and columns without explaining what that is (you're assumed to already know, and you're assumed to already know how to have done this in a prior version of Excel). In chapter 9, he talks about using the F4 key in a formula to cycle between $B2, $B$2, B$2 and B2... however, he doesn't clarify what the difference is until chapter 20 (250 pages later).

The real value of the book is in the middle - the chapters on functions (this takes up about a third of the book). The chapter on financial functions mostly went over my head, but seemed authoritative - and since the two chapters on statistics and engineering functions were accurate and well done, I'll assume the author was as knowledgeable about financial functions as well. There were scattered minor errors such as "The [base 10] logarithm for 5,100 is somewhere between 2 and 3" (pg. 751), but there weren't too many of these and they didn't detract too terribly from the material. This whole section actually seems out of place with the rest of the book, as it covers everything from the ground up, rather than assuming that you're an Excel power user.

All in all, it's clear that this book is written for professional accountants who have already read at least one other introductory book on Excel and are just trying to familiarize themselves with what's new in Excel 2007. This is fine, and worthwhile - I just felt like I was misled by the advertising and the packaging that ought to have said "A guide to Excel 2007 for Excel 2003 experts". Page 386 makes this unequivocal when it states, "I understand that everyone reading this book believes that they know Excel formulas." Well, no... that's why I bought the book. The "fill handle" is mentioned several times but never explained. There are multiple mentions of "arrays" (distinct from ranges, which are also never defined, although the meaning of this is pretty clear), but the term is never clarified. I still don't know what he means by an "array" vs a "range". I think a range is a pair of cell names (e.g. B7:D11) and an array is a comma-separated list of ranges - but I can't be sure, since it's not explained. 20 pages of "Excel basics and terminology" would have been a HUGE help.

There are also several problems that a better proofreader ought to have caught. In a lot of places, the text doesn't match the application (for example, he calls the "Popular" tab "Personalize" in several places, and he refers the "Opulent" theme as "Deluxe"). What makes this frustrating is that the screenshots in the book *do* match Excel (but not the text of the book!) In other places, the screenshots don't match the application - "Comparing one worksheet to another" and "Highlighting an entire row" in chapter 9, for example. These features aren't there at all. In many of the examples in the functions section, he refers to cell ranges that don't appear in the screenshots. Chapter 12 includes a forward reference to chapter 41, "Connecting with Word, Access, Powerpoint and OneNote". There are only 38 chapters in the book, and the chapter he seems to be referring to (chapter 37) is actually called "Interacting with other office applications".

Finally, there are somethings that the book doesn't cover, that I was hoping for more discussion on - I was hoping for more coverage of charting in Excel, but this book devotes only 25 pages to the topic - there wasn't much more information on charting in this book than I was able to figure out just by playing around with the charting interface. I was hoping for a bit more from the "connecting worksheets, workbooks and external data" chapter - this is mostly just an overview of connectivity and no serious discussion (there are also no examples of integrating with non-Microsoft database products like Oracle or MySQL). Chapter 37, "Interacting with other Office Applications", was fairly pointless - all of the procedures were "use CTRL+C to copy the data and CTRL+V to paste it". I guess when you already have a 1,023-page book, you have to shorten some sections... but be aware that if these are your main interests, this isn't the book for you.

3 out of 5 stars

Poorly Organized, Overly Presumptive February 21, 2009
Ziggy Conure (SF Bay Area, USA)
1 out of 1 found this review helpful

The further into reading this manual I get, the more annoyed it leaves me. I read manuals like this from start to finish for two purposes: 1)to become familiar with the workings of the latest version of a particular program; and 2)to give myself a refresher to see whether I'm missing some useful fundamentals in my ongoing use of a tool that has served me for (in the case of Excel) almost twenty years. This book does a decent job on my first purpose; it is totally focused on the changes in Excel 2007 from the prior versions of Excel, and spends a lot of ink on discussing the author's attitudes about how Microsoft has done things and his annoyances at their not responding to more of his requests.

However, for my second purpose, I find this book to be very dissappointing. In fact, it occurs to me that a person who has never used a spreadsheet before who tries to learn by reading this book might not even come to understand the essence of how a spreadsheet works. The author never sets the context of what a spreadsheet does and when to use it, and he dives into his topic with no cogent concept of how he has organized his material and how this organization will build the reader's knowledge upon a solid foundation.

For example, very early in the book he goes into great detail about conditional formatting, long before he has said the first thing about how data gets into cells to begin with. Formulas and their absolute and relative references, the essence of Excel, don't appear until the middle of this tome. The book totally presumes that the reader has a decent working knowledge of previous versions of Excel--which would be fine if the book were entitled "Upgrading to Excel 2007" rather than "Using Excel 2007--The Only Excel Book You Need".

Somewhere in the preface the author mentions that writing the book was an intense and hermetic affair--which I began to appreciate once I realized that it didn't seem as though anybody else actually read the book before it was printed. It is very clear that the author, clearly an Excel expert, was under extreme competitive pressure to get something into publication as soon as possible after MS released Office 2007. In his haste, he was too busy comparing the new version to the previous to think about how his book would read to the person who wanted to start from the beginning.

The haste shows in other areas as well. There are blatent omissions of some pretty basic concepts, such as how to manoevre chart objects and manage and edit their data inputs, even as there is tremendous detail on other capabilities. There is the usual number of typos and incorrect illustration references that one sees in so many books nowadays that seem to go straight from their authors' word processors to the printing press. And not in the author's control but frustrating nonetheless are the graphics, mostly screen shots, that are so gray and often so small that they actually sent me to the optometrist for new glasses.

On the plus side, the book is a tremendous reference on functions, devoting hundreds of pages to exploring these in detail. And the author is clearly quite expert and understands the sorts of tasks that typical users employ Excel for. I would enjoy hearing him speak on, for example, his favorite tips and tricks, and I intend to take advantage of the resources on his MrExcel.com web site. I therefore expect to get some benefit from this book now and in the future, but it would have been so much better had the author collaborated with a good editor who could have lent a perspective on how the book would read to a reader who wants to start at the beginning.

Showing reviews 1-5 of 10

1 2 Next »

CERTAIN CONTENT THAT APPEARS ON THIS SITE COMES FROM AMAZON SERVICES LLC. THIS CONTENT IS PROVIDED ‘AS IS’ AND IS SUBJECT TO CHANGE OR REMOVAL AT ANY TIME.

Thank you for browsing ExcelBookstore.com!