ACCT 2666 - Advanced Excel 3 s.h.

This course is designed to build upon introductory or basic Excel spreadsheet knowledge. Topics covered will include a review of basic formulas and functions, keyboard tips and shortcuts, large data sets and multiple worksheets; introduce table relationships, upload and download data, sort, filter, query; pivot tables, if/then, lookups; formatting, charting, graphing, data visualization, and presentation; statistical analysis, SEARCH, FIND, TEXT, CONCATENATE, range functions, introduction to IFS, data analysis ratio calculation, amortization & depreciation schedules, verification of imported and exported data. A-E only. Offered Fall only.
Prerequisite(s): CSCI 1000 .