COPE TTS | Evaluated Learning Experience
BUS 107 Computer Business Applications
Varies (self-study; self-paced).
October 2022 - Present.
Upon successful completion of the course, students will be able to: create a plan for effective workbook and worksheet design; plan, design, create and manage Excel worksheets; identify and utilize the appropriate formatting for data in Excel; identify appropriate mathematical processes necessary to achieve a result in Excel; devise formulas utilizing relative, absolute and mixed cell references in formulas in Excel; describe how various charts can be used to represent quantitative data in in excel; manage large volumes of data through the use of trendlines, pivot tables, pivot charts, and slicers; determine appropriate use pivot tables to group and ungroup data in excel; explain the appropriate use of conditional math and statistical functions in excel; and analyze and manipulate data in Excel using mathematical and statistical functions.
This course offers students the opportunity to master the advanced functionality of Microsoft Excel, and to apply those skills to genuine business applications such as financial modeling, reporting, and the automation of accounting and financial tasks. In addition to covering the basic functions of Excel, areas of focus include graphs and charts, the use of advanced financial functions and analytical tools, reporting templates, linking of worksheets and workbooks, importing and manipulating data, auditing tools, and other features especially useful to the financial or accounting professional.
In the associate/certificate degree category OR in the lower division baccalaureate/associate degree category, 3 semester hours in Computer Business Applications (3/23).