Microsoft Works Spreadsheet Tutorial

Written by tricia goss | 13/05/2017
Microsoft Works Spreadsheet Tutorial
Microsoft Works Budget Spreadsheet

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

Microsoft Works Spreadsheet Tutorial
Microsoft Works Task Launcher

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 Spreadsheet Tutorial
Microsoft Works 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

Microsoft Works Spreadsheet Tutorial
Microsoft Works Charts

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.

Filter:
  • All types
  • Articles
  • Slideshows
  • Videos
Sort:
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the eHow.co.uk site, you consent to the use of cookies. For more information, please see our Cookie policy.