Excel

Take your Excel formulas to the next level with this updated reference

John Walkenbach's name is synonymous with excellence in computer books that decipher complex technical topics. Known as "Mr. Spreadsheet," Walkenbach provides you with clear explanations on all the methods you can use to maximize the power of Excel with formulas within the frameworks of all the new features of Excel 2010.

You'll learn how to create financial formulas, maximize the power of array formulas, develop custom worksheet functions with VBA, debug formulas, and much more. This invaluable reference is fully updated for the new Microsoft Office release and provides comprehensive formulas coverage, delivering more than 800 pages of Excel tips, tricks, and techniques you won't find anywhere else.

• Demonstrates how to use all the new features of Excel 2010 to maximize your formulas
• Shows how to develop custom worksheet functions with VBA, debug formulas, create financial formulas, and more
• Serves as an indispensable reference no matter your skill level
• Includes a valuable CD-ROM with sample files, templates and worksheets from the book, plus John Walkenbach's award-winning Power Utility Pak

Prepare to excel with Excel when you have John Walkenbach and Excel 2010 Formulas by your side!

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

Take your Excel formulas to the next level with this updated reference

John Walkenbach's name is synonymous with excellence in computer books that decipher complex technical topics. Known as "Mr. Spreadsheet," Walkenbach provides you with clear explanations on all the methods you can use to maximize the power of Excel with formulas within the frameworks of all the new features of Excel 2010.

You'll learn how to create financial formulas, maximize the power of array formulas, develop custom worksheet functions with VBA, debug formulas, and much more. This invaluable reference is fully updated for the new Microsoft Office release and provides comprehensive formulas coverage, delivering more than 800 pages of Excel tips, tricks, and techniques you won't find anywhere else.

• Demonstrates how to use all the new features of Excel 2010 to maximize your formulas
• Shows how to develop custom worksheet functions with VBA, debug formulas, create financial formulas, and more
• Serves as an indispensable reference no matter your skill level
• Includes a valuable CD-ROM with sample files, templates and worksheets from the book, plus John Walkenbach's award-winning Power Utility Pak

Prepare to excel with Excel when you have John Walkenbach and Excel 2010 Formulas by your side!

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

Excel 2010 In Depth is the beyond-the-basics, beneath-the-surface guide for everyone who wants to streamline their work with Excel 2010, and get more done in less time. Legendary Excel expert Bill Jelen provides specific, tested, proven solutions to the problems Excel users run into every day: challenges other books ignore or oversimplify. Jelen thoroughly covers all facets of working with Excel 2010, and adds new chapters on Excel Web App which allows multiple users to edit a spreadsheet simultaneously. New coverage also includes: Slicer, which offers dynamic filtering of PivotTables; Sparklines, which add data visualization to any cell; Calculation engine which improves the speed and accuracy of math, financial, and statistical functions; and the new version of Solver. As with all In Depth books, Excel 2010 In Depth presents comprehensive coverage, breakthrough techniques, exclusive shortcuts, quick access to information, troubleshooting help for tough problems, and real-world examples with nothing glossed over or left out. Step-by-step instructions with icons guide readers through essential tasks such as designing tables, entering data, importing external data, designing and executing queries, and designing data entry forms and printed reports. Additional chapters on advanced form and report design emphasize data entry efficiency and presentation clarity.

• By Bill Jelen, aka MrExcel, an Excel MVP and the principal behind the leading Excel website, MrExcel.com
• Covers all aspects of working with Excel 2010, from its updated Ribbon interface to its breakthrough collaboration and improved business intelligence
• For everyone who wants to get the most out of Excel 2010, from casual users to corporate professionals

Although recognized as a key to the design process, prototyping often falls victim to budget cuts, deadlines, or lack of access to sophisticated tools. This can lead to sloppy and ineffective prototypes or the abandonment of them altogether. Rather than lose this important step, people are turning to Microsoft Excel® to create effective, simple, and inexpensive prototypes. Conveniently, the software is available to nearly everyone, and most are proficient in its basic functionality.

Effective Prototyping with Excel offers how-to guidance on how everyone can use basic Excel skills to create prototypes - ranging from narrative wire frames to hi-fidelity prototypes. A wide array of software design problems and business demands are solved via practical step-by-step examples and illustrations.

. Step-by-step guide to prototyping with a simple and affordable tool nearly everyone already has on their desktop.
. Quickly and easily allows web and software designers to explore usability, design alternatives, and test theories prior to starting production.
. Perfect companion to Effective Prototyping for Software Makers - with the same author team and full-color treatment, useful case studies, and hands-on exercises.

The complete visual reference on Excel basics

Aimed at visual learners who are seeking an all-in-one reference that provides in-depth coveage of Excel from a visual viewpoint, this resource delves into all the newest features of Excel 2010. You'll explore Excel with helpful step-by-step instructions that show you, rather than tell you, how to navigate Excel, work with PivotTables and PivotCharts, use macros to streamline work, and collaborate with other users in one document.

• This two-color guide features screen shots with specific, numbered instructions so you can learn the actions you need to perform in order to execute a wide range of Excel 2010 tasks.
• Features beginning, intermediate andadvanced visual coverage of Excel 2010
• Shows you how to enter information into a worksheet, use formulas and functions, find and control formulaic errors, and much more
• Presents more than 1,000 screen shots that demonstrate step-by-step instructions of numerous Excel 2010 tasks

You're encouraged to move at your own pace as you acquire confidence and proficiency with the newest version of Excel.

ANALYZE HUGE AMOUNTS OF BUSINESS DATA FASTER, MORE EASILY, AND MORE ACCURATELY!

Use Microsoft’s free PowerPivot add-in for Excel 2010 to analyze immense amounts of data from any source, perform state-of-the-art business analysis far more easily, and make better decisions in less time!

Simple, step-by-step instructions walk you through installing PowerPivot, importing data, using PivotTables with PowerPivot, using super-powerful DAX functions and measures, reporting to print or SharePoint, and a whole lot more.

Whatever your Excel data analysis experience, this book will help you use PowerPivot to get the right answers, right now—without IT’s help!

•  Import and integrate data from spreadsheets, SQL Server, Access, Oracle, text files, Atom data feeds, and other sources

•  Analyze multiple tables together, without complicated VLOOKUPs

•  Format, sort, and filter data in the PowerPivot window

•  Add calculated columns using new DAX functions

•  Create powerful reports from PowerPivot data–and format them so executives instantly get your point

•  Discover PivotTable tricks that work even better in PowerPivot

•  Control multiple PivotTable elements on one worksheet, with one set of Excel 2010 Slicers

•  Use DAX Measures to quickly perform tasks that were difficult or impossible with Calculated Fields

•  Compare today’s sales to yesterday’s–or to sales from the parallel period last fiscal year.

•  Use Named Sets to prepare asymmetric reports, show actuals for past months and plan for future months.

About MrExcel Library:  Every book in the MrExcel Library pinpoints a specific set of crucial Excel tasks and presents focused skills and examples for performing them rapidly and effectively. Selected by Bill Jelen, Microsoft Excel MVP and mastermind behind the leading Excel solutions website MrExcel.com, these books will

•  Dramatically increase your productivity–saving you 50 hours a year, or more

•  Present proven, creative strategies for solving real-world problems

•  Show you how to get great results, no matter how much data you have

•  Help you avoid critical mistakes that even experienced users make

If you're a SQL programmer or an experienced Excel user, here at last is the ultimate resource on developing reporting solutions with Excel. Focused on report development using OLTP databases, this book is packed with comprehensive information on both technical and strategic aspects. You'll thoroughly examine the main features of Excel's reporting technology-PivotTable reports, Spreadsheet reports, parameter queries, and web components. With notes, tips, warnings, and real-world examples in each chapter, you'll be able to put your knowledge to work immediately. This book includes:

• Single-source coverage of Excel's report development features
• Extensive and in-depth information on PivotTable and Spreadsheet report features, functions, and capabilities
• Thorough documentation of the Microsoft Query program included with Excel
• Comprehensive information on Excel's client-based OLAP cube tools for processing very large datasets from OLTP data sources
• Detailed information on creating and working with web-enabled Excel reports

• 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.