Microsoft Excel 2010 Formulas & Functions Inside Out, by Egbert Jeschke, Helmut Reinke, Sara Unverhau and Eckehard Pfeifer, is derived from a couple of German language books on the same topic from the Mind GmbH group. Microsoft Office 2010 is latest version from Microsoft after Office 2007.
New features in Office 2010 include a built-in screen capture tool, a background removal tool, new SmartArt templates and author permissions. The 2007 “Office Button” was replaced with a menu button that leads to a full-window file menu, known as Backstage View, giving easy access to task-centered functions such as printing and sharing. A notable accessibility regression from 2007 is that the menu button scores worse with the Fitts’s law accessibility calculation than previous versions. A modified Ribbon interface is present in all Office applications, including Office Outlook, Visio, OneNote, Project, and Publisher. Office applications also have functional jumplists in Windows 7, which would allow easy access to recent items and tasks relevant to the application.
The Outlook Social Connector is a new feature in Microsoft Office 2010, which allows users to connect to and receive updates from their social network inside Microsoft Outlook. When users view their emails a name, picture, and title is available for the person they are contacting. Upcoming appointments can also be viewed with this new feature and users can request friends. Outlook Social Connector currently supports Facebook, LinkedIn, MySpace and Windows Live Messenger.
Microsoft Excel, part of Microsoft Office, is one of the elementary spreadsheet softwares which has been growing in popularity, use and complexity over the years. Frequently there is a desire and need for Excel users to try and use it in ways not known to them.
In such situations they reach out to reference books such as these so as to have a reference book for advanced usage techniques. The feedback from various advanced users is also useful for further improvements in the product.
Microsoft Excel 2010 Formulas & Functions Inside Out under review is a very comprehensive reference on formulas and functions. Not only is the format of large number of functions mentioned but in-depth examples are subsequently provided.
The entire range of functions starting from date and time, text and data, logical and include latest features like power-pivot are explained in details.
The book is highly recommended right from the beginner to the advanced user of Microsoft Excel.