Indicators of Program Quality:
IPQ7 - Program leadership, management, and accountability
Learning Objectives:
By the conclusion of the training, participants will be
able to ...
1. Create, and add formatting of cells for multiple data types in basic
EXCEL spreadsheets.
2. Develop basic formulas, (such as addition, multiplication, division)
within EXCEL that meet the needs of ABE program administrators and be able
to locate help in Excel for more complex formulas.
3. Locate existing reports from SMARTT / COGNOS, import these reports to
EXCEL and add basic formatting, sorting, inserting columns or rows, etc.
4. Locate relevant DOE budget documents on the web (such as Budget Detail
Pages. Request for Funds Form, Amendment Form, etc.)
and save and edit these files.
5. Identify sources for EXCEL templates
to assist in program administration.