Product Description: Get the most out of Excel 2013 with this exceptional advice from Mr. Spreadsheet himself! Excel 2013 is excellent, but there's lots to learn to truly excel at Excel! In this latest addition to his popular Mr. Spreadsheet's Bookshelf series, John Walkenbach, aka "Mr...read more

Product Description: The best of the best from our Excel, Word, Access, and PowerPoint Bibles! Learn the sought-after features of the core applications from the Office 2013 suite. This Office 2013 Bible features the best-of-the-best content from the Excel 2013 Bible, by "Mr...read more

Take control of your spreadsheets and use VBA to create your own custom Excel applications Author and Excel guru John Walkenbach, known to his devoted fans as "Mr. Spreadsheet," guides you through taking your Excel skills to the next level by creating your own customized spreadsheet solutions using Visual Basic for Applications (VBA). This updated edition of this bestselling 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. Introduces you to a wide array of new Excel 2013 options, beginning with the most important tools and operations for the Visual Basic Editor Provides an overview of the essential elements and concepts for programming with Excel, including using VBA to customize your applications and automate functions Shares techniques for handling errors, debugging, working with range objects, controlling flow, and much more Zeroes in on creating custom dialog boxes, toolbars, and menus Add a personal touch to your spreadsheets and present your data the way you want with Excel VBA Programming For Dummies, 3rd Edition.

Product Description: Si preparar ?excels? te hace perder un monton de tiempo que podrias dedicar a tareas mas productivas, en este manual encontraras las instrucciones basicas para aprender de forma rapida, sin tecnicismos ni argot informatico. Contiene todo lo que necesitas saber:comparar documentos, utilizar hojas de calculo, introducir datos, trabajar con formulas y funciones, y muchas cosas mas, asi como las novedades que incorpora Excel 2010...read more

Product Description: Excel 2010 es una hoja de cálculo extremadamente completa, con numerosas características desconocidas para el usuario común, como Visual Basic para Aplicaciones (VBA), el lenguaje de programación integrado en Excel y en otras aplicaciones de Microsoft Office...read more

An overview of the spreadsheet application for power users explains how to customize Excel UserForms, develop new utilities, use VBA with charts and PivotTables, and facilitate interactions with other applications.

A reference collection of formulas for spreadsheet challenges covers a wide range of applications, from basic to advanced, including financial formulas, nesting functions, error values, naming, cell formatting, protection options, array formulas, PivotTables, and auditing, accompanied by a CD-ROM containing sample workbooks illustrating formula concepts and a Power Utility Pak. Original. (Intermediate/Advanced)

Product Description: Book by Walkenbach, John

Explains Excel's charting basics and covers such topics as trendlines, SmartArt, pivot charts, and VBA.

John Walkenbach comments on the new Excel: "I've been using Excel for over 15 years, and Excel 2007 is by far the most significant upgrade ever. For starters, we've got a new user interface, new open file formats, a larger worksheet grid, better use of memory and CPUs, new functions, and more templates. Dig a bit deeper and you'll find worksheet tables, 100 levels of undo, easier formula construction, better-looking charts, unlimited color choices, SmartArt, a handy page layout view, new conditional formatting options, new collaboration features, a very useful compatibility checker, workbook themes—and even 'skins' so you can change the look of the entire program." John Walkenbach's Favorite Excel 2007 Tips & Tricks consists of a series of non-trivial tips and tricks that cover all aspects of Excel. Tips are improved ways of maximizing the power of Excel to create robust applications. Tricks are shortcuts that will speed up application development with Excel. John's favorites include tips and tricks on dealing with function arguments, creating "impossible" charts, pivot tables, taming the new Ribbon, why use a UserForm, how to create add-ins in Excel 2007, absolute vs. relative references, changing data entry orientation, overcoming the 7-level nesting limit, dynamic chart data, sorting on more than three columns, entering fake data for testing purposes, custom functions, and much more.

Product Description: A must-have collection of Office 2010 application Bibles, written by the world?s leading experts Talk about a bargain! Office 2010 Library offers enormous savings on four invaluable resources that boast nearly 5,000 pages and cover the core Office programs: Excel, Access, PowerPoint, and Word...read more

Product Description: The best of the best from the bestselling authors of Excel, Word, and PowerPoint Bibles! Take your pick of applications from the Office 2010 suite and your choice of leading experts to show you how to use them. This Office 2010 Bible features the best-of-the-best content from the Excel 2010 Bible, by "Mr...read more

Product Description: Aunque millones de personas utilizan habitualmente Excel, la mayoría no llega a dominar ni siquiera la mitad de sus posibilidades. Este libro encontrará suficiente información para poder usar el programa en una nueva dimensión...read more