IPQ7 - Program leadership, management, and accountability
Learning Objectives:
By the conclusion of the training, participants will be able to...
Create and format cells for multiple data types in basic Excel spreadsheets;
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;
Locate existing reports from SMARTT/COGNOS, import these reports to Excel and add basic formatting, and perform functions (e.g. sort data, insert columns or rows, etc.)
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; and
Format reports for printing, such as set print area, create header/footer, apply shading and borders, etc.