Cart
Free Shipping in Australia
Proud to be B-Corp

Microsoft Office Excel 2007 In Depth Bill Jelen

Microsoft Office Excel 2007 In Depth By Bill Jelen

Microsoft Office Excel 2007 In Depth by Bill Jelen


$39,99
Condition - Like New
Only 1 left

Summary

This textbook will ease the upgrade path to Microsoft Office Excel 2007. It has been crafted to grow with the user, providing the reference material needed for move towards Excel proficiency and use of more advanced features.

Microsoft Office Excel 2007 In Depth Summary

Microsoft Office Excel 2007 In Depth by Bill Jelen

Microsoft Office Excel 2007 In Depth will ease the upgrade path to the latest version of Microsoft best-selling spreadsheet program. The author 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 Summary: This book has been crafted to grow with the user, providing the reference material needed for move towards Excel proficiency and use of more advanced features. If you buy only one book on Excel, Microsoft Office Excel 2007 In Depth is the one to choose. 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 2007 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, Microsoft Office Excel 2007 In Depth is the book that will make it all better. Learn quickly and efficiently from a true Excel master using the In Depth formula for success. Here, you'll find information that's undocumented elsewhere even in Microsoft's own Help systems. You'll learn from finely crafted, real-life examples built by an author who lives and dies by the integrity of his spreadsheets. Excel's backbone is its formulas and functions. Master those and you will master your spreadsheets. Microsoft Office Excel 2007 In Depth 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! Author: Bill Jelenis an accomplished Excel author and the principal behind the leading Excel website, MrExcel.com. As an Excel consultant, he has written Excel VBA solutions for over 300 clients around the English-speaking world. His website hosts over 10 million page views annually. Prior to founding MrExcel.com, Jelen spent twelve years in the trenches, - working as a financial analyst for finance, marketing, accounting and operations departments of a $500 million public company.

Table of Contents

Table of 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

Additional information

GOR013242271
9780273721611
0273721615
Microsoft Office Excel 2007 In Depth by Bill Jelen
Used - Like New
Paperback
Pearson Education Limited
2008-07-24
1080
N/A
Book picture is for illustrative purposes only, actual binding, cover or edition may vary.
The book has been read, but looks new. The book cover has no visible wear, and the dust jacket is included if applicable. No missing or damaged pages, no tears, possible very minimal creasing, no underlining or highlighting of text, and no writing in the margins

Customer Reviews - Microsoft Office Excel 2007 In Depth