Microsoft Excel Introduction to Excel After completing this

  • Slides: 19
Download presentation
Microsoft Excel

Microsoft Excel

Introduction to Excel • After completing this lesson, you will be able to: •

Introduction to Excel • After completing this lesson, you will be able to: • Understand Excel vocabulary. • Enter information and data into a spreadsheet. • Add numbers in a Column. • Insert charts in a spreadsheet.

How to Find Excel on Your Computer To open Excel, click the Start button,

How to Find Excel on Your Computer To open Excel, click the Start button, point to All Programs, point to Microsoft Office, and then click Microsoft Office Excel.

A New Spreadsheet

A New Spreadsheet

Columns

Columns

Rows

Rows

Cells

Cells

Moving Around Excel

Moving Around Excel

How to Move Around Using the Keyboard

How to Move Around Using the Keyboard

To Move Across a Row

To Move Across a Row

Practice Moving Around in Excel

Practice Moving Around in Excel

Entering Data in a Cell

Entering Data in a Cell

Adding Numbers 1. Select all the numbers in Column B. 2. Look for Auto

Adding Numbers 1. Select all the numbers in Column B. 2. Look for Auto Sum in the Ribbon. 3. Click on Auto Sum. 4. The numbers in Column B should now be added up.

Selecting Cells To select a range of cells in a column/row, click the left

Selecting Cells To select a range of cells in a column/row, click the left mouse button in a cell and drag the mouse to highlight the cells. Your selection will turn blue.

To Make a Chart 1. Select all the columns and rows in your spreadsheet.

To Make a Chart 1. Select all the columns and rows in your spreadsheet.

2. Next click on the Insert Tab.

2. Next click on the Insert Tab.

3. Click one time on Column to make a Column chart. 4. A menu

3. Click one time on Column to make a Column chart. 4. A menu will appear. 5. Choose the Column chart you want to make.

6. Your Column Chart will appear in your spreadsheet

6. Your Column Chart will appear in your spreadsheet

Save your Excel Spreadsheet To save your work, click the File Tab, click Save

Save your Excel Spreadsheet To save your work, click the File Tab, click Save As. The Name of the document is Excel Workbook. Type your Name after Excel Workbook.