Beginning Excel
Use Excel for Visual Representation and Data Analysis
Class description
Learn the basics of Microsoft Excel 2013/2016 by learning ways to increase productivity and maximize visual representation and data analysis in the classroom. This training is designed for learners who are new to excel. Goals for this session are: learn basic terminology, data entry, data analysis, explanation of basic excel tools, and basic formatting tasks. Participants of this session will be able to create a basic spreadsheet and format it using the basic tools of excel.Attendees will receive 1.5 hours in-service credit upon completion of session.
Bell work
- After logging into the computer, go to START > PROGRAMS and open Excel. We will work in the downloaded version to get the most options.
- Please look at the objectives for today's session.
Objectives
- Become familiar with terminology and tools
- Create a simple workbook
- Add columns, rows, and pages
- Explore the formatting options within a sheet or workbook
- Create and explore formulas, sorting, and filtering
- Add and edit borders within a worksheet
- Creat a simple chart
Success Criteria
· Participants can explain common basic excel vocabulary terms
· Participants can create a workbook.
· Participants can add data to excel spreadsheet.
· Participants can use basic text formatting in spreadsheet (color, font type, size, bold).
· Participants can add new and adjust column/row widths and heights.
· Participants can adjust margins and page orientation
· Participants can merge cells (i.e. to create headings for data table).
· Participants can change the cell color.
· Participants can add border lines.
· Participants can use the sorting and filtering functions
· Participants can use the AVERAGE formula to find the average of a column or row.
· Participants can create a simple chart