2019-2020 Undergraduate Catalog 
    
    Mar 01, 2021  
2019-2020 Undergraduate Catalog [ARCHIVED CATALOG]

Add to Portfolio (opens a new window)

CSA* H135 - Spreadsheet Applications


Credits: 3
The course centers on the use of the current version of MS Excel at an advanced level. Other spreadsheets will be examined, (including online-based versions) as well as the exploration of online collaboration (in Wiki fashion). The instructional methodology will consist of exploring and applying advanced spreadsheet concepts to everyday situations and problems as presented in the textbook and as created by the instructor for the class. These are selected examples: Web query (getting data from a Web site directly into Excel), Goal seek, Excel database concepts, multilevel sorts, subtotals feature, Auto Filter, templates, converting table into a range, adding calculated fields to a table, drilling entries, 3-D references, linking workbooks, advanced functions..



Add to Portfolio (opens a new window)