Civil Engineering Association

Full Version: Excel Bible
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
Excel 2010 Bible

Author: John Walkenbach | Size: 8.86 MB | Format: PDF | Publisher: Wiley | Year: May 10, 2010 | pages: 1056 | ISBN: 0470474874, ISBN-13: 978-0470474877

[Image: 66236556726253776068.jpg]

[Image: info.png]

A comprehensive reference to the newest version of the world’s most popular spreadsheet application: Excel 2010

John Walkenbach's name is synonymous with excellence in computer books that decipher complex technical topics. Known as "Mr. Spreadsheet," Walkenbach shows you how to maximize the power of all the new features of Excel 2010.

An authoritative reference, this perennial bestseller proves itself indispensable no matter your level of skill, from Excel beginners and intermediate users to power users and potential 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 you won’t find anywhere else.

* Excel guru and bestselling author John Walkenbach ("Mr. Spreadsheet") guides you through every aspect of Excel
* Delivers essential coverage of all the newest features of Excel 2010
* Presents material in a clear, concise, logical format that is ideal for all levels of Excel experience
* Includes a CD that contains all the templates and worksheets used in the book plus John Walkenbach's award-winning Power Utility Pak

Excel 2010 Bible serves as an excellent resource on all things Excel!

Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.

[Image: Download.png]
Code:
***************************************
Content of this section is hidden, You must be registered and activate your account to see this content. See this link to read how you can remove this limitation:

http://forum.civilea.com/thread-27464.html
***************************************

Excel 2007 Bible

Author: John Walkenbach | Size: 25.11 MB | Format: PDF | Publisher: Wiley | Year: January 3, 2007 | pages: 866 | ISBN: 0470044039, ISBN-13: 978-0470044032

[Image: 90201806403547505677.jpg]

[Image: info.png]

"John Walkenbach provides excellent examples in this book that Excel users will find very useful."—David McRitchie, Microsoft MVP

The perennial bestseller—now fully updated for Excel 2007!

Whether you're already a power user or just starting, find out how to get the most out of this major new release of Excel from expert instructor and Microsoft MVP, "Mr. Spreadsheet," John Walkenbach. Each of the book's seven parts thoroughly focuses on key elements, so no matter what your level of expertise, you'll find what you need in the hundreds of examples, techniques, and tips in this comprehensive resource.
* Master Excel's new "menu-less" Ribbon user interface
* Understand formulas, functions, tables, worksheets, and workbooks
* Explore the new unlimited conditional formatting
* Develop custom functions, program with VBA, and create UserForms
* Analyze data using external database files and pivot tables
* Enhance your worksheets with new SmartArt tools
* Customize the Quick Access Toolbar and save time

The new Page Layout View displays your worksheet exactly as it will be printed
Easily create summary reports of your data with the enhanced PivotTable tool

[Image: Download.png]
Code:
***************************************
Content of this section is hidden, You must be registered and activate your account to see this content. See this link to read how you can remove this limitation:

http://forum.civilea.com/thread-27464.html
***************************************

Excel 2003 Bible

Author: John Walkenbach | Size: 8.42 MB | Format: PDF | Publisher: Wiley | Year: September 19, 2003 | pages: 936 | ISBN: 0764539671

[Image: 20928610024701712582.jpg]

[Image: info.png]

If Excel 2003 can do it, you can do it too...

Whether you’re just discovering Excel or are already a power user, there’s no better instructor than "Mr. Spreadsheet," John Walkenbach. From basic formulas, functions, and chart creation to data analysis, custom number formats, data validation, and Excel programming with VBA, this is the comprehensive resource for Excel 2003. No matter what your level of expertise, you’ll benefit from hundreds of examples, exercises, tips, techniques, and workarounds, all served with a generous helping of the master’s expert advice.
Inside, you’ll find complete coverage of Excel 2003
* Learn your way around cells, rows, columns, worksheets, workbooks, and ranges
* Discover how to create charts and diagrams, organize lists, and simplify complex tasks using Excel
* Develop formulas that manipulate text, look up values, and perform financial applications
* Analyze data using external database files and pivot tables
* Perform "what if" analysis, use Goal Seek and Solver, and gain proficiency with the Analysis ToolPak
* Use XML to facilitate data reporting, analysis, importing, and exporting
* Explore conditional formatting, link and consolidate worksheets, and use Excel in a workgroup
* Understand how Excel uses HTML in Internet applications
* Program Excel using VBA, develop UserForms, and create custom add-ins

[Image: Download.png]
Code:
***************************************
Content of this section is hidden, You must be registered and activate your account to see this content. See this link to read how you can remove this limitation:

http://forum.civilea.com/thread-27464.html
***************************************