RTM’d today: Microsoft Excel 2010 Formulas & Functions Inside Out
We’re very pleased to announce that Egbert Jeschke, Helmut Reinke, Sara Unverhau, Eckehard Pfeifer, Bodo Fienitz, and Jens Bock’s new book, Microsoft Excel 2010 Formulas & Functions Inside Out, has shipped to the printer!
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; and develop your own functions with Visual Basic for Applications (VBA).
About the Authors
- 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.
Egbert, Helmut, Sara, Eckehard, Bodo, and Jens’ book will be available via online retailers around December 15. In the meantime, here’s more information about the book:
Contents at a Glance
Part 1: Introducing Formulas and Functions in Microsoft Excel
Chapter 1 Solving Problems with Functions
Chapter 2 Using Functions and PowerPivot
Chapter 3 From Numbers to Formulas
Chapter 4 Formulas and Functions
Part 2: Creating Your Own Solutions in Excel
Chapter 5 Special Functions
Chapter 6 Custom Functions
Part 3: Functions
Chapter 7 Date and Time Functions
Chapter 8 Text and Data Functions
Chapter 9 Logical Functions
Chapter 10 Lookup and Reference Functions
Chapter 11 Information Functions
Chapter 12 Statistical Functions
Chapter 13 Database Functions
Chapter 14 Cube Functions (new in Excel 2007)
Chapter 15 Financial Functions
Chapter 16 Mathematical and Trigonometry Functions
Chapter 17 Engineering Functions
Part 4: Appendices
Introduction
At the beginning there was the idea... The proposal to write about every single Excel function with interesting and comprehensible examples came from Helmut Reinke – and everyone on the team agreed. “Yes, this is what Excel users need – a comprehensive reference book with all functions”. This was 8 years ago, and the enthusiasm hasn’t diminished.
At the beginning of this year there was the idea to translate our reference book into English. And what should we say: there were they again, this enthusiasm as in 2007 and the hard nut. But: we have cracked this hard nut and now we are really proud and happy to present you our first function book edition in English. Since we wrote this book, a couple of small Excel revolutions took place: A few years ago Excel 2007 was launched with many new properties and possibilities. For one and a half year now we also have Excel 2010 at our disposal, which includes even more new possibilities. We will address them partially in this book.
We hope that you, dear reader, will welcome this concept, and that this reference work will give you many ideas and support you when needed.
Who This Book Is For
Functions are the powerful tools in Microsoft Excel. Our goal is to give the readers an idea to each single function with the aid of plausible examples so that everyone is capable of using the exhaustless possibilities.
So this book is aimed to everyone who is interested in working with Microsoft Excel – independent of being a beginner or power user or of using Excel privately or on business.
We want to make readers with little experience familiar with the functions so they will see meaningful scenarios to use them.
But we also want to enable a reader who has worked with Excel and provide several scenarios to move to the next level of knowledge.
You want to calculate the probability of gaining in the lottery or have to provide meaningful reporting of the annual sales? No problem. Let’s get started.
Assumptions About You
We make a basic assumption that you are generally experienced in working with Microsoft Office and have a basic idea of Excel. We will spend no time explaining the user interface of Microsoft Excel and the single icons in the new ribbons.
If you are an experienced Excel user Chapter 1 and 2 can be skimmed over. If not we hope to give you an idea of the general possibilities you get with Excel. We hope that the many pages you have in front of you will be helpful to you. Use them to your advantage, and if you like the book, please don’t keep your opinion to yourself. Write to us and let us know what you like about it, and especially what we should improve.
How This Book Is Organized
All the functions have been tested in Excel 2000 to 2010. With the exception of 2007/2010-specific characteristics, most descriptions can even be used with Excel 97. Where necessary we added comments regarding the particularities of the different versions.
The book is divided into four parts.
Part 1: Introducing Formulas and Functions in Microsoft Excel 2010
This part contains Chapters 1-4. They describe working with Excel, provide a general introduction to using Microsoft Excel 2010, and give you a first look at formulas and functions. For beginners and experts alike, we have outlined the use of formulas and table functions with all the important notes, instructions, tips, and tricks.
Because we consider the Excel 2010 add-in PowerPivot quite extraordinary, we have introduced it briefly in this section. It has relatively little to do with spreadsheet functions, but we still wanted to acquaint you with it.
Part 2: Creating Your Own Solutions in Excel
Chapters 5 and 6 show that you can do a lot more with most functions than just use them in a worksheet. You can create and program your own functions.
Chapter 5 Special Functions provides examples for using special functions in names and conditional formatting, as well as for validity and data checks. We hope you will find many ideas and clues for your own Excel solutions here.
Chapter 6 Custom Functions introduce you to programming in Excel. You can create any custom functions in Excel and then use them just like the built-in functions.
Part 3: Functions
Chapters 7 through 17 provide the descriptions of the main Excel functions.
Chapter 7 Date and Time Functions
Chapter 8 Text and Data Functions
Chapter 9 Logical Functions
Chapter 10 Lookup and Reference Functions
Chapter 11 Information Functions
Chapter 12 Statistical Functions
Chapter 13 Database Functions
Chapter 14 Cube Functions (new in Excel 2007)
Chapter 15 Financial Functions
Chapter 16 Mathematical and Trigonometry Functions
Chapter 17 Engineering Functions