- Subscribe to this page:
- RSS
- Email Alert
spreadsheets
(240 results)-
White Papers
Spreadsheet Programming
Jun 2008
Spreadsheets are among the most widely used programming systems in the world. Individuals and businesses use spreadsheets for a wide variety of applications, ranging from performing simple...
Provided by Oregon State University
-
White Papers
Test-Driven Goal-Directed Debugging in Spreadsheets
Jun 2008
The authors present an error-detection and -correction approach for spreadsheets that automatically generates questions about input/output pairs and, depending on the feedback given by the user,...
Provided by Oregon State University
-
White Papers
Dimension Inference in Spreadsheets
Jun 2008
The authors present a reasoning system for inferring dimension information in spreadsheets. This system can be used to check the consistency of spreadsheet formulas and can be employed to detect...
Provided by Oregon State University
-
Whitepapers
How to Become an Innovative Sales Manager in Four Virtual Steps
Jan 2011
This SellingPower white paper explores four strategic ways sales managers can win by leveraging virtual tools for internal team collaboration, client presentations, training and more.
Provided by Citrix Online
-
White Papers
Getting Closer to the Customer: Overcoming Common Sales AnalysisChallenges
Jul 2011
Because of this, many retailers struggle with limited visibility into real-time trends from day to day - not to mention during seasonal and promotional campaigns. It becomes hard to implement the...
Provided by SAP
-
White Papers
Using Bayesian Statistical Methods to Determine the Level of Error in Large Spreadsheets
Feb 2009
Spreadsheets are ubiquitous with evidence that Microsoft Excel, the leading application in the area, has an install base of 90% on end-user desktops. Nowhere is the usage of spreadsheets more...
Provided by Dundalk Institute of Technology
-
Downloads
10+ ways to train your users on Office 2007 for free
Jun 2007
Buried deep within the sitemap of Microsoft.com are lots of options for training your users on Office 2007. But ever since the incredible Mr. Clippit, users have been quick to shrug off Microsoft...
Provided by Tiffany Songvilay
-
Webcasts
Microsoft Office System Webcast: Top 10 Tips for Excel 2007 (Level 100)
Aug 2007
Microsoft Office Excel 2007 is a powerful tool that one can use to create and format spreadsheets. More significantly, Excel 2007 enables a person to analyze and share information, so one can make...
Provided by Microsoft
-
Webcasts
Instant Payroll Totals for Quarterly Tax Reporting
Oct 2007
Accurate numbers are a must for filling out quarterly tax forms, but creating the various subtotals for state and federal forms can be time-consuming. Now users can get the information they need...
Provided by Microsoft
-
Webcasts
Microsoft Office System Webcast: Advanced Tips and Tricks: What You Can Really Do With Your Documents Across the 2007 Office Release (Level 300)
Oct 2007
The presenter of this webcast provides for a high-level overview of the breadth of document production capabilities across the 2007 Microsoft Office release. The presenter explains the new dynamic...
Provided by Microsoft
-
Book chapters
Excel Hacks: Hacking PivotTables
Jun 2007
PivotTables are one of Excel's most powerful attractions, though many people don't know what they do. PivotTables display and extract a variety of information from a table of data that resides...
Provided by O'Reilly Media
-
Book chapters
Integrating Excel and Access: Data Access From Excel VBA
Oct 2005
VBA gives one the opportunity to take more control of the data; it performs queries that are not possible from the user interface, and one can now automate many operations. There are numerous...
Provided by O'Reilly Media
-
Whitepapers
Solution brief: Optimization in Energy & Utilities - Effectively plan, schedule and monitor systems
Oct 2012
The energy market has changed dramatically, and responding well means energy companies can't get bogged down by cumbersome manual planning and spreadsheet solutions. Read this solution brief to...
Provided by IBM
-
eBooks
Office 365 Migration for Dummies: Microsoft and Quest (now part of Dell) Special Edition
Jan 2013
This book will guide you in performing a migration to Office 365. Although the chapters in this book are independent of each other, they are presented in sequential order to guide you through each...
Provided by Quest Software, Inc., now a part of Dell
-
Webcasts
MSDN Webcast: Using Data in Excel Solutions Built With Visual Studio Tools for the Office System (Level 100)
Dec 2007
Microsoft Visual Studio Tools for the Microsoft Office System enables developers to build scalable Line-Of-Business (LOB) solutions based on Microsoft Office applications. Developers can harness...
Provided by Microsoft
-
Webcasts
Microsoft Office System Webcast: Compatibility Tips for the 2007 Office System File Formats - Collaborating With Users of Earlier Versions (Level 300)
Dec 2007
The new file formats for the 2007 Office release offer tremendous benefits, from better security to easier editing. So, if concerns over the need to roundtrip documents between the 2007 Office...
Provided by Microsoft
-
Webcasts
Microsoft Office System Webcast: How Windows Vista and the 2007 Office System Work Better Together (Level 300)
Feb 2008
This webcast discovers how one can benefit from the integration of the capabilities in Windows Vista as a user of the 2007 Microsoft Office system. It explains how one can configure the improved...
Provided by Microsoft
-
Webcasts
Momentum Webcast: Do Extraordinary Things Every Day With Microsoft Dynamics CRM! (Level 100)
Apr 2008
In this webcast, we show you how the productivity of your sales, customer service, and marketing teams can be dramatically increased by taking advantage of the enhancements in the newly released...
Provided by Microsoft
-
Webcasts
Microsoft Office System Webcast: Advanced Tips and Tricks for Getting Data and Other Content into and out of Your Documents (Level 300)
Feb 2008
This webcast looks at tools across the 2007 Microsoft Office system that manages information and enables to do more with documents than one might imagine. This webcast, take a look at new or...
Provided by Microsoft
-
White Papers
Link or Embed an Excel Worksheet
Dec 2007
When one want to create a dynamic link between the content of the document and the content in a Microsoft Office Excel workbook, insert the content as an object. Unlike when the user paste content...
Provided by Microsoft
-
White Papers
Share and Publish Your Files in the 2007 Office Release
Dec 2007
When one is ready to share the files with others, one can click the Microsoft Office Button, and then choose two commands to help one accomplish that task. The Send command enables the user to...
Provided by Microsoft
-
White Papers
Set a Password to Open or Modify a Document, Workbook, or Presentation
Dec 2007
In the 2007 Microsoft Office system, one can use passwords to help prevent other people from opening or modifying Microsoft Office Word 2007 documents, Microsoft Office Excel 2007 workbooks, and...
Provided by Microsoft
-
White Papers
Apply, Customize, and Save a Document Theme in Word or Excel
Dec 2007
One can quickly and easily format an entire document to give it a professional and modern look by applying a document theme. A document theme is a set of formatting choices that include a set of...
Provided by Microsoft
-
White Papers
A Visual Introduction to the 2007 Office Release
Dec 2007
Much of the 2007 Office release has been built on an entirely new structure, and one will find that some of its features look different from those of earlier versions and work quite a bit...
Provided by Microsoft
-
White Papers
Share Data Between Excel and Word Healthcare Forms
Dec 2007
People working within the healthcare field often collect data in a Microsoft Office Excel 2003 workbook and then need to include some of that information in a form letter or a report created in...
Provided by Microsoft Tips
-
Case Studies
Hospital Uses Business Intelligence Solution to Save Time and Gain Insight From Data
Apr 2008
The Children's Hospital of Philadelphia (CHOP) is a leading pediatric hospital based in Philadelphia, Pennsylvania. The hospital's department of Pathology and Laboratory Medicine, which collects...
Provided by Microsoft Tips
-
Case Studies
Building Services Firm Improves Data Exchange With Office Business Application
Mar 2008
Cooperativa Architetti e Ingegneri Reggio Emilia Progettazione (CAIREPRO) is well known in Italy's structural engineering industry. The company provides Architectural, Engineering, and...
Provided by Microsoft Tips
-
Webcasts
Microsoft Office System Webcast: Summarizing Data Effectively Using New Excel 2007 Formulas and Functions (Level 100)
Apr 2008
In this one-hour webcast, Microsoft Office Excel Most Valuable Professional (MVP) demonstrates the powerful new formulas and functions that let the users summarize data more effectively than ever...
Provided by Microsoft Tips
-
Webcasts
Microsoft Office System Webcast: Tips and Tricks for Office 2008 for Mac: Incredible Documents Made Simple (Level 200)
Jun 2008
Microsoft Office 2008 for Mac offers a wide range of new features and formatting tools for creating great documents, presentations, and workbooks more easily than one might imagine. Create own...
Provided by Microsoft
-
Webcasts
Microsoft Office System Webcast: Compatibility Tips for Office 2008 for Mac and the 2007 Office Release for Windows (Level 200)
Jun 2008
Those who are using 2007 Microsoft Office system, must have already know about the many incredible features and formatting capabilities that are new in this release. If one also use Microsoft...
Provided by Microsoft
-
White Papers
Automatically Inferring ClassSheet Models From Spreadsheets
Jun 2010
Many errors in spreadsheet formulas can be avoided if spreadsheets are built automatically from higher-level models that can encode and enforce consistency constraints. However, designing such...
Provided by Oregon State University
-
White Papers
The Microsoft Office Fluent User Interface: IT Decision Maker Perception of Productivity, Training, and Support Requirements
Aug 2007
This white paper presents the results of a commissioned study conducted by Forrester Consulting on behalf of Microsoft Corporation to help IT organizations that are considering adopting the 2007...
Provided by Microsoft
-
White Papers
ViSSh: A Data Visualisation Spreadsheet
Jan 2008
This paper describes a data visualisation system which uses spreadsheets as its user interface metaphor. Similar systems implemented in the past were hampered by the contradiction between an...
Provided by University of Cape Town
-
Webcasts
Microsoft Office System Webcast: Tips and Tricks for the 2007 Microsoft Office System (Level 100)
Oct 2008
The Microsoft Office system has evolved from a suite of personal productivity products to a more comprehensive and integrated system. The 2007 release presents the Microsoft Office Fluent user...
Provided by Microsoft
-
Webcasts
Microsoft Office System Webcast: Tips and Tricks: Design Your Documents for Maximum Impact (Level 200)
Oct 2008
In this webcast attendee will learn how to design documents and presentations that help to shine the content. Attendee will explore the features in the Microsoft Office 2007 system. They will also...
Provided by Microsoft
-
Webcasts
Adjust Page Breaks to Control What Is Printed on Each Page
Jan 2008
Printing a worksheet that has many rows and columns can be a real challenge. Before sending the worksheet data to the printer, one can quickly rearrange page breaks to define what will be printed...
Provided by Microsoft
-
Webcasts
Find Help for Excel Functions
Jan 2008
Functions are prewritten formulas that simplify the process of entering calculations. Using functions, users can quickly create formulas that might be difficult to build. Although many functions,...
Provided by Microsoft
-
Webcasts
The New Excel 2007 Fluent Interface
Jan 2008
This webcast shows how conditional formatting, advanced visuals and the new user interface make it easier than ever to analyze business data with Excel 2007.
Provided by Microsoft
-
Webcasts
Use Simple Formulas to Do the Math
Jan 2008
Simple formulas can be used in Excel 2007 to add, subtract, multiply, and divide. For example, users can use a prewritten formula called the SUM function to find totals - such as the total monthly...
Provided by Microsoft
-
Webcasts
Transpose Data in Excel 2007
Dec 2007
Excel 2007 makes it easy to transpose data from rows to columns, and vice versa. Watch this webcast to learn how.
Provided by Microsoft
-
Webcasts
Create Formulas With Formula AutoComplete
Jan 2008
The Formula AutoComplete feature in Office Excel 2007 helps to avoid gotchas - those little syntax or typing mistakes that can break the formula and display an error in the cell. Every step of the...
Provided by Microsoft
-
Webcasts
Distribute the Contents of 1 Cell Across Multiple Cells
Jan 2008
Storing information, such as a full address, in one column can limit what can be done with that information. For example, one can't easily filter or sort by part of the address, such as...
Provided by Microsoft
-
Webcasts
Combine the Contents of Multiple Cells Into 1 Cell
Jan 2008
This webcast is useful for those who ever wanted to combine the contents of several cells into one cell. Say there is a worksheet of employee names, with first and last names in separate columns,...
Provided by Microsoft
-
Webcasts
Merge a Range of Cells Into a Single Cell
Jan 2008
Using the Merge feature in Excel 2007, users can quickly turn that worksheet into an easy-to-scan, appealing report. When merging cells, one can join several adjacent cells into one larger cell....
Provided by Microsoft
-
White Papers
Evolution of the Investigator Satisfaction Ranking Report: The Advantage of Using the "PROC REPORT Procedure/ODS Excel" Versus a "CROSSTAB Output" or "CROSSTAB/ODS Excel"
Feb 2009
This paper describes the evolution of the SAS programming of a report used in employee evaluations by a government agency. The data is taken from a survey seeking customers' opinion of the service...
Provided by Pennsylvania State University
-
Case Studies
Midwest Healthcare Provider Achieves Efficiency Boost and Cost Reduction
May 2009
Medica is a regional healthcare provider headquartered in Minneapolis and active in the Upper Midwest. To better manage its rapidly growing and diverse employee base, Medica required an advanced...
Provided by Softscape
-
White Papers
Business Intelligence (BI) Vs. Spreadsheets
Jan 2008
Spreadsheets have been used by small and mid-size organizations to satisfy their demands for analysis, to give them a competitive advantage. But the concern for business confidence in spreadsheet...
Provided by ELegant MicroWeb Technologies
-
Webcasts
Easy and Affordable Document Management for Microsoft Office 2007
Oct 2008
Many organizations believe that document management is not only too expensive, but also difficult to understand and use. As a result, document management implementations have often been limited to...
Provided by EMC
-
Webcasts
The Enterprise Spreadsheet: Pushing Toward Transparency
Mar 2009
The presenter of this webcast shows how spreadsheets are adapting to the new economy and transforming capital markets operations. Capital markets are at an historic crossroads. Clients need more...
Provided by Microsoft
-
Webcasts
Deployment Best Practices and Recommendation
Mar 2009
To further assist with making sure that the Office 2007 deployment projects are completely successful, the presenters of this webcast will share key learning's and best practices. Based on...
Provided by Microsoft
-
Webcasts
Document Conversion Recommendations With Converter Technology
Feb 2009
Office 2007 supports a new file format, Open XML. While this new format offers enhanced functionality, there are important considerations when converting from the old binary file format. The...
Provided by Microsoft
-
Webcasts
Tips and Tricks for the 2007 Microsoft Office System (60 Minutes + 15 Mins Q&A)
Jan 2009
The Microsoft Office system has evolved from a suite of personal productivity products to a more comprehensive and integrated system. The 2007 release presents the Microsoft Office Fluent user...
Provided by Microsoft
-
Webcasts
Momentum Webcast: Best Practices for Deploying 2007 Microsoft Office Client (Level 200)
Jan 2009
The attendee of this webcast will learn how deploying 2007 Microsoft Office system client software can be faster and cheaper than deploying the client software for earlier versions of Microsoft...
Provided by Microsoft
-
Webcasts
Fundamentals of Open XML
Feb 2009
Office 2007's new file format, Open XML, provides many improvements to document creation, handling, and security. This webcast takes a close look at the changes in format, as well as highlight...
Provided by Microsoft
-
Webcasts
Microsoft Dynamics Webcast: Personal Business Intelligence (Level 100)
Feb 2009
The presenter of this webcast focuses on Microsoft Office Excel reports (available to Microsoft Dynamics GP 10.0 customers) and the Excel Report Builder feature of SmartList Builder (an a la carte...
Provided by Microsoft
-
White Papers
Microsoft Dynamics GP and Office: Extending the Reach
Jan 2009
This paper offers highlights of how Microsoft Dynamics® GP and the Microsoft Office® system work together to help people optimize productivity, access and analyze information, and collaborate and...
Provided by Microsoft
-
White Papers
DataSafeXL: A Brief Overview of Microsoft Excel Vulnerabilities
Jan 2008
This paper will provide the user with a brief overview of the Microsoft Excel security environment and examine in more detail the effectiveness of Microsoft Excel's built-in protection features....
Provided by DataSafeXL
-
Webcasts
Secure Your Legal Documents: Tips & Tricks for Managing Hidden Content in Word, Excel, and PowerPoint (Level 300)
Nov 2007
The presenter of this webcast gives the straight scoop on what document metadata is and what it is not. The attendee will learn what types of hidden content can exist in Word, Excel, and...
Provided by Microsoft
-
Webcasts
Tips and Tricks to Manage Data Effectively by Using Excel Tables (Level 200)
Jan 2008
This webcast will help to streamline the calculations and summaries by storing the information in Excel data tables.
Provided by Microsoft
-
Webcasts
Top 10 Tips for Excel 2007 (Level 100)
Jan 2008
This webcast explores how Excel 2007 takes advantage of a new, results-oriented User Interface (UI) that provides easy access to powerful productivity tools, offers a larger workspace, and...
Provided by Microsoft
-
Resource Center
Test-drive Microsoft Office 2007
Jan 2009
This is an online test drive of Microsoft® Office 2007 programs. This real-time test drive is the fastest way to try out Microsoft Office 2007 and does not require product installation or...
Provided by Microsoft
-
Webcasts
Microsoft Dynamics Webcast: Creating Value and Driving Performance for Finance Professionals (Level 100
Dec 2008
Finance professionals can gain more relevant business insights, simplify compliance processes, drive more consistent, accurate reporting, and get more value from their technology investments using...
Provided by Microsoft
-
Webcasts
Tips & Tricks Office 2007
Dec 2008
The Microsoft Office System has evolved from a suite of personal productivity products to a more comprehensive and integrated system. This webcast will demonstrate useful tips and tricks for...
Provided by Microsoft
-
Webcasts
Microsoft Office System Webcast: Reports and Visual Reports in Project 2007: Working With Excel (Level 200)
Dec 2008
With Microsoft Office Project 2007, it is easy to communicate and present project information by applying charts and diagrams from Microsoft Office Excel to create custom reports based on Office...
Provided by Microsoft
-
Case Studies
Long-Term Planning Pays Off in Optimised Resource Usage
Oct 2008
With annual expenditure of £340 million, effective financial planning is essential to achieving the Reading Borough Council's aim of continually improving the quality of its services, while also...
Provided by Fujitsu
-
Webcasts
Creating Pivot Diagrams From PivotTable Reports in Visio
Jan 2008
This webcast shows how to take an excel list and create a pivot diagram in Excel.
Provided by Microsoft
-
Webcasts
Highlighting and Removing Duplicate Table Values in Excel
Jan 2008
This webcast shows step-by-step instructions covering the spectrum of the 2007 Office system. The webcast shows how to highlight duplicate values in tables.
Provided by Microsoft
-
Webcasts
Formatting With Conditional Filtering to Organize Data
Jan 2008
This webcast shows step-by-step instructions covering the spectrum of the 2007 Office system. The webcast provides introduction and definition of conditional formatting and provides quick tips for...
Provided by Microsoft
-
Webcasts
Customizing Conditional Formatting in Excel 2007
Jan 2008
This webcast shows step-by-step instructions covering the spectrum of the 2007 Office system. The webcast provides quick tips for customizing conditional formatting in Excel 2007.
Provided by Microsoft
-
Webcasts
Insert and Delete Rows, Columns, and Worksheets
Jan 2008
In Excel 2007, users can quickly insert new rows, columns, cells, and worksheets - and just as easily delete them - with a few clicks. This webcast shows how fast users can insert and delete...
Provided by Microsoft
-
Webcasts
Place Your Favorite Commands on the Quick Access Toolbar
Jan 2008
There's a fast way to put the commands and buttons users use most often within easy reach - put them on the Quick Access Toolbar. This row of buttons above the Ribbon, part of the Microsoft Office...
Provided by Microsoft
-
Case Studies
Using Excel Services and Open XML to Create Custom Office Business Applications
Aug 2008
Microsoft needed to expand and upgrade the business intelligence application that executives and analysts used extensively to scale globally and meet the needs of a diverse organization. User...
Provided by Microsoft
-
Case Studies
Firm Cuts Insurers' Modeling Time Nearly 95 Percent With High-Performance Solutions
Nov 2008
IHA Consultants, a small IT consultancy, helps healthcare and property/casualty insurers by providing Web-based stochastic solutions for advanced actuarial modeling. The company's Stochastic...
Provided by Microsoft
-
Webcasts
Advanced Tips & Tricks for Excel Charting: Financial Pitch Books Made Simple (Level 300)
Jan 2006
If there is logic to it, Microsoft Office Excel can do it, especially when it comes to charting. The presenter of this webcast provides tips and techniques for the things users might not know...
Provided by Microsoft
-
Webcasts
Use Formulas in Tables
Jan 2008
Tables are a great way to present columns of numbers in the Microsoft Office Outlook 2007 e-mail messages. Save time when users need basic math formulas, such as a sum, average, or finding the...
Provided by Microsoft
-
Webcasts
Add Colors, Fonts, and Effects With PowerPoint 2007 Themes
Jan 2008
For those who have been using design templates in PowerPoint 2003, they are going to love themes in PowerPoint 2007. Themes pull together color schemes, font styles, and effects into appealing...
Provided by Microsoft
-
Webcasts
The New PowerPoint 2007 Fluent Interface
Jan 2008
This webcast provides an overview of how new design tools and close integration with Excel 2007 make it easy to create engaging presentations with PowerPoint 2007.
Provided by Microsoft
-
Webcasts
Use Word Viewer to Open or Print Word Documents
Jan 2008
For those who don't have Word on their computer, they can still open Word documents - as long as they have Word Viewer. In this webcast, a Microsoft employee who uses Word himself shows how to...
Provided by Microsoft
-
Webcasts
Transpose Data in Excel 2007
Dec 2007
Excel 2007 makes it easy to transpose data from rows to columns, and vice versa. Watch this webcast to learn how.
Provided by Microsoft
-
Webcasts
Use Simple Formulas to Do the Math
Jan 2008
Simple formulas can be used in Excel 2007 to add, subtract, multiply, and divide. For example, users can use a prewritten formula called the SUM function to find totals - such as the total monthly...
Provided by Microsoft
-
Webcasts
Microsoft Office System Webcast: Top Tips for Excel 2007 (Level 100)
Dec 2007
Microsoft Office Excel 2007 is a powerful tool that can use to create and format spreadsheets. More significantly, Excel 2007 enables to analyze and share information, so one can make more...
Provided by Microsoft
-
Webcasts
MSDN Webcast: Using Data in Excel Solutions Built With Visual Studio Tools for the Office System (Level 100)
Dec 2007
Microsoft Visual Studio Tools for the Microsoft Office System enables developers to build scalable Line-Of-Business (LOB) solutions based on Microsoft Office applications. Developers can harness...
Provided by Microsoft
-
Webcasts
Microsoft Office System Webcast: Compatibility Tips for the 2007 Office System File Formats - Collaborating With Users of Earlier Versions (Level 300)
Dec 2007
The new file formats for the 2007 Office release offer tremendous benefits, from better security to easier editing. So, if concerns over the need to roundtrip documents between the 2007 Office...
Provided by Microsoft
-
Webcasts
Microsoft Office System Webcast: How Windows Vista and the 2007 Office System Work Better Together (Level 300)
Feb 2008
This webcast discovers how one can benefit from the integration of the capabilities in Windows Vista as a user of the 2007 Microsoft Office system. It explains how one can configure the improved...
Provided by Microsoft
-
Webcasts
Momentum Webcast: Do Extraordinary Things Every Day With Microsoft Dynamics CRM! (Level 100)
Apr 2008
In this webcast, we show you how the productivity of your sales, customer service, and marketing teams can be dramatically increased by taking advantage of the enhancements in the newly released...
Provided by Microsoft
-
Webcasts
Microsoft Office System Webcast: Advanced Tips and Tricks for Getting Data and Other Content into and out of Your Documents (Level 300)
Feb 2008
This webcast looks at tools across the 2007 Microsoft Office system that manages information and enables to do more with documents than one might imagine. This webcast, take a look at new or...
Provided by Microsoft
-
Webcasts
TechNet Webcast Express: Exploring the Report Center in SharePoint Server 2007 (Level 100)
Jun 2007
The attendee of this webcast will learn more about the Report Center in Microsoft Office SharePoint Server 2007. This webcast includes creating a dashboard and a Key Performance Indicator (KPI),...
Provided by Microsoft
-
White Papers
Link or Embed an Excel Worksheet
Dec 2007
When one want to create a dynamic link between the content of the document and the content in a Microsoft Office Excel workbook, insert the content as an object. Unlike when the user paste content...
Provided by Microsoft
-
White Papers
Share and Publish Your Files in the 2007 Office Release
Dec 2007
When one is ready to share the files with others, one can click the Microsoft Office Button, and then choose two commands to help one accomplish that task. The Send command enables the user to...
Provided by Microsoft
-
White Papers
Set a Password to Open or Modify a Document, Workbook, or Presentation
Dec 2007
In the 2007 Microsoft Office system, one can use passwords to help prevent other people from opening or modifying Microsoft Office Word 2007 documents, Microsoft Office Excel 2007 workbooks, and...
Provided by Microsoft
-
White Papers
Apply, Customize, and Save a Document Theme in Word or Excel
Dec 2007
One can quickly and easily format an entire document to give it a professional and modern look by applying a document theme. A document theme is a set of formatting choices that include a set of...
Provided by Microsoft
-
White Papers
A Visual Introduction to the 2007 Office Release
Dec 2007
Much of the 2007 Office release has been built on an entirely new structure, and one will find that some of its features look different from those of earlier versions and work quite a bit...
Provided by Microsoft
-
White Papers
Share Data Between Excel and Word Healthcare Forms
Dec 2007
People working within the healthcare field often collect data in a Microsoft Office Excel 2003 workbook and then need to include some of that information in a form letter or a report created in...
Provided by Microsoft Tips
-
Case Studies
Hospital Uses Business Intelligence Solution to Save Time and Gain Insight From Data
Apr 2008
The Children's Hospital of Philadelphia (CHOP) is a leading pediatric hospital based in Philadelphia, Pennsylvania. The hospital's department of Pathology and Laboratory Medicine, which collects...
Provided by Microsoft Tips
-
Case Studies
Building Services Firm Improves Data Exchange With Office Business Application
Mar 2008
Cooperativa Architetti e Ingegneri Reggio Emilia Progettazione (CAIREPRO) is well known in Italy's structural engineering industry. The company provides Architectural, Engineering, and...
Provided by Microsoft Tips
-
Webcasts
Microsoft Office System Webcast: Summarizing Data Effectively Using New Excel 2007 Formulas and Functions (Level 100)
Apr 2008
In this one-hour webcast, Microsoft Office Excel Most Valuable Professional (MVP) demonstrates the powerful new formulas and functions that let the users summarize data more effectively than ever...
Provided by Microsoft Tips
-
Webcasts
TechNet Webcast: Extending Excel With Excel Services (Level 200)
Jun 2008
Microsoft Office Excel is the de facto number-crunching, analyze-anything tool, but when one needs to share that information with others, it becomes difficult. With Excel Services in Microsoft...
Provided by Microsoft
-
Webcasts
Microsoft Office System Webcast: Tips and Tricks for Office 2008 for Mac: Incredible Documents Made Simple (Level 200)
Jun 2008
Microsoft Office 2008 for Mac offers a wide range of new features and formatting tools for creating great documents, presentations, and workbooks more easily than one might imagine. Create own...
Provided by Microsoft
-
Webcasts
Microsoft Office System Webcast: Compatibility Tips for Office 2008 for Mac and the 2007 Office Release for Windows (Level 200)
Jun 2008
Those who are using 2007 Microsoft Office system, must have already know about the many incredible features and formatting capabilities that are new in this release. If one also use Microsoft...
Provided by Microsoft
-
White Papers
Automatically Inferring ClassSheet Models From Spreadsheets
Jun 2010
Many errors in spreadsheet formulas can be avoided if spreadsheets are built automatically from higher-level models that can encode and enforce consistency constraints. However, designing such...
Provided by Oregon State University
-
Whitepapers
Transforming spreadsheets: planning, budgeting and forecasting for midsize companies
Jan 2012
A spreadsheet-based approach to performance management won't meet the challenges facing growing midsize businesses. You need confidence in the information you're using for critical...
Provided by IBM
-
White Papers
The Microsoft Office Fluent User Interface: IT Decision Maker Perception of Productivity, Training, and Support Requirements
Aug 2007
This white paper presents the results of a commissioned study conducted by Forrester Consulting on behalf of Microsoft Corporation to help IT organizations that are considering adopting the 2007...
Provided by Microsoft
-
White Papers
ViSSh: A Data Visualisation Spreadsheet
Jan 2008
This paper describes a data visualisation system which uses spreadsheets as its user interface metaphor. Similar systems implemented in the past were hampered by the contradiction between an...
Provided by University of Cape Town
-
Webcasts
Microsoft Office System Webcast: Tips and Tricks for the 2007 Microsoft Office System (Level 100)
Oct 2008
The Microsoft Office system has evolved from a suite of personal productivity products to a more comprehensive and integrated system. The 2007 release presents the Microsoft Office Fluent user...
Provided by Microsoft
-
Webcasts
Microsoft Dynamics Webcast: SmartList Builder Gets Even Better With the New Excel Report Builder Functionality (Level 100)
Oct 2008
Now one can query more data in more ways, because SmartList Builder gives the access to all the information that one capture, enabling to create the own reports in Microsoft Office Excel from...
Provided by Microsoft
-
Webcasts
Microsoft Office System Webcast: Tips and Tricks: Design Your Documents for Maximum Impact (Level 200)
Oct 2008
In this webcast attendee will learn how to design documents and presentations that help to shine the content. Attendee will explore the features in the Microsoft Office 2007 system. They will also...
Provided by Microsoft
-
Webcasts
Adjust Page Breaks to Control What Is Printed on Each Page
Jan 2008
Printing a worksheet that has many rows and columns can be a real challenge. Before sending the worksheet data to the printer, one can quickly rearrange page breaks to define what will be printed...
Provided by Microsoft
-
Webcasts
Find Help for Excel Functions
Jan 2008
Functions are prewritten formulas that simplify the process of entering calculations. Using functions, users can quickly create formulas that might be difficult to build. Although many functions,...
Provided by Microsoft
-
Webcasts
The New Excel 2007 Fluent Interface
Jan 2008
This webcast shows how conditional formatting, advanced visuals and the new user interface make it easier than ever to analyze business data with Excel 2007.
Provided by Microsoft
-
Webcasts
Use Simple Formulas to Do the Math
Jan 2008
Simple formulas can be used in Excel 2007 to add, subtract, multiply, and divide. For example, users can use a prewritten formula called the SUM function to find totals - such as the total monthly...
Provided by Microsoft
-
Webcasts
Transpose Data in Excel 2007
Dec 2007
Excel 2007 makes it easy to transpose data from rows to columns, and vice versa. Watch this webcast to learn how.
Provided by Microsoft
-
Webcasts
Use Word Viewer to Open or Print Word Documents
Jan 2008
For those who don't have Word on their computer, they can still open Word documents - as long as they have Word Viewer. In this webcast, a Microsoft employee who uses Word himself shows how to...
Provided by Microsoft
-
Webcasts
The New PowerPoint 2007 Fluent Interface
Jan 2008
This webcast provides an overview of how new design tools and close integration with Excel 2007 make it easy to create engaging presentations with PowerPoint 2007.
Provided by Microsoft
-
Webcasts
Add Colors, Fonts, and Effects With PowerPoint 2007 Themes
Jan 2008
For those who have been using design templates in PowerPoint 2003, they are going to love themes in PowerPoint 2007. Themes pull together color schemes, font styles, and effects into appealing...
Provided by Microsoft
-
Webcasts
Use Formulas in Tables
Jan 2008
Tables are a great way to present columns of numbers in the Microsoft Office Outlook 2007 e-mail messages. Save time when users need basic math formulas, such as a sum, average, or finding the...
Provided by Microsoft
-
Webcasts
Advanced Tips & Tricks for Excel Charting: Financial Pitch Books Made Simple (Level 300)
Jan 2006
If there is logic to it, Microsoft Office Excel can do it, especially when it comes to charting. The presenter of this webcast provides tips and techniques for the things users might not know...
Provided by Microsoft
-
Case Studies
Firm Cuts Insurers' Modeling Time Nearly 95 Percent With High-Performance Solutions
Nov 2008
IHA Consultants, a small IT consultancy, helps healthcare and property/casualty insurers by providing Web-based stochastic solutions for advanced actuarial modeling. The company's Stochastic...
Provided by Microsoft
-
Case Studies
Using Excel Services and Open XML to Create Custom Office Business Applications
Aug 2008
Microsoft needed to expand and upgrade the business intelligence application that executives and analysts used extensively to scale globally and meet the needs of a diverse organization. User...
Provided by Microsoft
-
Webcasts
Place Your Favorite Commands on the Quick Access Toolbar
Jan 2008
There's a fast way to put the commands and buttons users use most often within easy reach - put them on the Quick Access Toolbar. This row of buttons above the Ribbon, part of the Microsoft Office...
Provided by Microsoft
-
Webcasts
Insert and Delete Rows, Columns, and Worksheets
Jan 2008
In Excel 2007, users can quickly insert new rows, columns, cells, and worksheets - and just as easily delete them - with a few clicks. This webcast shows how fast users can insert and delete...
Provided by Microsoft
