Excel Advanced Features
Advanced Features of Excel
On this page, we will move on to the more advanced features of Excel.
Meet Google Sheets
Review the following videos to learn how to use formulas, function, tables, charts, and more in Excel:
|
Simple Formulas (3:38) |
Complex Formulas (5:10) |
Functions (5:15) |
|
Tables (3:19) |
Charts (4:30) |
Page Layout and Printing (5:36) |
If you do not have access to Data Dashboard, use this . Don't forget to follow directions for converting from .cvs to .xlsx, explained in previous pages.
Excel Practice
Use this sample file Download sample file or a spreadsheet you have downloaded from Skyward or Data Dashboard to complete the following tasks:
- Freeze the columns with the student's name and header row.
- Expand each column so the headers can be read by double-clicking the divider between the letters at the top of the columns.
- Find the average score for the SRI using a Formula, and label it, "Formula Average:".
- Find the average score for the SRI using a Function, and label it, "Function Average:".
- Create a chart for the student's DORF data.
- Delete all unused columns.
- Use the following formula to create a column with a student's Active Directory (login) information.
- If the student's information starts on Row 2, and the Last Name is in Column B, First Name in Column C, and the Student ID in Column A, you will use the following formula:
=LEFT(C2,1)&LEFT(B2,3)&RIGHT(A2,4)
- IF you cells have extra spaces in them, use the TRIM() function to remove them.
- Use the fill handle to copy the formula for all students.
- If the student's information starts on Row 2, and the Last Name is in Column B, First Name in Column C, and the Student ID in Column A, you will use the following formula:
- Format the data by turning it into a table.