Mar 28, 2024  
2011-2012 Undergraduate Catalog 
    
2011-2012 Undergraduate Catalog [ARCHIVED CATALOG]

Add to Portfolio (opens a new window)

MFTC 219H - Honors Spreadsheet Applications


This course provides a hands-on approach to spreadsheet analysis, performance management, and graphics, using Microsoft Excel 2010. Topics to be discussed include: using Excel to enter data, develop formulas, correct mistakes, use-built-in formulas and functions, perform “scenario analysis”, create graphs and charts, conduct financial forecasts, manage data, and print worksheets. Advanced topics will include: logical and lookup functions used in buyers spreadsheets and programming using Visual Basic. The course will explore the possible connections between Excel and the database Access, query data, and generate Excel pivot tables from Access.
3 credits
Corequisite: Enrollment in the Fashion Scholars Program or permission of the Dean of Academics



Add to Portfolio (opens a new window)