DISCOVER
×

Microsoft Works Spreadsheet Tutorial

Updated April 17, 2017

Microsoft Works is a small office productivity suite that often comes free with Microsoft Windows. One of the applications available is the Microsoft Works Spreadsheet program. Works offers similar features to those of Microsoft Excel and you can save Works spreadsheets with Excel file extensions as well, so you utilise them in Excel or share them with Microsoft Office users.

Getting Started

You can start Microsoft Works Spreadsheet from the Microsoft Works Task Launcher. Go to the "Start" menu, point to "Programs" or "All Programs," open the "Microsoft Works" folder and select "Microsoft Works Task Launcher." From the "Quick Launch" task pane on the right of the window, select "Works Spreadsheet." A new, blank spreadsheet window will open.

Templates

Microsoft Works offers many types of spreadsheet templates. Before building your own spreadsheet from scratch, you may want to check the templates available, as there might be one suited for your purpose. From the task pane on the right of the Microsoft Works Spreadsheet window, click the "Browse Templates" option. A new window will open displaying a gallery of Microsoft Works Spreadsheet template types such as financial worksheets, graphs and charts and household records.

Select the type of worksheet you want to make, to see all of the available styles for that type. Click on a template in the "Preview Style" list to get a preview of how the template looks and the type of information it contains. When you find a template you want to use, click "Use This Style" at the top of the preview pane. A new Microsoft Works Spreadsheet window will open with the template.

Blank Spreadsheets

If there is not a template you would like to use, you can make a spreadsheet from a blank Microsoft Works spreadsheet. Click on the cell to select it and type in the data you want to enter. To format cells and the data in them, select the cell or cells you want to change, right click and select "Format."

To make a chart in Microsoft Works Spreadsheet, select the range of cells containing the chart data and click the "New Chart" button on the toolbar. Choose a chart type and click "OK."

To use formulas in a spreadsheet, click the cell you want to contain the calculation. Click the "Easy Calc" button on the toolbar. Select the type of function you want to use in the list or click the "Other" button for a complete list of functions available. Select the function you want to use and click the "Insert" button. Follow the prompts to complete the calculation.

To save a spreadsheet, click the "Save" button on the toolbar or in the "File" menu. To make a spreadsheet compatible with Microsoft Excel, go to the "File" menu and select "Save As." In the "Save as Type" drop-down list, select "Excel Workbook." Name the spreadsheet and save it.

Cite this Article A tool to create a citation to reference this article Cite this Article

About the Author

Tricia Goss' credits include Fitness Plus, Good News Tucson and Layover Magazine. She is certified in Microsoft application and served as the newsletter editor for OfficeUsers.org. She has also contributed to The Dollar Stretcher, Life Tips and Childcare Magazine.