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 liworld’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.
About the Author
John Walkenbach (Tucson, AZ) principal of J-Walk and Associates, Inc. is a leading authority on spreadsheet software and creator of the award-winning Power Utility Pak. He has written more than 30 books and 300 articles and reviews for publications including PC World, InfoWorld, and Windows. He also maintains the popular Spreadsheet Page at www.j-walk.com/ss and promotes all his books at that site.
New to Edition
Students will:
Learn their 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
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
