Articles liés à Using Microsoft Office Excel 2007
Synopsis
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
Les informations fournies dans la section « Synopsis » peuvent faire référence à une autre édition de ce titre.
À propos de l?auteur
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.
À propos de la quatrième de couverture
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
Les informations fournies dans la section « A propos du livre » peuvent faire référence à une autre édition de ce titre.
Acheter neuf
Afficher cet article
EUR 56,82
Gratuit expédition vers Etats-Unis
Destinations, frais et délaisRésultats de recherche pour Using Microsoft Office Excel 2007
Image d'archives
Special Edition Using Microsoft(R) Office Excel 2007
Edité par
Que Pub, 2006
ISBN 10 : 078973611X
ISBN 13 : 9780789736116
Ancien ou d'occasion
Couverture souple
Vendeur : BookHolders, Towson, MD, Etats-Unis
Évaluation du vendeur 5 sur 5 étoiles
Etat : Very Good. [ No Hassle 30 Day Returns ][ Ships Daily ] [ Underlining/Highlighting: NONE ] [ Writing: NONE ] [ Edition: Reprint ] Publisher: Que Pub Pub Date: 12/6/2006 Binding: paperback Pages: 1046 Reprint edition. N° de réf. du vendeur 6896401
Quantité disponible : 1 disponible(s)
Image d'archives
Special Edition Using Microsof
Edité par
Que Pub, 2006
ISBN 10 : 078973611X
ISBN 13 : 9780789736116
Ancien ou d'occasion
Couverture souple
Vendeur : World of Books (was SecondSale), Montgomery, IL, Etats-Unis
Évaluation du vendeur 5 sur 5 étoiles
Etat : Very Good. Item in very good condition! Textbooks may not include supplemental items i.e. CDs, access codes etc. N° de réf. du vendeur 00085995039
Quantité disponible : 1 disponible(s)
Image d'archives
Special Edition Using Microsoft(R) Office Excel 2007
Vendeur : ThriftBooks-Atlanta, AUSTELL, GA, Etats-Unis
Évaluation du vendeur 5 sur 5 étoiles
Paperback. Etat : As New. No Jacket. Pages are clean and are not marred by notes or folds of any kind. ~ ThriftBooks: Read More, Spend Less. N° de réf. du vendeur G078973611XI2N00
Quantité disponible : 1 disponible(s)
Image d'archives
Special Edition Using Microsoft(R) Office Excel 2007
Vendeur : ThriftBooks-Atlanta, AUSTELL, GA, Etats-Unis
Évaluation du vendeur 5 sur 5 étoiles
Paperback. Etat : Very Good. No Jacket. Former library book; May have limited writing in cover pages. Pages are unmarked. ~ ThriftBooks: Read More, Spend Less 3.75. N° de réf. du vendeur G078973611XI4N10
Quantité disponible : 1 disponible(s)
Image d'archives
Using Microsoft Office Excel 2007
Edité par
Pearson Education, Limited, 2006
ISBN 10 : 078973611X
ISBN 13 : 9780789736116
Ancien ou d'occasion
Couverture souple
Vendeur : Better World Books, Mishawaka, IN, Etats-Unis
Évaluation du vendeur 5 sur 5 étoiles
Etat : As New. Special. Used book that is in almost brand-new condition. N° de réf. du vendeur 50326925-6
Quantité disponible : 1 disponible(s)
Image d'archives
Using Microsoft Office Excel 2007
Edité par
Pearson Education, Limited, 2006
ISBN 10 : 078973611X
ISBN 13 : 9780789736116
Ancien ou d'occasion
Couverture souple
Vendeur : Better World Books: West, Reno, NV, Etats-Unis
Évaluation du vendeur 5 sur 5 étoiles
Etat : Good. Special. Used book that is in clean, average condition without any missing pages. N° de réf. du vendeur GRP96824441
Quantité disponible : 2 disponible(s)
Image d'archives
Special Edition Using Microsoft Office Excel 2007
Vendeur : AwesomeBooks, Wallingford, Royaume-Uni
Évaluation du vendeur 5 sur 5 étoiles
Paperback. Etat : Very Good. Special Edition Using Microsoft Office Excel 2007 This book is in very good condition and will be shipped within 24 hours of ordering. The cover may have some limited signs of wear but the pages are clean, intact and the spine remains undamaged. This book has clearly been well maintained and looked after thus far. Money back guarantee if you are not satisfied. See all our books here, order more than 1 book and get discounted shipping. N° de réf. du vendeur 7719-9780789736116
Quantité disponible : 1 disponible(s)
Image d'archives
Special Edition Using Microsoft Office Excel 2007
Vendeur : Bahamut Media, Reading, Royaume-Uni
Évaluation du vendeur 5 sur 5 étoiles
Paperback. Etat : Very Good. This book is in very good condition and will be shipped within 24 hours of ordering. The cover may have some limited signs of wear but the pages are clean, intact and the spine remains undamaged. This book has clearly been well maintained and looked after thus far. Money back guarantee if you are not satisfied. See all our books here, order more than 1 book and get discounted shipping. N° de réf. du vendeur 6545-9780789736116
Quantité disponible : 1 disponible(s)
Image d'archives
Using Microsoft Office Excel 2007
Edité par
Pearson Education, Limited, 2006
ISBN 10 : 078973611X
ISBN 13 : 9780789736116
Ancien ou d'occasion
Couverture souple
Vendeur : Better World Books Ltd, Dunfermline, Royaume-Uni
Évaluation du vendeur 5 sur 5 étoiles
Etat : Very Good. Special. Ships from the UK. Former library book; may include library markings. Used book that is in excellent condition. May show signs of wear or have minor defects. N° de réf. du vendeur GRP23642426
Quantité disponible : 1 disponible(s)
Image d'archives
Special Edition Using Microsoft Office Excel 2007
Edité par
Que, 2007
ISBN 10 : 078973611X
ISBN 13 : 9780789736116
Ancien ou d'occasion
Couverture souple
Vendeur : Anybook.com, Lincoln, Royaume-Uni
Évaluation du vendeur 5 sur 5 étoiles
Etat : Fair. 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. N° de réf. du vendeur 9159797
Quantité disponible : 1 disponible(s)