Excel Online

How does using Excel Online apply to UDL and SDI?

What Excel Online accessibility tool can I use now?

What area of AT is Excel Online accessibility tool related?

Page Activities

  1. Practice each of the Excel Online features and add-on apps as provided below in the video tutorials.

  2. After completing each of the Excel Online features and add-on apps complete the Word doc you downloaded (see homepage for link if needed).

    • Complete the chart below by indicating which area of AT and UDL is supported by the skill area provided through the accessibilty feature of the app.

    • Please describe how one of the accessibility tools in Office 365 online support an area of AT.

    • Please identify one UDL Principle and Guideline that supports one of the accessibility tools in Office 365.

Video Tutorials

Design Accessibility From The Start

In This Video...

Learn how to design for accessibility by:

Formatting Cells

    • Name styles

    • Cell types

    • Avoid merging cells

    • Name sheet tabs

Accessible Tables

    • Avoid merge cells

    • Avoid blank cells

    • Table header - name styles

Charts

    • Layout tab - add named lables

    • Avoid using only color for charts, vary shapes, line types and textures

    • Adjusting lines

Learn The Basics of Excel in 12 Minutes

In This Video...

Learn how to:

  • Create title of a sheet

  • Create title headers

  • Enter/edit data in a cell/, align data

  • Adjust cell width

  • Adjust colum formatting

  • Locate the formula bar

20 Excel Functions

In This Video...

Learn 20 Excel functions:

  • SUM

  • AVERAGE

  • ROUND

  • IF

  • SUMIF

  • COUNTIF and 14 more functions

Download the free reference guide EssentialFunctions.xlsx at www.seletraining.com


This resource was funded through the Bureau of Exceptional Student Education with IDEA

Part B dollars. The information and resources are provided as a free awareness service to the educational community and do not reflect any specific endorsement by any parties involved.

Technology & Learning Connections Team

http://www.tlc-mtss.com