No one is better at revealing the secrets of Excel than "Mr. Spreadsheet" himself. This power-user's guide is packed with procedures, tips, and ideas for expanding Excel's capabilities with Visual Basic® for Applications. Excel 2007 has a few new tricks up its sleeve, and John Walkenbach helps you make the most of them all.



You'll learn to customize Excel UserForms, develop new utilities, use VBA with charts and PivotTables, and create event-handling applications. Work with VBA subprocedures and function procedures, facilitate interactions with other applications, build user-friendly toolbars, menus, and help systems, and much more. Get ready to make Excel do your bidding.

Millions of users create and share Excel spreadsheets every day, but few go deeply enough to learn the techniques that will make their work much easier. There are many ways to take advantage of Excel's advanced capabilities without spending hours on advanced study. Excel Hacks provides more than 130 hacks — clever tools, tips and techniques — that will leapfrog your work beyond the ordinary.Now expanded to include Excel 2007, this resourceful, roll-up-your-sleeves guide gives you little known "backdoor" tricks for several Excel versions using different platforms and external applications. Think of this book as a toolbox. When a need arises or a problem occurs, you can simply use the right tool for the job. Hacks are grouped into chapters so you can find what you need quickly, including ways to:

• Reduce workbook and worksheet frustration — manage how users interact with worksheets, find and highlight information, and deal with debris and corruption.
• Analyze and manage data — extend and automate these features, moving beyond the limited tasks they were designed to perform.
• Hack names — learn not only how to name cells and ranges, but also how to create names that adapt to the data in your spreadsheet.
• Get the most out of PivotTables — avoid the problems that make them frustrating and learn how to extend them.
• Create customized charts — tweak and combine Excel's built-in charting capabilities.
• Hack formulas and functions — subjects range from moving formulas around to dealing with datatype issues to improving recalculation time.
• Make the most of macros — including ways to manage them and use them to extend other features.
• Use the enhanced capabilities of Microsoft Office 2007 to combine Excel with Word, Access, and Outlook.

You can either browse through the book or read it from cover to cover, studying the procedures and scripts to learn more about Excel. However you use it, Excel Hacks will help you increase productivity and give you hours of "hacking" enjoyment along the way.

Author(s) : Liviu Asnash, Eran Megiddo, Craig Thomas
Publisher : Wrox
Year : Mar 2007
ISBN 10 : 0470104899
ISBN 13 : 9780470104897
Language : English
Pages : 404
File type : PDF
Size : 5.5 MB

Excel Services is a new technology being delivered as part of Microsoft Office SharePoint Server 2007. Excel Services will enable managed and secure distribution of Excel reports, incorporating spreadsheets in business intelligence dashboards and portals, protecting the proprietary information in spreadsheets, and building custom applications with Excel-based logic. This book will walk you through the process of understanding what Excel Services is, how your business can benefit from it, and how to incorporate it in your solutions.

This book is designed to be an introduction to Excel Services for all those that want to understand what it is, what it does, what the benefits are, and how to get started. The target audience is IT TDMs and developers that need to come up to speed on the new technologies in Office 2007 and may be responsible for evaluating and deploying Office 2007 and Office SharePoint 2007. This book is also great for all Microsoft partners including system integrators, consulting companies, hosting companies, VARs and independent software vendors that will be building and deploying solutions for their customers based on the new Office technologies. Anyone currently managing or developing solutions with Excel, Windows SharePoint Services, SharePoint Portal Server, or business intelligence solutions should read this book to understand the basics of Excel Services

This book is for anyone who wants to learn what Excel Services is, what it does, what the benefits are, and how to get started. You should have an understanding of Excel, basic knowledge of Excel 2007, and familiarity with Windows SharePoint Services.

The leading Microsoft Office application experts together in one book! Here's the best of the best on Office 2007. Microsoft designed Office 2007 to be used as a package. We designed this Bible as a package that combines the best from the Word, Excel, PowerPoint, Outlook, and Access Bibles with chapters covering Publisher, OneNote, and InfoPath, as well as Groove and SharePoint. It's a veritable buffet of information from some of the leading Office application experts. You'll learn to take advantage of every new feature and how they all work together to help you work better.

Author(s): John L. Viescas
Publisher: MS Press
Year: 2004
ISBN: 0735615136
Language: English
File type: PDF
Pages: 1288
Size (for download): 20 MB


Access is just one part of MS’s overall data management product strategy. Like all good relational databases, it allows you to link related information easily—for example, customer and order data that you enter. But Access also complements other database products because it has several powerful connectivity features. As its name implies, Access can work directly with data from other sources, including many popular PC database programs (such as dBASE and Paradox); with many SQL (structured query language) databases on the desktop, on servers, on minicomputers, or on mainframes; and with data stored on Internet or intranet Web servers.

Access also fully supports MS’s ActiveX technology, so an Access application can be either a client or a server for all the other Office applications, including MS Word, Excel, PowerPoint, Outlook, FrontPage, Publisher, and the new MS OneNote.

Access provides a very sophisticated application development system for the MS Windows operating system. This helps you build applications quickly, whatever the data source. In fact, you can build simple applications by defining forms and reports based on your data and linking them with a few Visual Basic statements; there’s no need to write complex code in the classic programming sense. Because Access uses Visual Basic, you can use the same set of skills with other applications in MS Office or with MS Visual Basic.

MS Access can also act as a direct source of information published on an intranet or the World Wide Web. Data access pages let you quickly create and deploy intranet applications using pages that you create directly from Access much like you would create an Access application form. Data access pages can retrieve and update data stored either in an Access database or in MS SQL Server. MS Access 2003 includes new and enhanced features to allow you to export or import data in XML format (the lingua franca of data stored on the Web) or to directly link to an XML data source on a MS SharePoint Services Web site. You can export data (or subsets of data) stored in a MS Access or SQL Server database to a SharePoint server and then link those files back into your original application.