| Title | Date Added | Company | |
|---|---|---|---|
![]() |
Microsoft Office System Webcast: Top Tips for Excel 2007 (Level 100) | 2007-12-13 | Microsoft |
| 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 informed decisions. This webcast explore 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 delivers faster performance. The attendee of this webcast will learn the top ten ways that can put Excel 2007 to work. | |||
![]() |
Microsoft Office System Webcast: My How You've Changed: Side-by-Side Tips for Excel 2000 and Excel 2003 (Level 100) | 2007-10-09 | Microsoft |
| The presenter of this webcast explains how the capabilities of Microsoft Office Excel 2003 have evolved beyond those of Microsoft Office Excel 2000. The attendee will learn how to turn data into practical information using powerful tools that enable to analyze, communicate, and share results. | |||
![]() |
Instant Payroll Totals for Quarterly Tax Reporting | 2007-10-05 | Microsoft |
| 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 fast - thanks to the new list feature in Microsoft Office Excel 2003. Put the list feature to work on company's payroll register for one-click totals of quarterly payroll data like gross pay, and have tax form totals in seconds. | |||
![]() |
Merge Cells or Combine Their Contents | 2007-10-05 | Microsoft |
| Merging and combining are terms that have similar meanings, but in Excel, they are two different things. For example, in case of several columns of information over which the user would like to spread one title, the user would merge cells to get that effect. If the user has information such as first and last names in separate columns, he or she would combine the cell contents to show the names together in one column. This webcast will show the two different techniques. | |||
![]() |
Make Sense of Your Data Using PivotTable Reports | 2007-10-05 | Microsoft |
| Imagine being faced with a pile of data that is needed to organize and summarize in a hurry. And what's more, the user has to present the information in a way that highlights specific aspects of the data. If this sounds familiar, the PivotTable report feature in Microsoft Office Excel 2003 could be useful. PivotTable reports are interactive tables that make it possible to move information around, so that one can see how it fits together. This webcast helps the attendee to learn how to work with PivotTable reports. | |||
![]() |
Use Excel to Help With IRS Audits | 2007-10-05 | Microsoft |
| During the course of a tax audit, an Internal Revenue Service (IRS) agent may request additional data to assist in the examination of the tax records. Microsoft Office Excel 2003 makes job easy. The Excel spreadsheet program helps make number-crunching easy and critical numbers simple to find. By using an Excel worksheet, users can respond to audit requests in a number of tax-related areas. Depreciation expense is a great example. | |||
![]() |
Get a New Perspective on Data With PivotDiagrams | 2007-10-05 | Microsoft |
| A PivotDiagram in Microsoft Office Visio 2007 is similar to an Excel PivotTable report: It arranges data in a visual way so that users can more easily see and explain the meaning behind the facts. When users create a PivotDiagram, Visio imports the data and adds three things to the diagram: a legend with information about the data source, a title box, and a primary shape that aggregates all the data in the data source. This webcast shows how PivotDiagrams can help to get a fresh perspective on the data.
Tags: Collaboration Tools |
|||
![]() |
Enable Blocked Macros | 2007-10-05 | Microsoft |
| Not sure what to do when get a security warning about a macro? What are macro security settings, the Trust Center, and Trusted Locations anyway? This webcast will help to learn how to enable macros and make informed security decisions that can help to keep the computer safer while working. | |||
![]() |
Freeze or Unfreeze Rows and Columns | 2007-10-05 | Microsoft |
| Navigating a large, complex worksheet with thousands of cells can be a challenge sometimes. The problem is that, as user scroll down, the column and row labels are no longer visible, so it's hard to tell what the data user is looking at refers to. By using the Freeze Panes command in Excel, specific rows and columns can stay visible while scrolling. This webcast will help to learn how to freeze and unfreeze rows and columns, and make viewing worksheet a snap. | |||
![]() |
Hide or Unhide Rows and Columns | 2007-10-05 | Microsoft |
| While trying to get at the specific data from a huge worksheet with thousands of data entries user can get many difficulties. In Excel 2007, rows and columns can hide in several ways to change view of the worksheet. After finishing the task, user can unhide the rows and columns to return the worksheet to its original state. This webcast shows quick ways to temporarily hide the data, so user can focus on what he or she do want. |