Earlier this month I was part of a panel presentation at the American Council of the Blind’s summer convention. The panel spoke on financial literacy. My portion of the session dealt with using Microsoft Excel to create pivot tables and using what are known as datatypes in Excel with a screen reader. I wanted to make the materials from that presentation available. Resources include:
- Audio of my part of the presentation.
- A Word document containing the text of the presentation.
- A plain text transcript of the presentation.
- An example spreadsheet with pivot tables.
- A sample spreadsheet using datatypes for stock information.
Additional Resources
You can obtain more details on the features of Excel discussed in the presentation at the following locations:
- Creating Pivot Tables
- Excel Datatypes – Stocks and Geography
- List of datatypes in Excel
- Excel Stock History Function
- Sample Templates Using multiple data types
- Creating drop-downs in Excel using data validation
- Tables in Excel.
Pivot tables have been invaluable for me in Excel for many years. It is well worth the investment of time to understand how to create them.
The newer datatypes in Excel make getting a great deal of information on multiple topics relatively straight forward. Stocks and geography are just the beginning.
Comments