Mr. Spreadsheet's Bookshelf
3 primary works • 4 total works
Book 7
Take your Excel formulas to the next level with this updatedreference John Walkenbach's name is synonymous with excellence in computerbooks that decipher complex technical topics. Known as "Mr.Spreadsheet," Walkenbach provides you with clear explanations onall the methods you can use to maximize the power of Excel withformulas within the frameworks of all the new features ofExcel 2010. You'll learn how to create financial formulas, maximize thepower of array formulas, develop custom worksheet functions withVBA, debug formulas, and much more. This invaluable reference isfully updated for the new Microsoft Office release and providescomprehensive formulas coverage, delivering more than 800 pages ofExcel tips, tricks, and techniques you won't find anywhereelse.
* Demonstrates how to use all the new features of Excel 2010 tomaximize your formulas * Shows how to develop custom worksheet functions with VBA, debugformulas, create financial formulas, and more * Serves as an indispensable reference no matter your skilllevel * Includes a valuable CD-ROM with sample files, templates andworksheets from the book, plus John Walkenbach's award-winningPower Utility Pak Prepare to excel with Excel when you have John Walkenbach andExcel 2010 Formulas by your side! Note: CD-ROM/DVD and other supplementary materials arenot included as part of eBook file.
* Demonstrates how to use all the new features of Excel 2010 tomaximize your formulas * Shows how to develop custom worksheet functions with VBA, debugformulas, create financial formulas, and more * Serves as an indispensable reference no matter your skilllevel * Includes a valuable CD-ROM with sample files, templates andworksheets from the book, plus John Walkenbach's award-winningPower Utility Pak Prepare to excel with Excel when you have John Walkenbach andExcel 2010 Formulas by your side! Note: CD-ROM/DVD and other supplementary materials arenot included as part of eBook file.
Book 8
This unique book offers valuable tips and tricks to maximize the capabilities of Excel, the indispensable and immensely popular spreadsheet application. An ideal resource for advancing beginners and intermediate-level users, this book offers shortcuts that are sure to speed up application development with Excel and take readers' skills to the next level. Some of the author's favorite tips and tricks include dealing with function arguments, creating 'impossible' charts, tweaking Pivot Tables, copying print settings across sheets, taming "automatic" toolbars, and using a UserForm. Additional tips and tricks show how to create dynamic chart data, use Analysis Toolpak, sort on more than three columns, attach toolbars to worksheets, enter fake data for testing purposes, apply custom functions, and much more.
Book 12
The go to resource for how to use Excel dashboards and reports to better conceptualize data Many Excel books do an adequate job of discussing the individual functions and tools that can be used to create an "Excel Report." What they don't offer is the most effective ways to present and report data. Offering a comprehensive review of a wide array of technical and analytical concepts, Excel Reports and Dashboards helps Excel users go from reporting data with simple tables full of dull numbers, to presenting key information through the use of high-impact, meaningful reports and dashboards that will wow management both visually and substantively. Details how to analyze large amounts of data and report the results in a meaningful, eye-catching visualization Describes how to use different perspectives to achieve better visibility into data, as well as how to slice data into various views on the fly Shows how to automate redundant reporting and analyses Part technical manual, part analytical guidebook, Excel Dashboards and Reports is the latest addition to the Mr.
Spreadsheet's Bookshelf series and is the leading resource for learning to create dashboard reports in an easy-to-use format that's both visually attractive and effective.
Spreadsheet's Bookshelf series and is the leading resource for learning to create dashboard reports in an easy-to-use format that's both visually attractive and effective.
Save time and be more productive with this helpful guide to Excel macros! While most books about Excel macros offer only minor examples, usually aimed at illustrating a particular topic, this invaluable resource provides you with the tools needed to efficiently and effectively program Excel macros immediately. Step-by-step instructions show you how to create VBA macros and explain how to customize your applications to look and work exactly as you want them to. By the end of the book, you will understand how each featured macro works, be able to reuse the macros included in the book and online, and modify the macro for personal use. * Shows you how to solve common problems with the featured macros, even if you lack extensive programming knowledge * Outlines a problem that needs to be solved and provides the actual Excel macro, as well as the downloadable code, to solve the problem * Provides an explanation of how each macro works and where to use the macro With 101 Ready-to-Use Excel Macros, Microsoft MVP Michael Alexander helps you save time, automate tasks, and ultimately be more productive.