Skip to Main Content

Computer Application Software Guide / Comp 2000: Creating an Excel Spreadsheet

Step by Step Guide on how to use different computer application software such as PowerPoint, Microsoft Word, Excel, Access, Publisher, Onedrive, and Outlook

Video Tutorial

Video

Video

Video

Charts

Creating an Excel Spreadsheet

Creating an Excel Spreadsheet/Workbook

Entering data

Creating a workbook/Spreadsheet in Excel

Each new document you open in Excel is called a workbook. Within each workbook, you create a worksheet, which you'll see as a tab at the bottom of the screen. By default, a new worksheet is called Sheet1, but you can right-click on it and choose Rename to give it the name you'd like.

  1. Open Excel.

  2. Select Blank workbook. Or, press Ctrl+N.

To manually enter data:

  1. Select an empty cell, such as A1, and then type text or a number.

  2. Press Enter or Tab to move to the next cell.

To fill data in a series:

  1. Enter the beginning of the series in two cells: such as Apr and May; or 2020 and 2021.

  2. Select the two cells containing the series, and then drag the fill handle Fill handle across or down the cells.

  3. Dont forget to save progress. To save the file, click the File menu at the top-left corner, and then select Save As. Depending on your version of Excel, you'll usually have the option to save the file to your computer or OneDrive.

Creating a new workbook from a template

Creating a New Workbook Using A Template

Excel connects to an online database full of thousands of useful templates. When you open a new workbook or click File > New, you’ll see a list of templates available. To open a new workbook with one of the templates, double-click it.

You can also use the search box to locate templates. Click into the search bar and type anything you want to search for.