Every enterprise requires business analytics and decision support systems (DSS) in order to develop a competitive advantage. This course uses MS Excel, the foundational data analysis tool, to build on the skills and concepts covered in introductory computer application courses. This course covers advanced Excel formulae, concepts, and applications using larger and more professional worksheets and focusses on the data modeling approach using Excel vs. the calculator approach. Topics include if-then modeling, built-in functions, charting, transferring data across applications, and using the built-in tools such as PivotTables, Sparklines, Slicers, PowerPivots, and macros.
Upon successful completion of the course, the student will be able to:
Effective as of Fall 2013
BSYS 2050 is offered as a part of the following programs:
Interested in being notified about future offerings of BSYS 2050 - Business Data Analytics? If so, fill out the information below and we'll notify you by email when courses for each new term are displayed here.