ADMN 1313 - Spreadsheet Applications

3 sem hrs cr

A study to provide fundamentals of spreadsheet applications including entering, formatting, charting, managing, and analyzing data using software. Prerequisite: INFS 1010  

In rare and unusual circumstances, a course prerequisite can be overridden with the permission of the Department Lead for the discipline.

This course may include proctored exams which must be completed on campus or at an instructor approved proctoring center which may require additional costs to the student. Please consult your instructor for additional details.

  Formerly/Same As (formerly INFS 1250, CITC 1307)

Transfer (UT) or Non-Transfer Course (UN): UN

Students will be able to…

• create, edit, format, and print spreadsheets.
• enter formulas and functions in a spreadsheet.
• analyze and chart financial data
• manage multiple worksheets and workbooks.

Course Outline Topics

• Excel Basics Review
• Conditional Formatting
• Tables and Charts
• Meaningful Formulas
• PivotTables & Charts
• Visual Design
• Creating Dashboards
• Data Modeling
• Macros
• VBA (Visual Basic)
• PowerPivot