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, point to All Programs, point to Microsoft Office, and then click Microsoft Office Excel.
A New Spreadsheet
Columns
Rows
Cells
Moving Around Excel
How to Move Around Using the Keyboard
To Move Across a Row
Practice Moving Around in Excel
Entering Data in a Cell
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 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.
2. Next click on the Insert Tab.
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
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.