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.

Featured

  • Pierce County

    CARES dashboard ensures county spending delivers results

    The CARES Act Funding Outcomes Dashboard helps Pierce County, Wash., monitor funding and key performance indicators for public health emergency response, economic stabilization and recovery, community response and resilience, and essential government services.

  • smart city challenge

    AI-based traffic management improves mobility, saves fuel, cuts pollution

    Researchers are developing a dynamic feedback traffic signal control system that reduces corridor-level fuel consumption by 20% while maintaining a safe and efficient transportation environment.

Stay Connected

Sign up for our newsletter.

I agree to this site's Privacy Policy.