Resources

134 Resources for

microsoft excel

Subscribe to this listing via:
RSS
Email

Did you mean Microsoft Excel 2003 (10 results), Microsoft Excel 2007 (9 results), Microsoft Excel 2002 (3 results)

BNET Resources

Three Tricks to Boost Your Excel Productivity: Even if you spend a lot of time using Excel, you may not be taking full advantage of the spreadsheet program's power. Productivity501 sheds some light on three of Excel's lesser-known, but extremely useful, capabilities. They are: Transpose copy function Validate entries to a list ...; Tags: Microsoft Office, Rick Broida, Microsoft Excel, Productivity501; Blog posts 2008-07-03
Using A Validation List In Another Worksheet Or Workbook: 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 entries for a cell. When a user clicks the cell to enter data, Excel provides a drop-down list...; Tags: Microsoft Corp., cell, Microsoft Excel; White papers
Synchronize Excel Reports With A Single Data Source: The analysts needed to take existing year-end financial reports and summarize, group, and chart the data in various ways to present to their organizations' business decision makers. Data analysts rely on Microsoft Excel to connect to, display, and format data. However, copying and pasting data between cell ranges or between...; Tags: Microsoft Corp., data source, analyst, spreadsheet, financial; White papers
Create A Sharepoint Team Services List With Excel: Although you can create lists one item at a time on your SharePoint team Web site by using a Web browser, a faster method - especially for a large list - is to create it in a Microsoft Excel spreadsheet and then import the spreadsheet to your team Web site.; Tags: PRODUCTIVITY, Collaboration, Groupware, Microsoft Office, Microsoft Corp., Microsoft SharePoint, spreadsheet, Microsoft Excel, Excel spreadsheet, Web browser, team, Web site; White papers
Distribute An Excel Worksheet In An E-Mail Message: If you have Microsoft Outlook or Outlook Express installed, you can embed a worksheet in an e-mail message and send it directly from Excel. Distributing a worksheet via e-mail allows you to quickly share a worksheet with others, Embed a worksheet in a message, Use HTML format so almost anyone...; Tags: Microsoft Office, Groupware, Microsoft Corp., Microsoft Excel, Microsoft Outlook, e-mail, HTML; White papers

Help Protect And Work With Business Intelligence Data In Excel: This paper explains one way to work around versioning problems. It briefly touches on how you can answer the "why" questions posed by business intelligence data. Finally, it shows how to use Excel to connect directly to data cubes, a useful technique for those times when Data Analyzer isn't available....; Tags: Pricing, Tools & Techniques, Microsoft Corp., business intelligence, Microsoft Excel, technique; White papers
Prepare Your Excel Worksheet For Printing: Your worksheet looks fine on the screen, so you're ready to print-right? Not exactly. You'll save time and paper by following the steps described in this paper to fine-tune your worksheet, avoid common printing problems, and prints the result. And also if you plan to print a specific portion of...; Tags: Document management, Microsoft Corp., printing, Microsoft Excel; White papers
25 Easy Pivot Table Reports: Having trouble visualizing how to use a PivotTable report to analyze your data? While you can use these techniques for just about any type of source data. To work directly with these PivotTable reports, download Excel 2002 Sample: PivotTable Reports, the companion workbooks. This paper gives information of how to...; Tags: Microsoft Excel, Microsoft Office, Microsoft Corp., data source, technique; White papers
Add Eye-Catching Formatting To Your Charts: To give your Excel chart a custom, eye-catching look, you can easily apply formatting to data markers. Data marker is a bar, area, dot, slice, or other symbol in a chart that represents a single data point or value that originates from a worksheet cell. Related data markers in a...; Tags: Microsoft Corp.; White papers
Create A Gantt Chart In Excel: There are many ways to create a Gantt chart. For example, Microsoft Project, a task-planning program, makes it easy to track and chart project timelines with a built-in Gantt chart view. Another option is to use Excel. Excel does not contain a built-in Gantt chart format; however, you can create...; Tags: Microsoft Corp., Gantt Chart, Microsoft Excel; White papers
Using Charts And Diagrams In The Classroom: If you're a teacher, you know that everyone learns differently. Some students are analytical, while others are more visually inclined. And then personality comes into play: the class clowns, the shy kids, the troublemakers, the chatterboxes, the social butterflies, and the loners are all represented in almost every classroom. The...; Tags: Microsoft Excel, Microsoft Corp., tool; White papers
Clarify And Emphasize Data In An Excel Chart: You can choose different options in an Excel chart to emphasize your data in different ways. For example, when you're measuring sales revenue along with number of units sold, you can add a second axis to measure a portion of values differently from another portion. This paper gives some examples...; Tags: Microsoft Office, Microsoft Corp., Clarify, Microsoft Excel, sales; White papers
Pivot, Swivel, And Roll: It's Not Just For Dancing Anymore: A PivotTable report is an interactive table - a cross-tabulated Excel report - that quickly combines and compares large amounts of data. You can rotate its rows and columns to see different summaries of the source data, and you can display the details for areas of interest. Knowing how to...; Tags: Microsoft Corp., spreadsheet; White papers
Autocorrect: The Proofreader Over Your Shoulder In Excel: You probably don't have time to check for typos-but you want a flawless worksheet all the same. The solution is AutoCorrect: a built-in proofreader that automatically corrects common typos, misspellings, grammatical errors, and incorrect capitalization. This paper explains how to use AutoCorrect and how its useful while typing so that...; Tags: Microsoft Excel, Microsoft Corp.; White papers
Overview And Samples Of Data Validation: Microsoft Excel data validation lets you define what type of data you want entered in a cell. This white paper describes how to set up data validation, including the types of data you can validate and the messages you can display, and provides a workbook that you can download to...; Tags: Microsoft Corp.; White papers
Use Microsoft Query To Retrieve External Data: You can use Microsoft Query to retrieve data from external sources. By using Microsoft Query to retrieve data from your corporate databases and files, you don't have to retype the data that you want to analyze in Excel. You can also refresh your Excel reports and summaries automatically from the...; Tags: Storage, Microsoft Excel, database, Microsoft Corp.; White papers
Data Validation 1: Control User Choices With Lists In Excel: 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 only the items that you provide. But drop-down lists are only part of a larger Excel...; Tags: Microsoft Corp., Microsoft Excel; White papers
Four Ways To Publish External Data Ranges To The Web: 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 formulas in adjacent columns to perform calculations on the data. You can publish an external data...; Tags: Channel management, Microsoft Office, Databases, Microsoft SQL Server, Microsoft Excel, Web, Web page, database, Microsoft Corp.; White papers
Data Validation 2: Using Other Validation Tools In Excel: 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 column explains how to use other types of validation and create messages to help others enter the data...; Tags: Microsoft Excel, Microsoft Corp.; White papers
Refresh External Data In Excel Services: 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 an external data source, such as in a database or in an Online Analytical Processing...; Tags: Data mining, Microsoft Office, Databases, Microsoft Corp., OLAP, data source, Microsoft Excel, database; White papers