Archive for the 'Microsoft Office' Category
Excel users. Access users. You’re probably among the majority, living in one camp or the other but rarely crossing between the two. Yet Microsoft designed these applications to work together. In this book, you’ll discover how Access benefits from Excel’s flexible presentation layer and versatile analysis capabilities, while Access’s relational database structure and robust querying tools enhance Excel. Once you learn to make the team work, you’ll find that your team’s productivity is the real winner.
* Move data easily between Excel and Access
* Store Excel data in a structured relational database
* Create Excel PivotTables with Access data
* Report Access data using Excel’s presentation layer
* Use VBA, ADO, and SQL to move data from one application to the other
* Save time and increase productivity by automating redundant processes with VBA
* Simplify integration tasks using XML
* Integrate Excel data into other Office applications
Many experienced users may initially find Excel 2007 rather disorientating. But 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.
You’ll learn how to maximize your efficiency at producing professional-looking spreadsheets and charts and become competent at analyzing data using a variety of tools. The book includes practical examples to illustrate advanced features. It also covers new features of Excel 2007 along with ways to access old features. You’ll even gain timesaving tips and shortcuts.
Step-by-step instructions for creating VBA macros
Harness the power of VBA and create custom Excel applications
Make Excel 2007 work for you! This clear, nonintimidating guide shows you how to use VBA to create Excel apps that look and work the way you want. Packed with plenty of sample programs, it explains how to work with range objects, control program flow, develop custom dialog boxes, create custom toolbars and menus, and much more.
Discover how to
* Grasp essential programming concepts
* Use the Visual Basic® Editor
* Navigate the new Excel user interface
* Communicate with your users
* Deal with errors and bugs
