Conquer Microsoft® Excel® formulas and functions—from the inside out!
You’re beyond the basics, so dive right in and really put Excel formulas and functions to work! This supremely organized reference packs hundreds of timesaving solutions, troubleshooting tips, and workarounds. It’s all muscle and no fluff. Discover how the experts increase their data analysis capabilities using Excel 2003, 2007, or 2010—and challenge yourself to new levels of mastery.
Customize Excel formulas using 350+ built-in functions
Create reusable formulas for common calculations
Learn smarter ways to calculate date and time values
Systematically search worksheets with lookup and reference functions
Perform advanced calculations using mathematical, statistical, and financial functions
Build complex formulas by nesting one function inside of another
Analyze profit margins and more with new functions in Excel 2010
Develop your own functions with Visual Basic® for Applications (VBA)
NOTE: The sample Excel files that accompany the book were updated on 12/4/2012. Click the Companion Content link to download the files.
Microsoft Excel 2010 Formulas and Functions Inside Out
Egbert Jeschke is a Senior Consultant and Trainer who has specialized in Business Intelligence solutions with Excel. As someone who has dedicated his life to relational and multidimensional databases, he appreciates the power of Excel and its use for management solutions. He is author and co-author of several books on the use of office software for Microsoft Press and other publishers.
Helmut Reinke, the spiritus rector of this team, has written for numerous publications on Office applications, business solutions, project management, and business management. He is an organization developer with an emphasis on success and business planning, and is an Excel guru of the first rank. Among his many years in sales and consulting, he has extensive educational experience, which he uses successfully as an instructor and trainer.
Sara Unverhau has a degree in international business administration, specializing in marketing and communications. As a team leader, she combines her passion for both areas with close attention to customer service and the user experience. She has contributed to numerous publications on Microsoft Office and business issues.
Dr. Eckehard Pfeifer is a mathematician from Dresden. He works as a freelance software developer, consultant, and trainer for Microsoft Office. He is a Microsoft Certified Software Developer (MCSD) for .NET, and focuses primarily on the Office environment. He writes for various publications, and is a co-author of several books.
Dr. Bodo Fienitz, Ph.D., teaches in adult education, specializing in the sciences (Chemistry, Physics, and Biology) and IT-related subjects. With his interest in data visualization, he became an expert in Microsoft Excel.
Jens Bock, Business Graduate in Business Administration, works in the field of document and quality management. Through his work as consultant for Web applications, he has years of experience in the use of Microsoft Excel.
Comments about oreilly Microsoft® Excel® 2010 Formulas and Functions Inside Out:
There's plenty of books on the subject of Excel, so I was interested to see how Microsoft Excel 2010 Formulas and Functions Inside Out would fare in such competition. Weighing in at 1088 pages, and split into four sections, it certainly falls into the comprehensive reference category.
In the first section a problem solving approach offers a speedy orientation to some of Excel's most useful formulas and functions. The many insights, tips and tricks also whet the appetite for what's to come.
The second section lifts functions out from the worksheet cells, and spotlights how they can be used within macros to deliver more sophisticated programming solutions. It's a good place to discover new concepts and ideas. Many of these solutions also include visual and charting scenarios, plus there's an introduction to creating custom functions with Excel's built-in Visual Basic for Applications (VBA) development tools.
In both these sections the content is attractively presented in a practical step-by-step flow. Most pages have at least one colourful image, figure or table. The text is further supplemented by plenty of embedded boxes containing notes, tips, associated information and references to sample files. It's a presentation style that lends itself to the experimental approach, rather than a long reading session.
Although not strictly in the formula and function domain, the authors have also thrown in examples of the new PowerPivot in action. A feature I'm sure will be heavily utilised by 2010 edition owners.
Section three is dedicated to in-depth function explanations, suitably organised into category-specific chapters. Despite the technical nature of the content, even here there's no shortage of colourful graphics and informative boxes.
And finally, the appendixes contain the obligatory function lists in A-Z and category arranged format, plus a summary of the features new to Excel 2010.
The comprehensive nature of this reference is further enhanced by a suitably large collection of downloadable sample files. These samples are fully cross referenced by chapter usage at the front of the book.
In conclusion this book is a strong product in this competitive marketplace. It's certainly a book I could recommend to anyone with a basic understanding of Excel and a desire to dig deeper into its potential. And despite being aimed at Excel 2010, there's still a great deal of value for 2003 and 2007 version users.
Bottom Line Yes, I would recommend this to a friend