› › Excel 2007 Introduction Part Ii












Excel 2007 Charts

Author : John Walkenbach

Publisher : John Wiley and Sons

Page : 578 pages

File Size : 18,94 MB

Release : 2007-12-10

Category : Computers

ISBN : 047033603X

Get eBook

Book Description

Excel, the top number-crunching tool, now offers a vastly improved charting function to help you give those numbers dimension and relativity. John Walkenbach, a.k.a. Mr. Spreadsheet, clearly explains all these charting features and shows you how to choose the right chart for your needs. You’ll learn to modify data within the chart, deal with missing data, format your chart, use trend lines, construct “impossible” charts, create charts from pivot tables, dress them up with graphics, and more. Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.



Excel 2010 Power Programming with VBA

Author : John Walkenbach

Publisher : John Wiley & Sons

Page : 1088 pages

File Size : 24,28 MB

Release : 2010-04-09

Category : Computers

ISBN : 0470625503

Get eBook

Book Description

All the methods and tools you need to successfully program with Excel John Walkenbach's name is synonymous with excellence in computer books that decipher complex technical topics. With this comprehensive guide, "Mr. Spreadsheet" shows you how to maximize your Excel experience using professional spreadsheet application development tips from his own personal bookshelf. Featuring a complete introduction to Visual Basic for Applications and fully updated for the new features of Excel 2010, this essential reference includes an analysis of Excel application development and is packed with procedures, tips, and ideas for expanding Excel’s capabilities with VBA. Offers an analysis of Excel application development and a complete introduction to Visual Basic for Applications (VBA) Features invaluable advice from "Mr. Spreadsheet" himself (bestselling author John Walkenbach), who demonstrates all the techniques you need to create large and small Excel applications Provides tips, tricks, and techniques for expanding Excel's capabilities with VBA that you won’t find anywhere else This power-user's guide is packed with procedures, tips, and ideas for expanding Excel's capabilities with VBA.



Excel 2007 PivotTables and PivotCharts

Author : Peter G. Aitken

Publisher : John Wiley & Sons

Page : 315 pages

File Size : 36,63 MB

Release : 2007-07-02

Category : Computers

ISBN : 0470169710

Get eBook

Book Description

Devoted entirely to PivotTables and PivotCharts, this book shows you how to take full advantage of these powerful tools, which enable you to pull meaningful information from masses of seemingly meaningless data. Loaded with illustrations and real-world examples, it takes you step by step through creating a PivotTable; formatting, filtering, and grouping data; creating PivotCharts from those data; and more. You’ll learn to work with multidimensional data, how to create and manipulate PivotTables using VBA, and—most importantly—you’ll discover what these tools can do for you.



Excel 2007 Power Programming with VBA

Author : John Walkenbach

Publisher : John Wiley & Sons

Page : 1104 pages

File Size : 34,32 MB

Release : 2011-07-05

Category : Computers

ISBN : 1118050681

Get eBook

Book Description

This book is a single reference that’s indispensable for Excel beginners, intermediate users, power users, and would-be power users everywhere Fully updated for the new release, this latest edition provides comprehensive, soup-to-nuts coverage, delivering over 900 pages of Excel tips, tricks, and techniques readers won’t find anywhere else John Walkenbach, aka "Mr. Spreadsheet," is one of the world’s leading authorities on Excel Thoroughly updated to cover the revamped Excel interface, new file formats, enhanced interactivity with other Office applications, and upgraded collaboration features Includes a valuable CD-ROM with templates and worksheets from the book Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.