Office and SharePoint 2010 User's Guide: Integrating SharePoint with Excel, Outlook, Access and Word

  • 11h 11m
  • Michael P. Antonovich
  • Apress
  • 2010

Web sites, collaboration, document management, paperless offices—we want it all in business today, but how do we achieve all of these goals? More importantly, if you work for one of the millions of small-to-medium-sized businesses, how do you find the time to build the expertise necessary to reach these goals? Even the most powerful tool will not allow you to succeed unless you can get the majority of your staff to use it efficiently and effectively. You need a guide that demonstrates a platform that small-to-medium-sized businesses can use to reach these goals.

Office and SharePoint 2010 User’s Guide demystifies the path that every Microsoft Office user can follow to benefit from the synergism of tools they are already familiar with. Together with SharePoint 2010, users can achieve goals like web sites with a consistent single view, improved collaboration within their organization, and better document management, and may even get one step closer to the paperless office we’ve been promised for years. This book has topics for Office users of all skill levels, from those just starting to use Office tools to experienced power users. It examines each major Office tool and shows how it contributes to the support and use of SharePoint in today’s increasingly electronic-based office environment.

What you’ll learn

  • How to access, customize, share, and extend SharePoint document libraries in conjunction with Word, Excel, and other Office products
  • Different ways of working through Office while interacting with SharePoint, like synchronizing your calendar and contacts, exporting databases, and modifying them with SharePoint’s list view
  • The best ways of managing content across teams and your entire organization
  • What it really means to leverage all of SharePoint’s capabilities by tying them directly into the Office applications you use every day

About the Author

Michael P. Antonovich graduated from Lehigh University with a bachelor's degree in chemical engineering in 1976 and a MBA in 1980, but his career almost from the start evolved toward computers and application development. He started working with large mainframe systems but quickly developed a keen interest in microcomputers when Apple introduced its Apple II, for which he wrote his first book in 1983. Over the years, he has learned many different systems, applications, and programming languages, but the first development environment he felt really strong about was FoxBase and later FoxPro. During the 90s, he published four books on FoxPro before the Internet and SQL Server bug bit him.

In addition to his full-time jobs developing applications, he has conducted dozens of different computer training classes for companies and universities over the years. Since his first SharePoint book, Michael has become a regular speaker at many of the SQL Saturday, Code Camp, and SharePoint Saturday events in the state of Florida, having presented nearly two dozen sessions in the last three years. He also has been serving on the Information Technology Advisory Committee of Valencia Community College.

In 2003, he joined the IT team of Orange County Public Schools as they prepared to launch a major new student tracking system. But the lure of the Internet along with a "little" product called SharePoint pulled him back into Internet development in the fall of 2006, when he took on the task of heading up the technical team to develop a new SharePoint portal for the school district that would provide all users with a single, consistent, easy-to-use interface. Since then, his team has completed the refresh and branding of all district Internet and intranet sites. They also worked with representatives from each of the over 170+ schools in the district to create new branded sites that follow a common site template providing consistency in locating information across the schools. Currently, Michael's team is preparing for a refresh of the branding for both the schools and intranet sites to enhance the consistency between sites further and to take advantage of the new SharePoint 2010 features. They are also committed to expanding the number of applications embedded or run through SharePoint employee sites to help reduce the district's paper usage and improve operating efficiencies. Orange County Public Schools is the 10th largest school district in the United States.

In this Book

  • Introduction
  • An Overview of SharePoint
  • SharePoint Lists
  • Creating Content Pages
  • Using Your Document Library with Microsoft Office
  • Using Outlook
  • Managing Lists with Access
  • Managing SharePoint Lists from Excel
  • Publishing Excel with Excel Services
  • An Introduction to Creating Forms with InfoPath
  • Publishing InfoPath Forms in SharePoint Libraries
  • Peer-to-Peer Collaboration with SharePoint Workspace
  • Additional Supporting Libraries


Rating 4.0 of 1 users Rating 4.0 of 1 users (1)
Rating 4.6 of 37 users Rating 4.6 of 37 users (37)