Excel As Your Database is ideal if you need to manage facts and figures, yet have little need for a full-scale relational database management system. You'll learn how to use Excel to enter, store, and analyze your data. This book assumes some exposure to Excel, but no prior experience with databases.
Over 500 screen visuals and clear-cut instructions guide you through the features of Excel 2010, from formulas and charts to navigating around a worksheet and understanding Visual Basic for Applications¬†and macros.
Debra Dalgleish, Microsoft Office Excel "Most Valuable Professional" since 2001, and an expert and trainer in Excel, brings together a one-stop resource for anyone curious about representing, analyzing, and using their data with PivotTables and PivotCharts.
Excel 2007: Beyond the Manual will introduce those who are already familiar with Excel basics to more advanced features, like consolidation, what-if analysis, PivotTables, sorting and filtering, and some commonly used functions.
In this book, Michael Kofler provides definitive coverage of Visual Basic for Applications (VBA)¬†for Excel by showing how it can be used to implement real-world business solutions. Designed to be useful to programmers who have never used VBA before, it also covers advanced topics needed for users already familiar with VBA.
This comprehensive reference explains the new category of software that OneNote represents and its user paradigm, including detailed discussion of features, and interoperability with other programs and services from Microsoft and from third parties.
Beginning SharePoint with Excel is for advanced Excel users who want to extend the usefulness of Excel by adding the collaborative features of SharePoint. The authors provide easy-to-implement examples of powerful business solutions, and they take care to explore the interaction between Excel and SharePoint.
Beginning PivotTables in Excel 2007 explains what PivotTables are, how you can benefit from using them, how to create them and modify them, and how to use their enhanced features. Using a PivotTable in Microsoft Office Excel 2007 is a quick and exciting way to slice and dice a large amount of data.
Beginning OpenOffice Calc is the only book on OpenOffice Calc you will ever need. Introduced by the foremost authority on Calc itself, Jacek Artymiak, the book guides the reader through a sequence of tutorials from the level of beginner to professional mastery.