Spreadsheets - IT Library : ZDNet Asia

White Papers

Case Studies

Vendor Webcast

Show all content

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.

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.

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.

Organize Your Data by Using an Excel Table 2007-10-05 Microsoft

Microsoft Office Excel 2007 makes data alive. Use Excel tables to summarize and emphasize related data: Organize, sort, filter, and calculate data any way. Plus, choose from among a number of professional-looking styles - or users even create a style of their own - to give reports a polished appearance and make the data easy to read and understand.

Analyze Product Sales With a PivotTable Report 2007-10-05 Microsoft

A user has all the data for his or her sales report, and wants to make a dynamic presentation. With PivotTable reports in Microsoft Office Excel 2007, the sales report will sparkle with power, flair, and functionality. Show just the big picture, show all the details, or show anything in between. Easily create multiple worksheets to switch back and forth between the various versions of the report.

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.

Jump to [1] 2 3 4 5 6 7 8

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.
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.
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.
Organize Your Data by Using an Excel Table	2007-10-05	Microsoft
Microsoft Office Excel 2007 makes data alive. Use Excel tables to summarize and emphasize related data: Organize, sort, filter, and calculate data any way. Plus, choose from among a number of professional-looking styles - or users even create a style of their own - to give reports a polished appearance and make the data easy to read and understand.
Analyze Product Sales With a PivotTable Report	2007-10-05	Microsoft
A user has all the data for his or her sales report, and wants to make a dynamic presentation. With PivotTable reports in Microsoft Office Excel 2007, the sales report will sparkle with power, flair, and functionality. Show just the big picture, show all the details, or show anything in between. Easily create multiple worksheets to switch back and forth between the various versions of the report.
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.