- Subscribe to this page:
- RSS
- Email Alert
software tips
(587 results)-
White Papers
Create A New Database
Jun 2007
This white paper covers the basic process of starting Office Access 2007 and creating a database, either by using a template or by creating your own tables, forms, reports, and other database...
Provided by Microsoft
-
White Papers
Goal: Distribute Project Information In Printed Format
Jun 2007
This paper contains the activities which are defined as "Goals" because they are organized around the project management life cycle. After your project is scheduled, you may want to distribute the...
Provided by Microsoft
-
White Papers
Open An Existing Database
Jun 2007
This white paper describes the different methods you can use to open existing Microsoft Office Access 2007 databases. You can open databases from Windows Explorer or from within Access itself. You...
Provided by Microsoft
-
White Papers
Goal: Distribute Project Information Online
Jun 2007
This paper is about goals which are described as activities because they are organized around the project management life cycle. After you schedule your project, you may want to distribute the...
Provided by Microsoft
-
White Papers
Add One Or More Records To A Database
Jun 2007
This white paper explains how to enter data into a Microsoft Office Access 2007 database. It also provides the background information needed to understand the various data entry processes, and it...
Provided by Microsoft
-
White Papers
About Scheduling
Jun 2007
Project schedules a project from the information you enter about the following-The overall project, the individual work items required to complete the project, the resources needed to complete...
Provided by Microsoft
-
White Papers
Import Or Link To Data In A Text File
Jun 2007
You can bring data from a text file into Microsoft Office Access 2007 in two ways. If you want a copy of the data that you can edit within Access, import the file into a new or existing table by...
Provided by Microsoft
-
White Papers
Define Your Project Goals And Success Criteria
Jun 2007
Defining project success seems simple - deliver on time and on budget. But are those really the success factors that are most important to your customer, the project sponsor? As a project manager,...
Provided by Microsoft
-
White Papers
Export A Database Object To Another Access Database
Jun 2007
Access provides a number of ways to copy an object such as a table or form from one database to another. Copying and pasting an object is easiest, but exporting an object offers you more options....
Provided by Microsoft
-
White Papers
Use Data Stored In Other File Formats When Building A Project Plan
Jun 2007
As a project manager, you may need to integrate data from different programs into your Microsoft Office Project plans. For example, you may start out listing your Work Breakdown Structure (WBS)...
Provided by Microsoft
-
White Papers
Export A Table Or Query To A Sharepoint Site
Jun 2007
If members of your department or workgroup use Windows SharePoint Services 2.0 or later to communicate and collaborate with each other, you might encounter scenarios where some of the data in your...
Provided by Microsoft
-
White Papers
Use The Microsoft Office System To Meet Operations Challenges
Jun 2007
Choosing the best technology for your business is more complex than ever - and it's crucial. Project and process management tools are essential to your operational efficiency, but determining the...
Provided by Microsoft
-
White Papers
Export Data To A Text File
Jun 2007
You can export data from Office Access 2007 in a variety of formats, including Microsoft Office Excel 2007, Microsoft Office Word 2007, and Microsoft Windows SharePoint Services 3.0 lists. This...
Provided by Microsoft
-
White Papers
Leveraging The Power Of Project Team Collaboration
Jun 2007
An alarming percentage of IT projects do not deliver expected functionality on schedule and within budget, and many projects are canceled before they are completed. Team collaboration issues are...
Provided by Microsoft
-
White Papers
Create A Validation Rule To Validate Data In A Field
Jun 2007
A validation rule limits or controls what users can enter in a table field or a control (such as a text box) on a form. Microsoft Office Access 2007 provides a number of ways to validate data, and...
Provided by Microsoft
-
White Papers
Present Your Microsoft Project Schedule In A Simple Format By Using Visio
Jun 2007
When you design a presentation for customers or upper management, you want to be clear and thorough. But you probably don't want to include the level of detail that is important to a project...
Provided by Microsoft
-
White Papers
Set Default Values For Fields Or Controls
Jun 2007
This white paper explains how to set a default value for a table field or for a control on a form in a Microsoft Office Access 2007 database. The default values that you set will appear in the...
Provided by Microsoft
-
White Papers
Fast-Track Tasks To Shorten Your Project Schedule
Jun 2007
"Fast-tracking" is often the most effective way to shorten the duration of a project. You fast-track a project by scheduling tasks that were originally scheduled to run one after the other to run...
Provided by Microsoft
-
White Papers
Create An Input Mask To Enter Field Or Control Values In A Specific Format
Jun 2007
An input mask is a set of literal characters and mask characters that control what you can and cannot enter in a field. Input masks control how users enter data into a database. For example, an...
Provided by Microsoft
-
White Papers
Display Multiple Currencies In Project For International Projects
Jun 2007
Are you a project manager who works on international projects? What if you have team members in Germany, subcontractors in China, and a client in Japan? In a situation like this, chances are...
Provided by Microsoft
-
White Papers
Create And Use An Index To Improve Performance
Jun 2007
If you often search a table or sort its records by a particular field, you can speed up these operations by creating an index for the field. This paper introduces indexes and covers how to decide...
Provided by Microsoft
-
White Papers
Improve Your Process - And Your Bottom Line - With Six Sigma
Jun 2007
Six Sigma is a powerful approach to improving processes to do things better, faster, and at lower cost. It can be applied to every facet of business, from production, to human resources, to order...
Provided by Microsoft
-
White Papers
Collect Data By Using E-Mail Messages
Jun 2007
Microsoft Office Access 2007 makes it easy to gather data from people who are located anywhere on the globe, such as members of your sales team, survey participants, or contacts. Office Access...
Provided by Microsoft
-
White Papers
Manage Project Risks And Issues
Jun 2007
Management of project risks and issues is one of the most critical yet easily overlooked aspects of successful project management. Risks and issues can quickly derail plans and divert focus from...
Provided by Microsoft
-
White Papers
Data Collection E-Mail Options
Jun 2007
Use the Collecting Data Using E-Mail Options dialog box to view and change the options that control how Microsoft Office Access 2007 processes replies to a data collection e-mail message. The...
Provided by Microsoft
-
White Papers
Attract Client Mindshare
Jun 2007
Clients often embark on new consulting projects with the best of intentions. Over time, however, conflicting demands prevent clients from devoting to your project the time that's desired or even...
Provided by Microsoft
-
White Papers
Using Your Own Labels In Formulas
Jun 2007
Cell references can make formulas harder to read, especially when your worksheet has lots of complex formulas. Fortunately Microsoft Excel 2000 provides an easier way to refer to cells whenever a...
Provided by Microsoft
-
White Papers
About Project Crashing (Shortening A Project Schedule)
Jun 2007
Adding more resources to a project to shorten its duration is called "crashing". For non-project managers, crashing seems like an obvious thing to do. But adding resources to a project is often...
Provided by Microsoft
-
White Papers
Enable Autofilter Functionality For A Protected Worksheet
Jun 2007
By default, the AutoFilter functionality in Excel becomes unavailable when you protect part or all of a spreadsheet. If you use Microsoft Office Excel 2003 or Excel 2002, you can restore that...
Provided by Microsoft
-
White Papers
About Risk Identification
Jun 2007
Project managers typically classify risks as either "threats" or "opportunities." The practice of risk identification focuses on reducing the probability and impact of a threat while increasing...
Provided by Microsoft
-
White Papers
Insert Julian Dates In Worksheets
Jun 2007
The phrase "Julian date" is used to refer to a date format that is a combination of the current year, and the number of days since the beginning of the year. For example, January 1, 2003 is...
Provided by Microsoft
-
White Papers
About Scope Management
Jun 2007
Managing the scope of a project is an important part of project management. By properly managing the scope of your project, you help to ensure that only the essential work required for project...
Provided by Microsoft
-
White Papers
Making Links Easier To Maintain
Jun 2007
This white paper explains us the different ways of updating and maintaining the links in Excel. Links can be updated manually, automatically, when the source book is not available, when the source...
Provided by Microsoft
-
White Papers
Build Effective Project Teams
Jun 2007
A project team is a group that works together to execute the tasks necessary to meet customer requirements. Before a project team meets for the first time, before they start "forming, storming,...
Provided by Microsoft
-
White Papers
Use The Group Command To Show And Hide Data
Jun 2007
Instead of constantly updating separate files and worksheets, wouldn't it be great if you could maintain all your data in one worksheet, then show certain details to your boss but hide them from...
Provided by Microsoft
-
White Papers
Communicate With Project Stakeholders
Jun 2007
As a project manager, you spend most of your time communicating. You deliver information upward and downward, internally and externally. Daily, you make and receive status reports, e-mail...
Provided by Microsoft
-
White Papers
Using A Validation List In Another Worksheet Or Workbook
Jun 2007
Data validation is an Excel feature that helps users enter data correctly on worksheets. One form of data validation lets you define a source list, elsewhere on the worksheet, of the possible...
Provided by Microsoft
-
White Papers
Improve Project Performance By Sharing Information
Jun 2007
Unfortunately, people sometimes attempt to amass power by keeping information to themselves. In project management, however, the opposite approach is the most effective. Sharing project...
Provided by Microsoft
-
White Papers
Data Validation 1: Control User Choices With Lists In Excel
Jun 2007
Have you ever needed to create drop-down lists or otherwise control the type of data that users enter on a worksheet? Drop-down lists provide one form of data control by forcing users to select...
Provided by Microsoft
-
White Papers
Know When To Pull The Plug On A Doomed Project
Jun 2007
Project managers focus on bringing a project to a successful conclusion. But what about a project that shouldn't be completed? Knowing when to pull the plug on a project is an important skill to...
Provided by Microsoft
-
White Papers
Create A New Project From An Existing Project Or Database
Jun 2007
You may find it helpful to base a new project on an existing Microsoft Office Project (MPP) file or a Microsoft Office Project Database (MPD) file. When basing a new project on an existing project...
Provided by Microsoft
-
White Papers
What's My Job? A Guide To Planning The Best Training Programs
Jun 2007
As training manager, you need to be adept at developing successful learning programs so you can support individual and company goals. To do this, you need to encourage participation not only at...
Provided by Microsoft
-
White Papers
Improvements To Deploying Data Access Pages In Access
Jun 2007
One goal of Access 2002 is to make it less confusing to create and deploy data access pages. Access 2002 has added database, project, and page properties that make it easier to deploy pages that...
Provided by Microsoft
-
White Papers
Create A New Project From A Template
Jun 2007
Microsoft Office Project 2007 provides several templates. A template Project file format [.mpt] lets you reuse existing schedules as the starting point for creating new schedules. Task and...
Provided by Microsoft
-
White Papers
Streamline Your Recruiting Process With Outlook 2003
Jun 2007
Everyone in your HR department wants to get new employees on board as efficiently as possible. A long, drawn-out recruiting process is hard on everyone, from recruiters to hiring managers to...
Provided by Microsoft
-
White Papers
Using Page Events To Add Custom Functionality In Access
Jun 2007
This paper explains how to use page events to add custom functionality in Access. This paper also has some attributes which is related to page events like Focus event, BeforeDelete event,...
Provided by Microsoft
-
White Papers
Create A New Project
Jun 2007
When creating a new project, you can choose to schedule the project from a start date or a finish date, and you can define specific file properties to help you organize or find your project. After...
Provided by Microsoft
-
White Papers
Protect The Confidentiality Of Employee Performance Assessments
Jun 2007
Employee performance assessments are confidential by nature, and as an HR professional, it's your job to protect that confidentiality. But you also need to be able to share this information with...
Provided by Microsoft
-
White Papers
View And Upload Documents To Project Server
Jun 2007
Before you add a document to a document library, you must be connected to Microsoft Office Project Server 2007 and a workspace site needs to be created for your project. Typically, a workspace...
Provided by Microsoft
-
White Papers
Modifying The Row Source Of A List Box On A Data Access Page In Access
Jun 2007
When you add a drop-down list box or list box to a data access page by using a wizard, Access sets the ListRowSource property of the drop-down list box or list box to the table or query you...
Provided by Microsoft
-
White Papers
Collect And Protect Confidential HR Information
Jun 2007
HR professionals often work with personal information about employees, such as medical and financial records. This white paper is useful for developing important HR reports, but it isn't just data...
Provided by Microsoft
-
White Papers
View And Edit Project Issues And Risks
Jun 2007
All projects are challenged by issues and risks. A risk is an event or situation that can negatively affect a project, if it occurs. In contrast, issues are events that are already happening....
Provided by Microsoft
-
White Papers
Improvements To Creating Data Access Pages In Access
Jun 2007
A common issue with data access pages in Access 2000 relates to creating pages using the Page Wizard. The wizard does not allow you to set the UniqueTable property, which specifies the table whose...
Provided by Microsoft
-
White Papers
Generate And Manage Leads
Jun 2007
As a personal financial advisor, you need to generate new business in order to be successful. Before you begin making those painful cold calls or handing out business cards at conferences to drum...
Provided by Microsoft
-
White Papers
Open Or Edit A File In A Sharepoint Library
Jun 2007
The method that you choose to open or edit a file in a library on a Microsoft Windows SharePoint Services site depends on what you want to do with the file and how the library is set up. For...
Provided by Microsoft
-
White Papers
Improvements To Browsing Data Access Pages In Access
Jun 2007
In Access 2000, the ability to update data in a page is very limited. Most of these limitations have been removed in Access 2002. The paper also provides a table which summarizes the similarities...
Provided by Microsoft
-
White Papers
Create Logical Folder Structures In Outlook Stay In The Loop With The Tablet PC Or Pocket PC
Jun 2007
As a manager, you probably have incidental meetings and other unplanned events happening to you all the time. Maybe someone you pass in the hall needs to chat about an ongoing project. Maybe you...
Provided by Microsoft
-
White Papers
View Project Files If You Don't Have Project 2007 Installed
Jun 2007
Microsoft doesn't have a viewer program that enables you to open a project file on a computer that doesn't have Microsoft Office Project 2007 installed. However, if you don't have Office Project...
Provided by Microsoft
-
White Papers
Adding Items To Combo Boxes And List Boxes Programmatically In Access
Jun 2007
When you need to give users a list of choices, you typically provide those choices in a combo box control or a list box control. Most Access developers use combo boxes because they're more...
Provided by Microsoft
-
White Papers
E-Mail Tips For Real Estate Agents
Jun 2007
Not so many years ago, most real estate professionals couldn't imagine conducting business without a telephone or a fax machine. Today, the paradigm of business communication is e-mail. In the...
Provided by Microsoft
-
White Papers
Add A Note To A Task, Resource, Or Project
Jun 2007
This paper gives information of how to add a note to a task, resource, or project and its steps as to how to proceed. To include additional or supporting information, you add a note to a task,...
Provided by Microsoft
-
White Papers
Creating A New Database
Jun 2007
Creating the structure for a database is easy. But an empty database is no more useful than an empty Microsoft Office Word document or an empty Microsoft Office Excel worksheet. It is only when...
Provided by Microsoft
-
White Papers
Search The Web, Your Desktop, And E-Mail With The MSN Search Toolbar
Jun 2007
The MSN Search Toolbar - a new feature that's available as a free download from the MSN Web site - is a great tool for searching the Web for information and for searching your computer for...
Provided by Microsoft
-
White Papers
Save A File To A Sharepoint Library Or Another Web Location
Jun 2007
A SharePoint site or document management server can provide a central location for people to manage and track files. For example, you can use a SharePoint library to manage versions of files,...
Provided by Microsoft
-
White Papers
Web Solutions Using Access
Jun 2007
Using Access 2002, you can create a variety of solutions for the Web. The Microsoft Developer Network (MSDN) and Office Online sites offer a number of Access-related articles to get you started....
Provided by Microsoft
-
White Papers
Create Logical Folder Structures In Outlook
Jun 2007
Organizing your e-mail is really about achieving two goals. The first goal is to save old messages where you can find them quickly. The second goal is to distinguish easily between messages you've...
Provided by Microsoft
-
White Papers
Create A Connection To Microsoft Office Project Server
Jun 2007
To connect to Microsoft Office Project Server you need a Project Server account. To create an account, you must first start Microsoft Office Project offline. Then you can create the account, exit...
Provided by Microsoft
-
White Papers
Organize Newsletter Content With Linked Text Boxes
Jun 2007
If you've ever had to create a newsletter or other publication with multiple articles and pictures, you know that it can be difficult to fit everything in the space allowed. Using linked text...
Provided by Microsoft
-
White Papers
Managing The Size Of Your Mailbox
Jun 2007
If the messages in your mailbox are taking up too much space, you've probably already been warned to start deleting some of them or risk being unable to send and receive mail. You can take steps...
Provided by Microsoft
-
White Papers
The Duration Or Work Value Changed Unexpectedly When I Assigned A Resource
Jun 2007
When you assign a resource to a task, the duration or work value changes automatically. The duration, work, and resource assignments for a task are interlinked. When you assign a resource to a...
Provided by Microsoft
-
White Papers
Linking To External Data Sources In An Access Project
Jun 2007
The Link Table Wizard is a new feature of Access 2002. If your Access project is connected to a Microsoft SQL Server version 7.0 or later database, or to a SQL Server 2000 Desktop Engine running...
Provided by Microsoft
-
White Papers
Develop Positive Relationships With Parents
Jun 2007
Parents' involvement in their child's education is a key factor in the child's scholastic success. Parental participation ranges from paying little or no attention to overt hovering. As the...
Provided by Microsoft
-
White Papers
Set The Status Date
Jun 2007
Microsoft Office Project uses the status date to display progress with progress lines, include non-time phased progress information such as percent complete in a project, or to calculate earned...
Provided by Microsoft
-
White Papers
Avoiding Divide By Zero Errors In Access
Jun 2007
If you try to divide a number by zero in Access, you receive a #DIV/0 error if you are in a form or report, or a #ERROR if you are in a query. This paper has the steps which demonstrate the...
Provided by Microsoft
-
White Papers
Copy Outlook Contacts To The Outlook Express Address Book
Jun 2007
Outlook Express is a no-cost, basic e-mail program that is included with Microsoft Internet Explorer. Outlook Express stores contacts in a Microsoft Windows Address Book file with an extension of...
Provided by Microsoft
-
White Papers
Use A PERT Analysis To Estimate Task Durations
Jun 2007
You have many ways to gather information to estimate durations. However, most of these methods don't allow you the flexibility of analyzing best-case and worst-case scenarios. A Program,...
Provided by Microsoft
-
White Papers
Roadmap For Updating The Data In Your Access Database
Jun 2007
Access provides several tools for adding, changing, removing, and otherwise updating the data in a database. So, which tool do you use? This topic provides a "roadmap" that briefly describes the...
Provided by Microsoft
-
White Papers
Show The Critical Path
Jun 2007
To meet a specific finish date for your project, it is important to keep an eye on the project's critical path. You can display the critical path in any of several ways, and you can also change...
Provided by Microsoft
-
White Papers
Want To Mail Your Survey? Do It Now!
Jun 2007
Are you in charge of doing a survey or conducting a poll? Is e-mail the best way to get in touch with the participants? Do you want to store the data in an Access database or a Microsoft SQL...
Provided by Microsoft
-
White Papers
Import And Export Text Data With Outlook
Jun 2007
Using a text file is helpful when the converters that are provided with Outlook do not directly match the format of the data that you want to import. Most programs can export and import text...
Provided by Microsoft
-
White Papers
Fast-Track Tasks To Shorten Your Project Schedule
Jun 2007
"Fast-tracking" is often the most effective way to shorten the duration of a project. You fast-track a project by scheduling tasks that were originally scheduled to run one after the other to run...
Provided by Microsoft
-
White Papers
Create An Input Mask To Enter Field Or Control Values In A Specific Format
Jun 2007
An input mask is a set of literal characters and mask characters that control what you can and cannot enter in a field. Input masks control how users enter data into a database. For example, an...
Provided by Microsoft
-
White Papers
Display Multiple Currencies In Project For International Projects
Jun 2007
Are you a project manager who works on international projects? What if you have team members in Germany, subcontractors in China, and a client in Japan? In a situation like this, chances are...
Provided by Microsoft
-
White Papers
Create And Use An Index To Improve Performance
Jun 2007
If you often search a table or sort its records by a particular field, you can speed up these operations by creating an index for the field. This paper introduces indexes and covers how to decide...
Provided by Microsoft
-
White Papers
Improve Your Process - And Your Bottom Line - With Six Sigma
Jun 2007
Six Sigma is a powerful approach to improving processes to do things better, faster, and at lower cost. It can be applied to every facet of business, from production, to human resources, to order...
Provided by Microsoft
-
White Papers
Collect Data By Using E-Mail Messages
Jun 2007
Microsoft Office Access 2007 makes it easy to gather data from people who are located anywhere on the globe, such as members of your sales team, survey participants, or contacts. Office Access...
Provided by Microsoft
-
White Papers
Manage Project Risks And Issues
Jun 2007
Management of project risks and issues is one of the most critical yet easily overlooked aspects of successful project management. Risks and issues can quickly derail plans and divert focus from...
Provided by Microsoft
-
White Papers
Data Collection E-Mail Options
Jun 2007
Use the Collecting Data Using E-Mail Options dialog box to view and change the options that control how Microsoft Office Access 2007 processes replies to a data collection e-mail message. The...
Provided by Microsoft
-
White Papers
Attract Client Mindshare
Jun 2007
Clients often embark on new consulting projects with the best of intentions. Over time, however, conflicting demands prevent clients from devoting to your project the time that's desired or even...
Provided by Microsoft
-
White Papers
Using Your Own Labels In Formulas
Jun 2007
Cell references can make formulas harder to read, especially when your worksheet has lots of complex formulas. Fortunately Microsoft Excel 2000 provides an easier way to refer to cells whenever a...
Provided by Microsoft
-
White Papers
About Project Crashing (Shortening A Project Schedule)
Jun 2007
Adding more resources to a project to shorten its duration is called "crashing". For non-project managers, crashing seems like an obvious thing to do. But adding resources to a project is often...
Provided by Microsoft
-
White Papers
Enable Autofilter Functionality For A Protected Worksheet
Jun 2007
By default, the AutoFilter functionality in Excel becomes unavailable when you protect part or all of a spreadsheet. If you use Microsoft Office Excel 2003 or Excel 2002, you can restore that...
Provided by Microsoft
-
White Papers
About Risk Identification
Jun 2007
Project managers typically classify risks as either "threats" or "opportunities." The practice of risk identification focuses on reducing the probability and impact of a threat while increasing...
Provided by Microsoft
-
White Papers
Insert Julian Dates In Worksheets
Jun 2007
The phrase "Julian date" is used to refer to a date format that is a combination of the current year, and the number of days since the beginning of the year. For example, January 1, 2003 is...
Provided by Microsoft
-
White Papers
About Scope Management
Jun 2007
Managing the scope of a project is an important part of project management. By properly managing the scope of your project, you help to ensure that only the essential work required for project...
Provided by Microsoft
-
White Papers
Making Links Easier To Maintain
Jun 2007
This white paper explains us the different ways of updating and maintaining the links in Excel. Links can be updated manually, automatically, when the source book is not available, when the source...
Provided by Microsoft
-
White Papers
Build Effective Project Teams
Jun 2007
A project team is a group that works together to execute the tasks necessary to meet customer requirements. Before a project team meets for the first time, before they start "forming, storming,...
Provided by Microsoft
-
White Papers
Use The Group Command To Show And Hide Data
Jun 2007
Instead of constantly updating separate files and worksheets, wouldn't it be great if you could maintain all your data in one worksheet, then show certain details to your boss but hide them from...
Provided by Microsoft
-
White Papers
Communicate With Project Stakeholders
Jun 2007
As a project manager, you spend most of your time communicating. You deliver information upward and downward, internally and externally. Daily, you make and receive status reports, e-mail...
Provided by Microsoft
-
White Papers
Using A Validation List In Another Worksheet Or Workbook
Jun 2007
Data validation is an Excel feature that helps users enter data correctly on worksheets. One form of data validation lets you define a source list, elsewhere on the worksheet, of the possible...
Provided by Microsoft
-
White Papers
Improve Project Performance By Sharing Information
Jun 2007
Unfortunately, people sometimes attempt to amass power by keeping information to themselves. In project management, however, the opposite approach is the most effective. Sharing project...
Provided by Microsoft
-
White Papers
Data Validation 1: Control User Choices With Lists In Excel
Jun 2007
Have you ever needed to create drop-down lists or otherwise control the type of data that users enter on a worksheet? Drop-down lists provide one form of data control by forcing users to select...
Provided by Microsoft
-
White Papers
Know When To Pull The Plug On A Doomed Project
Jun 2007
Project managers focus on bringing a project to a successful conclusion. But what about a project that shouldn't be completed? Knowing when to pull the plug on a project is an important skill to...
Provided by Microsoft
-
White Papers
Four Ways To Publish External Data Ranges To The Web
Jun 2007
An external data range is data from a separate source, such as a Microsoft Access or SQL Server database, that you've brought into Microsoft Excel. You can format the data in Excel and add...
Provided by Microsoft
-
White Papers
Develop And Present Project Plan, Scope, And Timeline
Jun 2007
Management consulting projects often drive mission-critical initiatives within a client organization. They can also consume valuable client resources such as time and money. Developing project...
Provided by Microsoft
-
White Papers
Correcting Sorting Problems With Text And Numbers
Jun 2007
If only a few rows were out of order when you sorted the list, the quickest way to correct the problem is to format any text cells as numbers and then re-enter the values to store them as numbers....
Provided by Microsoft
-
White Papers
Manage Costs During The Project Life Cycle
Jun 2007
During a project life cycle, a project manager must continuously compare actual costs to the budget in order to stay within the project's projected costs. As a project manager, you can use several...
Provided by Microsoft
-
White Papers
Data Validation 2: Using Other Validation Tools In Excel
Jun 2007
Although lists are handy and easy to use, they're just one form of data validation. Put briefly, in addition to creating drop-down lists, you can validate numbers, dates, times, and text. This...
Provided by Microsoft
-
White Papers
About Communication Planning
Jun 2007
Communication planning can dramatically affect the outcome of a project, especially considering the number of stakeholders that can be involved. A project manager must create and manage a...
Provided by Microsoft
-
White Papers
Refresh External Data In Excel Services
Jun 2007
Data in a Microsoft Office Excel workbook that has been displayed in Excel Services can come from two different locations. The data may be stored directly in the workbook, or it may be stored in...
Provided by Microsoft
-
White Papers
Gather Project Performance Data
Jun 2007
A key activity of project management is highlighting problems and issues early in the process and taking appropriate action. The earlier the action, the less likely the project is to suffer. To do...
Provided by Microsoft
-
White Papers
Sort Data In Excel Services
Jun 2007
Sorting data is an integral part of data analysis. You might want to organize a list of names in alphabetical order or you might want to compile a list of product inventory levels from highest to...
Provided by Microsoft
-
White Papers
Improve Project Performance Using Historical Data
Jun 2007
Why should you chronicle project history? One important reason is to avoid doing the same thing over and over, and expecting different results each time. If your organization wants to improve its...
Provided by Microsoft
-
White Papers
Change Workbook Parameters In Excel Services
Jun 2007
Although you cannot directly edit cells in a Microsoft Office Excel workbook by using Excel Services, before saving the Excel workbook, a workbook author can define one or more parameters, each of...
Provided by Microsoft
-
White Papers
Overview Of Connecting (Importing) Data
Jun 2007
There is a world of data outside of your Microsoft Office Excel workbook that you can use inside of your workbook. But how do you find it, import it, update it, secure it, and manage it? It is all...
Provided by Microsoft
-
White Papers
Connect A List View Web Part To Excel Web Access
Jun 2007
To provide greater flexibility and control over the display of a Microsoft Office Excel workbook in Excel Services, you can connect a List View Web Part of a document library or a list to the...
Provided by Microsoft
-
White Papers
Connect To (Import) External Data
Jun 2007
The main benefit of connecting to external data is that you can periodically analyze this data in Microsoft Office Excel without repeatedly copying the data, which is an operation that can be...
Provided by Microsoft
-
White Papers
You Asked For It: Crabby's Top 5 Excel Tips And Tricks
Jun 2007
You use Excel for analyzing data, getting data from the Web, building formulas and functions, and even creating calendars. You know that Microsoft Excel is a handy program for accomplishing all...
Provided by Microsoft
-
White Papers
Refresh Connected (Imported) Data
Jun 2007
A cell range, Excel table, PivotTable report, or PivotChart report can all be connected to an external data source. You can refresh the data to update data from this external data source. Each...
Provided by Microsoft
-
White Papers
Administration Of Shared Workbooks
Jun 2007
Microsoft Excel shared workbooks provide a simple, flexible way for a group of people to collaborate on a list or other data-driven project. With a shared workbook, you can design your workflow...
Provided by Microsoft
