Writing Excel Macros with VBA, 2nd Edition
To achieve the maximum control and flexibility from Microsoft Excel often requires careful custom programming using the VBA (Visual Basic for Applications) language. Writing Excel Macros with VBA, 2nd Edition offers a solid introduction to writing VBA macros and programs, and will show you how to get more power at the programming level: focusing on programming languages, the Visual Basic Editor, handling code, and the Excel object model. more »
Beginning Microsoft Excel 2010
Beginning Microsoft Excel 2010 is a practical, step-by-step guide to getting started with the world's most widely-used spreadsheet application. The book offers a hands-on approach to learning how to create and edit spreadsheets, use various calculation formulas, employ charts / graphs, and get work done efficiently.

Microsoft rolled out several new features with Excel 2010 - perhaps the most notable was the ability to use Excel 2010 online and collaborate on a project in real time. Beginning Microsoft Office 2010 keeps you up-to-date with all of these features and more. more »
Excel 2010 Made Simple
Get the most out of Excel 2010 with Excel 2010 Made Simple - learn the key features, understand what's new, and utilize dozens of time-saving tips and tricks to get your job done. Over 500 screen visuals and clear-cut instructions guide you through the features of Excel 2010, from formulas and charts to navigating around a worksheet and understanding Visual Basic for Applications (VBA) and macros.

Excel 2010 Made Simple takes a practical and highly effective approach to using Excel 2010, showing you the best way to complete your most common spreadsheet tasks. You'll learn how to input, format, sort, and filter your data to find out what you want to know. You'll see how to place your data in tables and named ranges for easy access, all of which will get you working efficiently and productively. more »
Excel VBA Programming For Dummies, 2nd Edition
Take your Excel skills to the next level with VBA programming

Now that you've mastered Excel basics, it's time to move to the next level-creating your own, customized Excel 2010 solutions using Visual Basic for Applications (VBA). The new edition of this non-threatening guide is your key to getting there. Using step-by-step instruction and the accessible, friendly For Dummies style, this practical book shows you how to use VBA, write macros, customize your Excel apps to look and work the way you want, avoid errors, and more. more »
Excel Formulas and Functions For Dummies, 2nd Edition
Excel is a complex program. Mastering the use of formulas and functions lets you use Excel to compute useful day-to-day information, such as calculating the true cost of credit card purchases or comparing 15-year and 30-year mortgage costs. This fun and friendly book demystifies Excel's built-in functions so you can put them to work.

You'll find step-by-step instructions on 150 of Excel's most useful functions, how they work within formulas, and how to use them to make your life easier. more »
Learn Excel 2011 for Mac
Microsoft Excel 2011 for Mac OS X is a powerful application, but many of its most impressive features can be difficult to find. Learn Excel 2011 for Mac by Guy Hart-Davis is a practical, hands-on approach to learning all of the details of Excel 2011 in order to get work done efficiently on Mac OS X. From using formulas and functions to creating databases, from analyzing data to automating tasks, you'll learn everything you need to know to put this powerful application to use for a variety of tasks. more »
PowerPivot for Business Intelligence Using Excel and SharePoint
PowerPivot comprises a set of technologies for easy access to data mining and business intelligence analysis from Microsoft Excel and SharePoint. Power users and developers alike can create sophisticated, online analytic processing (OLAP) solutions using PowerPivot for Excel, and then share those solutions with other users via PowerPivot for SharePoint. Data can be pulled in from any of the leading database platforms, as well as from spreadsheets and flat files.

The book takes a scenario-based approach to showing you how to collect data, to mine that data through insightful analysis, and to draw conclusions that drive business performance. more »
Office 2010 Bible, 3rd Edition
Get the very most out of Office 2010 with this all-in-one resource. Microsoft Office Bible 2010 combines the best-of-the-best content from the Excel 2010 Bible, Word 2010 Bible, PowerPoint 2010 Bible, and the Access 2010 Bible. You'll get quickly up to speed on the major power tools of Office 2010 - plus find additional content for Publisher, Outlook, and much more. Put Office 2010 to work and make your work easier with this best-of-the-best guide! more »
Excel 2010 Bible
What better way to learn Excel 2010 than from "Mr. Spreadsheet" himself? Excel guru, Microsoft MVP, and author of all the previous top-selling editions of Excel Bible, John Walkenbach provides more than 1,000 pages packed with techniques, tips, and tricks for beginners as well as Excel power users. Discover what's new in Excel 2010, learn shortcuts you didn't know, make the Ribbon interface work for you, and master all the latest ins-and-outs with this must-have guide. more »
Statistical Analysis with Excel For Dummies, 2nd Edition
What do you need to calculate? Manufacturing output? A curve for test scores? Sports stats? You and Excel can do it, and this non-intimidating guide shows you how. It demystifies the different types of statistics, how Excel functions and formulas work, the meaning of means and medians, how to interpret your figures, and more - in plain English. more »