CIS231M: Advanced Worksheets

Theory Hours 3 Lab Hours 3 Credits 4

Provides an expanded understanding of the intermediate to advanced features of Microsoft Excel®. Students apply problem-solving and critical-thinking skills while mastering advanced spreadsheet application techniques using the latest version of Excel. Topics include development of more complex formulas by combining and nesting formulas, database formulas and functions, complex charting, forecasting and trend analysis, statistical analysis and business “What- If” data analysis techniques. Prerequisites: CIS110M with a grade of “C” or better and placement into MATH145M. (Cannot be used toward graduation requirements for Computer Science majors).