Charts, Formulas, Pivot Tables

Charts and graphs

[23 minutes total]

These seven tutorials show how to make charts and graphs in Excel. Visual displays of data can help school stakeholders understand patterns and trends quickly and easily.

After viewing the tutorial(s), use the back key in your browser to return to this web site.

Trace cell references

[2 minutes total]

Excel spreadsheets often contain a number of calculations and it is easy to lose track of which data are feeding into a particular calculated cell. These two tutorials show how to visually display the data items that are being used in particular calculated cell values.

After viewing the tutorial(s), use the back key in your browser to return to this web site.

Protection

[5 minutes total]

Once Excel data are formatted, calculated, and/or displayed to facilitate data collection and analysis, it often is useful to protect the data so that another user cannot delete or alter them. These three tutorials show how to protect Excel data so that they are not lost to accidental or intentional deletion.

After viewing the tutorial(s), use the back key in your browser to return to this web site.

Pivot tables and charts

[24 minutes total]

The Pivot tables and chartsfeature in Excel lets educators begin disaggregating and analyzing data within seconds (literally) of receiving original data files from state departments, testing companies, and/or school districts. These ten tutorials show how to use what is perhaps the most powerful data analysis tool within Excel (note: dynamic pivot charts do not work in Macintosh versions of Excel, but pivot tables do!). Before viewing these tutorials, it is recommended that you view the Charts and Graphs tutorials if you do not already know how to use Excel’s charting features.

After viewing the tutorial(s), use the back key in your browser to return to this web site.

Formulas and functions

[23 minutes total]

These eight tutorials show how to work with Excel’s various formulas and functions, which are used to calculate totals, averages, etc. While the mathematical aspects of Excel often intimidate users, some basic knowledge in this area is often necessary to work with school and student data.

After viewing the tutorial(s), use the back key in your browser to return to this web site.

You may need to turn off your browser’s pop-up blocker or install the latest Flash plug-in to view these tutorials.