Spreadsheeting: More resources

Links to resource pages for WordPerfect Office, OpenOffice, Google Docs and Microsoft Excel, as well as speadsheet design guidance

SPREADSHEETS

Corel WordPerfect Office X4 (http://www.corel.com/servlet/Satellite/us/en/Product/1207676528492?trkid=wpox4sem&trkid=35552624): In May, Corel released the latest version of its WordPerfect Office, which included a spreadsheet. The spreadsheet supports the Open Document Format. It also features an old fashioned menu bar, for those who have never gotten the hang of the Microsoft Office 2007 ribbon, noted Jason Larock, a Corel director of product marketing.

OpenOffice (http://www.openoffice.org): The open source OpenOffice is a volunteer-developed fully functional office suite, offering many of the same features as Microsoft Office. Other commercial office suites, such as StarOffice (http://www.sun.com/software/star/staroffice/index.jsp) and IBM's Lotus Symphony (http://symphony.lotus.com/software/lotus/symphony/home.jspa) use OpenOffice as the base. Free download.

Google Docs (http://docs.google.com/): here is where you can try google's online Office suite, which includes a spreadsheet, called Calc.

SPREADSHEET DESIGN

Overview of Spreadsheets (http://www.cof.orst.edu/net/software/spread/overview.sht): This online tutorial, from University of Leeds, offers timely advice on how to best arrange all the elements of a spreadsheet.

PivotTables (http://www.numbergo.com/Support/Tutorial/PivotTableTutorial.aspx): A tutorial from NumberGo.

MICROSOFT EXCEL RESOURCES

Excel Services (http://office.microsoft.com/en-us/sharepointserver/HA101054761033.aspx) read about how to use Microsoft SharePoint server to distribute the results of Excel spreadsheets to coworkers and on the Web.

What's new in Microsoft Office Excel 2007 (http://office.microsoft.com/en-us/excel/HA100738731033.aspx): Curious as to what you're missing by sticking with an older version of Excel? Rich conditional formatting, improved sorting, table enhancements and more. Microsoft offers video tutorials as well (http://office.microsoft.com/en-us/training/CR100479681033.aspx).

Excel Demos (http://office.microsoft.com/en-us/excel/CH100740791033.aspx): trying to figure to figure out how to make something work in Excel. Here, Microsoft presents a plethora of demonstrations of the new features in Excel 2007.

Microsoft Excel home page (http://office.microsoft.com/en-us/excel/FX100487621033.aspx): Microsoft offers a vast library of information for present and past versions of Excel, including training, demons, Webcasts and templates.

Microsoft business intelligence (http://www.microsoft.com/bi/products/office2007_excel.aspx): Microsoft has been touting business intelligence and dating mining capabilities in Microsoft Office. This page shows how Excel may be used in some cases as an alternative to more expensive BI software.

About the Author

Joab Jackson is the senior technology editor for Government Computer News.

Reader Comments

Please post your comments here. Comments are moderated, so they may not appear immediately after submitting. We will not post comments that we consider abusive or off-topic.

Please type the letters/numbers you see above