AC 315. Computer Based Accounting Systems (3)

This course covers the features of Microsoft Excel and spreadsheet concepts used in the design of accurate professional worksheets for business, industry, and nonprofit environments. Topics include entering data; creating formulas; professional formatting; creating charts; creating, sorting, and filtering tables; working with functions; linking and consolidating worksheets; sheet protection; creating pivot tables; analyzing data with pivot tables; and programming Excel with VBA. Prerequisites: "C" or higher in AC 311 . Course fee: $55.00.