Excel Advanced Features

 Advanced Features of Excel

On this page, we will move on to the more advanced features of Excel.

 

LaptopMeet 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.

 

LaptopExcel Practice

Use this 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.
  • Format the data by turning it into a table.