Special Edition Using Microsoft Office Excel 2007 will ease the path to upgrade to the latest version of the program Microsoft's best-selling spreadsheet. The author, introduces "Mr. Excel" you to the new interface, allowingyou to get back up to speed in doing your job, and then will introduce a powerful new features available in Excel 2007. Among other skills, you will learn how to create amazing data visualizations using conditional formatting and data in-cell bar. This is the only book you need on Microsoft Office Excel 2007! ? Excel 2007 is the most, attracting the largest ever release of Excel. Books? Direct approach explains the most important features of Excel 2007 in a thorough, easy-to-understand format. Furthermore, it is clear comparing the versions of Excel with Excel 2007, which makes for a seamless transition to the latest version of the program. This is a must-have desk reference for today. S? Professional business? Gainer? David, Group Program Manager, Microsoft Excel ONLY EXCEL BOOK YOU NEED We created this book to grow with you, providing the reference material you need as you move toward the ability of Excel and use the features of more advanced. If you buy only one book on Excel, Special Edition Using Microsoft Office Excel 2007 is the book you need. Does your life play in a spreadsheet? Are numbers in columns and rows make or break you in the world of work? Tired of having numbers kick in your face with the power of other users a simple Excel spreadsheet that makes you look paltry compared with their fancy charts and pivot tables? If you answered yes to all these questions, Special Edition Using Microsoft Office Excel 2007 is bookthat will make it all better. Learn quick and correct efficientlyfrom Excel master using the tried and true SpecialEdition Using the formula for success. Here, you will findinformation that undocumented? Elsewhere? Even inMicrosoft? S? Help system itself. You? Will learn from finelycrafted, real-life examples built by an author who livesand die by the integrity of his spreadsheets. Excel backbone? Are formulas and functions. Master these and you will master your spreadsheets Special. Edition Using Microsoft Office Excel 2007 provides more down and dirty to help you with formulas and functions from? Will find in other books! See how it? S carried out in real life! Don? T satisfied with 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! ISI Introduction I Mastering the New User Interface 1 Introducing the Ribbon User Interface. . . . . . . . . . . . . 21 2 Quick Access Toolbar. . . . . . . . . . . . . . . . . . . . . . 41 3 Mini Toolbar and Other UI Infrastructure. . . 53 4 Keyboard Shortcuts. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 65 5 Galleries, Live Preview, and Themes. . . . . . . . . . . . . . . . 87 6 Excel Options Dialog. . . . . . . . . . . . . . . . . . 103 II A Tour What? New S 7 The Big Grid. 121 8 Fabulous Table Intelligence. . 131 9 Visualizing Data in Excel. . . . 153 10 Using Pivot Tables for Data Analysis. . 191 Format Pivot Table 11. . . . . . . . . . . . . . . . . . . . . . . 215 12 Data Tables to Excel 2007 Pivot crunching. . . . . . . 237 13 Removing Duplicates and Filtering. . . . . . . . . . . . . . . . 271 14 Sorting Data. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 287 "> 15 Using Excel Charts.................................. 299 16 Using SmartArt, Shapes, WordArt, and Text. . 327 17 Using Pictures and Clip Art. .. . . . . . . . . . . . . . . . . . . . . . 351 III Working on Environmental Legacy 18 File Format Differences. . . . . . . . . . . . . . . . . . . . . . . . . . . . . 365 19 Working with Prior Versions 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 Function Text. 451 24 Using Powerful Functions: Logical, Lookup, and Database function. . 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 Using Functions Automating repetitive VBA Macros. . 969 37 Interacting with Other Office Applications. . 1005 38 A Tour Best Add-Ins for Excel. 1019 Index. 1025