Book description
Web sites. Collaboration. Document management. Paperless offices. We want it all in business today, but how do you 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 and 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 small to medium-sized businesses can use to reach these goals.
Office and SharePoint 2007 User's Guide: Integrating SharePoint with Excel, Outlook, Access and Word demystifies the path every Microsoft Office user can follow to benefit from the synergism of tools they are already familiar with. Together with SharePoint 2007, users can achieve goals like web sites with a consistent single view, improved collaboration within their organization, better document management, and maybe 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 the experienced power user. 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.
Table of contents
- Copyright
- Dedication
- About the Author
- About the Technical Reviewer
- Acknowledgments
- Introduction
- An Introduction to SharePoint
-
SharePoint Lists Everything Is a List
- Exploring SharePoint's Built-in List Types
- Creating a New SharePoint List Based on an Existing Template
- Adding Items to Your New List
- Building a Custom List
- Modifying the Columns in Your List
- Using Alerts to Notify You When Your List Is Changed
- Creating RSS Feeds for Your List
- Defining Views for Your List
- Sorting and Filtering Lists
- Summary
-
Creating Content Pages All Content Pages in SharePoint Are Really Web Pages
- Adding a Page to Your Site
- Placing Simple Content on Your New Page
- Adding Functionality with Web Part Pages
- Using Web Parts to Display Libraries and Lists
- Creating Master-Detail Relationships Between Your Lists
- Editing Existing Pages with Check-Out and Check-In
- Tracking Page Versions
- Publishing Pages to Your Site
- Recovering Accidental Deletions with the Recycle Bin
- Summary
-
Using Your Document Library with Microsoft Office
- Opening a SharePoint Document from Within Microsoft Office
- Editing and Saving a Document to a Document Library
- What Is Metadata?
- Using Metadata with the Document Information Panel
- Managing Your Documents with the Document Management Panel
- Other Document Management Panel Features
- Searching Your Documents
- Using Word to Contribute to Your Blog Site
- Understanding Word's New Open XML File Format
- Summary
-
Using Outlook
- Synchronizing Your Contacts Lists Between SharePoint and Outlook
- Synchronizing Your Calendars Between SharePoint and Outlook
- Synchronizing Tasks Between SharePoint and Outlook
- Using Outlook to Work Offline with Content
- Letting Alerts Notify You of SharePoint Changes
- Using Outlook's RSS Reader to Subscribe to SharePoint RSS Feeds
- Sending E-mail to Lists
- Sending Links via Send To
- Summary
-
Managing Lists with Access
- Exporting SharePoint Lists to Access
- Linking SharePoint Lists to Access
- Use Multivalued Fields in Lists
- Creating Access Forms and Reports from a SharePoint List
- Working with Offline Lists Within Access
- Controlling Which Forms and Reports Are Available in SharePoint
- Can Recycle Bin Recover Deleted List Records?
- Summary
- Managing SharePoint Lists from Excel
-
Publishing Excel with Excel Services Why Should I Use Excel Services?
- Configuring Excel Services
- Publishing an Excel Form to Excel Services
- Why You Need Parameters to Make Your Excel Form Interactive
- Defining Parameters for Your Excel Form
- Using the Excel Page Web Part
- Viewing Data from External Sources in Excel Using a Data Connection
- Working with the Report Center
- Introduction to KPIs
- Creating Dashboards with Excel and KPIs
- Summary
-
An Introduction to Creating Forms with InfoPath
- Why You Should Use InfoPath
- Exploring the InfoPath Interface
- Creating a Simple Form
- Migrating Your Existing Word Forms into InfoPath
- Migrating Your Existing Excel Workbook into InfoPath
- Defining InfoPath Views
- Building Data Connections for Forms
- Connecting InfoPath Forms to Data
- Creating and Reusing Form Sections with Template Parts
- Summary
- Publishing InfoPath Forms in SharePoint Libraries
-
Peer-to-Peer Collaboration with Groove
- Getting into the Groove
- A Quick Look at Groove's Other Tools
- Sharing Your Files Using Groove: Simple Group Collaboration
- Setting Up a SharePoint Document Library Connection
- Setting Permissions for the SharePoint Files Folder
- Working on SharePoint Documents Offline
- Protecting Changes with Check-Out and Check-In Along with Versioning
- Collaborating with People Outside Your Organization
- Synchronizing Files Between Groove and SharePoint Document Libraries
- Who Is the Synchronizer?
- Summary
- Additional Supporting Libraries
Product information
- Title: Office and SharePoint 2007 User's Guide: Integrating SharePoint with Excel, Outlook, Access, and Word
- Author(s):
- Release date: May 2008
- Publisher(s): Apress
- ISBN: 9781590599846
You might also like
book
Microsoft SharePoint 2013 Inside Out
Conquer SharePoint 2013—from the inside out! You’re beyond the basics, so dive right into SharePoint 2013—and …
book
Deploying Microsoft 365 Teamwork: Exam MS-300 Guide
Prepare to achieve Microsoft 365 Certified Teamwork Administrator Associate certification by learning essential SharePoint Online concepts, …
book
Check Point NGX R65 Security Administration
Check Point NGX R65 is the next major release of Check Point's flagship firewall software product, …
book
Next Generation Excel: Modeling In Excel For Analysts And MBAs (For MS Windows And Mac OS), 2nd Edition
Take Excel to the next level in accounting and financial modeling In this new Second Edition …