Special Edition Using Microsoft Office Excel 2007
Language: English
Published by Que, 2007
- Softcover
- Used
Seller: Anybook.com, Lincoln, United KingdomAnybook.com
AbeBooks seller since December 22, 1999
Condition: Used - Fair
£ 2.50
Quantity: 1 available
Add to basketItem description from seller
This is an ex-library book and may have the usual library/used-book markings inside.This book has soft covers. In fair condition, suitable as a study copy. Please note the Image in this listing is a stock photo and may not match the covers of the actual item,1800grams, ISBN:9780789736116.
Seller Inventory # 9159797
- Title
- Special Edition Using Microsoft Office Excel 2007
- Author
- Jelen, B.
- Publisher
- Que
- Publication year
- 2007
- Condition
- Fair
- Binding
- Soft cover
- Language
- English
- ISBN 10
- 078973611X
- ISBN 13
- 9780789736116
- Item weight
- 1,800 grams
- Seller catalogs
- Computing
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
"Synopsis" may belong to another edition of this title.
About the Author
Bill Jelen
, Excel MVP and MrExcel, has been using spreadsheets since 1985, and he launched the MrExcel.com website in 1998. His team provides custom Excel applications to clients around the world. You can see Bill as a regular guest on Call for Help with Leo Laporte in Australia, in Canada, and on Google Video. Bill produces a daily video podcast about Excel. He also enjoys taking his show on the road, doing a one- to four-hour power Excel seminar anywhere that a room full of accountants or Excellers will show up.
"About the title" may belong to another edition of this title.
Anybook.com
Lincoln, United Kingdom
AbeBooks seller since December 22, 1999
Shipping rates from United Kingdom to U.S.A.
| Item | 5 to 10 business days | 1 to 3 business days |
|---|---|---|
| First item | £ 15.22 | £ 34.62 |
Payment methods
Store description
Based in central Lincoln, Anybook Ltd. sells exclusively on line. We specialise in academic works. All our books are in good condition or better, unless otherwise described. We will respond to your enquiry promptly and mail books out within 24 hours of receiving payment. We use Royal Mail and other reputable couriers at greatly discounted postage rates. If you find cheaper postage from the UK, we'll match it. Remember if you are unsatisfied in any way with any purchase, we will give you a complete and unconditional refund. All books are hand wrapped. All e-mails answered personally. All books are offered subject to being unsold.…
Seller's business information
Anybook Ltd.
28 West End,, Burgh le Marsh,
Lincolnshire, United Kingdom PE24 5EY
Terms of sale
Anybook Ltd is a company registered in England and Wales. Company Registration Number: 3692291. VAT Number: GB753406145. Share Capital GBP100.
Registered Offices:
28 West End,
Burgh le Marsh,
Lincolnshire,
PE24 5EY
UK
Customer Services:
2,Outer Circle Business Park,
Outer Circle Road,
Lincoln
LN2 4HX
UK
Email Address: sales@anybook.com
Telephone Number: +44 (0) 1522 519 991
Authorized Representative: Ms. Claire Williams
Right of withdrawal
If you are a consumer you can withdraw from the contract in accordance with the following. Consumer means any natural person who is acting for purposes which are outside his trade, business, craft or profession.
Information regarding the right of withdrawal
Statutory right to withdraw
You have the right to withdraw from this contract within 14 days without giving any reason.
The withdrawal period will expire after 14 days from the day on which you acquire, or a third party other than the carrier and indicated by you acquires, physical possession of the last good or the last lot or piece.
To exercise the right of withdrawal, electronically fill in and submit a clear statement on our website, under "My Purchases" in "My Account". We will communicate to you an acknowledgement of receipt of such a withdrawal on a durable medium (e.g. by e-mail) without delay.
To meet the withdrawal deadline, it is sufficient for you to send your communication concerning your exercise of the right of withdrawal before the withdrawal period has expired.
Effects of withdrawal
If you withdraw from this contract, we will reimburse to you all payments received from you, including the costs of delivery (except for the supplementary costs arising if you chose a type of delivery other than the least expensive type of standard delivery offered by us).
We may make a deduction from the reimbursement for loss in value of any goods supplied, if the loss is the result of unnecessary handling by you.
We will make the reimbursement without undue delay, and not later than 14 days after the day on which we are informed about your decision to withdraw from this contract.
We will make the reimbursement using the same means of payment as you used for the initial transaction, unless you have expressly agreed otherwise; in any event, you will not incur any fees as a result of such reimbursement.
We may withhold reimbursement until we have received the goods back, or you have supplied evidence of having sent back the goods, whichever is the earliest.
You shall send back the goods or hand them over to Anybook.com, Lincolnshire, United Kingdom, +44 01522 424108, without undue delay and in any event not later than 14 days from the day on which you communicate your withdrawal from this contract to us. The deadline is met if you send back the goods before the period of 14 days has expired. You will have to bear the direct cost of returning the goods. You are only liable for any diminished value of the goods resulting from the handling other than what is necessary to establish the nature, characteristics and functioning of the goods.
Exceptions to the right of withdrawal
The right of withdrawal does not apply to:
- The delivery of newspapers, journals or magazines with the exception of subscription contracts; and
- The supply of digital content which is not supplied on a tangible medium (e.g. on a CD or DVD) if you accepted when you placed your order that we could start to deliver it, and that you could not withdraw once delivery had started.
Shipping terms
Orders usually ship within 1 business day. We use Royal Mail and other reputable couriers at greatly discounted postage rates. If your book order is heavy or over-sized, or valuable enough to require tracking, we may contact you to let you know extra shipping is required.