1 / 10

Microsoft Excel

Microsoft Excel. Quick Overview. Putting students first to make learning last a lifetime Celebrating academics, diversity, and innovation. Objectives & CCSS. Introduce staff to the basic functions in Excel At the end of this training you will be familiar with: Enter cell data

jalia
Download Presentation

Microsoft Excel

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Microsoft Excel Quick Overview Putting students first to make learning last a lifetime Celebrating academics, diversity, and innovation

  2. Objectives & CCSS • Introduce staff to the basic functions in Excel • At the end of this training you will be familiar with: • Enter cell data • Edit and format cells • Use tabs & basic ribbon functions • Create new worksheets • Sort data • Practice creating graphs CCSS.MP5 Use appropriate tools strategically

  3. Enter Cell Data The amount of data you choose to enter into Excel can range from a few cells to thousands of cells. To enter your data, simply select the cell you want and type it in.

  4. Edit and Format Your Cells 1 2 3 4 Format Text Add borders Highlight cells Alignment

  5. Sorting Data Highlight the area that you would like to sort. Select the Data tab and click the Sort button. A dialog box will pop up. Select the row that you would like to sort and click OK. 2 1 3

  6. Create a Chart 2 Highlight the data using your cursor. Click on the Insert tab. Select the type of chart you would like to use to display your data. 3 1

  7. Format a Chart Most of the time Excel will auto-format your data into the appropriate chart. To enhance your chart, use the Chart Tools area.

  8. Creating a Worksheet • A workbook is a file that contains one or more worksheets that you can use to organize various kinds of related information. • A worksheet is the primary document that you use in Excel to store and work with data (also called a spreadsheet). A worksheet consists of cells that are organized into columns and rows; a worksheet is always stored in a workbook. 1 3 2

  9. Good Excel Resources • Excel Is Fun YouTube Channel • http://www.youtube.com/user/ExcelIsFun?feature=watch • MrExcel.com

  10. Application – Classroom Use • Have student collect data, input it into Excel, create a table or graph. The graph can then be pasted into a PowerPoint presentation! • Students can input spelling words and sort them alphabetically • Student can use the border functions to demonstrate perimeter and area understanding • Use functions to calculate descriptive statistics on large data sets

More Related