OBT 135 - MS Excel and Access II

(5)
Use Microsoft Excel for PCs to apply advanced formatting techniques to spreadsheets and charts, write complex formulas and use advanced functions, use What-if Analysis tools, manage and analyze worksheet data, and automate tasks with templates and macros. Use Microsoft Access for PCs to design a relational database, enhance the design of tables, use advanced query and filter techniques, and design custom forms and reports. Prerequisite: OBT 134.