- International Fees
International fees are typically three times the amount of domestic fees. Exact cost will be calculated upon completion of registration.
Course details
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.
Credits
2.0
- Not offered this term
- This course is not offered this term. Please check back next term or subscribe to receive notifications of future course offerings and other opportunities to learn more about this course and related programs.
Learning Outcomes
Upon successful completion of the course, the student will be able to:
- Use correct data modeling terminology.
- Describe the components of functional spreadsheet applications.
- Create simple financial models.
- Solve financial/business problems using appropriate functions.
- Organize data lists using filters and PivotTables.
- Summarize data using statistical functions.
- Employ built-in tools in Excel.
- Analyze business data using analytics.
Effective as of Fall 2013
Subscribe
Interested in being notified about future offerings of Business Data Analytics (BSYS 2050)? If so, fill out the information below and we'll notify you by email when courses for each new term are displayed here.
Programs and courses are subject to change without notice.